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

Reply via email to