Re: connection pool and reconnect to database

On Mon, 13 Dec 2004, Morus Walter wrote:

> I'm currently working on the migration of an application from oracle to
> postgresql.
>
> I'm using a org.postgresql.jdbc3.Jdbc3PoolingDataSource to manage the
> connections.
>
> Everything works find, except that I'm forced to restart the application
> whenever the postgresql server is restarted.
>
> Since the application is server based (running inside tomcat) and runs
> on a different server this introduces additional dependencies I'd prefer
> to avoid.
>
> Is there any way to have the connection pool detect the case of broken
> database connections and try to create new ones?
> How do others handle this issue?
>

The connection pool that comes with the driver is not very featureful and
it's a better idea to use a third party pool from jakarta or elsewhere.

Kris Jurka