Re: ejb transaction exception..!!

[David Jencks]

What are you using for your rar to connect to oracle?  I wonder if you are using a tranql adapter that closes the connection whenever there is an sql error.  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]                           Transaction       - Unexpected exception rolling back [EMAIL PROTECTED]; continuing with rollback  javax.transaction.xa.XAException             at org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:88)             at org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:542)             at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:446)             at org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:155)             at org.apache.geronimo.transaction.manager.TransactionManagerImpl$$FastClassByCGLIB$$14ee5fe0.invoke(<generated>)             at net.sf.cglib.reflect.F                ……………….                ……………….   org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:171)             at org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(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       - Unable to roll back transaction  java.lang.IllegalStateException: Status is STATUS_NO_TRANSACTION             at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:438)             at org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(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:[EMAIL PROTECTED]] 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(ContainerPolicy.java:123)         at org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:80)         at org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor.java:82)         at org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)                   …….                   …….    Caused by: javax.ejb.EJBException: Error executing statement: UPDATE AccountDetails SET bankID = CASE WHEN ? THEN ? ELSE bank         at com.infosys.j2ee.setlbank.appservice.accounts.impl.AccountsInfoEJB.credit(AccountsInfoEJB.java:322)                     …….                   ……. Caused by: javax.ejb.FinderException: Error executing statement: UPDATE AccountDetails SET bankID = CASE WHEN ? THEN         at org.openejb.entity.cmp.SingleValuedFinder.execute(SingleValuedFinder.java:83)         at org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java:72)         at org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(ComponentContextInterceptor.java:56)                   …….                   …….   Caused by: org.tranql.ql.QueryException: Error executing statement: UPDATE AccountDetails SET bankID = CASE WHEN ? THEN ? ELSE         at org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java:69)         at org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java:64)     Caused by: java.sql.SQLException: ORA-00920: invalid relational operator                   …….                   …….           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)       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***