Ping Method

On this page

Determines whether connection to Oracle server is valid.

Syntax

Visual Basic
C#


'Declaration Public Function Ping() As Boolean


public bool Ping()

Return Value

true, if the connection is valid; otherwise, false.

Remarks

If the application has an open connection for a long time, it is recommended to check whether the connection is still valid, before using it. Call of Ping method has single round trip on Oracle server.

It is not a good idea to keep a connection open for long time. Connection pool automatically pings all connections within, thus closing old connections and opening new ones is encouraged.

If the connection being pinged is not initialized or has the state other than ConnectionState.Open, the method throws an exception.

Example

This code sample shows how to check for server availability before issuing a query.

csharp


public void ExecuteSafely(OracleConnection connection) { OracleCommand command = new OracleCommand("INSERT INTO Dept(DeptNo, DName) Values('50', 'DEVELOPMENT')"); command.Connection = connection; try { if (connection.Ping()) { command.ExecuteNonQuery(); Console.WriteLine("Successfully executed"); } else { connection.Close(); Console.WriteLine("Unable to ping the server"); } } catch { connection.Close(); Console.WriteLine("Error during query execution"); } }

public void ExecuteSafely(OracleConnection connection) 
{ 
        OracleCommand command = new OracleCommand("INSERT INTO Dept(DeptNo, DName) Values('50', 'DEVELOPMENT')");
        command.Connection = connection;
        try
        {
                if (connection.Ping())
                {
                        command.ExecuteNonQuery();
                        Console.WriteLine("Successfully executed");
                }
                else
                {
                        connection.Close();
                        Console.WriteLine("Unable to ping the server");
                }
        }
        catch
        {
                connection.Close();
                Console.WriteLine("Error during query execution");
        } 
}

Visual Basic


Public Sub ExecuteSafely(ByVal connection As OracleConnection) Dim command As New OracleCommand("INSERT INTO Dept(DeptNo, DName) Values('50', 'DEVELOPMENT')") command.Connection = connection Try If (connection.Ping()) Then command.ExecuteNonQuery() Console.WriteLine("Successfully executed") Else connection.Close() Console.WriteLine("Unable to ping the server") End If Catch connection.Close() Console.WriteLine("Error during query execution") End Try End Sub

Public Sub ExecuteSafely(ByVal connection As OracleConnection)
        Dim command As New OracleCommand("INSERT INTO Dept(DeptNo, DName) Values('50', 'DEVELOPMENT')")
        command.Connection = connection
        Try
                If (connection.Ping()) Then
                        command.ExecuteNonQuery()
                        Console.WriteLine("Successfully executed")
                Else
                        connection.Close()
                        Console.WriteLine("Unable to ping the server")
                End If
        Catch
                connection.Close()
                Console.WriteLine("Error during query execution")
        End Try
End Sub

Reference

OracleConnection Class
OracleConnection Members

Send Feedback