JDBC: Insert ID

[sde]

When you have a database that you can setup to automatically increment an ID field, is there a way via JDBC to retrieve the value after an insert?

I'm using JDBC with DB2 and I'm not sure if I'm just sol on this one.

[Belisarius]

You know, I never bothered looking up how to do this because I was able to solve my problem with an SQL query, but I think there is a way to do what you want. Use the execute(String sql, int autoGeneratedKeys) method. You can then call getGeneratedKeys(), which returns a ResultSet. Let me know if it works for you.

[sde]

i found the getGeneratedKeys() method, but i can't seem to get it to work.

it does say jdbc3.0 , and i'm not sure what version of jdbc i'm on .. i'll try looking up how to find this out.

[sde]

Statement stmt = conn.createStatement();
// Obtain the generated key that results from the query.
stmt.executeUpdate("INSERT INTO authors " +
                   "(first_name, last_name) " +
                   "VALUES ('George', 'Orwell')",
                   Statement.RETURN_GENERATED_KEYS);
ResultSet rs = stmt.getGeneratedKeys();
if ( rs.next() ) {
    // Retrieve the auto generated key(s).
    int key = rs.getInt(1);
}

here is a code example of what i need ..

i can't find the getGeneratedKeys() method off the Statement object for the life of me. =/

is the jdbc version related to the j2sdk version ? i'm on 1.4.2

[npa]

what do you mean you can't find it ?

does the code you've written compile ? it should ...

[sde]

yes i just did it as you posted that lol .. it works!! damn netbeans just doesn't recognize any of that.

i was relying on my IDE drop down stuff too much to check for validity.

[Belisarius]

Netbeans only seems to pickup on stuff after you compile, and often you need to hit enter on a line marked as an error before it goes away.

[sde]

i had that figured out, .. but what about the feature when you type a dot after a class and it drops down with all the properties/methods available for that object? it is not showing everything. maybe i need to update netbeans.

[Belisarius]

Well, it won't show private methods and whatnot . . . I honestly don't use that function very often so I'm not sure why it's doing that.

[sde]

http://java.sun.com/j2se/1.4.2/docs/...tGeneratedKeys()

it's a public method. i am dependant on the drop down help .. for now anyway.

[Belisarius]

Rely on the API more, it's a bit easier to just look through the methods on an object that way.

[npa]

yes, i do this too - i have the api downloaded so its a bit faster to view,

[sde]

thanks for the advice.