The AS7 book!

JBoss Tuning

JBoss 5 book

No Registration required. Use your FB account to add comments to articles.

Twitter Button

Poll

Which is your favourite JSF library?
 
Top Programming Sites
Home JBoss AS JBoss run out of Connections ?

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 !