Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 59495 invoked from network); 29 Nov 2006 22:42:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Nov 2006 22:42:16 -0000 Received: (qmail 56511 invoked by uid 500); 29 Nov 2006 22:42:23 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 56336 invoked by uid 500); 29 Nov 2006 22:42:22 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 56325 invoked by uid 99); 29 Nov 2006 22:42:22 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Nov 2006 14:42:22 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of dccarew@gmail.com designates 64.233.162.230 as permitted sender) Received: from [64.233.162.230] (HELO nz-out-0102.google.com) (64.233.162.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Nov 2006 14:42:11 -0800 Received: by nz-out-0102.google.com with SMTP id j2so1213632nzf for ; Wed, 29 Nov 2006 14:41:51 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=R9rRtqHSnDyK+lN7/Dx1C/pWIcv2OT5f9+4eQ32NqKi7aszjJpNUXwbNWeiD7lLXXpPEotfjt2KUnU5rvIj3d264P8JINqPVWkUijYPIIourkHHr9kvJ0ZUFIRojNEzIZ1odSlT9QXze7Ikcg+1D4QRfl8NjTWSG5gzFBKzQT8I= Received: by 10.35.119.11 with SMTP id w11mr2431568pym.1164840111095; Wed, 29 Nov 2006 14:41:51 -0800 (PST) Received: by 10.35.88.20 with HTTP; Wed, 29 Nov 2006 14:41:50 -0800 (PST) Message-ID: <419beb980611291441y82bcaffib3276c4ea46dfaf4@mail.gmail.com> Date: Wed, 29 Nov 2006 16:41:51 -0600 From: "David Carew" To: user@geronimo.apache.org Subject: Re: Rollbacks at database level throws exception in Geronimo In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17742_16565677.1164840111017" References: X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_17742_16565677.1164840111017 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 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 > > > > > > > > > ------=_Part_17742_16565677.1164840111017 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 <vimalathithen@gmail.com> 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 <meenakshijai@yahoo.com > 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





------=_Part_17742_16565677.1164840111017--