1 Reply Latest reply on Nov 20, 2008 10:14 AM by jaikiran pai

    No ManagedConnections available within configured blocking t

    Juan Carbajal Newbie

      Hello everyone:
      I heard JBOOS 4.0.2 has a bug when it comes to db pooling,
      I 've upgraded my version to 4.2.2 G.A. and it didn't help at all
      I 'm still facing th "No ManagedConnections available within configured blocking timeout ( 60000 [ms] )" problem, funny, it just shows up with DB2 8 DBMS.
      I am certain I have no pool leakin all my connections within my apps are closed and this is what I've got in my datasource.
      <?xml version="1.0" encoding="UTF-8"?>

      <local-tx-datasource>
      <jndi-name>jdbc/jndiname</jndi-name>
      <connection-url>jdbc:db2://server:port/db</connection-url>
      <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
      <user-name>user</user-name>
      pasword
      <min-pool-size>10</min-pool-size>
      <max-pool-size>100</max-pool-size>
      <blocking-timeout-millis>60000</blocking-timeout-millis>
      <idle-timeout-minutes>5</idle-timeout-minutes>
      </local-tx-datasource>

      If you realize I have a loose maxpoolsize
      In my DB2 8 db settings I have the following
      Max number of active applications (MAXAPPLS) = AUTOMATIC
      Max number of existing agents (MAXAGENTS) = 400
      thanks in advance