10 Replies Latest reply on Sep 21, 2006 8:07 AM by Dejan Kocic

    Connection pool problem:No ManagedConnections available

    praneeth reddy Newbie

      Hi,
      I am getting the following exception when i try to get the connection from the connection pool
      (I set the max-connection pool size to 100)

      No ManagedConnections available within configured blocking timeout ( 20000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 20000 [ms] ))

      Is there any way to monitor the number of connections in connection pool?

      Following is the datasource file:

      <local-tx-datasource>
      <jndi-name>defaultSource</jndi-name>
      <connection-url>jdbc:oracle:thin:@localhost:1521:host</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>username</user-name>
      password
      <min-pool-size>5</min-pool-size>
      <max-pool-size>100</max-pool-size>
      <max-idle-timeout>0</max-idle-timeout>
      <blocking-timeout-millis>20000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      <track-statements>false</track-statements>
      </local-tx-datasource>

      Thanks