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 working in webportal using Java,Mysql. I am facing below issue. I cant able to resolve the issue. Daily i am restart the server then this issue is not coming... how to resolve this issue. without restart the server....
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
Jan Cumps wrote:This happens when you do not close each connection you get from the pool.
Are you sure ? For me the error explains something like user set the number of connection to very less or the maxIdle or maxActive set to zero, which cause the application out of connection when he needs one.
I'm not sure what the problem is here. But I think your web server is overwhelmed by the amount of load (the mysql connections) given to it. Here's a solution, close all of your mysql connections after use. Do not set mysql connection scope to "session".
Another solution is to speed up your web server. [link removed]
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com