tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jay Gardner" <>
Subject RE: saving object
Date Mon, 08 Apr 2002 00:21:01 GMT
It is best to set the column to auto-increment and put the unique constraint
on it. Which programming language are you using?

If JAVA, the mm.mysql driver has a method that does what you want: stmt =
            int Results = stmt.executeUpdate(sql);
            applicantID = stmt.getLastInsertID();

If PERL, dbi will return the row # you just inserted using:


If PHP, This returns the ID number used for the last INSERT statement:

	$id_num = mysql_insert_id();

If C,  Returns the last number generated for an AUTO_INCREMENT field:

	id = mysql_insert_id(&mysql);
printf("The new ID is %d\n", id);

When using an ORACLE database, I generally use a sequence generator. I first
make a call to get the next number in the sequence, then use that number as
the key for my insert.

--Jay Gardner

-----Original Message-----
From: Jay Gardner []
Sent: Sunday, April 07, 2002 12:02 AM
To: Tomcat Users List
Subject: RE: saving object

What database are you using?

-----Original Message-----
From: []
Sent: Saturday, April 06, 2002 9:15 PM
To: Tomcat Users List
Subject: Re: saving object

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

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

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

View raw message