geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lin Sun" <linsun....@gmail.com>
Subject Re: JDBC URL parameters and Geronimo console
Date Thu, 28 Aug 2008 14:36:04 GMT
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 <andrus@objectstyle.org> 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
>

Mime
View raw message