3 Replies Latest reply on Mar 13, 2014 12:31 AM by Dharma Rao

    IJ000453: Unable to get managed connection for

    Dharma Rao Newbie

      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.

        • 1. Re: IJ000453: Unable to get managed connection for
          Wolf-Dieter Fink Master

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

          • 2. Re: IJ000453: Unable to get managed connection for
            Dharma Rao Newbie

            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

            • 3. Re: IJ000453: Unable to get managed connection for
              Dharma Rao Newbie

              Hi All,

               

              Any help on this.

               

              Regards,

              Dharma.