Return-Path: 
 <commons-user-return-4813-apmail-jakarta-commons-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org
Received: (qmail 55790 invoked from network); 4 Sep 2003 12:03:24 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 4 Sep 2003 12:03:24 -0000
Received: (qmail 65327 invoked by uid 500); 4 Sep 2003 12:03:10 -0000
Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org
Received: (qmail 65269 invoked by uid 500); 4 Sep 2003 12:03:09 -0000
Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:commons-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:commons-user-subscribe@jakarta.apache.org>
List-Help: <mailto:commons-user-help@jakarta.apache.org>
List-Post: <mailto:commons-user@jakarta.apache.org>
List-Id: "Jakarta Commons Users List" <commons-user.jakarta.apache.org>
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
Delivered-To: mailing list commons-user@jakarta.apache.org
Received: (qmail 24165 invoked from network); 4 Sep 2003 10:16:06 -0000
Message-ID: <1D2B2C77C9CF964EB1331ABEB51562E101C0F4D7@ukntsvr2.uk.drte.com>
From: "Keates, Mark" <Mark.Keates@dendrite.com>
To: "Jakarta Commons Users List (E-mail)" <commons-user@jakarta.apache.org>
Subject: [DBCP]
Date: Thu, 4 Sep 2003 04:26:54 -0400
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain; charset="iso-8859-1"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Hi,

I'm using pooling within a Servlet (under Tomcat) against Oracle with
'maxIdle=3' and 'maxActive=4' settings.
I do see the 4 connections drop down to 3 but the remaining connections
persist against the database.
Does anyone have a method by which these will disconnect if the connection
is idle for a given time,
i.e. no activity? If this is done on the Oracle side, then it can't be
global, i.e. affect other users.

Regards,

Mark

          <Resource name="jdbc/TestServlet" auth="Container"
                    type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/TestServlet">
		<parameter>
			<name>factory</name>
	
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
		</parameter>
		<parameter>
			<name>username</name>
			<value>xxx</value>
		</parameter>
		<parameter>
			<name>password</name>
			<value>yyy</value>
		</parameter>
		<parameter>
			<name>driverClassName</name>
			<value>oracle.jdbc.driver.OracleDriver</value>
		</parameter>
		<parameter>
			<name>url</name>
			<value>jdbc:oracle:thin:@host:port:instance</value>
		</parameter>
		<parameter>
			<name>validationQuery</name>
			<value>SELECT 1 FROM DUAL</value>
		</parameter>
		<parameter>
			<name>maxActive</name>
			<value>4</value>
		</parameter>
		<parameter>
			<name>maxIdle</name>
			<value>3</value>
		</parameter>
		<parameter>
			<name>maxWait</name>
			<value>30000</value>
		</parameter>
		<parameter>
			<name>removeAbandoned</name>
			<value>true</value>
		</parameter>
		<parameter>
			<name>logAbandoned</name>
			<value>true</value>
		</parameter>
		<parameter>
			<name>removeAbandonedTimeout</name>
			<value>120</value>
		</parameter>
          </ResourceParams>


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

**********************************************************************


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org