You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by je...@ext.mpsa.com on 2006/10/30 12:23:56 UTC
OJB 1.0.4 : problem with method getLastInsertIdentityQuery from
PlaftformDb2Impl on DB2 Z/os
hello,
switching from ojb 1.0.3 to 1.0.4 i have discovered that the
implementation of the getLastInsertIdentityQuery method on the
PlaftformDb2Impl has changed.
Prior to version 1.0.0 the SQL request was :
values IDENTITY_VAL_LOCAL() fetch first row only
which can't be used on DB2 Z/os (at least V7) as the values command doesnt
exist.
from version 1.0.0 to 1.0.3 (included) the request was :
select IDENTITY_VAL_LOCAL() from sysibm.sysdummy1
which, i think, works on DB2 V7/V8 on windows , unix , linux and Z/os.
and with the 1.0.4 the request is now :
values IDENTITY_VAL_LOCAL()
so it doesn't work anymore on DB2 Z/os v7.
I have checked in subversion and i think it may have been changed while
creating/modifying the derby platform in december.
Could it be possible to go back to this request for the db2 platform :
select IDENTITY_VAL_LOCAL() from sysibm.sysdummy1
or is there a reason to the use of the "values" command ?
Regards,
Jérémie Quinet.
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: OJB 1.0.4 : problem with method getLastInsertIdentityQuery from
PlaftformDb2Impl on DB2 Z/os
Posted by Armin Waibel <ar...@apache.org>.
Hi Jeremie,
sorry for the late reply - I overlooked your post.
jeremie.quinet@ext.mpsa.com wrote:
> hello,
>
> switching from ojb 1.0.3 to 1.0.4 i have discovered that the
> implementation of the getLastInsertIdentityQuery method on the
> PlaftformDb2Impl has changed.
>
> Prior to version 1.0.0 the SQL request was :
>
> values IDENTITY_VAL_LOCAL() fetch first row only
>
> which can't be used on DB2 Z/os (at least V7) as the values command doesnt
> exist.
>
> from version 1.0.0 to 1.0.3 (included) the request was :
>
> select IDENTITY_VAL_LOCAL() from sysibm.sysdummy1
>
> which, i think, works on DB2 V7/V8 on windows , unix , linux and Z/os.
>
>
> and with the 1.0.4 the request is now :
>
> values IDENTITY_VAL_LOCAL()
>
> so it doesn't work anymore on DB2 Z/os v7.
>
> I have checked in subversion and i think it may have been changed while
> creating/modifying the derby platform in december.
>
> Could it be possible to go back to this request for the db2 platform :
>
> select IDENTITY_VAL_LOCAL() from sysibm.sysdummy1
>
> or is there a reason to the use of the "values" command ?
>
I rollback the changes (made in 1.0.4) as you suggested. Thanks for the
hint.
regards,
Armin
>
> Regards,
>
> Jérémie Quinet.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org