[Info-Ingres] Problem when Ingres server is rebooted

[simonl at unwired.com.au]

My personal favourite way of doing it is to raise a database event
before shutting down the server.  Your application must listen for the
event & then disconnect.  Only other problem with this (besides
requiring a code change) is you must remember to use some special
shutdown command which sends the event to all databases in the
installation.

If reconnecting is really required, perhaps wait a specified time and
then attempt to reconnect.  This must be coded for.

Cecil Westerhof wrote:
> We have a program that uses a remote Ingres database server. When the remote
> server reboots the database connection handle is offcourse not valid
> anymore. Is there a way to see that the remote server has rebooted? If so
> what is the best way to handle this? I suppose a close is not possible
> anymore. How do I clear the old handle? And when this is done, can I
> reconnect to the rebooted Ingres server?