WhatDoesTheMessageNoManagedConnectionsAvailableMean

    What Does The Message No Managed Connection Available mean?

     

    It means that all possible connections to the db are in use and/or that a thread has timed-out waiting for a connection to open up.

     

    Possible solutions:

     

    Increase your connection pool size

    Add

    <max-pool-size>whatever</max-pool-size>

    to your -ds.xml file to increase

    the number of connections available. The default is 20

     

    There is an attribute

    MaxConnectionsInUse

    viewable on the jmx-console against the

    ManagedConnectionPool

    that can help you understand how many connections you really need.

     

    Tell your threads to wait longer for a connection to open up

    Add

    <blocking-timeout-millis>whatever</blocking-timeout-millis>

    to your -ds.xml file to increase the length of time to wait. The default is 30000 (5000 before JBoss-3.2.4) milli-seconds.

     

    Make sure you are properly closing open connections

     

    CanJBossTellMeWhenIDontCloseAConnection?