Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 17860 invoked from network); 10 May 2006 15:20:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 10 May 2006 15:20:36 -0000 Received: (qmail 34694 invoked by uid 500); 10 May 2006 14:18:33 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 34667 invoked by uid 500); 10 May 2006 14:18:33 -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 34656 invoked by uid 99); 10 May 2006 14:18:33 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 May 2006 07:18:33 -0700 X-ASF-Spam-Status: No, hits=1.6 required=10.0 tests=FUZZY_CREDIT,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [143.182.124.21] (HELO azsmga101-1.ch.intel.com) (143.182.124.21) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 May 2006 07:18:31 -0700 Received: from azsmga001.ch.intel.com ([10.2.17.19]) by azsmga101-1.ch.intel.com with ESMTP; 10 May 2006 07:18:09 -0700 Received: from fmsmsx332.fm.intel.com (HELO fmsmsx332.amr.corp.intel.com) ([132.233.42.148]) by azsmga001.ch.intel.com with ESMTP; 10 May 2006 07:18:09 -0700 X-IronPort-AV: i="4.05,109,1146466800"; d="scan'208,217"; a="34307733:sNHT155392265" Received: from fmsmsx312.amr.corp.intel.com ([132.233.42.227]) by fmsmsx332.amr.corp.intel.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 10 May 2006 07:18:08 -0700 Received: from mssmsx402.ccr.corp.intel.com ([10.125.2.12]) by fmsmsx312.amr.corp.intel.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 10 May 2006 07:18:06 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6743C.8C3D53B4" Subject: RE: ejb transaction exception..!! Date: Wed, 10 May 2006 18:18:03 +0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ejb transaction exception..!! Thread-Index: AcZ0ANJEC3HkSevyQeqYp7g0ZKhdTwAJbibQAAVmI1A= From: "Zakharov, Vasily M" To: X-OriginalArrivalTime: 10 May 2006 14:18:06.0487 (UTC) FILETIME=[8E897270:01C6743C] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C6743C.8C3D53B4 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Santosh, =20 Could you please post here your database deployment plan and the deployment command you use? =20 Vasily Zakharov Intel Middleware Product Division =20 =20 ________________________________ From: Santosh Koti [mailto:Santosh_Koti@infosys.com]=20 Sent: Wednesday, May 10, 2006 3:47 PM To: user@geronimo.apache.org Subject: RE: ejb transaction exception..!! =20 =20 Got thru the exception, by setting the alternate ejb-ql for Oracle in the deployment plan. =20 But now I am facing this exception: =20 =20 =20 332604 ERROR [http-0.0.0.0-8081-Processor23] Transaction - Unexpected exception rolling back org.apache.geronimo.connector.outbound.LocalXAResource@1cbbbe6d; continuing with rollback javax.transaction.xa.XAException at org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAR esource.java:88) at org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResource s(TransactionImpl.java:542) at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(Transac tionImpl.java:446) at org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback( TransactionManagerImpl.java:155) at org.apache.geronimo.transaction.manager.TransactionManagerImpl$$FastClas sByCGLIB$$14ee5fe0.invoke() at net.sf.cglib.reflect.F ................... ................... =20 org.apache.geronimo.transaction.context.InheritableTransactionContext.co mplete(InheritableTransactionContext.java:171) at org.apache.geronimo.transaction.context.InheritableTransactionContext.co mmit(InheritableTransactionContext.java:146) ................... ................... =20 Caused by: Unable to rollback at org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback (ManagedJDBCConnection.java:113) =20 ................... ................... =20 Caused by: java.sql.SQLException: Closed Connection at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) ................... ................... =20 =20 332604 ERROR [http-0.0.0.0-8081-Processor23] org.apache.geronimo.transaction.context.AbstractTransactionContext - Unable to roll back transaction java.lang.IllegalStateException: Status is STATUS_NO_TRANSACTION at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(Transac tionImpl.java:438) at org.apache.geronimo.transaction.context.InheritableTransactionContext.ro llbackAndThrow(InheritableTransactionContext.java:308) =20 =20 =20 =20 PS: Is this due to some configuration problem in the ejb-qls...??? That is my guess, I am not sure, yet to test it also...!=20 Meanwhile , if some 1 can give the clue, it would be great..!! =20 Thanks, Santosh. "Don't talk about yourself; it will be done when you leave. " =20 -----Original Message----- From: Santosh Koti [mailto:Santosh_Koti@infosys.com]=20 Sent: Wednesday, May 10, 2006 12:40 PM To: user@geronimo.apache.org Subject: ejb transaction exception..!! =20 Hi Folks, =20 I am facing a problem in running ejb based transaction. =20 Here is stack trace for my exception (in parts): =20 javax.ejb.TransactionRolledbackLocalException at org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic y.java:123) at org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction ContextInterceptor.java:80) at org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor .java:82) at org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238) ....... ....... =20 Caused by: javax.ejb.EJBException: Error executing statement: UPDATE AccountDetails SET bankID =3D CASE WHEN ? THEN ? ELSE bank at com.infosys.j2ee.setlbank.appservice.accounts.impl.AccountsInfoEJB.credi t(AccountsInfoEJB.java:322) =20 ....... ....... Caused by: javax.ejb.FinderException: Error executing statement: UPDATE AccountDetails SET bankID =3D CASE WHEN ? THEN at org.openejb.entity.cmp.SingleValuedFinder.execute(SingleValuedFinder.jav a:83) at org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java :72) at org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compo nentContextInterceptor.java:56) ....... ....... =20 Caused by: org.tranql.ql.QueryException: Error executing statement: UPDATE AccountDetails SET bankID =3D CASE WHEN ? THEN ? ELSE at org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java:69) at org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java:64) =20 =20 Caused by: java.sql.SQLException: ORA-00920: invalid relational operator ....... ....... =20 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) =20 =20 =20 I think the key word : 'CASE' is giving problem, because it is not been recognized by Oracle during the execution of the query. =20 But any ways to remove that , or can any1 suggest some workarounds which will be of great help...!! I tried many options , but no luck :-( Thanks, Santosh. "Don't talk about yourself; it will be done when you leave. " =20 **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** =09 ------_=_NextPart_001_01C6743C.8C3D53B4 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Santosh,

 =

