tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristen Walker <kwal...@sbceo.org>
Subject Re: Connection Pool Exhausted
Date Fri, 21 Aug 2009 16:10:51 GMT
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:
> 
>> We had some help debugging the connection pool exhausted issue over the
>> weekend and for now it seems that changing jdbcUsePool=true to
>> jdbcUsePool=false stops the site from crashing due to connection pool
>> issues.  We are going to investigate more to see why connection pooling
>> isn't working like expected.
> 
> You can obtain a stack trace that should point to the offending code
> by using the Deprecated log abandoned functionality in BasicDataSource:
> 
>    setLogAbandoned()
>    setRemoveAbandoned()
>    setRemoveAbandonedTimeout()
> 
>    
> http://commons.apache..org/dbcp/apidocs/org/apache/commons/dbcp/BasicDataSourc
> e.html
> 
> There is some indication that logging of abandoned connections/statements
> will continue in some form:
> 
>   http://wiki.apache.org/commons/DBCP
> 
> - Bob
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
> 

--
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


Mime
View raw message