Re: [JDBC] Retrieving last InsertedID : INSERT... RETURNING safe ?

spastor@motionsponsor.com wrote:
> Only one exception is regarding the best method to retrieve the last inserted id (serial). There are many posts on this topic but i couldn t find a definitive response.
> I am using postgresql version 8.2.6 and jdbc 8.2_p505, i ve been experiencing INSERT statement with RETURNING myID, using an executeQuery it works great, i retrieve the proper value everytime at least from the few tests i have been doin locally.
> Is it THAT easy or could this method break somehow in a live environement ?

It is that easy, and that is a good way to do it.

Alternatively, if you need to support older PostgreSQL version for example, you could use a "SELECT currval('sequence')" query after the INSERT. Much of the of discussion you saw were probably about implementing the JDBC getGeneratedKeys() function that some applications need for portability reasons, or because of middleware that doesn't know how to do INSERT RETURNING. PostgreSQL driver doesn't support that at the moment, but as long as you don't need it, you'll be fine.

-- 
   Heikki Linnakangas
   EnterpriseDB   
http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly