tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Sinclair <stevensincl...@163.com>
Subject Re: Tomcat DBCP Connection pool issue
Date Tue, 26 Jun 2012 06:39:02 GMT
在 2012-6-26,13:11,Kiran Badi <kiran@poonam.org> 写道:

> Hi All,
> 
> While testing the pagination links ,I am getting below error,
> 
> SEVERE: null
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout
waiting for idle object
>    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
>    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
>    at indianads.getServicesTourDetail.doGet(getServicesTourDetail.java:106)
>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>    at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> Was able to get connection
>    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
>    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
>    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
>    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
>    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
>    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
>    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394)
>    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
>    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
>    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:166)
>    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
>    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>    at java.lang.Thread.run(Thread.java:662)
> Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
>    at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1144)
>    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
>    ... 24 more
> 
> Where should I look to see as how many connection are establised on the DB side and how
many I have still that I can use ?
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
> 

You can use java jmx console to monitor the number of db connections.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message