When I FIRST make a DB query through one of my JSPs/servlets, I get this msg printed to the console.
AbandonedObjectPool is used (org.apache.commons.dbcp.abandonedobjectp...@b32627) LogAbandoned: true RemoveAbandoned: true RemoveAbandonedTimeout: 30 I don't get it afterwards, possibly insinuating I'm using one connection that get's recycled. Even if I get an exception error later thrown (printed) to the console, it doesn't give me that message again. -----Original Message----- From: Elli Albek [mailto:e...@sustainlane.com] Sent: Wednesday, November 04, 2009 6:02 PM To: Tomcat Users List Subject: Re: ConnectionPool question As far as I remember, "abandoned" is a connection that was not closed. So if you call recycle on a connection it will not generate abandoned message. The messages that you see are from connections that you do not close. I also remember that closing a connection closes statements and result sets, but it has been a while since I read the source. Give the filter above a shot. It would takes maybe an hour to get running and can solve all your problems in one go. You may experience a major boost to your system performance even comparing to closing every connection (because you will be using a single connection per request as opposed to multiple open/close). E On Wed, Nov 4, 2009 at 11:43 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Josh, > > On 11/4/2009 12:11 PM, Josh Gooding wrote: > > type="javax.sql.DataSource" > > [snip] > > > <res-type>javax.sql.DataSource</res-type> > > I believe it is these types that must match, and they do. Don't change > a thing. > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAkrx2VUACgkQ9CaO5/Lv0PCvIQCgvuD2fkIQ7iHH+xlT22SdRmnq > E7YAn0JmNbP22/rm6hwKPchNm1dbbXyj > =zIOM > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
