skip to main content
Using the Driver : Using DataDirect Connection Pooling : Configuring Pooling-Related Options
  

Try DataDirect Drivers Now

Configuring Pooling-Related Options

The following table summarizes how connection pooling-related connection options work with the drivers. The connection options are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name is listed immediately after the GUI name in parentheses. See "Connection Option Descriptions" for details about configuring the options.
Table 6. Summary: Connection Pooling Connection Options
Option
Characteristic
Specifies whether to use the driver’s connection pooling.
If set to 1 (Enabled), the driver uses connection pooling.
If set to 0 (Disabled), the driver does not use connection pooling.
Default: 0 (Disabled)
Determines whether the state of connections that are removed from the connection pool for reuse by the application is reset to the initial configuration of the connection.
If set to 1 (Enabled), the state of connections removed from the connection pool for reuse by an application is reset to the initial configuration of the connection. Resetting the state can negatively impact performance because additional commands must be sent over the network to the server to reset the state of the connection.
If 0 (Disabled), the state of connections is not reset.
Default: 0 (Disabled)
An integer value to specify the amount of time, in seconds, to keep connections open in a connection pool.
Default: 0
An integer value to specify the maximum number of connections within a single pool.
Default: 100
An integer value to specify the minimum number of connections that are opened and placed in a connection pool when it is created. If set to 0, no connections are opened in addition to the current existing connection.
Default: 0