auto generated keys

[abhi_iips]

how to retrieve auto generated keys after executing an insert statement, i have a filed named id which is of autonumber type, i want to get back the id generated by database management system....

plz give me a clear code to do so.....

tx in advance.............

[sandeepsai39]

Follow These Three steps.
Statement stmt =connection_object.createStatement();
String query =" insert into --------------------------";
//inserting into database
stmt.executeUpdate(query);
-------------------
//to get autogenrated keys

rs = stmt.getGeneratedKeys();

[abhi_iips]

it throws unsupported exception...i had tried this code, even i tried it wid prepared statement.....plz give me some working code

[sandeepsai39]

check whether stmt.executeUpdate(query) sucess or not else ,check in your database specified table has autogengenerated key or not.