p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Pro JSP (http://p2p.wrox.com/forumdisplay.php?f=93)
-   -   Postgresql Transactions (http://p2p.wrox.com/showthread.php?t=40264)

satyr March 23rd, 2006 08:31 AM

Postgresql Transactions
 
Hi, I Have this problem using transactions in Jsp Pages , this is a sample of the page used when I hit the button "save":

<%
....
conn.executequery("insert into foo").....
conn.setautocommit(false);
conn.executequery("insert into foo2)....
...
%>
where conn is a Session Connection object

So I launch in the browser the page and hit save; after this
in another browser window I launch the same page and Hit "save", but at this point the program stops at the first line (insert into foo), until I do a commit or rollback on the first browser window.
Why this? I aspect the program stops go on until the third line !!!



All times are GMT -4. The time now is 07:32 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.