石英连接已经关闭（1.5.2） [英] Quartz connection already closed (1.5.2)
问题描述
我们在成功解雇后获得此异常（石英1.5.2）：
M：2014-01-08 07：31：14,737 [QuartzScheduler_Worker -9] ERROR org.quartz.core.ErrorLogger - 标记执行的作业完成时发生错误。 job ='DEFAULT.MIL002_APPLINK_HTTP_SMS_20140108070013'
org.quartz.JobPersistenceException：无法关闭jdbc连接。已经关闭。 [请参阅嵌套异常：java.sql.SQLException：已经关闭。]
org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection（JobStoreSupport.java:2299）
org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete（JobStoreTX.java:1337）
org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete（QuartzScheduler.java:1490）
org.quartz.core.JobRunShell.run（JobRunShell.java:270） ）
org.quartz.simpl.SimpleThreadPool $ WorkerThread.run（SimpleThreadPool.java:520）
*嵌套异常（基础原因）---------------
java.sql.SQLException：已经关闭。
at org.apache.commons.dbcp.PoolableConnection.close（PoolableConnection.java:77）
org.apache.commons.dbcp.PoolingDataSource $ PoolGuardConnectionWrapper.close（PoolingDataSource.java:180）
org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection （JobStoreSupport.java:2297）
org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete（JobStoreTX.java:1337）
org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete（QuartzScheduler.java:1490）
org.quartz.core.JobRunShell。运行（JobRunShell.java:270）
org.quartz.simpl.SimpleThreadPool $ WorkerThread.run（SimpleThreadPool.java:520)
我们将org.quartz.impl.jdbcjobstore.PostgreSQLDelegate与SimpleThreadPool一起使用。这个类处理DB：org.quartz.impl.jdbcjobstore.JobStoreTX
有什么想法吗？
We are getting this exception after a job fired successfully (quartz 1.5.2):
M: 2014-01-08 07:31:14,737 [QuartzScheduler_Worker-9] ERROR org.quartz.core.ErrorLogger - An error occured while marking executed job complete. job= 'DEFAULT.MIL002_APPLINK_HTTP_SMS_20140108070013'
org.quartz.JobPersistenceException: Couldn't close jdbc connection. Already closed. [See nested exception: java.sql.SQLException: Already closed.]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection(JobStoreSupport.java:2299)
at org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete(JobStoreTX.java:1337)
at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1490)
at org.quartz.core.JobRunShell.run(JobRunShell.java:270)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
* Nested Exception (Underlying Cause) ---------------
java.sql.SQLException: Already closed.
at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection(JobStoreSupport.java:2297)
at org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete(JobStoreTX.java:1337)
at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1490)
at org.quartz.core.JobRunShell.run(JobRunShell.java:270)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
We use the org.quartz.impl.jdbcjobstore.PostgreSQLDelegate with a SimpleThreadPool. This class handles the DB: org.quartz.impl.jdbcjobstore.JobStoreTX
Any ideas?
推荐答案
WorkerThread.run（SimpleThreadPool.java:520）
*嵌套异常（基础原因）---------------
java.sql.SQLException：已经关闭。
at org.apache.commons.dbcp.PoolableConnection.close（PoolableConnection.java:77）
org.apache.commons.dbcp.PoolingDataSource
WorkerThread.run(SimpleThreadPool.java:520)
* Nested Exception (Underlying Cause) ---------------
java.sql.SQLException: Already closed.
at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)
at org.apache.commons.dbcp.PoolingDataSource
PoolGuardConnectionWrapper.close（PoolingDataSource.java:180)
at org .quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection（JobStoreSupport.java:2297）
org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete（JobStoreTX.java： 1337）
org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete（QuartzScheduler.java:1490）
org.quartz.core.JobRunShell.run（JobRunShell.java:270）
at org.quartz.simpl.SimpleThreadPool
PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection(JobStoreSupport.java:2297)
at org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete(JobStoreTX.java:1337)
at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1490)
at org.quartz.core.JobRunShell.run(JobRunShell.java:270)
at org.quartz.simpl.SimpleThreadPool
WorkerThread.run（SimpleThreadPool.java:520）
我们使用org.quartz.impl.jdbcjobstore.PostgreSQLDelegate一个SimpleThreadPool。这个类处理DB：org.quartz.impl.jdbcjobstore.JobStoreTX
有什么想法吗？
WorkerThread.run(SimpleThreadPool.java:520)
We use the org.quartz.impl.jdbcjobstore.PostgreSQLDelegate with a SimpleThreadPool. This class handles the DB: org.quartz.impl.jdbcjobstore.JobStoreTX
Any ideas?
这篇关于石英连接已经关闭（1.5.2）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
