Database connection pooling

Hi,

I have an Enhydra server running an application that talks to a SQL Server
database running on a seperate machine, using JSQLConnect.  All goes well
until (for whatever reason) the database server has to restart, or
connectivity is interrupted for some other reason.

When the database comes back up, no db queries can be made by the
application until it is restarted; any activity that attempts to query the
database (eg, a user attempting to log in) results in the following error:

DBComms::transmit exception:java.net.SocketException: Connection reset by
peer: socket write error

However, once the application (not the multiserver) is restarted, everything
is fine again.  What could be causing this?  It seems that perhaps the
multiserver is pooling database connections that have been closed rather
than opening new connections.

Thanks for any help.