DataDirect connection pooling

Connection pooling allows you to reuse connections rather than creating a new one every time the driver needs to establish a connection to the underlying database. Your Progress DataDirect for ODBC driver enables connection pooling without requiring changes to your client application.

Refer to DataDirect Connection Pooling in the Progress DataDirect for ODBC Drivers Reference for more information.

To configure the driver to use connection pooling:

• Set the Connection Pooling (Pooling) option to 1.
• Set the Connection Reset (ConnectionReset) option to 1 or 0. Setting it to 1 resets the state of connections removed from the connection pool for reuse by an application to the initial configuration of the connection. Setting it to 0 does not reset the state of connections.
• Set the Load Balance Timeout (LoadBalanceTimeout) option to specify an integer value to specify the amount of time, in seconds, to keep connections open in a connection pool.
• Set the Max Pool Size (MaxPoolSize) option to specify an integer value to specify the maximum number of connections within a single pool.
• Set the Min Pool Size (MinPoolSize) option to an integer value to specify the minimum number of connections that are opened and placed in a connection pool when it is created.

The following examples show how to configure the driver to use connection pooling with user ID and password authentication:

DRIVER=DataDirect 8.0 Salesforce;HostName=login.salesforce.com;ConnectionReset=0;LoadBalanceTimeout=0;
MaxPoolSize=100;MinPoolSize=0;Pooling=1;LogonID=jsmith@example.com;Password=secret

Driver=ODBCHOME/lib/ivsfrc28.so
Description=My Salesforce Data Source
...
ConnectionReset=0
...
HostName=login.salesforce.com
...
LoadBalanceTimeout=0
...
LogonID=jsmith@example.com
...
MaxPoolSize=100
...
MinPoolSize=0
...
Password=secret
...
Pooling=1
...