I should add that your app should use the connection and the throw it back in the pool rather quickly. Upping the connections might fix it or prolong the inevitable errors. You should really find out why you are not releasing the connections.
It is possible you could just have so much traffic that you need another tomcat. -e On Fri, 8 Aug 2003, Eric J. Pinnell wrote: > Is it also unlimited (or insanely huge) on the database? > > -e > > On Fri, 8 Aug 2003, Barclay A. Dunn wrote: > > > 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] > > > > > > --------------------------------------------------------------------- > 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]
