tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject Re: saving object
Date Sun, 07 Apr 2002 04:14:51 GMT
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
>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
>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:   <>
>For additional commands: <>
>Troubles with the list: <>

To unsubscribe:   <>
For additional commands: <>
Troubles with the list: <>

View raw message