[
https://issues.apache.org/jira/browse/DBCP-447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phil Steitz closed DBCP-447.
----------------------------
Resolution: Invalid
Feel free to reopen if you can demonstrate somehow that this is actually a DBCP
bug. DBCP is throwing the SQL Exception because the BasicDataSource has been
closed (as the message says). In versions of DBCP prior to 1.3/1.4, there was
no such check, which may be why upgrade to 1.4 triggers the failure.
> 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 so that they are
> compatible with type 4/JDK 6.0.
> Common dbcp 1.2 to dbcp 1.4
> Common pool 1.2 to pool 1.6
> Sporadically we are getting quartz scheduler error.
> Here is the stack trace:
> [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)
> Is this issue related to Spring/hibernate?
> Please Suggest ..
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
