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