Hi

> Is there any proven method for JDBC auto reconnect or
> recovery so any statements/resultsets continue automatically?

No and there can't be.
SQL servers need to drop uncommited transactions on restart.

If the transaction is gone, there is nothing the JDBC layer can do.
[Though, you could write a application specific layer, that keeps track on
changes and such and repost them in your case. However, the same can simply
be accomplished, if you repeat your procedures...]

Regards,
Steffen


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