Return-Path: <seanslists@comcast.net>
Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Delivered-To: mailing list commons-user@jakarta.apache.org
Received: (qmail 9847 invoked from network); 8 Aug 2003 22:07:11 -0000
Received: from rwcrmhc12.comcast.net (216.148.227.85)
  by daedalus.apache.org with SMTP; 8 Aug 2003 22:07:11 -0000
Received: from comcast.net (unknown[65.116.140.143](misconfigured sender))
          by comcast.net (rwcrmhc12) with SMTP
          id <2003080822071801400jm5d0e>
          (Authid: ferguson.sean);
          Fri, 8 Aug 2003 22:07:18 +0000
Message-ID: <3F341F16.8050809@comcast.net>
Date: Fri, 08 Aug 2003 15:07:18 -0700
From: "Sean W. Ferguson" <seanslists@comcast.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Jakarta Commons Users List <commons-user@jakarta.apache.org>
Subject: Re: Help! heavy traffic is crapping out our site every 5 min! DBCP
 exceptions
References: <NGEOKOKDGGGILDDBHCJNGEBICNAA.barclay@happypuppy.com>
In-Reply-To: <NGEOKOKDGGGILDDBHCJNGEBICNAA.barclay@happypuppy.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Well, I know nothing about the dbcp, but perhaps its actually running 
out of available pools?

Barclay A. Dunn wrote:
> i also asked for help from the tomcat-users list, and we narrowed my problem
> down to (surprise) dbcp problems.
> 
> 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, though i have subscribed to this list to remedy that if
> possible.
> 
> i am using a try / catch / finally block to close EVERY connection in my
> code. i mean 100%. but i think i am still seeing leaks.
> 
> thanks,
> barclay
> 
> 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)
> ...
> 
> AND
> 
> 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)
> ...
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
> 
>