Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 24235 invoked from network); 28 Aug 2008 14:36:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 28 Aug 2008 14:36:36 -0000 Received: (qmail 35927 invoked by uid 500); 28 Aug 2008 14:36:33 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 35393 invoked by uid 500); 28 Aug 2008 14:36:32 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 35382 invoked by uid 99); 28 Aug 2008 14:36:32 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Aug 2008 07:36:32 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of linsun.unc@gmail.com designates 209.85.217.17 as permitted sender) Received: from [209.85.217.17] (HELO mail-gx0-f17.google.com) (209.85.217.17) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Aug 2008 14:35:35 +0000 Received: by gxk10 with SMTP id 10so4746217gxk.19 for ; Thu, 28 Aug 2008 07:36:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=02FNL0lNnvNcy2RnMRuKfo7Xlh4Xh2x+ajkJ8zulk9M=; b=kTzy0iUo2BB1pUjia2gWwWuLNldB7QU924XwBRRmcb+82OIuAfk8+TaG1gD9Tb4Uvt sqiwf1vi8JDpaCZeoGsh8kj0c0st6CrSBvZSXldhwnEd11ZPnkhSOvLmhogm+oY7zCtf /AwD0Ye6Vmg+uaFdL3i6flckD0Epfu2QRYk5Q= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=VUQ10jiqHMrsgUQe5QyShMdHOMCBp+Ssnij3sqBNdI3JcA/Uf707JWDkvMa7+TUA4t d1F17+dBEmZkCJPwKr39eqxYWy3fN7/ot+5wh2LrNLdxNR9q2Hck/Jcl0MlDN5OymHnq qd8e5QlTytfva8o2ES5cviY//o8kPeReW4EzM= Received: by 10.150.148.1 with SMTP id v1mr2308049ybd.48.1219934165163; Thu, 28 Aug 2008 07:36:05 -0700 (PDT) Received: by 10.150.137.19 with HTTP; Thu, 28 Aug 2008 07:36:04 -0700 (PDT) Message-ID: Date: Thu, 28 Aug 2008 10:36:04 -0400 From: "Lin Sun" To: user@geronimo.apache.org Subject: Re: JDBC URL parameters and Geronimo console In-Reply-To: <8076B611-0209-478A-A34E-722E64D3BF99@objectstyle.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <8076B611-0209-478A-A34E-722E64D3BF99@objectstyle.org> X-Virus-Checked: Checked by ClamAV on apache.org Hi, The default connection pool idle timeout is 15 mins... do you think you'll need longer than that? If so, you might want to increase that value at the database portlet. You should be able to configure a generic DB pool also, which allows you to specify a ConnectionURL value. Lin On Thu, Aug 28, 2008 at 9:22 AM, Andrus Adamchik wrote: > Hi, > > I have a MySQL Database Pool configured via Geronimo console (G. 2.1.2). It > works, except that sometimes I am getting mysql IO exceptions, which I > attribute to the server closing pooled connections after some time of > inactivity. This can be fixed by adding "autoReconnect=true" to the JDBC > URL. Here is the problem though - Geronimo console database pool config > screen does not support adding extra URL parameters (for MySQL anyways, I > think it does for "other" type of databases). Any ideas how to work around > it? Should I configure a generic DB pool? > > Thanks, > Andrus >