I have an enterprise application [.ear].
The environment as follows:
a. Oracle9i
b. Geronimo1.0M5
c. JDK 1.4.2
d. Fedora core Release 3
Previously i got an issue ''ORA-00920 SQL Exception
and then i got to know that the bug is fixed, and added the classes OracleDBSyntaxFactory.java OracleGenerator.java OracleEJBQLCompilerFactory.java
to tranql.jar and added the snippet
<ejb-ql-compiler-factory>org.tranql.ejbcompiler.OracleEJBQLCompilerFactory</ejb-ql-compiler-factory>
<db-syntax-factory>org.tranql.sql.oracle.OracleDBSyntaxFactory</db-syntax-factory>
to openejb-jar.xml and this resolved the error
Now the error has been changed to following:
16:29:20,924 WARN [SystemExceptionInterceptor] MySecuritySession
javax.transaction.SystemException: Unable to commit container transaction
at org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(InheritableTransactionContext.java:327)
at org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:199)
at org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(InheritableTransactionContext.java:146)
at org.openejb.transaction.ContainerPolicy$TxRequiresNew.invoke(ContainerPolicy.java:246)
at org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:80)
at org.openejb.slsb.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:98)
at org.openejb.transaction.ContainerPolicy$TxRequiresNew.invoke(ContainerPolicy.java:234)
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)
at org.openejb.server.ejbd.EjbRequestHandler.invoke(EjbRequestHandler.java:297)
at org.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD(EjbRequestHandler.java:325)
at org.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:196)
at org.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:150)
at org.openejb.server.ejbd.EjbServer.service(EjbServer.java:87)
at org.openejb.server.ejbd.EjbServer$$FastClassByCGLIB$$d379d2ff.invoke(<generated>)
at net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
at org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke(FastMethodInvoker.java:38)
at org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:118)
at org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:760)
at org.apache.geronimo.gbean.runtime.RawInvoker.invoke(RawInvoker.java:57)
at org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke(RawOperationInvoker.java:36)
at org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept(ProxyMethodInterceptor.java:96)
at org.activeio.xnet.ServerService$$EnhancerByCGLIB$$b99e9050.service(<generated>)
at org.activeio.xnet.ServicePool$2.run(ServicePool.java:67)
at org.activeio.xnet.ServicePool$3.run(ServicePool.java:90)
at org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run(ThreadPool.java:138)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.tranql.ql.QueryException: Error executing statement: UPDATE USER_INFO SET OU_ID = CASE WHEN 1 = ? THEN ? ELSE OU_ID END, BUSINESS_PARTY_ID = CASE WHEN 1 = ? THEN ? ELSE BUSINESS_PARTY_ID END, LOCALE_CODE = CASE WHEN 1 = ? THEN ? ELSE LOCALE_CODE END, USER_F_NAME = CASE WHEN 1 = ? THEN ? ELSE USER_F_NAME END, USER_L_NAME = CASE WHEN 1 = ? THEN ? ELSE USER_L_NAME END, EMAIL_ID = CASE WHEN 1 = ? THEN ? ELSE EMAIL_ID END, TELEPHONE = CASE WHEN 1 = ? THEN ? ELSE TELEPHONE END, STREET = CASE WHEN 1 = ? THEN ? ELSE STREET END, CITY = CASE WHEN 1 = ? THEN ? ELSE CITY END, STATE = CASE WHEN 1 = ? THEN ? ELSE STATE END, COUNTRY = CASE WHEN 1 = ? THEN ? ELSE COUNTRY END, POSTAL_CODE = CASE WHEN 1 = ? THEN ? ELSE POSTAL_CODE END, CREATED_BY = CASE WHEN 1 = ? THEN ? ELSE CREATED_BY END, CREATED_DATE = CASE WHEN 1 = ? THEN ? ELSE CREATED_DATE END, UPDATED_BY = CASE WHEN 1 = ? THEN ? ELSE UPDATED_BY END, UPDATED_DATE = CASE WHEN 1 = ? THEN ? ELSE UPDATED_DATE END, LOGIN_NAME = CASE WHEN 1 = ? THEN ? ELSE LOGIN_NAME END, LOGIN_PASSWORD = CASE WHEN 1 = ? THEN ? ELSE LOGIN_PASSWORD END, ACTIVE_FLAG = CASE WHEN 1 = ? THEN ? ELSE ACTIVE_FLAG END, USER_LOCK = CASE WHEN 1 = ? THEN ? ELSE USER_LOCK END, PASSWORD_MODIFIED_DATE = CASE WHEN 1 = ? THEN ? ELSE PASSWORD_MODIFIED_DATE END, USER_ADMIN_FLAG = CASE WHEN 1 = ? THEN ? ELSE USER_ADMIN_FLAG END, SECRET_QUESTION = CASE WHEN 1 = ? THEN ? ELSE SECRET_QUESTION END, SECRET_ANSWER = CASE WHEN 1 = ? THEN ? ELSE SECRET_ANSWER END, WHEN 1 = ? THEN ? ELSE ONE_TIME_PASSWORD_FLAG END WHERE USER_ID = ?
at org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java:69)
at org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java:61)
at org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java:46)
at org.tranql.cache.InTxCache.flush(InTxCache.java:85)
at org.apache.geronimo.transaction.context.AbstractTransactionContext.flushState(AbstractTransactionContext.java:115)
at org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:175)
... 27 more
Caused by: java.sql.SQLException: ORA-12704: character set mismatch
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:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:103)
at org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java:67)
... 32 more
16:29:20,927 DEBUG [EjbRequestHandler] EJB RESPONSE: EJB_SYS_EXCEPTION:java.rmi.RemoteException: The bean encountered a non-application exception. method; nested exception is:
javax.transaction.SystemException: Unable to commit container transaction
16:29:21,012 DEBUG [EjbRequestHandler] setting cl=[org.apache.geronimo.kernel.config.MultiParentClassLoader id=MyApp-ear] for geronimo.server:EJBModule=MyApp.jar,J2EEApplication=MyApp-ear,J2EEServer=geronimo,j2eeType=StatelessSessionBean,name=MySecuritySession
Can anyone pl help me what went wrong?
Thanks In Advance,
Deepesh
| This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.com |
