spring把quartz从1.8.3升级到2.2.3

最新推荐文章于 2023-02-19 00:31:08 发布

lfwer

最新推荐文章于 2023-02-19 00:31:08 发布

阅读量860

点赞数

分类专栏： spring 文章标签： quartz spring

spring 专栏收录该内容

13 篇文章

订阅专栏

前段时间将项目中spring 3.1.0升级到4.2.7后，发现不兼容老版的quartz（1.8.3），因此升级quartz到2.2.3。

1 quartz依赖包如下：

<dependency>  
   <groupId>org.quartz-scheduler</groupId>  
   <artifactId>quartz</artifactId>  
   <version>2.2.3</version>  
</dependency>  
<dependency>  
   <groupId>org.quartz-scheduler</groupId>  
   <artifactId>quartz-jobs</artifactId>  
   <version>2.2.3</version>  
</dependency>

2 在数据库中创建quartz相关的表

#  
# In your Quartz properties file, you'll need to set   
# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate  
#  
#  
# By: Ron Cordell - roncordell  
#  I didn't see this anywhere, so I thought I'd post it here. This is the script from Quartz to create the tables in a MySQL database, modified to use INNODB instead of MYISAM.  
 
DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;  
DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;  
DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;  
DROP TABLE IF EXISTS QRTZ_LOCKS;  
DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;  
DROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS;  
DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;  
DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;  
DROP TABLE IF EXISTS QRTZ_TRIGGERS;  
DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;  
DROP TABLE IF EXISTS QRTZ_CALENDARS;  
 
CREATE TABLE QRTZ_JOB_DETAILS(  
SCHED_NAME VARCHAR(120) NOT NULL,  
JOB_NAME VARCHAR(200) NOT NULL,  
JOB_GROUP VARCHAR(200) NOT NULL,  
DESCRIPTION VARCHAR(250) NULL,  
JOB_CLASS_NAME VARCHAR(250) NOT NULL,  
IS_DURABLE VARCHAR(1) NOT NULL,  
IS_NONCONCURRENT VARCHAR(1) NOT NULL,  
IS_UPDATE_DATA VARCHAR(1) NOT NULL,  
REQUESTS_RECOVERY VARCHAR(1) NOT NULL,  
JOB_DATA BLOB NULL,  
PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP))  
ENGINE=InnoDB;  
 
CREATE TABLE QRTZ_TRIGGERS (  
SCHED_NAME VARCHAR(120) NOT NULL,  
TRIGGER_NAME VARCHAR(200) NOT NULL,  
TRIGGER_GROUP VARCHAR(200) NOT NULL,  
JOB_NAME VARCHAR(200) NOT NULL,  
JOB_GROUP VARCHAR(200) NOT NULL,  
DESCRIPTION VARCHAR(250) NULL,  
NEXT_FIRE_TIME BIGINT(13) NULL,  
PREV_FIRE_TIME BIGINT(13) NULL,  
PRIORITY INTEGER NULL,  
TRIGGER_STATE VARCHAR(16) NOT NULL,  
TRIGGER_TYPE VARCHAR(8) NOT NULL,  
START_TIME BIGINT(13) NOT NULL,  
END_TIME BIGINT(13) NULL,  
CALENDAR_NAME VARCHAR(200) NULL,  
MISFIRE_INSTR SMALLINT(2) NULL,  
JOB_DATA BLOB NULL,  
PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),  
FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)  
REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP))  
ENGINE=InnoDB;  
 
CREATE TABLE QRTZ_SIMPLE_TRIGGERS (  
SCHED_NAME VARCHAR(120) NOT NULL,  
TRIGGER_NAME VARCHAR(200) NOT NULL,  
TRIGGER_GROUP VARCHAR(200) NOT NULL,  
REPEAT_COUNT BIGINT(7) NOT NULL,  
REPEAT_INTERVAL BIGINT(12) NOT NULL,  
TIMES_TRIGGERED BIGINT(10) NOT NULL,  
PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),  
FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)  
REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))  
ENGINE=InnoDB;  
 
