This content has been marked as final.
Show 1 reply
-
1. Re: local-tx-datasource and autocommit
mikevmoran Feb 9, 2006 5:19 PM (in response to jobo)Jobo,
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.