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 !!!
|