openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Linskey" <plins...@gmail.com>
Subject Re: DB2 and "FOR UPDATE OF" clause
Date Thu, 06 Sep 2007 21:09:53 GMT
It's not my database; all I know is what I got from the database metadata logs.

FWIW, I was also seeing an exception complaining about the 'FOR UPDATE
OF' clause. I was surprised by the syntax, as I would have expected it
to say 'FOR UPDATE OF <something>'.

-Patrick

On 9/6/07, catalina wei <catalina.wei@gmail.com> wrote:
> Hi Patrick,
> That SQL is correct syntax if you are running DB2 UDB version 8.1 or earlier
> and the isolation level is set pessimistic.
>
> If you are not running the said DB2 version and still seeing "FOR UPDATE OF"
> string, then we have a problem in DB2Dictionary.
>
> Catalina
>
>
> On 9/6/07, Patrick Linskey <plinskey@gmail.com> wrote:
> >
> > Hi,
> >
> > I'm seeing SQL like so:
> >
> > SELECT  t0.ID, t0.VERSN, t0.STRINGFIELD FROM SIMPLEPERSISTENTCLASS t0
> > FOR UPDATE OF
> >
> > Is this valid DB2 SQL? I'm using a DB2 database that returns SQL08016
> > from a call to getDatabaseProductVersion(). I'm guessing that the
> > checks for the FOR UPDATE clauses are getting tripped up somewhere.
> > Any suggestions about what it should be for this version of DB2?
> >
> > -Patrick
> >
> > --
> > Patrick Linskey
> > 202 669 5907
> >
>


-- 
Patrick Linskey
202 669 5907

Mime
View raw message