-
1. Re: javax.resource.ResourceException: IJ000453 Unable to get managed connection for java:jboss/jdbc/
jaikiran Jul 6, 2016 2:47 AM (in response to gadar)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/
wdfink Jul 7, 2016 2:14 AM (in response to gadar)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/
gadar Jul 8, 2016 1:58 AM (in response to 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>