commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Asmita Maruti Shinde (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DBCP-447) java.sql.SQLException: Data source is closed
Date Mon, 21 Sep 2015 08:19:04 GMT

     [ 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)

Mime
View raw message