Pool
This topic describes the Pool element.
Description
Specifies pooling for this database.
Attributes
| Attribute | Description and use | Type |
|---|---|---|
| Type | Either of the following:
| string |
| Size | The size of the pool, that is, the maximum number of idle connections in the pool. This number must be equal to or higher than the number of Workers deployed in your Content Deployer. (optional) | integer |
| MonitorInterval | Number of seconds between checks for idle objects by an eviction thread. The value defaults to -1 (never check for idle objects). (optional) | integer |
| IdleTimeout | Number of seconds a connection can remain idle before the evictor evicts it (that is, closes it). The value defaults to -1 (never evict idle objects). | integer |
| CheckoutTimeout | Number of seconds a connection can remain checked out before it is returned to the pool. (optional) | integer |
| MinEvictableIdleTimeout | The number of seconds after which connections in the pool that have been idle are eligible to be evicted (that is, closed). This value defaults to 1800 (that is, 30 minutes). | integer |
| ValidationQuery | The query string used for connection validation when a connection is requested from the pool. This query must be a SQL | string |
| AcquireRetryAttempts | The number of times a connection is retried in the event of a failure to connect. "5" would be a good value for this attribute. (optional) | integer |
| TestOnBorrow | Set to | Boolean |