[jboss-user] [JCA/JBoss] - Re: autocommit question

[amit4uall]

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