Hi All,
I am having a java program as a back end process, which will poll the table continuously, and picks up the record as soon as it falls in the table and process it.
Now that when the Oracle conectivity is disturbed, either the oracle goes down or due to some network problem, then it will not pick up any more record even when the Oracle problem is rectified unless I re-start my process.
My requirement is that once the oracle problem is corrected then my process should function asusal with out any manual intervention.
For this in the catch block I am checking the connection object and if it is null, I am trying to establishes the connection, till I get the value in the connection object. This is correct only at the time of starting up the process, the Oracle is down. Suppose after starting up the process if the Oracle goes down then that case also I am having values in the connection object, so I cannot check the above condition, and also I can not blindly establishes connection in the catch block, because the Exception could be of some other reason also. In that case how do I solve this problem.
Please help me out to resolve the above issue and it is urgent too.
Thanks in advance
Vasu.