users@glassfish.java.net

autoCommit issue

From: <forums_at_java.net>
Date: Wed, 18 May 2011 08:20:22 -0500 (CDT)

 Hello,

I am working with MS SQL server and getting an exception saying: "Cannot
invoke a rollback operation when the AutoCommit mode is set to "true"".

Now, I am trying to set the autoCommit to false and just cant find how to do
so. 

I've tryed to add properties to the connection-pool (AutoCommit,
DefaultAutoCommit, SetAutoCommit, RelaxAutoCommit) nothing seem to work.

I also saw that with MySQL you can solve this by adding
"?relaxAutoCommit=true" to the JDBC URL - It didn't work for me with MSSQL.

Can anyone help me?

Thank you all


--
[Message sent by forum member 'idididid']
View Post: http://forums.java.net/node/803342