Return-Path: Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list commons-user@jakarta.apache.org Received: (qmail 65582 invoked from network); 21 May 2003 19:49:00 -0000 Received: from amcuxfw803.amc.af.mil (HELO fw3.amc.af.mil) (131.9.254.187) by daedalus.apache.org with SMTP; 21 May 2003 19:49:00 -0000 Received: from amcw2av801.amc.ds.af.mil (amcw2av801.amc.af.mil [131.9.19.109]) by fw3.amc.af.mil with SMTP id h4LJmFEE000254; Wed, 21 May 2003 14:48:58 -0500 (CDT) Received: from amcw2ms873.amc.ds.af.mil ([131.9.25.137]) by amcw2av801.amc.ds.af.mil (SAVSMTP 3.0.1.45) with SMTP id M2003052114135014669 ; Wed, 21 May 2003 14:13:50 -0500 Received: from amcw2ms812.amc.ds.af.mil ([131.9.19.76]) by amcw2ms873.amc.ds.af.mil with Microsoft SMTPSVC(5.0.2195.5329); Wed, 21 May 2003 14:13:50 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: RE: DBCP options Date: Wed, 21 May 2003 14:13:49 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: DBCP options Thread-Index: AcMe8ioGveQCKuGhSpOdCsvkfkOK+AA2PWbw From: "Durham David Contr 805 CSS/SCBE" To: "Jakarta Commons Users List" , X-OriginalArrivalTime: 21 May 2003 19:13:50.0001 (UTC) FILETIME=[1C4C1210:01C31FCD] X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N > -----Original Message----- > From: Matthew Denson [mailto:mdenson@dayspring-tech.com] >=20 >=20 > I would recommend using the Jdbc2PoolDataSource which is in=20 > common-dbcp > after version 1.0. The API page for that package > http://jakarta.apache.org/commons/dbcp/apidocs/org/apache/comm > ons/dbcp/j > dbc2pool/package-summary.html is very helpful. If you want other help > let me know I got something to work that is very similar to your > situation for Oracle8i. >=20 The help is much appreciated. My understanding is that using setDefaultMaxActive(int maxActive) will = mean that I will never have more than max connections active. = Furthermore, using setDefaultMaxIdle(int maxIdle) will mean that idle = connections beyond maxIdle will be closed. When will they be closed? = It doesn't appear idle connections beyond maxIdle are being removed, or = I just don't know what is going to trigger that. Perhaps I need to do a = bit more config for that to happen? > Hope this helps, > Matthew Dave