[
https://issues.apache.org/jira/browse/DBCP-447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Asmita Maruti Shinde updated DBCP-447:
--------------------------------------
Description:
Recently we have upgraded below connection pooling jars:
Common dbcp 1.2 to dbcp 1.4
Common pool 1.2 to pool 1.6
Sporadically we are getting quartz scheduler error.
we are getting following error:
[exec] org.quartz.JobPersistenceException: Failed to obtain DB connection
from data source 'springNonTxDataSource.QuartzScheduler':
java.sql.SQLException: Data source is closed [See nested exception:
java.sql.SQLException: Data source is closed]
[exec] at
org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:168)
[exec] at
org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3169)
[exec] at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3935)
[exec] at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3956)
[exec] Caused by: java.sql.SQLException: Data source is closed
[exec] at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1362)
[exec] at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
Please Suggest ..
was:
Recently we have upgraded below connection pooling jars:
Common dbcp 1.2 to dbcp 1.4
Common pool 1.2 to pool 1.6
While running automation,Sporadically we are getting quartz scheduler error.
we are getting following error:
[exec] org.quartz.JobPersistenceException: Failed to obtain DB connection
from data source 'springNonTxDataSource.QuartzScheduler':
java.sql.SQLException: Data source is closed [See nested exception:
java.sql.SQLException: Data source is closed]
[exec] at
org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:168)
[exec] at
org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3169)
[exec] at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3935)
[exec] at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3956)
[exec] Caused by: java.sql.SQLException: Data source is closed
[exec] at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1362)
[exec] at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
Please Suggest ..
> java.sql.SQLException: Data source is closed
> --------------------------------------------
>
> Key: DBCP-447
> URL: https://issues.apache.org/jira/browse/DBCP-447
> Project: Commons Dbcp
> Issue Type: Bug
> Affects Versions: 1.4
> Environment: mysql Ver 14.14 Distrib 5.5.32, for Win64 (x86)
> Reporter: Asmita Maruti Shinde
> Priority: Blocker
>
> Recently we have upgraded below connection pooling jars:
> Common dbcp 1.2 to dbcp 1.4
> Common pool 1.2 to pool 1.6
> Sporadically we are getting quartz scheduler error.
> we are getting following error:
> [exec] org.quartz.JobPersistenceException: Failed to obtain DB connection
> from data source 'springNonTxDataSource.QuartzScheduler':
> java.sql.SQLException: Data source is closed [See nested exception:
> java.sql.SQLException: Data source is closed]
> [exec] at
> org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:168)
> [exec] at
> org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3169)
> [exec] at
> org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3935)
> [exec] at
> org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3956)
> [exec] Caused by: java.sql.SQLException: Data source is closed
> [exec] at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1362)
> [exec] at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
> Please Suggest ..
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
