0 Replies Latest reply on Oct 13, 2013 10:34 AM by Ravi Patil

    No managed connection available within the configured blocking timeout 30000 millis

    Ravi Patil Newbie

      Hi All,

       

      I am using Jboss AS 7.2.0 and I have configured around 11 datasources.

       

      I am getting No managed connection available within the configured blocking timeout 30000 millis

      I tried below options:

      manipulated on min, max connection pool size

      Idle timeout

      blocking timeout i set to 60000 millis

      but still it is throwing below error:

       

      2013-10-13 19:26:48,388 | DEBUG | com.company.DebugInterceptor | ref:1803431940 | 93 |

      DebugInterceptor.invoke | (Includes Exception Data) Could not get JDBC Connection; nested exception is

      java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for

      java:jboss/datasources/MYDS| http-/0.0.0.0:8080-1 |

      org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is

      java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/MYDS

      ..............................................

       

      Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/MYDS

      ...............................................

       

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

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

              at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)

              at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)

              at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:364)

              ... 109 more

       

       

      My datasource configuration is

                      <datasource jta="true" jndi-name="java:jboss/datasources/MYDS" pool-name="MYDS" enabled="true" use-java-context="true" use-ccm="true">

                          <connection-url>jdbc:oracle:thin:@TNS</connection-url>

                          <driver>oracle</driver>

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

                          <pool>

                              <min-pool-size>30</min-pool-size>

                              <max-pool-size>100</max-pool-size>

                              <prefill>true</prefill>

                              <use-strict-min>false</use-strict-min>

                              <flush-strategy>FailingConnectionOnly</flush-strategy>

                          </pool>

                          <security>

                              <user-name>uname</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 * from dual</check-valid-connection-sql>

                              <background-validation>true</background-validation>

                              <background-validation-millis>10000</background-validation-millis>

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

                              <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>

                          </validation>

                          <timeout>

                              <blocking-timeout-millis>60000</blocking-timeout-millis>

                              <idle-timeout-minutes>1</idle-timeout-minutes>

                              <allocation-retry>3</allocation-retry>

                          </timeout>

                      </datasource>

       

                            <driver name="oracle" module="com.oracle">

                              <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>

                          </driver>

      I am using oracle db and ojdbc6.jar as the driver and jdk 1.6.0.update 26

       

      Please help me to get out of this exception

       

      Thanks

      Ravi