CREATE TABLE QRTZ_CRON_TRIGGERS (  
SCHED_NAME VARCHAR(120) NOT NULL,  
TRIGGER_NAME VARCHAR(200) NOT NULL,  
TRIGGER_GROUP VARCHAR(200) NOT NULL,  
CRON_EXPRESSION VARCHAR(120) NOT NULL,  
TIME_ZONE_ID VARCHAR(80),  
PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),  
FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)  
REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))  
ENGINE=InnoDB;  
 
CREATE TABLE QRTZ_SIMPROP_TRIGGERS  
 (            
   SCHED_NAME VARCHAR(120) NOT NULL,  
   TRIGGER_NAME VARCHAR(200) NOT NULL,  
   TRIGGER_GROUP VARCHAR(200) NOT NULL,  
   STR_PROP_1 VARCHAR(512) NULL,  
   STR_PROP_2 VARCHAR(512) NULL,  
   STR_PROP_3 VARCHAR(512) NULL,  
   INT_PROP_1 INT NULL,  
   INT_PROP_2 INT NULL,  
   LONG_PROP_1 BIGINT NULL,  
   LONG_PROP_2 BIGINT NULL,  
   DEC_PROP_1 NUMERIC(13,4) NULL,  
   DEC_PROP_2 NUMERIC(13,4) NULL,  
   BOOL_PROP_1 VARCHAR(1) NULL,  
   BOOL_PROP_2 VARCHAR(1) NULL,  
   PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),  
   FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)   
   REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))  
ENGINE=InnoDB;  
 
CREATE TABLE QRTZ_BLOB_TRIGGERS (  
SCHED_NAME VARCHAR(120) NOT NULL,  
TRIGGER_NAME VARCHAR(200) NOT NULL,  
TRIGGER_GROUP VARCHAR(200) NOT NULL,  
BLOB_DATA BLOB NULL,  
PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),  
INDEX (SCHED_NAME,TRIGGER_NAME, TRIGGER_GROUP),  
FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)  
REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))  
ENGINE=InnoDB;  
 
CREATE TABLE QRTZ_CALENDARS (  
SCHED_NAME VARCHAR(120) NOT NULL,  
CALENDAR_NAME VARCHAR(200) NOT NULL,  
CALENDAR BLOB NOT NULL,  
PRIMARY KEY (SCHED_NAME,CALENDAR_NAME))  
ENGINE=InnoDB;  
 
CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS (  
SCHED_NAME VARCHAR(120) NOT NULL,  
TRIGGER_GROUP VARCHAR(200) NOT NULL,  
PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP))  
ENGINE=InnoDB;  
 
CREATE TABLE QRTZ_FIRED_TRIGGERS (  
SCHED_NAME VARCHAR(120) NOT NULL,  
ENTRY_ID VARCHAR(95) NOT NULL,  
TRIGGER_NAME VARCHAR(200) NOT NULL,  
TRIGGER_GROUP VARCHAR(200) NOT NULL,  
INSTANCE_NAME VARCHAR(200) NOT NULL,  
FIRED_TIME BIGINT(13) NOT NULL,  
SCHED_TIME BIGINT(13) NOT NULL,  
PRIORITY INTEGER NOT NULL,  
STATE VARCHAR(16) NOT NULL,  
JOB_NAME VARCHAR(200) NULL,  
JOB_GROUP VARCHAR(200) NULL,  
IS_NONCONCURRENT VARCHAR(1) NULL,  
REQUESTS_RECOVERY VARCHAR(1) NULL,  
PRIMARY KEY (SCHED_NAME,ENTRY_ID))  
ENGINE=InnoDB;  
 
