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