Get the ID of the record I have just inserted in Derby DB

Question

Possible Duplicate:
Retrieve id of record just inserted into a Java DB (Derby) database

I have a table in a Derby database with a column created:

id INTEGER GENERATED ALWAYS AS IDENTITY

How do I get the id of the last record inserted? How can I know what is the id of the record I have just inserted?

Answer 1

Java's Statement class has getGeneratedKeys(), which is designed to provide that information:

http://download.oracle.com/javase/6/docs/api/java/sql/Statement.html#getGeneratedKeys()

Answer 2

the IDENTITY_VAL_LOCAL() function should be your friend: http://db.apache.org/derby/docs/10.2/ref/rrefidentityvallocal.html

Answer 3

See following SO question: Retrieve id of record just inserted into a Java DB (Derby) database