[jboss-user] No ManagedConnections problem- JBoss + MSSQL

Tue May 29 05:44:07 EDT 2007

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 at ncs.com.sg
Web *     http://www.ncs.com.sg

-----Original Message-----
From: jboss-user-bounces at lists.jboss.org
[mailto:jboss-user-bounces at lists.jboss.org] On Behalf Of
jboss-user-request at 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 at 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 at 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 at 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.