RE: got sql exception:

[Yusuf <Yu...@ekalife.co.id>]

as suggested by the exception (ORA-00600), its an internal oracle error,
and not related to ibatis.
you can consult this problem in the metalink or oracle support. cmiiw.

-----Original Message-----
From: Ying.Li@equifax.com [mailto:Ying.Li@equifax.com]
Sent: Wednesday, October 04, 2006 8:49 AM
To: user-java@ibatis.apache.org
Subject: 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(SqlMapDaoT
emplate.java:205)
                at
com.equifax.authentication.ehub.persistence.batch.BatchSqlMapDao.getComm
unicationErrorRecords(BatchSqlMapDao.java:413)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
                at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
                at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.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.retrieveCom
municationErrorRecords(ErrorRecordReProcessor.java:212)
                at
com.equifax.authentication.ehub.batch.ErrorRecordReProcessor.processComm
unicationErrorRecords(ErrorRecordReProcessor.java:157)
                at
com.equifax.authentication.ehub.batch.ErrorRecordReProcessor.process(Err
orRecordReProcessor.java:86)
                at
com.equifax.authentication.ehub.batch.impl.BatchFileProcessHandlerImpl.p
rocess(BatchFileProcessHandlerImpl.java:125)
                at
com.equifax.authentication.ehub.job.BatchInputProcessJob.performJob(Batc
hInputProcessJob.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