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

Using the Connection Pool Management Facility

Creating the Connection Pool

The Connection Pool in OO4O is a pool of OraDatabase objects. The pool is created by invoking the CreateDatabasePool method of the OraSession interface. An OraDatabase object represents a connection to an Oracle database and contains methods for executing SQL statements and PL/SQL blocks.

Obtaining and returning elements to and from the pool

To retrieve an OraDatabase object from the pool, the GetDatabaseFromPool method is called. This function returns a reference to an OraDatabase object.

Destroying the pool

The pool is implicitly destroyed if the parent session object that it belong to is destroyed. It can also be destroyed at any time by invoking the DestroyDatabasePool method.

Accessing the Pool attributes

The following are the Database Pool Properties. These properties are read-only.

Database Pool Properties
// Maximum Pool Size
// Current Size of the Pool
// Initial Size of the Pool

Doing Transaction processing using the Database from the Connection Pool

This is the recommended way of doing transactions:

set Odb = OraSession.GetDatabaseFromPool(0)