We use the Jakarta Commons' DBCP connection pooling package. It
allows you to specify a validation query which will run everytime a
connection is requested.
(drinc2much) wrote in message news:<. com>...
> Maybe I need to post this to a Tomcat group.
> Every night we shutdown our Oracle database while we do backups.
>
> After the database comes back up, we are unable to access it,giving us
> the following error:
> java.lang.Exception: Io exception: Connection reset by peer: socket
> write error
>
> So what we have done in the mean time is to restart the Tomcat server
> after the Oracle database is back up.
>
> Does anyone know what I need to do? The database is down for about 1.5
> hours a night.
>
> Let me know if there are any more details I can provide.
>
> Thanks,
>
> Chris