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.