When adding a new record, we run an insert query which auto-increments the primary key for the table. However the method (in java) which calls this query must return the newly created key.
Any ideas on how to do this, preferably using a single transaction?
Thanks
Try insert returning, something like this:
INSERT INTO distributors (did, dname) VALUES (DEFAULT, 'XYZ Widgets')