geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Akshay Panda <axa...@yahoo.com>
Subject Re: ORA-12704 error
Date Sun, 18 Dec 2005 07:25:47 GMT
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 <matt@hogstrom.org> 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 

Mime
View raw message