4:44 a.m.
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.