Could you please = post here your database deployment plan and the deployment command you = use?

 =

Vasily Zakharov

Intel Middleware Product = Division

 =

 =

From: Santosh Koti [mailto:Santosh_Koti@infosys.com]
Sent: Wednesday, May 10, = 2006 3:47 PM
To: = user@geronimo.apache.org
Subject: RE: ejb = transaction exception..!!

 

 

Got thru the = exception, by setting the alternate ejb-ql for Oracle in the deployment = plan.

 

= But now I am facing this exception:

 

 

 

332604 ERROR [http-0.0.0.0-8081-Processor23]       =             &= nbsp;       Transaction       - Unexpected exception = rolling back org.apache.geronimo.connector.outbound.LocalXAResource@1cbbbe6d; continuing with rollback

 javax.trans= action.xa.XAException

   = ;         at org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXARe= source.java:88)

   = ;         at = org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources= (TransactionImpl.java:542)

   = ;         at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(Transact= ionImpl.java:446)

   = ;         at = org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(T= ransactionManagerImpl.java:155)

   = ;         at org.apache.geronimo.transaction.manager.TransactionManagerImpl$$FastClass= ByCGLIB$$14ee5fe0.invoke(<generated>)

   = ;         at net.sf.cglib.reflect.F

   = ;            ……………….

   = ;            ……………….

 

org.apache.geroni= mo.transaction.context.InheritableTransactionContext.complete(Inheritable= TransactionContext.java:171)

   = ;         at org.apache.geronimo.transaction.context.InheritableTransactionContext.com= mit(InheritableTransactionContext.java:146)

   = ;            ……………….

   = ;            ……………….

 

Caused by: = Unable to rollback

   = ;         at org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(= ManagedJDBCConnection.java:113)

 

   = ;            ……………….

   = ;            ……………….

 

