带弹簧框架的石英作业商店

java spring quartz-scheduler

2022-09-04 21:02:39

我正在使用Spring Framework在Oracle DB上实现Quartz Job Store。我的应用程序上下文.xml如下

<bean id="driverJob" class="org.springframework.scheduling.quartz.JobDetailBean">
    <property name="jobClass" value="BatchFileCollector" />
</bean>

<bean id="ranchTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerBean">
    <property name="jobDetail" ref="driverJob" />
    <property name="startDelay" value="2000" />
    <property name="repeatInterval" value="10000" />
</bean>

<bean class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
    <property name="triggers">
        <list>
            <ref bean="ranchTrigger" />
        </list>
    </property>
    <property name="dataSource">
        <ref bean="dataSource.TEXAN"/>
    </property>
    <property name="applicationContextSchedulerContextKey">
        <value>applicationContext</value>
    </property>
    <property name="autoStartup">
        <value>true</value>
    </property>
    <property name="configLocation" value="classpath:quartz.properties"/>
</bean>

此配置给我带来了以下错误。

Caused by: org.quartz.JobPersistenceException: 

Couldn't store trigger: The job (DEFAULT.driverJob) referenced by the trigger does not exist. 

[See nested exception: org.quartz.JobPersistenceException: The job (DEFAULT.driverJob) referenced by the trigger does not exist.]

我正在使用Spring Framework 2.5.6。我必须升级我的石英版本吗？我找不到问题。

感谢您的帮助。

答案 1

您的 SchedulerFactoryBean 也需要注册“driverJob”。除了触发器之外，还要添加作业详细信息列表。

<bean id="job.statistics.DailyQPSValidationJobTrigger" class="org.quartz.CronTrigger">
    <property name="name" value="DailyQPSValidationTrigger" />
    <property name="jobName" value="DailyQPSValidation" />
    <property name="jobGroup" value="Statistics" />
    <property name="volatility" value="false" />
    <!-- Each day, 4 o'clock AM -->
    <property name="cronExpression" value="0 0 4 * * ?" />
</bean>

<!-- Scheduler -->

<bean id="job.SchedulerProperties" class="somecompany.someproduct.util.spring.PropertiesFactoryBean"
    scope="singleton">
    <property name="source">
        <props>
            <prop key="org.quartz.scheduler.instanceId">AUTO</prop>
            <prop key="org.quartz.scheduler.instanceName">JobCluster</prop>
            <prop key="org.quartz.jobStore.class">org.quartz.impl.jdbcjobstore.JobStoreTX</prop>
            <prop key="org.quartz.jobStore.driverDelegateClass">org.quartz.impl.jdbcjobstore.StdJDBCDelegate</prop>
            <prop key="org.quartz.jobStore.isClustered">true</prop>
            <prop key="org.quartz.jobStore.useProperties">false</prop>
        </props>
    </property>
</bean>

<bean id="job.Scheduler" class="org.springframework.scheduling.quartz.SchedulerFactoryBean" scope="singleton"
    lazy-init="false">
    <property name="startupDelay" value="30" />
    <property name="waitForJobsToCompleteOnShutdown" value="true" />
    <property name="dataSource" ref="jdbc.DataSource" />
    <property name="quartzProperties" ref="job.SchedulerProperties" />
    <property name="jobDetails">
        <list>
            <ref bean="job.statistics.DailyQPSValidationJobDetail" />
        </list>
    </property>
    <property name="triggers">
        <list>
            <ref bean="job.statistics.DailyQPSValidationJobTrigger" />
        </list>
    </property>
    <property name="schedulerListeners">
        <list>
            <bean class="somecompany.someproduct.job.SchedulerErrorListener">
                <property name="monitoringService" ref="monitoring.MonitoringService" />
            </bean>
        </list>
    </property>
    <property name="globalJobListeners">
        <list>
            <bean class="somecompany.someproduct.job.JobErrorListener">
                <property name="name" value="JobErrorListener" />
                <property name="monitoringService" ref="monitoring.MonitoringService" />
            </bean>
        </list>
    </property>
</bean>

答案 2

我在Quartz 1.5.2和Spring 3.0.4上遇到了同样的问题。问题在于，JobStoreSupport 类尝试使用作业的外键存储 cron 触发器（尝试从 db 加载作业），但尚未持久化。

石英1.6.1，1.7.2版本也有同样的问题。

<bean id="quartzScheduler" class="org.springframework.scheduling.quartz.SchedulerFactoryBean"
      depends-on="quartzDatabaseCreator">
    <property name="autoStartup">
        <value>true</value>
    </property>
    <property name="dataSource">
        <ref bean="dataSource"/>
    </property>
    <property name="quartzProperties">
        <props>
            <prop key="org.quartz.jobStore.selectWithLockSQL">SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ?
            </prop>
            <prop key="org.quartz.jobStore.driverDelegateClass">org.quartz.impl.jdbcjobstore.${qrtz.delegateClass}
            </prop>
        </props>
    </property>
    <property name="triggers">
        <list>
            <ref bean="cronTrigger"/>
        </list>
    </property>
    <property name="schedulerContextAsMap">
        <map>
            <entry key="sygnoServerHelper"><ref bean="sygnoServerHelper"/></entry>
            <entry key="requestDAO"><ref bean="requestDAO"/></entry>
            <entry key="alairoCache"><ref bean="alairoCache"/></entry>
        </map>
    </property>
</bean>

<bean id="cronTrigger" class="org.springframework.scheduling.quartz.CronTriggerBean">
    <property name="jobDetail" ref="checkGracePeriodJob" />
    <!--                                 # s m h dom mon dow [y]  -->
    <property name="cronExpression" value="0 0/5 * * * ?" />
</bean>

<bean id="checkGracePeriodJob" class="org.springframework.scheduling.quartz.JobDetailBean">
    <property name="jobClass" value="com.synergon.sygnoserver.CheckGracePeriodJob"/>
 </bean>