Hi !

i wonder how i can get the ID of the last insert made from the MySQL
Connector/J driver ?
does any one has an exemple of this ?

thank's


Guillaume MOCCAND
moccand_g (AT) hotmail (DOT) com

__________________________________________________ _______________
MSN Actions Solidaires : http://www.msn.fr/actionssolidaires/ la
solidarité à portée de click


--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=my...ie.nctu.edu.tw

You can use the JDBC 3.0 getGenerated() keys call as follows:

Int generatedKey = -1;
ResultSet rs = stat.getGeneratedKeys();
if (rs.next()){
generatedKey = rs.getInt(1);
}
rs.close();

Chhers,

Ben

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.691 / Virus Database: 452 - Release Date: 26/05/2004



--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=my...ie.nctu.edu.tw

Perhaps you can try something like this:

SELECT MAX(tbl.ID) FROM [table_name] tbl ?



Guillaume MOCCAND wrote:

--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=my...ie.nctu.edu.tw

How about: http://forum.java.sun.com/thread.jsp...essage=2229028

Last_INSERTED_ID() method





--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=my...ie.nctu.edu.tw

" Can someone explain to me why there is no support for retrieving this
value using the JDBC API "

Does nobody read here?? The very first reply to this thread (by me) =
showed
you how you could retrieve this data via a standard JDBC call, since =
then,
other hacks have been floating around - for what reason I don=92t know, =
as the
JDBC 3.0 method works fine.

Just to recap, for those that didn=92t read the first post, you can use =
the
JDBC 3.0 (MySQL is has a JDBC 3 compliant driver) method as such:

Statement stat =3D dbConn.createStatement();
Stat.executeUpdate("Some insert statement here");

ResultSet rs =3D stat.getGeneratedKeys();
Int insertedKeyValue =3D rs.getInt(1);

Rs.close();
Stat.close();


Cheers

Ben=20

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 28/05/2004
=20


--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=3D...ie.nctu.edu.tw

Guillaume MOCCAND wrote:

I don't know if this is the prefered way of doing it, but this is how
we do it:

rs = stmt.executeQuery("SELECT LAST_INSERT_ID()");
rs.next();
id = rs.getString(1);

It returns the last instert id of the session connected to
stmt, so you'll have to look out for concurrency and pooling
issues...

Rikard
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=my...ie.nctu.edu.tw