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]