Would you give me an example? I am not familiar with stored procesure though...
thanx a lot! ----- Original Message ----- From: "Jim Urban" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 3:06 PM Subject: RE: saving object > 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]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
