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 (herse.apache.org: domain of ductaa@gmail.com designates
 209.85.132.240 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=EtbYZOMN32xr0cgopNX/Msq72msLGyNZrTlcwH9jNDOfOFP1CzB1P9aiCLY1VuuivfJmRy/qi3USpydgmU/7+oAWXw8dE8EM2f7S6QbQiY9bWenEbWizH3i/sAeGCgJQ1hKH6urAWnf31X31BMWhwjaJkZJGk9HK4PEYoZruzQ8=
Message-ID: <a89437d30701111228m5a7e2ce6ucbad5d60fd987507@mail.gmail.com>
Date: Thu, 11 Jan 2007 15:28:12 -0500
From: "David Uctaa" <ductaa@gmail.com>
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: How to forcibly close abandoned database connections?
In-Reply-To: 
 <C42A63EE6824F744AD34570455B422658D6A69@UKACPX004.uk.int.atosorigin.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <a89437d30701100618x79d68731sb4d9f05c2f7a2d42@mail.gmail.com>
	 <C42A63EE6824F744AD34570455B422658D6A69@UKACPX004.uk.int.atosorigin.com>

Created a little admin app to do just that, and it worked perfectly.
All the connections being shown as "busy" cleared right out, and only
the minimum number of idle / available connections remained.

Thanks much.

On 1/10/07, Varley, Roger <Roger.Varley@atosorigin.com> wrote:
>
> >
> > I agree that is probably what is happening, since the application has
> > gone idle.  However, with garbage collection, while it will only
> > reclaim memory when necessary, there is a way to force garbage
> > collection.  I am looking for a similar process with abandoned
> > database connections.
> >
>
> If the connections will only re-cycle with increased demand, could you not create that demand with an "admin" type program that requests, opens & then closes X connections?
>
> Regards
> Roger
>
> _______________________________________________________
>
> This e-mail and the documents attached are confidential and intended
> solely for the addressee; it may also be privileged. If you receive this
> e-mail in error, please notify the sender immediately and destroy it.
> As its integrity cannot be secured on the Internet, the Atos Origin group
> liability cannot be triggered for the message content. Although the
> sender endeavours to maintain a computer virus-free network, the
> sender does not warrant that this transmission is virus-free and will
> not be liable for any damages resulting from any virus transmitted.
> _______________________________________________________
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

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