I cannot help you on this post but am looking for information on setting autocommit.
I'm using the mysql jdbc driver with a local-tx-datasource, Hibernate and cannot turn off auto commit by calling connection.setAutocommit(false). My rollbacks fail because you cannot rollback with autocommit set to true.
If I issue the command SET AUTOCOMMIT=0 at the command line it works just fine.
any help is greatly appreciated.