Specifies whether Oracle should maintain connections in a pool. An Oracle connection pool is a group of reusable physical connections spanning several sessions and managed by the Oracle Call Interface (OCI). By default, connection pooling is not used.
O90 Oracle9i
O10 Oracle 10g
CnnPool = 'value'
Parameter |
Description |
|---|---|
value |
Values are:
|
No
If CnnPool='Yes',
the Oracle9i or Oracle 10g client
creates a connection pool and can connect to Oracle 8, Oracle8i,
Oracle9i, and Oracle 10g Server.
The pool contains physical connections to Oracle Server and is managed
by the OCI. The pool persists until the DataWindow server terminates or OCI.dll is unloaded.
The DataWindow server can connect to 10 different Oracle servers, as distinguished by service name, concurrently. There can be no more than 20 connections per pool. Each pool is created by the Oracle9i or later client and might also contain connections to Oracle8 and Oracle8i servers. Once a connection pool has been created, the DataWindow server maintains the physical connections until it terminates or OCI.DLL is unloaded.
To use connection pooling:
Database profile Enter values in the following fields of the Connection tab in the Database Profile Setup dialog box:
Profile Name – Example
value: 08i-pool
Server – Provide the
full net service name created by Oracle Net. Example value: adcora8i.sybase.com
Login ID – Example
value: scott
Password
Connect as – Choose
an item from the drop-down menu. Example value: Normal
Make sure Use Connection Pool is selected.
Application Type the following in code where password, server_name, and login are the appropriate values for your connection:
SQLCA.DBMS = "O90 Oracle9i (9.0.1)" SQLCA.LogPass = <password> SQLCA.ServerName = "server_name" SQLCA.LogId = "login"
SQLCA.AutoCommit = False SQLCA.DbParameter = "CnnPool=’Yes’"
