View Single Post
  #1 (permalink)  
Old March 23rd, 2006, 08:31 AM
satyr satyr is offline
Registered User
 
Join Date: Mar 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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 !!!

Reply With Quote