Matt, my colleague deepesh set the NLS info, but i think didn't get posted. forwardig that...
The v$NLS_PARAMETERS records as follows: PARAMETER VALUE --------------------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_CHARACTERSET WE8ISO8859P1 NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE thanks akshay --- Matt Hogstrom <[EMAIL PROTECTED]> wrote: > 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 > > > > <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, 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 > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
