This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I am using Jboss 3.2.5, is there any solution to avoid getting this exception org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 5000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within c onfigured blocking timeout ( 5000 [ms] ))
I have increased the blocking timeout also ,& We are closing all the connections properly and there is no heavy load on the server also but still this exception is coming.
Can any one please let me know the solution for this ASAP.
Are you sure your EJBs are using DB connections longer than 5000ms? What is DB pool size? How many concurent users do you have? I think you can set timeout to 60000 (1 minute) as EJB server can be loaded hard. Or you have to set bigger DB pool size. It is better than to get this exception about used all DB connections.
Please check whether you are closing all the connections. For this take a log of the ConnectionManager of JBoss which indicates how many connections are closed or alive or locked in the pool. One more thing i guess i have read there is some leakage of connection in 3.2.5 connection pooling in JBoss. Any way try getting the log of the managed connection pool of JBoss. Here is the piece of code you would want to add in log4j.xml. So that you get the log for the connection manager