I am still getting the exception even after changing <local-tx-datasource> to <no-tx-datasource>
My oracle-ds.xml looks like: <?xml version="1.0" encoding="UTF-8"?> <no-tx-datasource> <jndi-name>jdbc/syfact</jndi-name> <connection-url>jdbc:oracle:thin:@172.16.90.112:1521:syfactge</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>abc</user-name> xyz <min-pool-size>5</min-pool-size> <max-pool-size>100</max-pool-size> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> <type-mapping>Oracle9i</type-mapping> </no-tx-datasource> and the exception is: java.sql.SQLException: You cannot commit with autocommit set! at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcComm it(BaseWrapperManagedConnection.java:545) at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConne ction.java:334) at com.syfact.core.util.DBConduit.endTransaction(DBConduit.java:1500)... Thanks and Regards, Amit View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4131873#4131873 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4131873 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user