Deepesh, I Google'd the error your getting and many of the entries had some information about NLS settings. Can you provide more detail about your environment? (Lnguage settings, Locale, etc.) Matt deepesh wrote: > Hi, > > 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 > > factory>org.tranql.ejbcompiler.OracleEJBQLCompilerFactory compiler-factory> > org.tranql.sql.oracle.OracleDBSyntaxFactory 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 > () > 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 > () > 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, ONE_TIME_PASSWORD_FLAG = CASE 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