|Subject||Re: [Firebird-Java] JDBC auto reconnect on fbserver crash|
> Is there any proven method for JDBC auto reconnect or recovery so anyThis is not possible on server - lifetime of database, transaction and
> statements/resultsets continue automatically?
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