quartz2.1.7 启动后TRIGGER_STATE就变为ERROR

0 0

quartz2.1.7 启动后TRIGGER_STATE就变为ERROR15

想用quartz做一个定时任务，定时任务都持久化到mysql数据库，
每次添加任务以后，数据库里面有数据，但任务没有执行（我设置的是马上执行），TRIGGER_STATE就变为ERROR.

<bean id="scheduler" lazy-init="false"
        class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
        <property name="dataSource">
            <ref bean="scheduleDataSource" />
        </property>
        <property name="autoStartup" value="true" />
        <property name="schedulerFactoryClass" value="org.quartz.impl.StdSchedulerFactory"></property>
        <property name="configLocation" value="classpath:quartz.properties" />
        <property name="schedulerName" value="cronScheduler" />

问题补充：#============================================================================
# Configure Main Scheduler Properties
#============================================================================

org.quartz.scheduler.instanceName = EvanLilyScheduler
org.quartz.scheduler.instanceId = AUTO

#============================================================================
# Configure ThreadPool
#============================================================================

org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount = 25
org.quartz.threadPool.threadPriority = 5

#============================================================================
# Configure JobStore
#============================================================================

org.quartz.jobStore.misfireThreshold = 60000
org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX

# 不同数据库系统中某一特定方言的驱动代理mysql
org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate

org.quartz.jobStore.useProperties=false
org.quartz.jobStore.dataSource=DS
#是否集群
org.quartz.jobStore.isClustered=false

#============================================================================
# Configure Datasources
#============================================================================
#mysql
org.quartz.dataSource.DS.driver = com.mysql.jdbc.Driver
org.quartz.dataSource.DS.URL = jdbc:mysql://localhost:3306/schedul
org.quartz.dataSource.DS.user = root
org.quartz.dataSource.DS.password =

org.quartz.dataSource.DS.maxConnections = 5
org.quartz.scheduler.classLoadHelper.class=org.quartz.simpl.CascadingClassLoadHelper

问题补充：JobDetail jobDetail = newJob(HttpJobExecutor.class)
                    .withIdentity(httpJob.getJobName(), HttpJobDO.JOB_GROUP)
                    .withDescription(httpJob.getDescription())
                    .storeDurably(true)//没有trigger关联时自动删除
                    .requestRecovery()//失败后重做
                    .build();
TriggerBuilder<Trigger> triggerBuilder = newTrigger()
                    .withIdentity(httpJob.getJobName())
                    .endAt(httpJob.getEndTime());
triggerBuilder.startNow();
CronScheduleBuilder cronScheduleBuilder = cronSchedule(httpJob.getCronExpression());
                triggerBuilder.withSchedule(cronScheduleBuilder);
Trigger trigger = triggerBuilder.build();

            scheduler.scheduleJob(jobDetail, trigger);

quartz