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