The following table describes attributes for the JDBCCONNECTIONPOOL element.
Table 2–45 JDBCCONNECTIONPOOL Attributes
Attribute |
Default |
Description |
---|---|---|
name |
none |
Specifies the name of the connection pool. A JDBCRESOURCE element's poolname attribute refers to this name. |
datasourceclassname |
none |
Specifies the class name of the associated vendor-supplied data source. This class must implement java.sql.DataSource or java.sql.XADataSource or both. |
steadypoolsize |
8 |
(optional) Specifies the initial and minimum number of connections maintained in the pool. |
maxpoolsize |
32 |
(optional) Specifies the maximum number of connections that can be created to satisfy client requests. |
maxwaittime |
60000 |
(optional) Specifies the amount of time, in milliseconds, that the caller is willing to wait for a connection. If 0, the caller is blocked indefinitely until a resource is available or an error occurs. |
poolresizequantity |
2 |
(optional) Specifies the number of connections to be destroyed if the existing number of connections is above the steady-pool-size (subject to the max-pool-size limit). This is enforced periodically at the idle-time-out-in-seconds interval. An idle connection is one that has not been used for a period of idle-time-out-in-seconds. |
idletimeout |
300 |
(optional) Specifies the maximum time that a connection can remain idle in the pool. After this amount of time, the pool can close this connection. |
transactionisolationlevel |
default JDBC driver isolation level |
(optional) Specifies the transaction isolation level on the pooled database connections. Allowed values are read-uncommitted, read-committed, repeatable-read, or serializable. Applications that change the isolation level on a pooled connection programmatically risk polluting the pool, which can lead to errors. See isolationlevelguaranteed for more details. |
isolationlevelguaranteed |
true |
(optional) Applicable only when transactionisolationlevel is explicitly set. If true, every connection obtained from the pool is guaranteed to have the desired isolation level. This may impact performance on some JDBC drivers. You can set this attribute to false if you are certain that the hosted applications do not return connections with altered isolation levels. |
connectionvalidationrequired |
false |
(optional) Specifies whether connections must be validated before being given to the application. If a resource's validation fails, it is destroyed, and a new resource is created and returned. Legal values are on, off, yes, no, 1, 0, true, false. |
connectionvalidationmethod |
auto-commit |
(optional) Legal values are as follows:
|
validationtablename |
none |
(optional) Specifies the table name to be used to perform a query to validate a connection. This parameter is mandatory if and only if connectionvalidationtype is set to table. |
failallconnections |
false |
(optional) If true, closes all connections in the pool if a single validation check fails. This parameter is mandatory if and only if isconnectionvalidationrequired is set to true. Legal values are on, off, yes, no, 1, 0, true, false. |