Skip Headers

Oracle® Objects for OLE Developer's Guide
10g Release 1 (10.1)

Part Number B10118-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Master Index
Master Index
Go to Feedback page

Detection of Lost Connections

OO4O linked with an 8.1.6 or later client supports detection of lost connections.

Applications can verify the status of the database connection by invoking the ConnectionOK property of the OraDatabase object. OraSession.GetDatabaseFromPool now checks to see if the connection is alive before returning the OraDatabase to the application.

If the connection is dead, GetDatabaseFromPool will drop the connection and refetch a live connection.

Example :

Dim MyDatabase As OraDatabase

Set MySession = CreateObject("OracleInProcServer.XOraSession")

Set MyDatabase = MySession.OpenDatabase("ora90", "scott/tiger", 0&)

'.... Other code

' Check if the database connection has not timed out

If MyDatabase.ConnectionOK Then

MsgBox " The database connection is valid"

End If