Pooling – PB Docs 126

Pooling database parameter

Description

Specifies the type of pooling
to use with an Oracle database.

Controls

  • ORA Oracle 11g

Syntax

Parameter

Description

value

Specifies whether to use pooling, and
if so, what kind of pooling. Values are:

  • Session

    For session pooling.

  • Connection

    For connection pooling.

  • None

    (Default) For no pooling.

Default

No pooling.

Usage

With the ORA driver you specify the type of pooling you want
with the Pooling DBParm. The O90 and O10 database drivers that you
can use in PowerBuilder to connect to the 9.x and 10.x versions of
the Oracle DBMS support connection pooling with the DBParm parameter
CNNPool. For backward compatibility purposes, the CNNPool parameter
is also supported by the ORA driver. However, if you set the Pooling
parameter with the ORA driver, the CNNPool parameter is ignored.

If you are using connection or session pooling, the proxy
user name is the connection or session pooling creator (which you
can provide in the PoolCreator and PoolPwd DBParm parameters), and
the Transaction object’s LogID is ignored.

If you select session pooling, you can enter a value for the SessionHomogeneous
DBParm to authenticate all sessions in the pool with the user name
and password in effect when the session pool was created. No proxy session
can be created if pooling is set to homogeneous session mode.

Examples

The following example creates a connection pool:

  • Database profile

    Select Connection Pooling from the Pooling Type drop-down
    list on the Pooling page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

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