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
