Both methods seem to only check the current connection and move on to the
next one. What if all of the connections are closed?
Anthony
-----Original Message-----
From: Alan Inser [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 7:44 AM
To: '[EMAIL PROTECTED]'
Subject: RE: GenericDataSource Reconnection
Hi,
>The difficulty is to find a pretty efficient SQL statement which you want
to
>execute each time before returning a connection.
> --- Matthias
As it was already suggested in this forum, the query "select dummy from
dual" could work well for a Oracle database. For other databases there would
be specific query strings like the one for Oracle. It could be a property of
the application.
Is anyone working with PoolMan connection pool instead of the one available
in Struts? Thanks.
Adriano Labate
-----Original Message-----
From: Matthias Bauer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 3:59 PM
To: [EMAIL PROTECTED]
Subject: Re: GenericDataSource Reconnection