0 Replies Latest reply on Aug 27, 2003 6:52 AM by firsttimer

    Oracle no-tx-datasource DS

    firsttimer Newbie

      Hello,
      The following is my datasource conf:

      <no-tx-datasource>
      <jndi-name>DataS</jndi-name>
      <connection-url>jdbc:oracle:oci8:@db</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>door</user-name>
      word
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

      <!-- Connection pooling parameters -->
      <min-pool-size>5</min-pool-size>
      <max-pool-size>100</max-pool-size>
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>

      </no-tx-datasource>


      My problem is although I have setup this datasource as no-tx-datasource, I still get the exception "java.sql.SQLException: You cannot commit with autocommit set!" when I try using connection.setAutoCommit(false);

      -Thanks in advance