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.su...@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 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-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general