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" <rfha...@yahoo.com> wrote: > --- On Mon, 8/17/09 at 11:38 AM, Kristen Walker <kwal...@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-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@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 kwal...@sbceo.org http://www.sbceoportal.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
