The getGeneratedKeys() method on Statement and PreparedStatement should do the trick:

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

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

--

Percy Wegmann

+1 512 637 8500 ext 148

_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list