OracleFailoverEventHandler Delegate

The OracleFailoverEventHandler represents the signature of the method that handles the OracleConnection.Failover event.

Declaration

// C#
public delegate FailoverReturnCode OracleFailoverEventHandler(object sender,          
OracleFailoverEventArgs eventArgs);

Parameter

• sender

  The source of the event.

• eventArgs

  The OracleFailoverEventArgs object that contains the event data.

Return Type

An int.

Remarks

To receive failover notifications, a callback function can be registered as follows:

ConObj.Failover += new OracleFailoverEventHandler(OnFailover); 

The definition of the callback function OnFailover can be as follows:

public FailoverReturnCode OnFailover(object sender, OracleFailoverEventArgs 
eventArgs) 
  

Example

void Main(string[] args) 
{ 
... 
// register callback function OnFailOver 
ConObj.Failover += new OracleFailoverEventHandler(OnFailOver); 
... 
} 

//Failover Callback Function 
public FailoverReturnCode OnFailOver(object sender, OracleFailoverEventArgs 
eventArgs) 
{ 

      switch (eventArgs.FailoverEvent) 
      { 
        case FailoverEvent.Begin: 
        { 
          Console.WriteLine(" \nFailover Begin - Failing Over ... Please stand
                           by \n"); 
          Console.WriteLine(" Failover type was found to be " + 
                           eventArgs.FailoverType); 
          break; 
        } 

        case FailoverEvent.Abort: 
        { 
          Console.WriteLine(" Failover aborted. Failover will not take
                            place.\n"); 
          break; 
        } 

        case FailoverEvent.End: 
        { 
          Console.WriteLine(" Failover ended ...resuming services\n"); 
          break; 
        } 

        case FailoverEvent.Reauth: 
        { 
          Console.WriteLine(" Failed over user. Resuming services\n"); 
          break; 
        } 

        case FailoverEvent.Error: 
        { 
          Console.WriteLine(" Failover error gotten. Sleeping...\n"); 
          Thread.Sleep(3000); 
          return FailoverReturnCode.Retry; 
        } 

        default: 
        { 
          Console.WriteLine("Bad Failover Event: %d.\n",
                             eventArgs.FailoverEvent); 
          break; 
        } 
      } 
  
      return FailoverReturnCode.Success; 

} /* OnFailover */ 
  

See Also: Oracle.DataAccess.Client Namespace "OracleConnection Class"