Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
User-Agent: Microsoft-Entourage/11.4.0.080122
Date: Fri, 21 Aug 2009 09:10:51 -0700
Subject: Re: Connection Pool Exhausted
From: Kristen  Walker <kwalker@sbceo.org>
To: Tomcat Users List <users@tomcat.apache.org>
Message-ID: <C6B4151B.7C7D%kwalker@sbceo.org>
Thread-Topic: Connection Pool Exhausted
Thread-Index: AcoiefPKMiD+XI5tEd6n0QAX8ggiCA==
In-Reply-To: <321685.13595.qm@web63102.mail.re1.yahoo.com>
Mime-version: 1.0
Content-type: text/plain;
	charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

I just wanted to report back on the connection pool exhausted issue.  I got
some help from the JASIG uPortal list and it turns out that some of my
settings in the uPortal config files were screwing with the way database
connection pooling was working.  Now that those settings have been tweaked,
it appears that connection pooling is working.  I am still doing some
testing over here, but things are looking a lot better now that the uPortal
settings are correct.

Thanks for all the help and troubleshooting ideas!  I really appreciate it.

-Kristen


On 8/17/09 12:29 PM, "Bob Hall" <rfhall3@yahoo.com> wrote:

> --- On Mon, 8/17/09 at 11:38 AM, Kristen Walker <kwalker@sbceo.org> wrote=
:
>=20
>> We had some help debugging the connection pool exhausted issue over the
>> weekend and for now it seems that changing jdbcUsePool=3Dtrue to
>> jdbcUsePool=3Dfalse stops the site from crashing due to connection pool
>> issues.=A0 We are going to investigate more to see why connection pooling
>> isn't working like expected.
>=20
> You can obtain a stack trace that should point to the offending code
> by using the Deprecated log abandoned functionality in BasicDataSource:
>=20
>    setLogAbandoned()
>    setRemoveAbandoned()
>    setRemoveAbandonedTimeout()
>=20
>   =20
> http://commons.apache..org/dbcp/apidocs/org/apache/commons/dbcp/BasicData=
Sourc
> e.html
>=20
> There is some indication that logging of abandoned connections/statements
> will continue in some form:
>=20
>   http://wiki.apache.org/commons/DBCP
>=20
> - Bob
>=20
>=20
>=20
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>=20

--
Kristen Walker

Digital Media Resources Developer
Instructional Media Services
Santa Barbara County Education Office
4400 Cathedral Oaks Road
P.O. Box 6307
Santa Barbara, CA 93160-6307
(805)964-4711 ext. 5244/FAX (805)683-3597
kwalker@sbceo.org
http://www.sbceoportal.org


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