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

Posted on 2009-02-11
Last Modified: 2013-11-24
what is the cause of this error?
Question by:Dehankar
    LVL 23

    Accepted Solution

    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....


    Author Closing Comment


    Author Comment


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    I had a project requirement for a displaying a user workbench .This workbench would consist multiple data grids .In each grid the user will be able to see a large number of data. These data grids should allow the user to 1. Sort 2. Export the …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    The viewer will learn how to implement Singleton Design Pattern in Java.
    This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now