tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Henry" <hxzh...@binary-solutions.net>
Subject saving object
Date Fri, 05 Apr 2002 21:41:31 GMT
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:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message