I have been a AVID listener/responder in SCJP Forum but new to this Servlet Discussions. I dont have much of working exposure towards servlets, but know the fundamentals of it.
My application is working in Struts/JSPs and I get this following error, when using any link on my 'Web Interface', after sometime. Upon restarting the web server, things start working properly. This error is not application-specific but it is a servlet exception. The error that gets displayed is :
javax.servlet.ServletException: Could not retrieve connection info from pool, cause: Timeout waiting for idle object at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) ... ... ...
The above error could be due to some improper coding in the application. But, I want to know, what all could be the possible cause for this kind of error.
If I could get some pointers in this direction, I can proceed in solving this. The application is in production and is used by a lot of users (> 500).
Thanks in advance, _Mani
[ April 25, 2005: Message edited by: Manikandan Jayaraman ] [ April 25, 2005: Message edited by: Manikandan Jayaraman ]
Please see your connection pool setting in server.I mean have you assigned enough connections for the application.I dont remember the exact properties but there are max connection,max connections live etc..
Please check those settings. You might get some clue.
"There are no mistakes, only lessons"
Joined: Sep 15, 2004
I am using Tomcat web server. I am not able to find the properties regarding connection pooling in Tomcat Administration and Tomcat Manager.
I had similar experience in having not closing the connection pool. I tried to fix it using shortcuts, but it didnt work. One thing was I increased the pool size. But again after little longer than usual, we had the same pbm.
So the main thing is to check where all you use the connection, check if you are closing the connection. Also ensure that you are closing the connections in a catch block, since if some errors come, that connection might be left hanging.
Hope this helps
Joined: Sep 15, 2004
May I know where should I configure my Pool Size? Can someone guide me here with respect to Tomcat Server?
In your haste to come in and ask a question, you seem to have missed reading our policy on display names, which quite clearly states that you must use a real (sounding) first and last name for your display name -- no joke names, "handles," or last initials are acceptable, no "exceptions" You can fix your display name here. Thanks for your cooperation!