CREATE TABLE QRTZ_SCHEDULER_STATE (  
SCHED_NAME VARCHAR(120) NOT NULL,  
INSTANCE_NAME VARCHAR(200) NOT NULL,  
LAST_CHECKIN_TIME BIGINT(13) NOT NULL,  
CHECKIN_INTERVAL BIGINT(13) NOT NULL,  
PRIMARY KEY (SCHED_NAME,INSTANCE_NAME))  
ENGINE=InnoDB;  
 
CREATE TABLE QRTZ_LOCKS (  
SCHED_NAME VARCHAR(120) NOT NULL,  
LOCK_NAME VARCHAR(40) NOT NULL,  
PRIMARY KEY (SCHED_NAME,LOCK_NAME))  
ENGINE=InnoDB;  
 
CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY);  
CREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP);  
 
CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);  
CREATE INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP);  
CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME);  
CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);  
CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE);  
CREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);  
CREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);  
CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME);  
CREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME);  
CREATE INDEX IDX_QRTZ_T_NFT_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME);  
CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE);  
CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE);  
 
CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME);  
CREATE INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY);  
CREATE INDEX IDX_QRTZ_FT_J_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);  
CREATE INDEX IDX_QRTZ_FT_JG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP);  
CREATE INDEX IDX_QRTZ_FT_T_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP);  
CREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);  
 
commit;

因为我这次是升级，原来的表已经存在了，所以需要先挨个删除，只是执行脚本中的删除命令是不管用的，因为有一些外键关系，有一些表需要自己手动删除一下。

3 自定义MyJobFactory，解决spring不能在quartz中注入bean的问题

package com.eversec.mastersp.business.job;  
 
import org.quartz.spi.TriggerFiredBundle;  
import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.beans.factory.config.AutowireCapableBeanFactory;  
import org.springframework.scheduling.quartz.AdaptableJobFactory;  
import org.springframework.stereotype.Component;  
 
/** 
* 自定义MyJobFactory，解决spring不能在quartz中注入bean的问题 
* 
* @author https://blog.youkuaiyun.com/growing_duck/article/details/75115913 
*/  
@Component  
public class MyJobFactory extends AdaptableJobFactory {  
 
 
   @Autowired  
   private AutowireCapableBeanFactory capableBeanFactory;  
 
   @Override  
   protected Object createJobInstance(TriggerFiredBundle bundle) throws Exception {  
       Object jobInstance = super.createJobInstance(bundle);  
       capableBeanFactory.autowireBean(jobInstance); //这一步解决不能spring注入bean的问题  
       return jobInstance;  
   }  
}

4 修改quartz.xml

<bean id="updateOrderJob" class="com.eversec.mastersp.business.job.UpdateOrderJob"/>  
<bean id="updateOrderJobDetail" class="org.springframework.scheduling.quartz.JobDetailFactoryBean">  
   <property name="jobClass" value="com.eversec.mastersp.business.job.UpdateOrderJob"/>  
   <property name="durability" value="true" />  
   <property name="requestsRecovery" value="true" />  
</bean>  
 
<!-- 注册调度任务 -->  
<bean id="quartzScheduler" lazy-init="false" autowire="no"   
class="org.springframework.scheduling.quartz.SchedulerFactoryBean">  
  <property name="triggers">  
     <list>  
        <ref bean="updateOrderTrigger"/>      </list>  
  </property>  
  <!-- 使用spring中配置的数据源和事务-->  
  <property name="dataSource" ref="dataSource"/>  
  <property name="transactionManager" ref="transactionManager" />  
  <property name="schedulerName" value="quartzScheduler" />  
  <property name="overwriteExistingJobs" value="true" />  
  <property name="startupDelay" value="5"/>  
  <property name="applicationContextSchedulerContextKey" value="applicationContext" />  
  <property name="configLocation" value="classpath:quartz.properties" />  
  <property name="autoStartup" value="true"/>  
  <property name="taskExecutor" ref="taskExecutor" />  
  <!-- 解决spring不能在quartz中注入bean的问题 -->  
  <property name="jobFactory" ref="myJobFactory" /> </bean>

