in the onAfterInit() event of the project, grab a handle to the data source.  
you can the add plans accordingly with addDBErrorRecoveryPlan()

 The plans work on a pattern matching  basis for error codes and 
error messages, and allows you to specify a number of retries or 
a restart of all database connections(good if db went down and 
handles are now invalid) in the data source.  

you can add plans that attempt to match all error codes and 
error messages specifically, or you can ignore some of the 
codes and messages by sending IGNORE_ERROR or IGNORE_MESSAGE
in those fields.  

For instance a good use of the plan might be to add a really generic restart
of connections for an error code of 28 (Data Source Exception)
simply by sending 28 to the error_code1 parameter and IGNORE_MESSAGE /IGNORE_ERROR
to all the other error code parameters.
ie 


This is much better documented in the online docs really....

Dan Byer
Yoichi Matsuura <[EMAIL PROTECTED]> wrote:
>Hi,>
> Does anyone know how to use CSpDBErrorRecoveryPlan?
>Especially, what kind of value should I set into
>errorCode and errorMessage? Please let me know
>which document I should refer.
>
> Thanks in advance,
>
> Yoichi
>-----------
>Yoichi Matsuura
>TERILOGY CO., LTD.
>

_________________________________________________________________________

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]

Reply via email to