geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Jencks <david_jen...@yahoo.com>
Subject Re: ejb transaction exception..!!
Date Wed, 10 May 2006 20:56:43 GMT
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  
> org.apache.geronimo.connector.outbound.LocalXAResource@1cbbbe6d;  
> 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.rollbackResour 
> ces(TransactionImpl.java:542)
>
>             at  
> org.apache.geronimo.transaction.manager.TransactionImpl.rollback 
> (TransactionImpl.java:446)
>
>             at  
> org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollbac 
> k(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.localTransactionRollba 
> ck(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: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 
> (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.cre 
> dit(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***
>


Mime
View raw message