ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris O'Connell" <oconn...@gorillachicago.com>
Subject RE: How to get the generated key from insert with Oracle
Date Thu, 08 May 2008 22:21:26 GMT
Even if I am executing all of this inside a transaction, don't I still have
concurrency issues with this approach?

-----Original Message-----
From: Larry Meadors [mailto:larry.meadors@gmail.com] 
Sent: Thursday, May 08, 2008 5:12 PM
To: user-java@ibatis.apache.org
Subject: Re: How to get the generated key from insert with Oracle

I think this would be the preferred SQL for that:

select ids.currval from dual

...where ids is your sequence's name.

Larry
No virus found in this incoming message.
Checked by AVG. 
Version: 8.0.100 / Virus Database: 269.23.10/1421 - Release Date: 5/7/2008
5:23 PM


Mime
View raw message