Subject JDBC auto reconnect on fbserver crash
Author imoffskating

We have been developing a multi user gaming server with firebird and
have had no problems until a few days ago.

We run firebird on an Ubuntu Linux box and connect to it using JDBC
with our own connection pool with 150 connections max.

fbserver unexpectedly crashed and fbguard restarted fbserver (see log

devserver (Client) Fri Jan 13 02:00:40 2006
/opt/firebird/bin/fbguard: bin/fbserver terminated abnormally (-1)

devserver (Client) Fri Jan 13 02:00:40 2006
/opt/firebird/bin/fbguard: guardian starting bin/fbserver

The problem then is our game server crashes because the connections
(some transactionned, some normal) are halfway though a commit etc.

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

Many thanks,