Errororg.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

what is the cause of this error?
DehankarAsked:
Who is Participating?
 
rama_krishna580Commented:
Check that the setting for the maximum number of connections in the pool is adequate.

I would highly recommend /against/ "no limit" connection pools. Even if you try set the connection pool size to be the same as the request handler pool size (which should be equivalent a long as you don't have DB connection leaks), you shouldn't set it to "no limit". You could bring down your database server if you have a connection leak on an app server. It's best to set your limit to something reasonable, but firm.

--> Setting the maxactive other than 0 and your problem will be solved....

R.K
0
 
DehankarAuthor Commented:
thanks
0
 
DehankarAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.