a little bit off topic.

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?


--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

Reply via email to