Pooling
database parameter
Description
Specifies the type of pooling to use with an Oracle
database.
Applies to
ORA Oracle (for 11g and later)
Syntax
|
1 |
Pooling =value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether to use pooling, and if so, what
|
Default value
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:
1my_trans.dbparm="pooling='connection'"
See also