well, i followed the dbcp comment that says "set to 0 for unlimited" and that turns out to be wrong.
i also tried -1 and that is equally unuseful in terms of setting it to unlimited. so i tried setting maxActive to 1000000000 and so far it is generating no errors. no, i'm wrong. connecs shot up to around 600 or maybe more, then we started getting the java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. the db has an insanely huge connection limit of 99,999 we think. barclay -----Original Message----- From: Eric J. Pinnell [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 1:27 PM To: Tomcat Users List Subject: RE: Help! heavy traffic is crapping out our site every 5 min! DBCP exceptions 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]
