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.getSomething(); Object o2 = db.getSomethingElse();
db.doInsert1(params); db.doInsert2(params);
con.commit(); } catch (SQLException sqle) { con.rollback(); throw sqle; } finally { if (con != null) { con.close(); } }
I thought that this should do the trick, but if the second insert fails the data inserted in the first insert are still there. I am using MySQL 4.0.21-7 with InnoDB and have tested that I can use transactions with the MySQL client.
Anyone got any tips?
Regards
Trond
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]