Subject Re: [Firebird-Java] JDBC auto reconnect on fbserver crash
Author Roman Rokytskyy
> Is there any proven method for JDBC auto reconnect or recovery so any
> statements/resultsets continue automatically?

This is not possible on server - lifetime of database, transaction and
statement handles is limited to the socket lifetime. And we have done
everything possible to prevent connection and its statements from working
after socket error on JDBC driver side.

The only possibility for you I see is to switch to CachedRowSet
implementation and use connection pooling that allows reconnecting (for
example the one shipped with Jaybird). It will not solve your problem, since
connection, its statements and result sets will die, but application won't
see this (only if connection dies during fetching result set or executing
some statement).