3 Replies Latest reply on Jul 8, 2016 1:58 AM by Saurabh Gadariya

    javax.resource.ResourceException: IJ000453 Unable to get managed connection for java:jboss/jdbc/

    Saurabh Gadariya Newbie

      I am getting ResourceException randomly. Does anyone have idea regarding this exception? What could be the root cause behind this??

       

      Currently I am working jboss-as-7.1.1.Final, earlier I was using jboss-5.1.0.GA. After up-gradation I found this issue.It is related to performance issue??

       

      Thanks in advance.

        • 1. Re: javax.resource.ResourceException: IJ000453 Unable to get managed connection for java:jboss/jdbc/
          jaikiran pai Master

          When asking for help, always provide the precise description of when and how you are running into an issue and always include the relevant logs and exception stacktraces. Without that, in its current form, it's highly unlikely to know what's causing the issue.

           

          P.S: JBoss AS 7.x is really old and it's no longer being developed (for bug fixes or features). WildFly (JBoss AS has been renamed to WildFly) 10.x is the latest available version, which is what I would recommend you to migrate to Downloads · WildFly. It may not be related to the issue you are running into, but JBoss AS 7.x at this point is no longer maintained.

          • 2. Re: javax.resource.ResourceException: IJ000453 Unable to get managed connection for java:jboss/jdbc/
            Wolf-Dieter Fink Master

            As already mentionend by Jaikiran, I would also strongly recommend to download the latest WildFly release, it is the successor of JBossAS7.

             

            The Problem might be

            1. A pool configuration problem as you have too less connections for the current load

            2. A DB (connection) problem as the pool can not create a new connection because of driver or connection issues

             

            You should provide a brief description and the full stacktrace for more help

            • 3. Re: javax.resource.ResourceException: IJ000453 Unable to get managed connection for java:jboss/jdbc/
              Saurabh Gadariya Newbie

              Logs::

              ------------

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Trying to solve an invalid connection.

              30-06-2016 14:01:38 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction

              30-06-2016 14:01:38 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Propagating exception: javax.resource.ResourceException: IJ000460: Error chec

              king for a transaction

              30-06-2016 14:01:38 ERROR com.kpn.common.dao.oracle.OracleDatabase [getOomConnection] javax.resource.ResourceException: IJ000460: Error checking for a transaction: java

              .sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction

               

               

              .....

              .....

              30-06-2016 18:29:19 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection

              for java:jboss/jdbc/tie/OomDB

              30-06-2016 18:29:19 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 18:29:19 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection

              for java:jboss/jdbc/tie/OomDB

              30-06-2016 18:29:19 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Trying to solve an invalid connection.

              30-06-2016 18:29:19 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 18:29:19 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection

              for java:jboss/jdbc/tie/OomDB

              30-06-2016 18:29:19 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 18:29:19 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection

              for java:jboss/jdbc/tie/OomDB

              30-06-2016 18:29:19 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 18:29:20 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection

              for java:jboss/jdbc/tie/OomDB

              30-06-2016 18:29:20 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 18:29:21 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection

              for java:jboss/jdbc/tie/OomDB

              30-06-2016 18:29:21 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Trying to solve an invalid connection.

              30-06-2016 18:29:21 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 18:29:21 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection

              for java:jboss/jdbc/tie/OomDB

              30-06-2016 18:29:21 INFO  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] Retrying create of connection

              30-06-2016 18:29:21 WARN  com.kpn.common.dao.oracle.OracleDatabase [createValidConnection] javax.resource.ResourceException: IJ000453: Unable to get managed connection

              for java:jboss/jdbc/tie/OomDB

              ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

               

              Oracle Version  10G

               

               

              ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

               

              Jboss Configuration

               

              <datasource jndi-name="java:jboss/jdbc/tie/OomDB"

                pool-name="OomDB" enabled="true" use-java-context="true">

                <connection-url>somrthing</connection-url>

                <driver>oracle</driver>

                <pool>

                <min-pool-size>10</min-pool-size>

                <max-pool-size>50</max-pool-size>

                <prefill>true</prefill>

                </pool>

                <security>

                <user-name>oomuser</user-name>

                <password>oomuser</password>

                </security>

                <new-connection-sql>select sysdate from dual</new-connection-sql>

                <validation>

                <check-valid-connection-sql>select sysdate from dual

                </check-valid-connection-sql>

                </validation>

                </datasource>