wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes How to configure connection autocommit=false? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "How to configure connection autocommit=false?" Watch "How to configure connection autocommit=false?" New topic
Author

How to configure connection autocommit=false?

Max Bogdanov
Greenhorn

Joined: Mar 12, 2011
Posts: 11

Hello,
I am using Resin AS (4.18), MSSQL Server(2005) and Hibernate as JPA provider. How to configure connection autocommit=false? By default it's true.
Datasource configuration from resin.xml:


Test code from a servlet:


Output:
[12-09-10 13:04:01.516] [WARNING] [com.jp.web.TestServlet] [#22] > autocommit=true

As a result I cannot use transactions in my application, then I try to rollback the transaction I receive exception:
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot invoke a rollback operation when the AutoCommit mode is set to "true".
...

I can't use conn.setAutoCommit(false); method directly as I use hibernate as JPA provider.

Thanks.

OC-JA,OCP-JP,OCP-JWCD,OCE-EJBD,OCE-JPAD
 
jQuery in Action, 2nd edition
 
subject: How to configure connection autocommit=false?
 
Similar Threads
Importance of jbossjta-properties.xml
JNDI Mapping for oracle datasource
Resin DB-pooling + authentication. HELP!
JBOSS startup error
Getting JNDI to work on Resin 2.1.14