geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From deepesh <deepesh.damoda...@cognizant.com>
Subject ORA-12704 error
Date Mon, 12 Dec 2005 10:46:51 GMT

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