CnnPool – PB Docs 126

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

Parameter

Description

value

Values are:

  • Yes

  • No (Default)

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:

See Also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x