Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to configure connection autocommit=false?

 
Max Bogdanov
Greenhorn
Posts: 11
C++ Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic