From user-return-3309-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org Thu May 11 06:03:07 2006 Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 24101 invoked from network); 11 May 2006 06:03:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 11 May 2006 06:03:04 -0000 Received: (qmail 60977 invoked by uid 500); 10 May 2006 20:57:01 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 60949 invoked by uid 500); 10 May 2006 20:57:01 -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 60930 invoked by uid 99); 10 May 2006 20:57:00 -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 13:57:00 -0700 X-ASF-Spam-Status: No, hits=1.5 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_WHOIS,HTML_MESSAGE,HTML_TAG_EXIST_TBODY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [216.136.174.115] (HELO smtp018.mail.yahoo.com) (216.136.174.115) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 10 May 2006 13:56:59 -0700 Received: (qmail 68739 invoked from network); 10 May 2006 20:56:38 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:Mime-Version:In-Reply-To:References:Content-Type:Message-Id:From:Subject:Date:To:X-Mailer; b=JN0UyXS4vRmjKFUrIuD/TYUgvE6IbRDnHgCdd9hXsrnPONNcEjF0wyh5FgcXliEgf78UmA5pZ8LkzudEoUTS9RFTtNKkbf16pqrFhD/Xgm5FIx7iwXDe1HECHrDRZcJGQEoBzhrxmnVWciI0GIkpy54LN31lKAgf6qinFV98ruQ= ; Received: from unknown (HELO ?192.168.1.5?) (david?jencks@66.93.38.137 with plain) by smtp018.mail.yahoo.com with SMTP; 10 May 2006 20:56:36 -0000 Mime-Version: 1.0 (Apple Message framework v746.2) In-Reply-To: <4690875E336998438DF43A78B8E38CF2E4F571@BLRKECMSG01.ad.infosys.com> References: <4690875E336998438DF43A78B8E38CF2E4F571@BLRKECMSG01.ad.infosys.com> Content-Type: multipart/alternative; boundary=Apple-Mail-11--663805093 Message-Id: <2D8FFF54-CEEF-412A-94D9-F1A30E3E679C@yahoo.com> From: David Jencks Subject: Re: ejb transaction exception..!! Date: Wed, 10 May 2006 13:56:43 -0700 To: user@geronimo.apache.org X-Mailer: Apple Mail (2.746.2) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --Apple-Mail-11--663805093 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes; format=flowed What are you using for your rar to connect to oracle? I wonder if =20 you are using a tranql adapter that closes the connection whenever =20 there is an sql error. I'm not quite sure which connector does what =20 at this point, so knowing which one you are using would be helpful. thanks david jencks On May 10, 2006, at 4:46 AM, Santosh Koti wrote: > > Got thru the exception, by setting the alternate ejb-ql for Oracle =20 > in the deployment plan. > > > But now I am facing this exception: > > > > > 332604 ERROR [http-0.0.0.0-8081-=20 > Processor23] Transaction - =20 > Unexpected exception rolling back =20 > org.apache.geronimo.connector.outbound.LocalXAResource@1cbbbe6d; =20 > continuing with rollback > > javax.transaction.xa.XAException > > at =20 > org.apache.geronimo.connector.outbound.LocalXAResource.rollback=20 > (LocalXAResource.java:88) > > at =20 > org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResour=20= > ces(TransactionImpl.java:542) > > at =20 > org.apache.geronimo.transaction.manager.TransactionImpl.rollback=20 > (TransactionImpl.java:446) > > at =20 > org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollbac=20= > k(TransactionManagerImpl.java:155) > > at =20 > org.apache.geronimo.transaction.manager.TransactionManagerImpl$=20 > $FastClassByCGLIB$$14ee5fe0.invoke() > > at net.sf.cglib.reflect.F > > =85=85=85=85=85=85. > > =85=85=85=85=85=85. > > > org.apache.geronimo.transaction.context.InheritableTransactionContext.=20= > complete(InheritableTransactionContext.java:171) > > at =20 > org.apache.geronimo.transaction.context.InheritableTransactionContext.=20= > commit(InheritableTransactionContext.java:146) > > =85=85=85=85=85=85. > > =85=85=85=85=85=85. > > > Caused by: Unable to rollback > > at =20 > org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollba=20= > ck(ManagedJDBCConnection.java:113) > > > =85=85=85=85=85=85. > > =85=85=85=85=85=85. > > > Caused by: java.sql.SQLException: Closed Connection > > at oracle.jdbc.dbaccess.DBError.throwSqlException=20 > (DBError.java:134) > > at oracle.jdbc.dbaccess.DBError.throwSqlException=20 > (DBError.java:179) > > =85=85=85=85=85=85. > > =85=85=85=85=85=85. > > > > 332604 ERROR [http-0.0.0.0-8081-Processor23] =20 > org.apache.geronimo.transaction.context.AbstractTransactionContext =20= > - Unable to roll back transaction > > java.lang.IllegalStateException: Status is STATUS_NO_TRANSACTION > > at =20 > org.apache.geronimo.transaction.manager.TransactionImpl.rollback=20 > (TransactionImpl.java:438) > > at =20 > org.apache.geronimo.transaction.context.InheritableTransactionContext.=20= > rollbackAndThrow(InheritableTransactionContext.java:308) > > > > > > PS: Is this due to some configuration problem in the ejb-qls=85??? =20 > That is my guess, I am not sure, yet to test it also=85! > > Meanwhile , if some 1 can give the clue, it would be =20 > 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.TransactionRolledbackLocalException > > at org.openejb.transaction.ContainerPolicy$TxRequired.invoke=20= > (ContainerPolicy.java:123) > > at =20 > org.openejb.transaction.TransactionContextInterceptor.invoke=20 > (TransactionContextInterceptor.java:80) > > at org.openejb.SystemExceptionInterceptor.invoke=20 > (SystemExceptionInterceptor.java:82) > > at org.openejb.GenericEJBContainer.invoke=20 > (GenericEJBContainer.java:238) > > =85=85. > > =85=85. > > > Caused by: javax.ejb.EJBException: Error executing statement: =20 > UPDATE AccountDetails SET bankID =3D CASE WHEN ? THEN ? ELSE bank > > at =20 > com.infosys.j2ee.setlbank.appservice.accounts.impl.AccountsInfoEJB.cre=20= > dit(AccountsInfoEJB.java:322) > > > =85=85. > > =85=85. > > Caused by: javax.ejb.FinderException: Error executing statement: =20 > UPDATE AccountDetails SET bankID =3D CASE WHEN ? THEN > > at org.openejb.entity.cmp.SingleValuedFinder.execute=20 > (SingleValuedFinder.java:83) > > at org.openejb.dispatch.DispatchInterceptor.invoke=20 > (DispatchInterceptor.java:72) > > at =20 > org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke=20 > (ComponentContextInterceptor.java:56) > > =85=85. > > =85=85. > > > Caused by: org.tranql.ql.QueryException: Error executing statement: =20= > UPDATE AccountDetails SET bankID =3D CASE WHEN ? THEN ? ELSE > > at org.tranql.sql.jdbc.JDBCUpdateCommand.execute=20 > (JDBCUpdateCommand.java:69) > > at org.tranql.cache.SimpleFlushStrategy.flush=20 > (SimpleFlushStrategy.java:64) > > > > Caused by: java.sql.SQLException: ORA-00920: invalid relational =20 > operator > > =85=85. > > =85=85. > > > at oracle.jdbc.dbaccess.DBError.throwSqlException=20 > (DBError.java:134) > > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) > > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) > > > > > I think the key word : =91CASE=92 is giving problem, because it is = not =20 > been recognized by Oracle during the execution of the query. > > > But any ways to remove that , or can any1 suggest some workarounds =20= > which will be of great help=85!! > > 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 =20 > intended solely for the use of the addressee(s). If you are not the =20= > intended recipient, please notify the sender by e-mail and delete =20 > the original message. Further, you are not to copy, disclose, or =20 > distribute this e-mail or its contents to any other person and any =20 > such actions are unlawful. This e-mail may contain viruses. Infosys =20= > has taken every reasonable precaution to minimize this risk, but is =20= > not liable for any damage you may sustain as a result of any virus =20 > in this e-mail. You should carry out your own virus checks before =20 > opening the e-mail or attachment. Infosys reserves the right to =20 > monitor and review the content of all messages sent to or from this =20= > e-mail address. Messages sent to or from this e-mail address may be =20= > stored on the Infosys e-mail system. > ***INFOSYS******** End of Disclaimer ********INFOSYS*** > --Apple-Mail-11--663805093 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=WINDOWS-1252 What are you using for your rar = to connect to oracle?=A0 I wonder if you are using a tranql adapter that = closes the connection whenever there is an sql error.=A0 I'm not quite = sure which connector does what at this point, so knowing which one you = are using would be helpful.

thanks
david = jencks

On May 10, 2006, = at 4:46 AM, Santosh Koti wrote:

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]=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Transaction=A0=A0=A0=A0=A0=A0 - = Unexpected exception rolling back = org.apache.geronimo.connector.outbound.LocalXAResource@1cbbbe6d; = continuing with rollback

=A0javax.transaction.xa.XAException

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 at = org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXARes= ource.java:88)

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

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 at = org.apache.geronimo.transaction.manager.TransactionImpl.rollback(Transacti= onImpl.java:446)

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 at = org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(Tr= ansactionManagerImpl.java:155)

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 at = org.apache.geronimo.transaction.manager.TransactionManagerImpl$$FastClassB= yCGLIB$$14ee5fe0.invoke(<generated>)

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

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =85=85=85=85=85=85.

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 =85=85=85=85=85=85.

org.apache.geronimo.transaction.context.InheritableTransactionContext.co= mplete(InheritableTransactionContext.java:171)

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 at = org.apache.geronimo.transaction.context.InheritableTransactionContext.comm= it(InheritableTransactionContext.java:146)

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =85=85=85=85=85=85.

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 =85=85=85=85=85=85.

Caused by: Unable to rollback

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 at = org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(M= anagedJDBCConnection.java:113)

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =85=85=85=85=85=85.

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 =85=85=85=85=85=85.

Caused by: java.sql.SQLException: Closed = Connection

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

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

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 =85=85=85=85=85=85.

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =85=85=85=85=85=85.

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

=A0java.lang.IllegalStateException: Status is = STATUS_NO_TRANSACTION

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 at = org.apache.geronimo.transaction.manager.TransactionImpl.rollback(Transacti= onImpl.java:438)

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 at = org.apache.geronimo.transaction.context.InheritableTransactionContext.roll= backAndThrow(InheritableTransactionContext.java:308)<= /P>

=A0

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

=A0 =A0=A0=A0=A0=A0=A0=A0= 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-----
Santosh Koti [mailto:Santosh_Koti@infosys.com]
Wednesday, May = 10, 2006 12:40 PM
user@geronimo.apache.org
ejb transaction = exception..!!

Hi Folks,

=A0

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

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

=A0=A0=A0=A0=A0=A0=A0 at = org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy.= java:123)

=A0=A0=A0=A0=A0=A0=A0 at = org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionCo= ntextInterceptor.java:80)

=A0=A0=A0 =A0=A0=A0=A0at = org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor.j= ava:82)

=A0=A0=A0=A0=A0=A0=A0 at = org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)

=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =85=85.

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =85=85.

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

=A0=A0=A0=A0=A0=A0=A0 at = com.infosys.j2ee.setlbank.appservice.accounts.impl.AccountsInfoEJB.credit(= AccountsInfoEJB.java:322)

=A0

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =85=85.

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =A0=A0=85=85.

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

=A0=A0=A0=A0=A0=A0=A0 at = org.openejb.entity.cmp.SingleValuedFinder.execute(SingleValuedFinder.java:= 83)

=A0=A0=A0=A0=A0=A0=A0 at = org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java:7= 2)

=A0=A0=A0=A0=A0=A0=A0 at = org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compone= ntContextInterceptor.java:56)

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =85=85.

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =A0=A0=85=85.

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

=A0=A0=A0=A0=A0=A0=A0 at = org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java:69)

=A0=A0=A0=A0=A0=A0=A0= at = org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java:64)

=A0

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

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =85=85.

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =A0=A0=A0=85=85.

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

=A0=A0=A0=A0=A0=A0=A0= at = oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)=

=A0=A0=A0=A0=A0=A0=A0 at = oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)

=A0
=A0

I think the key word : =91CASE=92 = =A0is 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 =A0workarounds which will be of great = help=85!!

I tried many options , but no luck = L

Thanks,

Santosh.

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

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***


= --Apple-Mail-11--663805093--