Subject RE: [Firebird-Java] Is it possible to reconnect after a network outage?
Author Steffen Heil
Hi

> Providing reconnect() method would mean that driver would
> need to re-prepare all open statements, re-execute queries
> and re-position the cursors on the right places to make it
> usable for all applications. Too complicated, is not required
> by the specification and can be much more easily handled on
> the application level.

Andalso impossible to implement in the driver, if the database was changed
inbetween.
Running the same statements again somewhen later will no nessessarily lead
to the same results if the database was changed by another connection.
(And this is not checkable by the driver, because tables could have been
changed by calling stored procedures, where the driver has no control what
happend...)
Moreover, locks that were held by the original connection cannot be
reinstantiated.

Regards,
Steffen


[Non-text portions of this message have been removed]