You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@geronimo.apache.org by Andrus Adamchik <an...@objectstyle.org> on 2008/08/28 15:22:24 UTC

JDBC URL parameters and Geronimo console

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

Re: JDBC URL parameters and Geronimo console

Posted by Andrus Adamchik <an...@objectstyle.org>.

Thanks Lin!

On Aug 28, 2008, at 5:36 PM, Lin Sun wrote:

> 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.

I know... The DB server can also drop the connection on its end, so  
the client timeout is not enough. What I really need is reconnect  
ability.

> You should be able to configure a generic DB pool also, which allows
> you to specify a ConnectionURL value.

Yeah, let me try that.

Thanks again,
Andrus

Re: JDBC URL parameters and Geronimo console

Posted by Lin Sun <li...@gmail.com>.

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 <an...@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
>