I know this topic has been discussed in the past, but there never has been a
satisfactory solution, as far as I can tell. The problem occurs when using
the ODBC adaptor to connect to MSSQL Server. If the database server resides
on a separate machine, and that machine is rebooted unexpectedly, the
WebObjects application connected to that server then raises a "Communication
Link Failure" exception whenever data is fetched.
The ways around this seem to be numerous, the safest of which may be to
handle the exception at the highest level and simply terminate/restart the
application. But in this instance I don't have access to Monitor which will
restart it for me, so I would like to force the Adaptor to reset the
database connection. Is this a possibility? Would it be as simple as
checking for a closed channel, calling openChannel if necessary? Or would
the adaptor be in some other type of wierd state where the channel is still
open, but the connection is just plain hosed (and unrecoverable)?
- Eric
