Re: 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 parameters of 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 database connections?

Good luck :)

El 17/04/2013, a las 17:01, itishree sukla <itishree(dot)sukla(at)gmail(dot)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 running on 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)