Advertise with us

Our eBooks

JBoss run out of Connections ?

Have you got No ManagedConnections available error message ? well there are 4 possible cause to this problem.......

# 1  Your connection pool is too small

Increase the max number of connections in your Datasource .ds.xml file

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

# 2  Your threads are being starved by cpu

Incresing the blocking timeout from default 30000 in your Datasource ds.xml

<blocking-timeout-millis>50000</blocking-timeout-millis>

# 3 You are not closing connections properly


Are you closing your connections in the finally method ? (If not your job is really in danger )

finally {
    if (resultSet != null)
      resultSet.close();
    if (statement != null)
      statement.close();

    connection.close();
}

#4 You have hit a bug !

This is the most unlikely......anyway a couple of bugs existed with release 3.2.5 and earlier, so check the bug parade !

Check the following article to learn how to trace your Datasource connections: How to trace JDBC statements with JBoss and WildFly

© 2021 mastertheboss.com. All Rights Reserved.

Please publish modules in offcanvas position.