cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: [c2] still problem with datasources
Date Mon, 23 Apr 2001 19:56:38 GMT
On Mon, 23 Apr 2001, Santiago Gala wrote:

> >> fwiw, i'm still having problems with the datasource manager not noticing
> >> connection timeout until after it's given me a stale connection.
> >
> >
> > Ok.  I am checking the isClosed() to see if the connection is stale.  Is there
> > anything else I should check?
> >
>
> I think this will not work always.
>
> I seem to remember having seen code somewhere that actually called a
> PerparedStatement containing "SELECT 1" to check if there was any
> problem with the actual socket connection. This can be done in the
> background every so and so time or before giving it to the requester...
>
> I'm not sure it is a good solution, but it could be a strategy that is
> configured for buggy drivers or buggy databases.

man, you're so right, i have run into this before. attached is a patch for
the avalon JdbcConnection class that might take care of this.

- donald

Mime
View raw message