ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mitchell, Steven C" <Steven.Mitch...@umb.com>
Subject Post Generated Keys
Date Mon, 27 Jun 2005 19:06:39 GMT
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?

View raw message