Re: [GENERAL] SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.sukla@xxxxxxxxx> 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)







-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux