java quartz 失败重试_重试Quartz Scheduler启动数据库连接失败

我们有一个Java应用程序，它使用Quartz来调度作业 . 我们使用的石英版本是：quartz-2.2.1

quartz配置使用JDBC作业存储 .

如果在石英调度程序对象上调用start方法时数据库连接已关闭(由于间歇性网络故障)，则会因以下异常而失败：

2017-05-28 00:05:45 org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't recover jobs: The connection is closed. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.]]

2017-05-28 00:05:45 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:692)

2017-05-28 00:05:45 at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567)

2017-05-28 00:05:45 at org.quartz.impl.StdScheduler.start(StdScheduler.java:142)

为了确保石英调度程序成功启动，我们在代码中添加了重试，该代码在每1秒后调用石英调度程序对象上的start方法 . 但是当数据库连接启动时，对quartz scheduler start方法的调用成功(它不会抛出任何异常) - 但是不会启动驻留在数据库中的关联触发器，也不会触发任何作业 .

知道这里有什么问题吗？任何帮助将不胜感激 .

这是石英配置，请注意我们已启用验证查询来处理糟糕的连接(由于间歇性网络故障)

#============================================================================

# Configure Main Scheduler Properties

#============================================================================

org.quartz.scheduler.instanceName = TestScheduler

org.quartz.scheduler.instanceId = AUTO

org.quartz.scheduler.skipUpdateCheck=true

#============================================================================

# Configure ThreadPool

#============================================================================

org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool

org.quartz.threadPool.threadCount = 50

org.quartz.threadPool.threadPriority = 5

#============================================================================

# Configure JobStore

#============================================================================

org.quartz.jobStore.misfireThreshold = 60000

org.quartz.jobStore.maxMisfiresToHandleAtATime = 15

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

org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate

org.quartz.jobStore.useProperties = false

org.quartz.jobStore.dataSource = aBPM

org.quartz.jobStore.tablePrefix = ABPM_

org.quartz.jobStore.isClustered = false

org.quartz.jobStore.useDBLocks = false

org.quartz.jobStore.acquireTriggersWithinLock = true

#============================================================================

# Configure Datasources

#============================================================================

org.quartz.dataSource.aBPM.driver = org.hsqldb.jdbcDriver

org.quartz.dataSource.aBPM.URL = jdbc:hsqldb:file:embeddedDb/db/abpmquartz

org.quartz.dataSource.aBPM.user = sa

org.quartz.dataSource.aBPM.encryptPassword = yes

org.quartz.dataSource.aBPM.password = fMFVvEFk3gFmM9ewWQkTNg==

org.quartz.dataSource.aBPM.maxConnections = 55

org.quartz.dataSource.aBPM.validationQuery= SELECT 1