问题描述
- 批量定时(使用quartz.jar) hibernate3.1.3+Spring1.2.8 程序运行一段时间停止
-
程序使用Hibernate 3.1.3+Spring 1.2.8,使用dbcp数据库连接,在程序中使用Quartz.jar定时四个任务,每天定时执行,运行几天后所有任务都不执行了,好像死锁了一样,无异常、无错误抛出,重新启动后又可正常执行。求高手指点,日志如下:
2013-09-17 21:00:41,859 org.hibernate.cfg.SettingsFactory - JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0
2013-09-17 21:00:41,890 org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.Oracle9Dialect
2013-09-17 21:00:41,890 org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
2013-09-17 21:00:41,890 org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Connection release mode: on_close
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 1
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.classic.ClassicQueryTranslatorFactory
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Query cache: disabled
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.EhCacheProvider
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Statistics: enabled
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
2013-09-17 21:00:41,921 org.hibernate.impl.SessionFactoryImpl - building session factory
2013-09-17 21:00:41,937 net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/D:/workspace/ZCCL_BatchServer/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
2013-09-17 21:00:42,500 org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
2013-09-17 21:00:42,578 org.springframework.aop.framework.DefaultAopProxyFactory - CGLIB2 available: proxyTargetClass feature enabled
2013-09-17 21:00:42,640 com.dcits.server.StartServer - Roman-----------systemEnv serverPort-----18171
2013-09-17 21:00:42,640 com.dcits.server.ListenServer - =======管理线程就绪=======
2013-09-17 21:00:42,640 com.dcits.server.ListenServer - 线程[1]启动完成
2013-09-17 21:00:42,640 com.dcits.server.ListenServer - 服务器忙,增加新线程
2013-09-17 21:00:42,640 com.dcits.server.ListenServer - 线程[2]启动完成
2013-09-17 21:00:42,640 com.dcits.server.AcceptServer - G0_L1_CR:=======正在监听端口[18171]=======
2013-09-17 21:00:42,640 com.dcits.server.AcceptServer - G0_L2_CR:=======正在监听端口[18171]=======
2013-09-17 21:00:42,671 org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2013-09-17 21:00:42,687 org.springframework.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
Hibernate: select * from ( select this_.JOB_ID as JOB1_15_0_, this_.JOB_NAME as JOB2_15_0_, this_.JOB_CLASS as JOB3_15_0_, this_.JOB_TYPE as JOB4_15_0_, this_.JOB_TRIGGER_STATE as JOB5_15_0_, this_.JOB_CRON_EXPRESSION as JOB6_15_0_, this_.JOB_METHOD as JOB7_15_0_, this_.JOB_GROUP as JOB8_15_0_, this_.JOB_SPRING_BEAN as JOB9_15_0_, this_.JOB_EXE_LAST_TIME as JOB10_15_0_, this_.JOB_EXE_NEXT_TIME as JOB11_15_0_, this_.JOB_START_TIME as JOB12_15_0_, this_.JOB_END_TIME as JOB13_15_0_, this_.JOB_TRIGGER_TYPE as JOB14_15_0_, this_.JOB_PRI as JOB15_15_0_, this_.JOB_TRIGGER_NAME as JOB16_15_0_, this_.JOB_TRIGGER_GROUP as JOB17_15_0_, this_.JOB_EXE_STATE as JOB18_15_0_ from CHQB_JOB this_ ) where rownum <= ?
2013-09-17 21:00:42,859 com.dcits.job.util.JobUtil - Roman--------------jobList's size------5
2013-09-17 21:00:42,859 com.dcits.job.util.JobUtil - (JobInfo)job's class -----0 0/3 * * * ?
2013-09-17 21:00:42,921 org.quartz.simpl.SimpleThreadPool - Job execution threads will use class loader of thread: main
2013-09-17 21:00:42,953 org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
2013-09-17 21:00:42,953 org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
2013-09-17 21:00:42,953 org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 1.4.2
2013-09-17 21:00:42,968 com.dcits.job.util.JobUtil - (JobInfo)job's class -----0 01 11 * * ?
2013-09-17 21:00:42,984 com.dcits.job.util.JobUtil - (JobInfo)job's class -----0 00 16 * * ?
2013-09-17 21:00:43,000 com.dcits.job.util.JobUtil - (JobInfo)job's class -----0 0/1 * * * ?
2013-09-17 21:00:43,046 com.dcits.job.util.JobUtil - (JobInfo)job's class -----0 50 16 * * ?
2013-09-17 21:00:43,062 org.quartz.core.QuartzScheduler - Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
2013-09-17 21:01:00,015 com.dcits.job.base.BaseJob - ----START------TrpLoadBatchJob----------
2013-09-17 21:01:00,015 com.dcits.job.TrpLoadBatchJob - Tue Sep 17 21:01:00 CST 2013################START RUN TrpLoadBatchJob ##########0