transaction .... shmansaction

[Dave Wingate]

Howdy all,

I'm taking my first stab at using transactions with JDBC code. I found this article from sun, but the code's not working for me:

 
try {
con = getConnection();
con.setAutoCommit(false);

Address userPersonAddress = new Address(req);
userPersonAddress.save(con);
Person userPerson = new Person(req, userPersonAddress.getAddressId(), -1);
userPerson.save(con);

// hack to test transactions
if (true) throw new Exception("fake exception");

User user = new User(req, userPerson.getPerId()); 
user.save(con);
userPerson.setCreatedByUserId(user.getUserId());
userPerson.save(con);

con.commit();
con.setAutoCommit(true);

}
catch (Exception e) {
 
try { if (con != null) con.rollback(); } catch (SQLException sqle) { ; /*do nothing*/ }

e.printStackTrace();
addError(req, e.getMessage());
return false;
}
  

I used a debugger to confirm that the rollback() method is getting executed, but I still end up with new DB rows.

I'm using MySQL for my DB. Could that be the problem? I'd appreciate any advice that the ranchers may have.

[Paul Sturrock]

I'm using MySQL for my DB. Could that be the problem?

Probably. If you want to use transactional stuff you need to make sure you are using a database which supports them. Some of the MySQL database engines (including the default ISAM) amazingly don't. Create your table using one of the db engines that supports transactions and you should be OK.

[Bryan Scarbrough]

Probably. If you want to use transactional stuff you need to make sure you are using a database which supports them.

MySQL 4.0.x.x does support transactions, BUT, you must use the InnoDB table type.