本文介绍了石英连接已经关闭(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?

推荐答案




这篇关于石英连接已经关闭(1.5.2)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-04 13:54