1 Reply Latest reply on May 19, 2009 6:41 PM by Peter Johnson

    Issue with JBoss JNDI Data Source Autocommit Feature

    NIranjan Nanda Apprentice


      In my current project, we are using JBoss 5 GA application server. For database interactions, we are using JNDI data source configured in JBoss AS. I am trying to configure the Autocommit to "FALSE", however, it is not happening. Even if I have put the required configuration in my oracle-ds.xml file, the autocommit seems to be in TRUE state and all my inserts are commited automatically in the DB. Please see below my configuration of oracle-ds.xml file.

      <?xml version="1.0" encoding="UTF-8"?>
       <!-- The minimum connections in a pool/sub-pool -->
       <!-- The maximum connections in a pool/sub-pool -->
       <!-- The time before an unused connection is destroyed -->
       <!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use -->
       <!-- ORACLE benefits from prepared statement caching -->
       <!-- Connection Properties -->
       <connection-property name="auto-commit">false</connection-property>

      This seems to be very strange. Is this a BUG in Jboss? Or I am missing any configuration? Please HELP.