【バッチＦＷ】バッチ実行時間の設定 (2009-09-02 17:03 by terasoluna素人 #45673)
お世話になります。
バッチフレームワークを使用して、開発を行っているのですが、10分以上動作させると
----------------------------------------------------------------------
jp.terasoluna.fw.batch.core.CollectorException: org.springframework.dao.DataAccessResourceFailureException: SqlMapClient operation; SQL [];
--- The error occurred in definition/Realization_sqlMap.xml.
--- The error occurred while applying a result map.
--- Check the realization.getAccountMarginAll-AutoResultMap.
--- The error happened while setting a property on the result object.
--- Cause: java.sql.SQLException: [0]:Client's query exceeded in the execution time limitation.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in definition/Realization_sqlMap.xml.
--- The error occurred while applying a result map.
--- Check the realization.getAccountMarginAll-AutoResultMap.
--- The error happened while setting a property on the result object.
--- Cause: java.sql.SQLException: [0]:Client's query exceeded in the execution time limitation.
at jp.terasoluna.fw.batch.core.JobManager.processCollect(JobManager.java:198)
at jp.terasoluna.fw.batch.core.JobManager.work(JobManager.java:152)
at jp.terasoluna.fw.batch.springsupport.init.JobExecutor.execute(JobExecutor.java:382)
at jp.terasoluna.fw.batch.springsupport.init.JobStarter.execute(JobStarter.java:137)
at jp.terasoluna.fw.batch.springsupport.init.JobStarter.main(JobStarter.java:106)
Caused by: org.springframework.dao.DataAccessResourceFailureException: SqlMapClient operation; SQL [];
--- The error occurred in definition/Realization_sqlMap.xml.
--- The error occurred while applying a result map.
--- Check the realization.getAccountMarginAll-AutoResultMap.
--- The error happened while setting a property on the result object.
--- Cause: java.sql.SQLException: [0]:Client's query exceeded in the execution time limitation.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in definition/Realization_sqlMap.xml.
--- The error occurred while applying a result map.
--- Check the realization.getAccountMarginAll-AutoResultMap.
--- The error happened while setting a property on the result object.
--- Cause: java.sql.SQLException: [0]:Client's query exceeded in the execution time limitation.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:113)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:196)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryWithRowHandler(SqlMapClientTemplate.java:300)
at jp.terasoluna.fw.batch.ibatissupport.IBatisDbCollectorImpl.doCollect(IBatisDbCollectorImpl.java:66)
at jp.terasoluna.fw.batch.core.AbstractCollector.collect(AbstractCollector.java:69)
at jp.terasoluna.fw.batch.core.JobManager.processCollect(JobManager.java:191)
