How to set auto-commit to false for all the DataSource connections

Solution Unverified - Updated -

Issue

  • How can i set the auto-commit=false for all the connections available inside the DataSource? When an application gets a connection from the DataSource, I want the retrieved connection to be set to auto-commit=false mode by default

  • I tried adding the following connection property in my oracle-ds.xml, but it does not work.

   <connection-property name="autoCommit">false</connection-property>
  • I am getting
Caused by: java.sql.SQLException: You cannot commit with autocommit set!
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1039)
    at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:757)

Environment

  • JBoss Enterprise Application Platform (EAP)
    • 4.3
    • 5.x
    • 6.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.