4 Replies Latest reply on Jan 15, 2004 4:41 AM by btal

    How to set my Datasource with autoCommit = false ?

    btal Newbie

      I am using JBoss 4 and I configured my data source this way:


      <no-tx-datasource>
      <jndi-name>appilogDataSource</jndi-name>
      <connection-url>jdbc:oracle:thin:@localhost:1521:TB</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <min-pool-size>10</min-pool-size>
      <max-pool-size>40</max-pool-size>
      <user-name>xxx</user-name>
      xxx
      </no-tx-datasource>

      Every time that I try to get a connection the autoCommit property is being set to "true" by default.

      I tried adding this line to the datasource:
      <connection-property name="autoCommit">false</connection-property>
      It didnt help either.

      Any help would be great. Thanks.