Can you use a stored procedure to inset the row? The stored procedure can query the id of the row just inserted and pass it back to you as an output parameter.
Jim > -----Original Message----- > From: Henry [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 05, 2002 3:42 PM > To: Tomcat Users List > Subject: saving object > > > 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]> > > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
