IJ000453: Unable to get managed connection for

[dharmarao]

Hi All,

We were running our application with jboss-5-1 successfully, but recently we moved to jboss-6-2 and very oftenly we are getting the above specified error.   any suggestion to get rid of this.

[wdfink]

Could you post a bit more information, i.e. configuration and stacktrace (log-files)?

[dharmarao]

Hi,

Any help?

My DatasourceFile standalone-full.xml looks like

<datasource enabled="true" jndi-name="java:/iam/im/jdbc/jdbc/idm" jta="false" pool-name="iam_im-imtaskpersistencedb-ds" use-java-context="true">

  <connection-url>jdbc:sqlserver://nandh01-m6:1433;selectMethod=cursor;DatabaseName=m6</connection-url>

  <driver>sqljdbc</driver>

  <pool>

  <min-pool-size>5</min-pool-size>

  <max-pool-size>200</max-pool-size>

  </pool>

  <security>

  <security-domain>iam_im-imtaskpersistencedb</security-domain>

  </security>

  <validation>

  <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>

  <validate-on-match>false</validate-on-match>

  <background-validation>true</background-validation>

  <background-validation-millis>120000</background-validation-millis>

  </validation>

  <timeout>

  <blocking-timeout-millis>10000</blocking-timeout-millis>

  <idle-timeout-minutes>5</idle-timeout-minutes>

  </timeout>

  </datasource>

And the error message is as follows:

19:43:12,690 ERROR [org.quartz.core.ErrorLogger] (iam_imDefaultQuartzScheduler_QuartzSchedulerThread) An error occured while scanning for the next trigger to fire.: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:/iam/im/jdbc/jdbc/idm' java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/iam/im/jdbc/jdbc/idm [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:/iam/im/jdbc/jdbc/idm' java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/iam/im/jdbc/jdbc/idm]
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:165) [quartz-all-1.7.3.jar:]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3739) [quartz-all-1.7.3.jar:]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2724) [quartz-all-1.7.3.jar:]
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:263) [quartz-all-1.7.3.jar:]
Caused by: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:/iam/im/jdbc/jdbc/idm' java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/iam/im/jdbc/jdbc/idm
at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:163) [quartz-all-1.7.3.jar:]
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:109) [quartz-all-1.7.3.jar:]
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:162) [quartz-all-1.7.3.jar:]
... 3 more

[dharmarao]

Hi All,

Any help on this.

Regards,

Dharma.

[thummanagoti441]

Have you resolved this issue ?