I am getting an error from a Session EJB trying to update two distinct Entity EJB's. From the session bean I open a transaction and create two entity objects. But immediately after trying to create the first one I get the following message:
com.evermind.server.rmi.OrionRemoteException: Error allocating db connection: java.sql.SQLException: Calling setAutoCommit(true) on a Connection is not allowed during a global transaction.; nested exception is: java.sql.SQLException: Calling setAutoCommit(true) on a Connection is not allowed during a global transaction.
at com.evermind.server.ApplicationServerTransactionSynchronization.getConnection(ApplicationServerTransactionSynchronization.java:408)
at CWUsuariosHome_EntityHomeWrapper20.create(CWUsuariosHome_EntityHomeWrapper20.java:535)
at com.saniline.catweb.ejb.session.usuarios.UsuariosSessionBean.InsertarUsuario(UsuariosSessionBean.java:59)
at UsuariosSession_StatelessSessionBeanWrapper2.InsertarUsuario(UsuariosSession_StatelessSessionBeanWrapper2.java:81)
at com.saniline.catweb.servlet.ASS.ASS_editSSUserServlet.doPageService(ASS_editSSUserServlet.java:153)
at com.saniline.catweb.servlet.CatalogoWebServlet.doPageService(CatalogoWebServlet.java:168)
at com.saniline.snfw.servlet.SnFwSessionServlet.doPageService(SnFwSessionServlet.java:83)
at com.saniline.snfw.servlet.SnFwServlet.service(SnFwServlet.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.saniline.snfw.servlet.SnFwServlet.service(SnFwServlet.java:54)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:285)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:126)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
I am using JDeveloper 10.1.2.1.
com.evermind.server.rmi.OrionRemoteException: Error allocating db connection: java.sql.SQLException: Calling setAutoCommit(true) on a Connection is not allowed during a global transaction.; nested exception is: java.sql.SQLException: Calling setAutoCommit(true) on a Connection is not allowed during a global transaction.
at com.evermind.server.ApplicationServerTransactionSynchronization.getConnection(ApplicationServerTransactionSynchronization.java:408)
at CWUsuariosHome_EntityHomeWrapper20.create(CWUsuariosHome_EntityHomeWrapper20.java:535)
at com.saniline.catweb.ejb.session.usuarios.UsuariosSessionBean.InsertarUsuario(UsuariosSessionBean.java:59)
at UsuariosSession_StatelessSessionBeanWrapper2.InsertarUsuario(UsuariosSession_StatelessSessionBeanWrapper2.java:81)
at com.saniline.catweb.servlet.ASS.ASS_editSSUserServlet.doPageService(ASS_editSSUserServlet.java:153)
at com.saniline.catweb.servlet.CatalogoWebServlet.doPageService(CatalogoWebServlet.java:168)
at com.saniline.snfw.servlet.SnFwSessionServlet.doPageService(SnFwSessionServlet.java:83)
at com.saniline.snfw.servlet.SnFwServlet.service(SnFwServlet.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.saniline.snfw.servlet.SnFwServlet.service(SnFwServlet.java:54)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:285)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:126)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
I am using JDeveloper 10.1.2.1.