Re: JDBC transactions using MySQL / DBCP in Tomcat 5.0.28

2004-11-22 Thread Mark Matthews
-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

Re: JDBC transactions using MySQL / DBCP in Tomcat 5.0.28

2004-11-16 Thread David Boyer
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

RE: JDBC transactions using MySQL / DBCP in Tomcat 5.0.28

2004-11-16 Thread Phillip Qin
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