CnnPool database parameter
Description
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). The CNNPool DBParm
is maintained in the ORA driver for backward compatibility only.
It is ignored if you use the Pooling DBParm.
The CnnPool parameter cannot be used for PowerBuilder components deployed
to EAServer, and external
users cannot participate in a connection pool. By default, connection
pooling is not used.
Controls
-
O90 Oracle9i
-
O10 Oracle 10g
-
ORA Oracle 11g
Syntax
|
1 |
CnnPool='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
Values are:
|
Default
No
Usage
If CnnPool='Yes',
the Oracle client creates a connection pool and can connect to 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.
Examples
To use connection pooling:
-
Database profile
Enter values in the following fields of the Connection page
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.sap.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:1SQLCA.DBMS="O90 Oracle9i (9.0.1)"<br>SQLCA.LogPass=<<span>password</span>><br>SQLCA.ServerName="<span>server_name</span>"<br>SQLCA.LogId="<span>login</span>"1<br>SQLCA.AutoCommit=False<br>SQLCA.DbParameter="CnnPool='Yes'"