geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Hogstrom <m...@hogstrom.org>
Subject Re: ORA-12704 error
Date Tue, 13 Dec 2005 07:18:50 GMT
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
> (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


Mime
View raw message