2 Replies Latest reply on Aug 14, 2006 8:56 PM by Kamalakar Ananthaneni

    JBoss 4.0.2 - You cannot set autocommit during a managed tra

    Andy Andy Newbie

      Dear all,

      JBoss 4.0.2 + JBoss Portal + Oracle

      When I use JBoss Portal (localhost:8080/portal) to call my portlet to do some database access in my JAVA class, it will connect to Oracle database and run the statement ?connection.setAutoCommit(false)?( Because I may need rollback). When I call this statement, there is an error occur as the following:

      java.sql.SQLException: You cannot set autocommit during a managed transaction!
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:462)

      at org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:432)


      Could any one help to suggest some solution?

      If you want to get more detail. Please ask me ! Thank you!

      Remarks: In JBoss, I have oracle-xa-ds.xml in the deploy folder for setting of oracle.