Subject | RE: [Firebird-Java] Is it possible to reconnect after a network outage? |
---|---|
Author | Steffen Heil |
Post date | 2008-03-26T21:38:47Z |
Hi
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]
> Providing reconnect() method would mean that driver wouldAndalso impossible to implement in the driver, if the database was changed
> 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.
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]