Hi All, I am having a major production issue.Every week , atleast once I am getting the following error. Iam using JBoss + MSSQL + Quartz. As far as i know this 'no managed connection' problem will come mostly, if there is not enough connection in the JBoss connection pool. Now my application and the Quartz are using the same datarouce.At first i suspected that my application is not closing the connection properly which might have resulted in this problem.But i checked my application code , and the closing it done properly. Is there any known problem in Quartz which uses many connections.I am planning to create a new datasource which will be used only for Quartz, Will this solves my problem. Pls help me to find a good solution to this problem. 2007-05-23 08:43:45,776 INFO [com.ncs.iframe.extensions.scheduler.quartz.IFrameQuartzScheduler] Scheduler initiating ... 2007-05-23 08:44:14,823 ERROR [org.quartz.impl.jdbcjobstore.JobStoreTX] MisfireHandler: Error handling misfires: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:/iconnectDS' org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )) org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:/iconnectDS' org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )) [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:/iconnectDS' org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))] at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSuppo rt.java :575) at org.quartz.impl.jdbcjobstore.JobStoreTX.doRecoverMisfires(JobStoreTX.jav a:1343) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobSt oreSupp ort.java:2449) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStore Support .java:2468) * Nested Exception (Underlying Cause) --------------- java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:/iconnectDS' org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )) at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProv ider.ja va:166) at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.j ava:111 ) at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSuppo rt.java :553) at org.quartz.impl.jdbcjobstore.JobStoreTX.doRecoverMisfires(JobStoreTX.jav a:1343) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobSt oreSupp ort.java:2449) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStore Support .java:2468) 2007-05-23 08:44:15,777 INFO [STDOUT] org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:/iconnectDS' org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )) [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:/iconnectDS' org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))] 2007-05-23 08:44:15,779 INFO [STDOUT] at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSuppo rt.java :575) 2007-05-23 08:44:15,779 INFO [STDOUT] at org.quartz.impl.jdbcjobstore.JobStoreTX.removeTrigger(JobStoreTX.java:36 5) 2007-05-23 08:44:15,779 INFO [STDOUT] at org.quartz.core.QuartzScheduler.unscheduleJob(QuartzScheduler.java:723) 2007-05-23 08:44:15,779 INFO [STDOUT] at org.quartz.impl.StdScheduler.unscheduleJob(StdScheduler.java:285) 2007-05-23 08:44:15,779 INFO [STDOUT] at com.ncs.iframe.extensions.scheduler.quartz.IFrameQuartzScheduler.unsched uleTask (IFrameQuartzScheduler.java:345) Best Regards, Shanmugam Karthikeyan Chief Architect Office NCS Pte. Ltd. (A member of the Singapore Telecom Group) 5 Ang Mo Kio St 62, NCS Hub, S (569141) ___________________________________ Tel * 65566786 Fax* 64835431 E-mail * skarthi(a)ncs.com.sg Web * http://www.ncs.com.sg -----Original Message----- From: jboss-user-bounces(a)lists.jboss.org [mailto:jboss-user-bounces@lists.jboss.org] On Behalf Of jboss-user-request(a)lists.jboss.org Sent: Tuesday, May 29, 2007 5:39 PM To: Shanmugam Karthikeyan NCS Subject: Welcome to the "jboss-user" mailing list (Digest mode) Welcome to the jboss-user(a)lists.jboss.org mailing list! Welcome to JBoss-user. Please observe the netitquette directives when posting here. To post to this list, send your email to: jboss-user(a)lists.jboss.org General information about the mailing list is at: https://lists.jboss.org/mailman/listinfo/jboss-user If you ever want to unsubscribe or change your options (eg, switch to or from digest mode, change your password, etc.), visit your subscription page at: https://lists.jboss.org/mailman/options/jboss-user/skarthi%40ncs.com.sg You can also make such adjustments via email by sending a message to: jboss-user-request(a)lists.jboss.org with the word `help' in the subject or body (don't include the quotes), and you will get back a message with instructions. You must know your password to change your options (including changing the password, itself) or to unsubscribe. It is: karmaker Normally, Mailman will remind you of your lists.jboss.org mailing list passwords once every month, although you can disable this if you prefer. This reminder will also include instructions on how to unsubscribe or change your account options. There is also a button on your options page that will email your current password to you.