Documentation Center

Pool

This topic describes the Pool element.

Description

Specifies pooling for this database.

Attributes

AttributeDescription and useType
Type

Either of the following:

jdbc
a more configurable connection pool manager. If additional connections are attempted, the connection is queued. For this value, include all the other attributes.
tridion
Only allows you to specify the size of the pool. If additional connections are attempted, an exception is raised. For this value, include the Size attribute only.
(required)
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). MonitorInterval must be higher than zero, and MinEvictableIdleTimeout must be zero or less, for this setting to have any effect.

(optional)
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). MonitorInterval must be higher than zero for this setting to have any effect. Is this value is set to a value higher than zero (that is, if a timeout is specified), the value of IdleTimeout is ignored.

(optional)
integer
ValidationQuery

The query string used for connection validation when a connection is requested from the pool. This query must be a SQL SELECT command, and defaults to the value SELECT 1 FROM DUAL. Leave this value untouched if you use Oracle; change it to SELECT 1 if you use Microsoft SQL Server.

(optional)
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 true to validate objects before they are borrowed from the pool. If validations fails, the object is dropped from the pool, and an attempt is made to borrow another. Defaults to false.

(optional)
Boolean