Part 1: Getting Started : Advanced Features : Using DataDirect Connection Pooling : Removing Connections from a Pool

Removing Connections from a Pool
A connection is removed from a connection pool when it exceeds its lifetime as determined by the Load Balance Timeout connection option. In addition, DataDirect has created connection attributes described in the following table to give your application the ability to reset connection pools. If connections are in use at the time of these calls, they are marked appropriately. When SQLDisconnect is called, the connections are discarded instead of being returned to the pool.
SQL_ATTR_CLEAR_POOLS Value: SQL_CLEAR_ALL_CONN_POOL
SQL_ATTR_CLEAR_POOLS Value: SQL_CLEAR_CURRENT_CONN_POOL
By default, if removing a connection causes the number of connections to drop below the number specified in the Min Pool Size option, a new connection is not created until an application needs one.

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.