Thread: SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

Hi Itsrhree

From the machine where is running the tomcat, do you check that you can connect to postgresql server (remember check
parametersof connection, user, password, ip)? 

Having this first step tested, then:

Do you have the correct connection pool configured on Catalina (Tomcat) and let this software to configure the pool of
databaseconnections? 

Good luck :)

El 17/04/2013, a las 17:01, itishree sukla <itishree.sukla@gmail.com> escribió:

> Dear All,
>
> Can any one please help me to fix this issue, i am getting this error from our application, currently Database is
runningon 9.2. 
>
> 2013-04-17 11:37:25:151 - {ERROR} database.ConnectionManager Thread [http-8080-1];  --- getConnection() Exception:
> org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
>     at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
>     at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
>     at com.tenkinfo.b2g.database.ConnectionManager.getConnection(ConnectionManager.java:39)
>     at com.tenkinfo.b2g.usermanagement.dao.UserManagementDAOImpl.getSessionData(UserManagementDAOImpl.java:228)
>     at com.tenkinfo.mapnsav.common.action.BaseAction.execute(BaseAction.java:156)
>     at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
>     at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
>     at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
>     at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>     at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
>     at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
>
> Do i have to set tcp _keepalive * paramter to less sec, or need to kill the idle connection ?
>
> Regards,
> Itishree

Alfonso Afonso
(personal)

I'd say you either have overloaded application (try increasing timeout), too small pool (increase pool) or connection leaks (find and fix).