Hi,



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()?