-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 DataSo
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 ex
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 insert
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 = db.get
