Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Java and JDK > Pro JSP
|
Pro JSP Advanced JSP coding questions. Beginning questions will be redirected to the Beginning JSP forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro JSP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 23rd, 2006, 08:31 AM
Registered User
 
Join Date: Mar 2006
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 !!!






Similar Threads
Thread Thread Starter Forum Replies Last Post
php and postgresql crmpicco PHP Databases 0 February 23rd, 2007 08:34 AM
tomcat with postgreSQL alejo_torres BOOK: Professional Apache Tomcat 0 October 14th, 2005 09:15 AM
question regarding PostgreSQL Moharo MySQL 2 September 9th, 2003 02:38 AM
Upgrading Postgresql 7.1.3 to 7.3.3 ganesh15 PHP How-To 1 September 3rd, 2003 11:07 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.