|
|
| Applications |
| Mailing Lists |
| Miscellaneous |
| Operating Systems |
| Programming |
Re: [JDBC] Retrieving last InsertedID : INSERT... RETURNING safe ?
From: Heikki Linnakangas <heikki(at)enterprisedb.com>
Date: Wed Feb 20 2008 - 08:50:06 EST
>
> In my case, we're talking about a system that has dozens of Java
> processes, many of which access the database. Because the system used
> to have autocommit on, one process could do the "insert nextval" and
> commit, and then another process could do an "insert nextval" and
> commit, and then the first process would do the "select currval" and
> would probably get the wrong value.
Date: Wed Feb 20 2008 - 08:50:06 EST
Paul Tomblin wrote:
> On Feb 20, 2008 8:14 AM, Heikki Linnakangas <heikki@enterprisedb.com> wrote:
>> Dave Cramer wrote: >>> I was going to say there are absolutely no situations where this is not >>> true, however in your case autocommit or not it doesn't matter. >>> You have a single connection for the entire application and asynchronous >>> events using that connection. Autocommit or not it will not work with >>> currval. >>> >>> In your case you must use nextval before doing the insert. >> Now you lost me. By asynchronous events, do you mean NOTIFY/LISTEN? What >> exactly is the scenario you're talking about?
>
> In my case, we're talking about a system that has dozens of Java
> processes, many of which access the database. Because the system used
> to have autocommit on, one process could do the "insert nextval" and
> commit, and then another process could do an "insert nextval" and
> commit, and then the first process would do the "select currval" and
> would probably get the wrong value.
From Dave's comment, I gather that those processes return the connection to the pool and grab a new one between the "insert nextval" and "select currval" steps? Yeah, I can see the problem in that case.
-- 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 cleanlyReceived on Wed Feb 20 08:52:50 2008
This archive was generated by hypermail 2.1.8 : Wed Jun 18 2008 - 23:45:12 EDT
|
Contact Us Legal Notices Order Services Online Pantek Home Privacy Policy IT news Site Map Pantek Library |