i adjusted the pool to unlimited and am still getting these errors. something else seems to be fekachte.
barclay -----Original Message----- From: Eric J. Pinnell [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 1:11 PM To: Tomcat Users List Subject: Re: Help! heavy traffic is crapping out our site every 5 min! DBCP exceptions Hi, Your pool of connections to your database is exhausted. Try upping the number. -e On Fri, 8 Aug 2003, Barclay A. Dunn wrote: > we are getting a ton of these errors in our catalina.out and i could use > help in fixing it. > > i know they are related to our connection pooling, but not what to do to > fix. my understanding of the underlying mechanics of connection pooling is > somewhat limited. > > i have put two different but related error messages in here: > > java.sql.SQLException: DBCP could not obtain an idle db connection, pool > exhausted > at > org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool > .java:123) > at > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.ja > va:110) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 > 12) > at com.happypuppy.util.HPSql.getConnection(HPSql.java:21) > at org.apache.jsp.index_jsp._jspService(index_jsp.java:222) > at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 > 04) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher. > java:684) > at > org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatch > er.java:575) > at > org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher > .java:498) > at > org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:8 > 22) > at org.apache.jsp._404_jsp._jspService(_404_jsp.java:373) > at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 > 04) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > va:260) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > va:191) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 > ) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. > java:170) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 > ) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java > :174) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458) > at > org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551) > at java.lang.Thread.run(Thread.java:536) > > org.apache.commons.dbcp.DbcpException: java.sql.SQLException: > [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne > ctionFactory.java:85) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect > ionFactory.java:184) > at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source) > at > org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool > .java:117) > at > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.ja > va:110) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 > 12) > at com.happypuppy.util.HPSql.getConnection(HPSql.java:21) > at com.happypuppy.util.HPUser.isLoggedIn(HPUser.java:121) > at > org.apache.jsp.checkLoggedIn_jsp._jspService(checkLoggedIn_jsp.java:56) > at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 > 04) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher. > java:684) > at > org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatch > er.java:575) > at > org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher > .java:498) > at > org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:8 > 22) > at org.apache.jsp._404_jsp._jspService(_404_jsp.java:351) > at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 > 04) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > va:260) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > va:191) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 > ) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. > java:170) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 > ) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java > :174) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458) > at > org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551) > at java.lang.Thread.run(Thread.java:536) > Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for > JDBC]Error establishing socket. > at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown > Source) > at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown > Source) > at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown > Source) > at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown > Source) > at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown > Source) > at > com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source) > at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) > at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne > ctionFactory.java:83) > ... 51 more > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]