I have done this with some row_id defined to be auto-insert on mysql. With auto-insert you know it will be unique but might want to make that a constraint.
insert .....blah blah select max(row_id) - yields the number of the last tx. row_id is just an example for your purpses. Good luck At 01:41 PM 4/5/02, you wrote: >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]>
