The getGeneratedKeys() method on Statement and PreparedStatement should do the trick:
http://docs.oracle.com/javase/6/docs/api/java/sql/Statement.html#getGenerate...)
Cheers, Percy
On Mon, Jan 28, 2013 at 7:11 PM, Mate Birkas birkas@gmail.com wrote:
Hi, this is my first post to this list, so forgive me if this is not the right place to post this. I tried to do my research (google, monetdb.org, python api help) but didn't find an answer.
How can I get the auto-generated primary key (integer) after executing an insert. I want to use it in a second insert to another table that references the first.
(in PostgreSQL I used the RETURNING clause for this)
thanks in advance Mate
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list