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

[itishree sukla <itishree.sukla@xxxxxxxxx>]

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