[jira] [Created] (DBCP-447) java.sql.SQLException: Data source is closed

[Asmita Maruti Shinde (JIRA)]

Asmita Maruti Shinde created DBCP-447:
-----------------------------------------

             Summary: 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

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 ..



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)