-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Trond G. Ziarkowski wrote:
Hi all!
In my webapp I do two db inserts into two different tables. If the
second one fails I want to rollback the first one. My code is something
like the following:
Connection con = gotten from jndi DataSource
Hi all!
In my webapp I do two db inserts into two different tables. If the
second one fails I want to rollback the first one. My code is something
like the following:
Connection con = gotten from jndi DataSource
DBBean db = new DBBean(con);
try {
con.setAutoCommit(false);
Object o =
Prior to your first insert, do you need to execute an SQL Start
transaction? Otherwise, it sounds like autocommit will revert to the
default start of true.
http://dev.mysql.com/doc/mysql/en/COMMIT.html
[EMAIL PROTECTED] 11/16/2004 12:14:13 PM
Hi all!
In my webapp I do two db inserts into
Shouldn't jdbc 3.0 do the trick?
-Original Message-
From: David Boyer [mailto:[EMAIL PROTECTED]
Sent: November 16, 2004 3:35 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: JDBC transactions using MySQL / DBCP in Tomcat 5.0.28
Prior to your first insert, do you need to execute