Hi,
We're working on providing auto-reconnection mechanism for our application that uses remote database for the backend.
Currently we've incorporated reconnection mechanism at Connection level and Statement level by introducing wrappers for these two classes.
While
testing we found that the connection got lost while processing the Resultset.
We're looking at possible ways for providing reconnection and re-execution of the Query which could not be successfully processed due to loss of connection.
Is it a good idea to provide wrapper at ResultSet level and re-process. This appears somewhat risky as the connection may go away after processing many records.
Are there ways to handle losing connection at Resultset level.
It will be great if we can get some ideas, links that sheds some light about this.
thanks,
Krishna