You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Yi...@equifax.com on 2006/10/04 03:49:28 UTC

got sql exception:

All,

I got following sql exception during queryforlist.  We are using oracle 
10g.  with ojdbc14.jar.  Thanks for any suggestion or clue.


ERROR|03 Oct 2006 
21:05:14,058|b_Worker-4|b.batch.ErrorRecordReProcessor|Caught Exception 
during procesCommunicationErrorRecords:Failed to queryForList - id 
[selectCommunicationRecords], parameterObject [{processId=3, rows=100, 
recordSeqNbr=1}].  Cause: 
com.ibatis.common.jdbc.exception.NestedSQLException: 
--- The error occurred in 
com/equifax/authentication/ehub/configuration/ehub_batch_sql_statements.xml. 
 
--- The error occurred while applying a parameter map. 
--- Check the selectCommunicationRecords-InlineParameterMap. 
--- Check the statement (query failed). 
--- Cause: java.sql.SQLException: ORA-00600: internal error code, 
arguments: [qerpfAllocateR], [], [], [], [], [], [], []

Caused by: java.sql.SQLException: ORA-00600: internal error code, 
arguments: [qerpfAllocateR], [], [], [], [], [], [], []
|
com.ibatis.dao.client.DaoException: Failed to queryForList - id 
[selectCommunicationRecords], parameterObject [{processId=3, rows=100, 
recordSeqNbr=1}].  Cause: 
com.ibatis.common.jdbc.exception.NestedSQLException: 
--- The error occurred in 
com/equifax/authentication/ehub/configuration/ehub_batch_sql_statements.xml. 
 
--- The error occurred while applying a parameter map. 
--- Check the selectCommunicationRecords-InlineParameterMap. 
--- Check the statement (query failed). 
--- Cause: java.sql.SQLException: ORA-00600: internal error code, 
arguments: [qerpfAllocateR], [], [], [], [], [], [], []

Caused by: java.sql.SQLException: ORA-00600: internal error code, 
arguments: [qerpfAllocateR], [], [], [], [], [], [], []

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: 
--- The error occurred in 
com/equifax/authentication/ehub/configuration/ehub_batch_sql_statements.xml. 
 
--- The error occurred while applying a parameter map. 
--- Check the selectCommunicationRecords-InlineParameterMap. 
--- Check the statement (query failed). 
--- Cause: java.sql.SQLException: ORA-00600: internal error code, 
arguments: [qerpfAllocateR], [], [], [], [], [], [], []

Caused by: java.sql.SQLException: ORA-00600: internal error code, 
arguments: [qerpfAllocateR], [], [], [], [], [], [], []

                 at 
com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:205)
                 at 
com.equifax.authentication.ehub.persistence.batch.BatchSqlMapDao.getCommunicationErrorRecords(BatchSqlMapDao.java:413)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method)
                 at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:585)
                 at 
com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
                 at $Proxy16.getCommunicationErrorRecords(Unknown Source)
                 at 
com.equifax.authentication.ehub.batch.ErrorRecordReProcessor.retrieveCommunicationErrorRecords(ErrorRecordReProcessor.java:212)
                 at 
com.equifax.authentication.ehub.batch.ErrorRecordReProcessor.processCommunicationErrorRecords(ErrorRecordReProcessor.java:157)
                 at 
com.equifax.authentication.ehub.batch.ErrorRecordReProcessor.process(ErrorRecordReProcessor.java:86)
                 at 
com.equifax.authentication.ehub.batch.impl.BatchFileProcessHandlerImpl.process(BatchFileProcessHandlerImpl.java:125)
                 at 
com.equifax.authentication.ehub.job.BatchInputProcessJob.performJob(BatchInputProcessJob.java:120)
                 at com.equifax.scheduler.JobBase.execute(JobBase.java:68)
                 at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                 at 
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520