informix 11 版 数据清理经常报211、244等错误，寻求解决办法。
2012-11-26 04:00:06.051 ERROR com.csii.batch.job.dataClear.ibs.DailyJnlClearJobService - org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state ; error code [-211]; --- The error occurred in META-INF/config/sql-mapping/sql.xml.
--- The error occurred while executing update.
--- Check the insert into ibsjnlqueryloghist_201210 select * from IBSJNLQUERYLOG where TRANSDATE >= ? AND TRANSDATE < ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQ
.ibs.DailyJnlClearJobService - java.lang.RuntimeException: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state ; error code [-211];
--- The error occurred in META-INF/config/sql-mapping/sql.xml.
--- The error occurred while executing update.
--- Check the insert into ibsjnlqueryloghist_201210 select * from IBSJNLQUERYLOG where TRANSDATE >= ? AND TRANSDATE < ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Cannot read system catalog (sysfragments).;
mework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state ; error code [-244];
--- The error occurred in META-INF/config/sql-mapping/sql.xml.
--- The error occurred while applying a parameter map.
--- Check the batch.getLastTableCount-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Could not do a physical-order read to fetch next row.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in META-INF/config/sql-mapping/sql.xml.
nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in META-INF/config/sql-mapping/sql.xml.
--- The error occurred while executing update.
--- Check the insert into ibsjnlqueryloghist_201210 select * from IBSJNLQUERYLOG where TRANSDATE >= ? AND TRANSDATE < ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Cannot read system catalog (sysfragments).
2012-11-26 04:00:06.054 ERROR com.csii.batch.job.dataClear.ibs.HistoryTableMonthDataClearJobService - org.springfra
-- The error occurred while applying a parameter map.
--- Check the batch.getLastTableCount-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Could not do a physical-order read to fetch next row.
LException: Cannot read system catalog (sysfragments).; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in META-INF/config/sql-mapping/sql.xml.
--- The error occurred while executing update.
--- Check the insert into ibsjnlqueryloghist_201210 select * from IBSJNLQUERYLOG where TRANSDATE >= ? AND TRANSDATE < ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Cannot read system catalog (sysfragments).
2012-11-26 04:00:06.051 ERROR com.csii.batch.job.dataClear
--java代码：ibsTxTemplate.execute(new TransactionCallback() {
public Object doInTransaction(TransactionStatus arg0) {
logger.info("==="+tablename+"bakup===");
try{
sqlMap.insert("batch.bakdata"+tablename, map);
logger.info("==="+tablename+"delete ===");
sqlMap.delete("batch.delete"+tablename, map);
logger.info("==="+tablename+"delete end ===");
}catch (Exception e) {
IBATIS查询SQL
<insert id="bakdataIBSJNL" parameterClass="java.util.HashMap">
insert into IBSJNLHIST_$lastMonth$
select * from IBSJNL where TRANSDATE >= #BeginDate# AND TRANSDATE < #EndDate#
</insert>
--211错误码的解释
-211 不能读取系统目录<目录表>。
数据库服务器在处理大多数语句时参照系统目录表。当不能读取这些重要的表时就产
生了严重的错误。检查伴随的ISAM错误代码以获得更多的信息。错误的影响取决于正
在执行的语句和特定的表，如下所示。
* CREATE TABLE语句，systabauth不能读取；该表可以被建立，但不能象正常
情况一样授权给PUBLIC。
* DROP TABLE语句，systables不能读取；不做任何动作。
* DROP TABLE语句，sysviews不能读取；该表将被取消，但任何依赖于该表的
视图将不能被自动取消。
* DROP VIEW语句，sysviews不能读取；不做任何动作。
* DROP INDEX语句，systables或sysindexs不能读取；不做任何动作。
* DROP SYNONYM语句，systables或syssynonyms不能读取；不做任何动作。
* DROP DATABASE语句，systables不能读取；不做任何动作。
* START DATABASE语句，systables不能读取；不做任何动作。
* DATABASE语句，systables或sysusers不能读取；该数据库不被选中
(没有当前数据库，后来的操作见错误-349)。
现在数据在数据清理及备份到历史表的数据时，informix库经常出错。
寻求解决办法，
谢谢。
在SQL中增加脏读或者锁等，或者两者都加上看下。。
--ADD HERE
set lock mode to wait 30;
--set isolation to dirty read;
insert into IBSJNLHIST_$lastMonth$
select * from IBSJNL where TRANSDATE >= #BeginDate# AND TRANSDATE < #EndDate#
页:
[1]