RE: ejb transaction exception..!!

Santosh Koti Wed, 10 May 2006 07:38:03 -0700

Vasily,

Well I am using was-ce (built on top of Geronimo) , so I am configuring & deploying the db pool from the server gui-console.

Regarding deployment plan , I have deployment plan for each of the components. (All the deployment plans will make the mail look messy J)

Let me know, if u want little more details.

Here is the one I used to get thru my exception.

-------------------------------------------My open-jbjar.xml--------------------------

<?xml version="1.0" encoding="UTF-8"?>

<openejb-jar

xmlns="http://www.openejb.org/xml/ns/openejb-jar-2.0"

xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.0"

xmlns:pkgen="http://www.openejb.org/xml/ns/pkgen-2.0"

xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"

xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.0"

configId="Appservices/Accounts">

<ejb-ql-compiler-factory>org.tranql.ejbqlcompiler.OracleEJBQLCompilerFactory</ejb-ql-compiler-factory>

<db-syntax-factory>org.tranql.sql.oracle.OracleDBSyntaxFactory</db-syntax-factory>

<enterprise-beans>

<ejb-name>AccountsInfoEJB</ejb-name>

<jndi-name>ejb/AccountsInfoEJB</jndi-name>

<ejb-ref>

<ref-name>ejb/AccountDetails</ref-name>

<ejb-link>AccountDetails</ejb-link>

</ejb-ref>

<ejb-ref>

<ref-name>ejb/CustomerEJB</ref-name>

<ejb-link>Customer</ejb-link>

</ejb-ref>

<resource-ref>

<ref-name>testbank</ref-name>

<resource-link>testbank</resource-link>

</resource-ref>

</session>

</enterprise-beans>

</openejb-jar>

-------------------------------------------My open-jbjar.xml--------------------------

Thanks,

Santosh.

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

-----Original Message-----
From: Zakharov, Vasily M [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 7:48 PM
To: [email protected]
Subject: RE: ejb transaction exception..!!

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:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 3:47 PM
To: [email protected]
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] 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: [email protected]
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***

RE: ejb transaction exception..!!

Reply via email to