how to SELECT LAST_INSERT_ID() in java

[int80]

I need to find out an auto_incrementing amount using LAST_INSERT_ID(). Is there a specific way to get that query executed and returned?

Code:

Resultset resultS = statement.executeQuery("SELECT LAST_INSERT_ID()");

When I use this, I get this value returned.

com.mysql.jdbc.JDBC4ResultSet@119298d

Am I right in assuming that this "119298d" is the value created by AUTO_INCREMENT? If so, how do I seperate it once in the resultset? (next())?

Also, if I want to use that value to create a unique set of results for a group, what type would it be (re)stored in? I'm guessing not an int. varchar(10)?!?

Sorry for all the questions, but this is important I get this done.

Thanks in advance.

[int80]

I've just realised, it can't be the value returned as, when I SELECT * FROM group_order; I get this:

Code:

+---------+-------------+
| groupID | bookingDate |
+---------+-------------+
|       1 | 12/12/2008  |
|       2 | 12/12/2008  |
|       3 | 12/12/2008  |
|       4 | 12/12/2008  |
|       5 | 12/12/2008  |
|       6 | 12/12/2008  |
|       7 | 12/12/2008  |
|       8 | 01/12/2000  |
+---------+-------------+

groupID is incrementing from 1, so god knows where that alphanumeric number came from.

[kalikakiran]

Hai This Is My First Message To Everybody:

[fishtoprecords]

Quote:

Originally Posted by int80

I need to find out an auto_incrementing amount using LAST_INSERT_ID(). Is there a specific way to get that query executed and returned?

com.mysql.jdbc.JDBC4ResultSet@119298d

Am I right in assuming that this "119298d" is the value created by AUTO_INCREMENT?

First, "119298d" is the address of the result set, not a value within it. it is not at all the value you are looking for.

You should test this. Start with a table with one record, do the insert, and if you don't get "2" or something close, you have it wrong.

You need to explicitly use the JDBC functions to return it. You start with something like:

Code:

      int numRows = stmt.executeUpdate(command,      Statement.RETURN_GENERATED_KEYS);

which does the insert and tells JDBC that you want the generated key. Then you have to get a new result set for it:

Code:

 ResultSet rs = null;
                try {
                    rs = stmt.getGeneratedKeys();
                    if (rs.next()) {
                        autoIncKeyFromApi = rs.getInt(1);
                    } else {
                        throw new RuntimeException("PIB, can't find most recent insert we just entered");
                    }
                    rs.close();
                    rs = null;
                }  finally {
                    if (rs != null) {
                        try {
                            rs.close();
                        } catch (SQLException ex) {} // ignore
                    }
                    try {
                        stmt.close();
                    } catch (SQLException ex) {}  // ignore
                }