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)
From: "Caldarale, Charles R" <Chuck.Caldarale@unisys.com>
To: Tomcat Users List <users@tomcat.apache.org>
Date: Wed, 4 Nov 2009 09:06:04 -0600
Subject: RE: ConnectionPool question
Thread-Topic: ConnectionPool question
Thread-Index: AcpdVq1d2VbRkm0mTh2lzZfd+OCyZwACDKuQ
Message-ID: 
 <99C8B2929B39C24493377AC7A121E21F967C354C6A@USEA-EXCH8.na.uis.unisys.com>
References: <4d7e0b220910291817i390fc7ccu40afc1ec00012b83@mail.gmail.com>
	 <4AEB5751.9060100@christopherschultz.net>
	 <4d7e0b220910302138r18ac7d5fs710b2f42f078bfba@mail.gmail.com>
	 <b97771c60911020108hce277d2n58a8e33994a4e805@mail.gmail.com>
	 <4AEF43C0.60708@christopherschultz.net>
	 <4d7e0b220911031101w652af97eubcd85d717aaacf5b@mail.gmail.com>
	 <4d7e0b220911031202j54b7c38k6ff771821793d6e4@mail.gmail.com>
	 <b97771c60911031213ocde5d2cqfbb98b579fad0e7d@mail.gmail.com>
	 <4d7e0b220911031224o32741dbcvff05932df1397244@mail.gmail.com>
	 <4d7e0b220911031306j7a365caelb60151fbf56f6d41@mail.gmail.com>
 <4d7e0b220911040556l70d17505sd8672a739861b94c@mail.gmail.com>
In-Reply-To: <4d7e0b220911040556l70d17505sd8672a739861b94c@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

> From: Josh Gooding [mailto:josh.gooding@gmail.com]
> Subject: Re: ConnectionPool question
>=20
> everytime I recycle a connection (close RS, statement, and the
> connection) does it place it back into the pool or is that what the
> abandoned connection messages are for letting me know they were
> abandoned and put back into the pool?

There are actually two sets of connection objects here: the real connection=
 to the DB server, and an associated connection wrapper that's visible to t=
he webapp(s).  If a webapp fails to close a connection wrapper and its asso=
ciated real connection stays idle beyond the configured limit, the associat=
ion between the wrapper and real connection is severed, the real connection=
 is returned to the pool, and the wrapper is discarded; it's at this time t=
hat the log entry is made, containing the stack trace of the point where th=
e wrapper was acquired by the webapp.

When the webapp closes the wrapper, both the real connection and the wrappe=
r are made available for reuse.

 - Chuck


THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MA=
TERIAL and is thus for use only by the intended recipient. If you received =
this in error, please contact the sender and delete the e-mail and its atta=
chments from all computers.


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