Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 87717 invoked from network); 26 Aug 2009 03:56:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 26 Aug 2009 03:56:16 -0000 Received: (qmail 12100 invoked by uid 500); 26 Aug 2009 03:56:37 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 12016 invoked by uid 500); 26 Aug 2009 03:56:37 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 12005 invoked by uid 99); 26 Aug 2009 03:56:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Aug 2009 03:56:36 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of chandrasekhargvv@gmail.com designates 209.85.219.206 as permitted sender) Received: from [209.85.219.206] (HELO mail-ew0-f206.google.com) (209.85.219.206) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Aug 2009 03:56:27 +0000 Received: by ewy2 with SMTP id 2so341459ewy.41 for ; Tue, 25 Aug 2009 20:56:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=m3gP2Cb8j3660tIax9w35fxRJ8OI+mYszzr+AtZ24qg=; b=ddFInFpilZQSjDMXbOO0Lb9i+avEDoU+qIxyfyd4f/sK0HQAVD04H4IvvJcTnhI1b/ 39R0PHPsdvxf9tN4FaJUBao8n5xF+sC14nh5pUazPaIoyUYSuaeYSG3f9+32qwHn3XwK E7+M9YyQ7MT+tiV6EIeloYik7cfU4g+BkwfOI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=BDfE+IchEB4f1ta6bL3qpl39xwy9If/7m7Bem8ehGIqj9DtClyNcM+1KZhir84TBvk SvKJVKk+zd85+z70KtJiJWCLHvQ1gHl+bEnN3m96UmQqe9b4v1/W7pEHGJULUblFO0PH uoX3Cqix3wX16BwbhjT2P6wJjc4HKuOvLig28= MIME-Version: 1.0 Received: by 10.210.62.4 with SMTP id k4mr7267363eba.25.1251258967460; Tue, 25 Aug 2009 20:56:07 -0700 (PDT) Date: Wed, 26 Aug 2009 05:56:07 +0200 Message-ID: <7eb9e0570908252056t7c39141amd6df5ac8b9c27848@mail.gmail.com> Subject: Db connection issue due to firewall From: chandra ganta To: users@tomcat.apache.org Content-Type: multipart/alternative; boundary=0015174c1242470e0c0472036ef3 X-Virus-Checked: Checked by ClamAV on apache.org --0015174c1242470e0c0472036ef3 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hello, We use a db datasource for one of our applications. The issue is that there is a firewall between tomcat server 5.5 & db server (ORACLE 9i), that cuts pool connections after 1 hour of ideal time. We've tried several configuration using : validationQuery testOnBorrow testOnReturn testWhileIdle timeBetweenEvictionRunsMillis numTestsPerEvictionRun minEvictableIdleTimeMillis But that does not solve the problem Could you please give me some advices about the way I have to configure this to get it working ? Best Regards, Chandra --0015174c1242470e0c0472036ef3--