When I want to roll back a transaction I use this method:
conn.setAutoCommit( false ); .... if ( error ) conn.rollback();
The problem is that I use a mySQL database and have to convert the tables from myISAM to innoDB! I don�t like that, because it gives you some problem when making a copy of the database and open the new database, then all the innoDB tables can�t open again!
Because of that I will hear if there are other ways to make roll back transactions? What about executeBatch()? [ April 10, 2005: Message edited by: Jeppe Fjord ]