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
----- Original Message -----
From: <MHall@stripped>
To: <java@stripped>
Sent: Monday, July 15, 2002 7:28 PM
Subject: returning identity field from a select statement
> 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 ?
>
>
>
> Michael Hall
> Email: MHall@stripped
>
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail java-thread4005@stripped
>
> 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-unsubscribe@stripped instead.
>
