[Opensource] Value of last inserted auto-generated key.

[Saurabh Tiwari]

 Hi,
    Presently I am using dbobj for adding records inside a table in which a column value is automatically generated by the database. Once I insert the record, how  I can get the value of last inserted autogenerated column considering that the other half (exluding that column)of the table is not unique. As I think, In a multithread enviornment I can achieve it either by creating a transaction block  at the dbobject level or using a synchronized method at the application level that involves insertion using dbobjects. 
Now questions are -
1. Is there any other way to achieve it?
2. Does dbobject provide the Transaction Block kind of mechanism?
Thanks.
Saurabh



---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.jcorporate.com/pipermail/opensource/attachments/20020611/c44141c6/attachment-0002.htm