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

[gadar]

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.

[jaikiran]

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.

[wdfink]

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

[gadar]

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>