Not with a sequence, I've been told that they are 'session' aware, so if you get id 123 in your session, no one else ever will.
Larry On Thu, May 8, 2008 at 4:21 PM, Chris O'Connell <[EMAIL PROTECTED]> wrote: > 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:[EMAIL PROTECTED] > 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 > >
