ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Post Generated Keys
Date Mon, 27 Jun 2005 19:51:29 GMT
Use sequence.currval instead.

On 6/27/05, Mitchell, Steven C <Steven.Mitchell@umb.com> wrote:
>  
> I'm converting an Oracle application to iBatis.  I discovered that the
> database is using triggers to generate ids (I was using sequence.nextval and
> my ids were off by one).  The documentation says iBatis supports both pre
> and post generated keys.  Is that true for Oracle too?  The post-generated
> example is for SQL Server @@IDENTITY.  I would have the DBAs turn off the
> triggers, but I have to run in parallel for some time.  Am I stuck doing a
> select on some other key immediately following the insert to find out the
> generated ID?

Mime
View raw message