4 Replies Latest reply on Dec 3, 2013 2:32 AM by Wolf-Dieter Fink

    IJ000453: Unable to get managed connection for java:/jdbc/TestDataSource in Jboss EAP 6.0.1

    Venugopal K Newbie

      Hi,

       

      We are using Jboss EAP 6.0.1 server and Database is: Oracle. After certain tries, we are getting "IJ000453: Unable to get managed connection for java:/jdbc/TestDataSource". Could somebody help us? Below is the complete exception stacktrace.

       

      Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/TestDataSource

              at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147) ~[ironjacamar-jdbc-1.0.13.Final-redhat-1.jar!/:1.0.13.Final-redhat-1]

              at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) ~[spring-jdbc-3.1.0.RELEASE.jar!/:3.1.0.RELEASE]

              at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) ~[spring-jdbc-3.1.0.RELEASE.jar!/:3.1.0.RELEASE]

              ... 74 common frames omitted

      Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/TestDataSource

              at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:390) ~[na:na]

              at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368) ~[na:na]

              at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464) ~[na:na]

              at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139) ~[ironjacamar-jdbc-1.0.13.Final-redhat-1.jar!/:1.0.13.Final-redhat-1]

              ... 76 common frames omitted

      Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (5000 [ms])

              at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:384) ~[na:na]

              at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397) ~[na:na]

              at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365) ~[na:na]

              at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329) ~[na:na]

              ... 79 common frames omitted

       

      Below is the Datasource configurations in standalone.xml:

       

      <datasource jta="true" jndi-name="java:/jdbc/TestDataSource" pool-name="TestDataSource" enabled="true" use-java-context="true" use-ccm="true">

                          <connection-url>jdbc:oracle:thin:@<hostName>:<portNumber>:<SID></connection-url>

                          <datasource-class>oracle.jdbc.OracleDriver</datasource-class>

                          <driver>oracle</driver>

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

                          <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

                          <pool>

                              <min-pool-size>2</min-pool-size>

                              <max-pool-size>5</max-pool-size>

                              <prefill>true</prefill>

                          </pool>

                          <security>

                              <user-name>username</user-name>

                              <password>password</password>

                          </security>

                          <validation>

                              <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>

                              <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>

                              <background-validation-millis>30000000</background-validation-millis>

                          </validation>

                          <timeout>

                              <blocking-timeout-millis>5000</blocking-timeout-millis>

                              <query-timeout>5</query-timeout>

                          </timeout>

                          <statement>

                              <prepared-statement-cache-size>25</prepared-statement-cache-size>

                          </statement>

                      </datasource>

       

      Are we missing to set any configuration parameter?

       

      Thanks,

      Venu