Re: saving object using sequence as ID, help!

From: Jaap $myweb$ <j.w.vandijk.remove_this_at_hetnet.nl>
Date: Sat, 6 Apr 2002 17:29:26 +0200
Message-ID: <a8n46e$d6d$1@cyan.nl.gxn.net>

currval is the current value OF YOUR SESSION, the last retrieved with nextval in your session. So it's save to use it.

Jaap.

"Henry" <hxzhang_at_binary-solutions.net> schreef in bericht news:RApr8.13573$226.639285_at_news2.telusplanet.net...
> From: "Henry" <hxzhang_at_binary-solutions.net>
> Subject: saving object into database with sequence as ID, help please!
> Date: Friday, April 05, 2002 2:42 PM
>
> I have a table with each row corresponds to a javabean object. The objects
> don't
> necessarily have a primary key, so i use a sequence number as its primary
> key, and a
> trigger to assign the sequence number to its ID column when a new object
is
> inserted
> into the database.
>
> However, after I insert the object into the table, how can i know the
> object's ID in the
> table? If I simply do a "..._seq.cur_val", it is not safe when multiple
> users can access
> the database and save their javabean into it at the same time.
>
> How could you guys accomplish that?
>
>
>
>
Received on Sat Apr 06 2002 - 09:29:26 CST