We have this problem for quite some time and I would like to see what suggestions
other have to solve this problem.
Configuration is NT 4.0 SP 4 or 5
ND 4.1.3 no SP
Oracle client 8.0.4 or 8.0.5
Oracle 8.0.5 database running under NT
When the database go down or the database disconnect the ND connection to the database
The non transactional part of ND logics will recover.
But anything that uses transaction will fail.
The only way to recover from this is to restart ND.
Any suggestion?
error recovery code in ND :-
CSpDataSource ds = null;
try
{
ds = CSpider.getDataSource ("dsPwb1");
}
catch (Exception ex)
{
CSpLog.send(this,CSpLog.ERROR,"Error getting DS; error : " +
ex);
}
try
{
ds.addDBErrorRecoveryPlan ( new CSpDBErrorRecoveryPlan (
CSpDBErrorRecoveryPlan.IGNORE_ERROR,3114,
CSpDBErrorRecoveryPlan.IGNORE_ERROR,true,
CSpDBErrorRecoveryPlan.ALWAYS_RETRY, 3));
ds.addDBErrorRecoveryPlan ( new CSpDBErrorRecoveryPlan (
CSpDBErrorRecoveryPlan.IGNORE_ERROR,1012,
CSpDBErrorRecoveryPlan.IGNORE_ERROR,true,
CSpDBErrorRecoveryPlan.ALWAYS_RETRY, 1));
}
catch (Exception ex)
{
CSpLog.send(this,CSpLog.ERROR,"Error adding Rec Plan; error :
" + ex);
}
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