其中UpdateOrderJob是我的自定义任务类。因为我是集群环境，使用了CMT，quartz.properties配置如下：

#==============================================================    
#Configure Main Scheduler Properties    
#==============================================================     
org.quartz.scheduler.instanceName=quartzScheduler  
org.quartz.scheduler.instanceId=AUTO  
org.quartz.scheduler.rmi.export=false  
org.quartz.scheduler.rmi.proxy=false  
#==============================================================    
#Configure JobStore    
#==============================================================   
org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreCMT  
org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate  
org.quartz.jobStore.tablePrefix=QRTZ_  
org.quartz.jobStore.isClustered=true  
org.quartz.jobStore.clusterCheckinInterval=20000  
#使用spring中配置的数据源  
org.quartz.jobStore.dataSource=dataSource  
org.quartz.jobStore.maxMisfiresToHandleAtATime=1  
org.quartz.jobStore.misfireThreshold=60000  
org.quartz.jobStore.txIsolationLevelSerializable=true#==============================================================    
#Configure ThreadPool    
#==============================================================   
org.quartz.threadPool.class=org.quartz.simpl.SimpleThreadPool  
org.quartz.threadPool.threadCount=10  
org.quartz.threadPool.threadPriority=5  
org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread=true  
#==============================================================  
#Skip Check Update  
#update:true  
#not update:false  
#==============================================================  
org.quartz.scheduler.skipUpdateCheck=true   
#============================================================================     
# Configure Plugins      
#============================================================================        
org.quartz.plugin.triggHistory.class=org.quartz.plugins.history.LoggingJobHistoryPlugin     
org.quartz.plugin.shutdownhook.class=org.quartz.plugins.management.ShutdownHookPlugin  
org.quartz.plugin.shutdownhook.cleanShutdown=true

5 自定义任务类

package com.eversec.mastersp.business.job;  
import java.text.SimpleDateFormat;  
import java.util.Calendar;  
import java.util.Date;  
import java.util.List;  
import java.util.concurrent.ExecutorService;  
import java.util.concurrent.Executors;  
import java.util.concurrent.TimeUnit;import org.apache.commons.logging.Log;  
import org.apache.commons.logging.LogFactory;  
import com.eversec.mastersp.business.entity.Activity;  
import com.eversec.mastersp.business.service.ActivityService;  
import com.eversec.mastersp.business.service.FilterActivityThread;  
import com.eversec.mastersp.business.service.FirstChargeThread;import com.eversec.mastersp.business.service.MordersService;  
import com.eversec.util.DateUtil;  
import com.eversec.util.PropertiesUtil;  
import org.quartz.Job;  
import org.quartz.JobExecutionContext;  
import org.springframework.beans.factory.annotation.Autowired;  
 
/** 
*  
* 自定义任务类需要实现Job接口 * 
*/  
public class UpdateOrderJob implements Job {  
 
  private static Log log = LogFactory.getLog(UpdateOrderJob.class);  
    
  //注入service  
  @AutowiredMordersLogService mordersLogService;  
 
  //任务执行方法  
@SuppressWarnings("unchecked")  
  public void execute(JobExecutionContext context) {  
 
     log.info("UpdateOrderJob run :" + new Date());  
     long start = System.currentTimeMillis();  
     try {  
        //现在可以使用注入的service了  
List<String> listDay = mordersService.findBySql("xxxxx");  
        if (listDay != null && listDay.size() > 0) {  
           mordersService.updateDayOrder(listDay, today);  
}  
        log.info("月初处理日包退订 end");  
} catch (Exception ex) {  
        log.error("月初处理日包退订失败", ex);  
}  
     //省略其他业务代码......  
     log.info("UpdateOrderJob cost time=" + (System.currentTimeMillis() - start));  
}  
}