Re: returning identity field from a select statement - Jeff Kilbride - com.mysql.lists.java

12 messages in com.mysql.lists.javaRe: returning identity field from a s...

From	Sent On	Attachments
MHa...@ica.com.au	15 Jul 2002 19:28
Jeff Kilbride	15 Jul 2002 20:44
Mark Matthews	15 Jul 2002 20:46
Tim Endres	15 Jul 2002 20:56
Steve Forsyth	15 Jul 2002 20:57
Javier Bolaños Molina(MCIC)	15 Jul 2002 23:20
Andrew Houghton	16 Jul 2002 09:23
Steve Forsyth	16 Jul 2002 11:20
Mark Matthews	16 Jul 2002 12:26
Jon Frisby	18 Jul 2002 20:12
Mark Matthews	18 Jul 2002 20:55
Jon Frisby	19 Jul 2002 11:24

Subject:	Re: returning identity field from a select statement
From:	Jeff Kilbride (je...@kilbride.com)
Date:	07/15/2002 08:44:51 PM
List:	com.mysql.lists.java

With mm.mysql, you can cast your statement object to an "org.gjt.mm.mysql.Statement" and use the "getLastInsertID" method. Here's an example of how I use this:

long lastInsertID = ((org.gjt.mm.mysql.Statement)stmt).getLastInsertID();

Where stmt is the Statement object you used to execute the insert. You can also use the last_insert_id function by executing the following select statement, but it has to be on the *same* connection that the insert was executed on:

SELECT last_insert_id() AS id;

--jeff

MYSQL already has a function mysql_insert_id() for use in the C API but this does not work in java.

Is there an equivalent function that I can use in my Java servlet to return the identity field after an insert ?

I am using the version 1.4 JDK and the version 2.0.14 MM.MYSQL JDBC Driver for mySQL .

I am using version 3.23.36 of mySQL.

Can anyone help ?

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.