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]>