Return-Path: Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org Received: (qmail 29727 invoked from network); 2 Dec 2004 20:17:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 2 Dec 2004 20:17:29 -0000 Received: (qmail 80722 invoked by uid 500); 2 Dec 2004 20:17:18 -0000 Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org Received: (qmail 80695 invoked by uid 500); 2 Dec 2004 20:17:17 -0000 Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Jakarta Commons Users List" Reply-To: "Jakarta Commons Users List" Delivered-To: mailing list commons-user@jakarta.apache.org Received: (qmail 80676 invoked by uid 99); 2 Dec 2004 20:17:17 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of haipengdu@gmail.com designates 64.233.170.196 as permitted sender) Received: from rproxy.gmail.com (HELO rproxy.gmail.com) (64.233.170.196) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 02 Dec 2004 12:17:15 -0800 Received: by rproxy.gmail.com with SMTP id a36so841043rnf for ; Thu, 02 Dec 2004 12:17:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=IlkPvdVxYemKMrBI9yKSkbjwsl9+ahFqR343iG9GUAWIhDSqkleLgkGpwyrcfWdPOX7oPjP7jGcvtLEm3KGOjSj44k9FPg0sxkSMuV9f9aGa420RABL48qx557twcLYDHuHpS8rbOvK2rsu3M1DUoETJCZuFlI8NSt+Jh35iQ7c= Received: by 10.38.209.7 with SMTP id h7mr1014101rng; Thu, 02 Dec 2004 12:17:13 -0800 (PST) Received: by 10.38.83.65 with HTTP; Thu, 2 Dec 2004 12:17:13 -0800 (PST) Message-ID: Date: Thu, 2 Dec 2004 13:17:13 -0700 From: haipeng du Reply-To: haipeng du To: commons-user@jakarta.apache.org Subject: about connection Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I use BasicDataSource as my datasource. A connection is created when I connected to database. Then connection was returned back to connection pool. But after long time (such as one ten hours), the connection can be used to connected to database. How could I set some timeout parameters so that I can check if that connection can not be used , I just make it to null and create a new connection? Do we have other ways to solve this problem? Thanks a lot. -- Haipeng Du Software Engineer Comphealth, Salt Lake City --------------------------------------------------------------------- To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: commons-user-help@jakarta.apache.org