Symptom:
JBoss Application server hangs after running for some periods of time with the following error mesagge:
org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
Cause:
Most likely connection pool leakage, i.e. open database connection but not properly close
Solution:
Correct code accordingly in order to close database connection gracefully.
Temporary solution:
Increase the number of pool by editing the <database>-ds.xml file, add the following lines:
<min-pool-size>0</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>30000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
JBoss Application server hangs after running for some periods of time with the following error mesagge:
org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
Cause:
Most likely connection pool leakage, i.e. open database connection but not properly close
Solution:
Correct code accordingly in order to close database connection gracefully.
Temporary solution:
Increase the number of pool by editing the <database>-ds.xml file, add the following lines:
<min-pool-size>0</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>30000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
No comments:
Post a Comment