I had a similar problem with Geronimo 1.1 and with WASCE 1.1 when using the generic TranQL connector. I ended up using WASCE 1.1.0.1 instead because they have DB2 specific TranQL connectors. When I used those, the rollback worked as expected.
On 11/28/06, Arunanthisivam Vimalathithen <[EMAIL PROTECTED]> wrote:
Hi, I am using the provided TranQL connectors for the datasource and the problem I faced seemed to be connected with the TranQL connector which seems to be setting auto commit to true. I was asked to file a JIRA on this ( http://issues.apache.org/jira/browse/GERONIMO-2576). There have been not any responses to that and I also could not make any headway into the issue so far. Thanks and regards, Vimalan On 11/28/06, Meenakshi <[EMAIL PROTECTED]> wrote: > > Hi Arunanthisivam, > > Were you able to debug the problem? I am also facing a similar error > wherein I > have set autocommit to false in the application and I am using DB2 9.1 > universal JDBC drivers...and I get the same error..as below: > > com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][10114][10307] Invalid > operation: Explicit COMMIT or ROLLBACK is not allowed when in > auto-commit mode. > at com.ibm.db2.jcc.c.p.rollback(p.java:752) > at com.ibm.db2.jcc.c.gc.rollback(gc.java:162) > at > com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions > (WSRdbManagedConnectionImpl.java :3663) > at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup > (WSRdbManagedConnectionImpl.java:3143) > at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1416) > at com.ibm.ejs.j2c.FreePool.returnToFreePool (FreePool.java:475) > at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1598) > at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java > :2237) > at com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletion > (LocalTransactionWrapper.java:1228) > at > com.ibm.ws.LocalTransaction.LocalTranCoordImpl.informSynchronizations > (LocalTranCoordImpl.java:1488) > at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup > (LocalTranCoordImpl.java:1196) > at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.end > (LocalTranCoordImpl.java:1301) > at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:731) > at com.ibm.ejs.csi.BeanManaged.postInvoke (BeanManaged.java:343) > at com.ibm.ejs.csi.TransactionControlImpl.postInvoke > (TransactionControlImpl.java:581) > at com.ibm.ejs.container.EJSContainer.postInvoke > (EJSContainer.java:3876) > at com.ibm.ejs.container.EJSContainer.postInvoke > (EJSContainer.java:3698) > at > > com.ibm.websphere.startupservice.EJSRemoteStatefulAdminServiceStartup_36ac1ed1 > . > start(Unknown Source) > at com.ibm.websphere.startupservice._AppStartUp_Stub.start > (_AppStartUp_Stub.java:252) > at com.ibm.ws.startupservice.StartBeanInfo.start > (StartBeanInfo.java:287) > at com.ibm.ws.startupservice.StartUpModule.appStart > (StartUpModule.java:152) > at com.ibm.ws.startupservice.StartUpApplication.start > (StartUpApplication.java:105) > at com.ibm.ws.startupservice.StartUpService.stateChanged > (StartUpService.java:461) > at com.ibm.ws.runtime.component.ApplicationMgrImpl.stateChanged > (ApplicationMgrImpl.java:1247) > at > > com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectEvent > (DeployedApplicationImpl.java:1112) > at com.ibm.ws.runtime.component.DeployedApplicationImpl.setState > (DeployedApplicationImpl.java:232) > at com.ibm.ws.runtime.component.DeployedApplicationImpl.setState > (DeployedApplicationImpl.java:227) > at com.ibm.ws.runtime.component.DeployedApplicationImpl.start > (DeployedApplicationImpl.java:826) > at > com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication > (ApplicationMgrImpl.java:948) > at > com.ibm.ws.runtime.component.ApplicationMgrImpl$AppInitializer.run > (ApplicationMgrImpl.java:2114) > at > com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run > (WsComponentImpl.java:340) > at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1499) > > Please let me know if you got the solution to the problem. > > Thanks, > Meenakshi > > > >
