Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of oconnell@gorillachicago.com
 designates 206.40.48.197 as permitted sender)
From: "Chris O'Connell" <oconnell@gorillachicago.com>
To: <user-java@ibatis.apache.org>
References: <17093837.post@talk.nabble.com>
 <17106214.post@talk.nabble.com>	 <17110744.post@talk.nabble.com>
	 <588283.75112.qm@web54506.mail.re2.yahoo.com>
	 <17111540.post@talk.nabble.com>
 <00b201c8b157$6e6ce300$4b46a900$@com>	 <a10a823c0805081511x46520cb1mabdb859a43a363d1@mail.gmail.com>
	 <00b401c8b159$dbbf9270$933eb750$@com>
 <a10a823c0805081537i56320851v123b62a2ff54d68@mail.gmail.com>
In-Reply-To: <a10a823c0805081537i56320851v123b62a2ff54d68@mail.gmail.com>
Subject: RE: How to get the generated key from insert with Oracle
Date: Fri, 9 May 2008 09:12:46 -0500
Message-ID: <00bf01c8b1de$c248b4e0$46da1ea0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcixXECprqV87dqgTJGv+DHEs1040gAgctTA
Content-Language: en-us

Thanks.  I had never heard this before.  Just to make sure we are talking
about the same thing, I'm not concerned about the sequence returning the
same value to two different people when the trigger is calling 'nextval'.
I'm worried about the fact that two inserts could happen before my code that
tries to call "sequence.currvalue" can execute for the first insert and I
end up with two difference insert actions that get the same value for
"sequence.currvalue".

It isn't that I don't believe you :) but this is counter to what I *thought*
I knew, so I'm trying to get a full understanding of what is going on.

Thanks,
Chris

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

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
<oconnell@gorillachicago.com> 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: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
>
>
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