Caused by: java.sql.SQLException: Closed Connection

   = ;         at = oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

   = ;         at = oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

   = ;            ……………….

   = ;            ……………….

 

 

332604 ERROR [http-0.0.0.0-8081-Processor23] org.apache.geronimo.transaction.context.AbstractTransactionContext &= nbsp;     - Unable to roll back transaction

 java.lang.I= llegalStateException: Status is STATUS_NO_TRANSACTION

   = ;         at = org.apache.geronimo.transaction.manager.TransactionImpl.rollback(Transact= ionImpl.java:438)

   = ;         at org.apache.geronimo.transaction.context.InheritableTransactionContext.rol= lbackAndThrow(InheritableTransactionContext.java:308)

 

 

 

 

PS: Is this due = to some configuration problem in the ejb-qls…??? That is my guess, I am = not sure, yet to test it also…!

         Meanwhile , if some 1 can give = the clue, it would be great..!!

 

Thanks,

Santosh.

"Don't talk about yourself; it will be done when you leave. = "

 

-----Original Message-----
From: Santosh Koti [mailto:Santosh_Koti@infosys.com]
Sent: Wednesday, May 10, = 2006 12:40 PM
To: = user@geronimo.apache.org
Subject: ejb transaction exception..!!

 

Hi = Folks,

 

I am facing a = problem in running ejb based transaction.

 

Here is stack trace for my exception (in = parts):

 

javax.ejb.T= ransactionRolledbackLocalException

    &nbs= p;   at org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy= .java:123)

    &nbs= p;   at = org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionC= ontextInterceptor.java:80)

        at org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor.= java:82)

    &nbs= p;   at = org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)

    &nbs= p;            = ; …….

    &nbs= p;            = ; …….

 

 Caused by: javax.ejb.EJBException: = Error executing statement: UPDATE AccountDetails SET bankID =3D CASE WHEN ? THEN ? ELSE = bank

    &nbs= p;   at = com.infosys.j2ee.setlbank.appservice.accounts.impl.AccountsInfoEJB.credit= (AccountsInfoEJB.java:322)

 

    &nbs= p;            = ; …….

    &nbs= p;             …….

Caused by: javax.ejb.FinderException: Error = executing statement: UPDATE AccountDetails SET bankID =3D CASE WHEN ? THEN

    &nbs= p;   at org.openejb.entity.cmp.SingleValuedFinder.execute(SingleValuedFinder.java= :83)

    &nbs= p;   at = org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java:= 72)

    &nbs= p;   at = org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compon= entContextInterceptor.java:56)

    &nbs= p;            = ; …….

    &nbs= p;             …….

 

Caused by: org.tranql.ql.QueryException: Error = executing statement: UPDATE AccountDetails SET bankID =3D CASE WHEN ? THEN ? ELSE

    &nbs= p;   at = org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java:69)<= /span>

    &nbs= p;   at = org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java:64)

 

 

Caused by: java.sql.SQLException: ORA-00920: invalid relational = operator

    &nbs= p;            = ; …….

    &nbs= p;             …….

 

    &nbs= p;   at = oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

    &nbs= p;   at = oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)

    &nbs= p;   at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)

 

 

 

I think the = key word : ‘CASE’  is giving = problem, because it is not been recognized by Oracle during the execution of the = query.

 

But any ways = to remove that , or can any1 suggest some  workarounds which will be of great help…!!

I tried many = options , but no luck L

Thanks,

Santosh.

"Don't talk about yourself; it will be done when you leave. = "

 

**************** = CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended = solely for the use of the addressee(s). If you are not the intended = recipient, please notify the sender by e-mail and delete the original = message. Further, you are not to copy, disclose, or distribute this = e-mail or its contents to any other person and any such actions are = unlawful. This e-mail may contain viruses. Infosys has taken every = reasonable precaution to minimize this risk, but is not liable for any = damage you may sustain as a result of any virus in this e-mail. You = should carry out your own virus checks before opening the e-mail or = attachment. Infosys reserves the right to monitor and review the content = of all messages sent to or from this e-mail address. Messages sent to or = from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
------_=_NextPart_001_01C6743C.8C3D53B4--