The pool properties used for the underlying connection pool
element.
]]>
The default auto-commit state of connections created by this pool.
The default read-only state of connections created by this pool. If not set then the setReadOnly
method will not be called.
The default TransactionIsolation state of connections created by this pool. If not set,
the method will not be called and it defaults to the JDBC driver.
The default TransactionIsolation names of connections created by this pool. If not set,
the method will not be called and it defaults to the JDBC driver.
The default catalog of connections created by this pool.
The maximum number of active connections that can be allocated from this pool at the same time.
The maximum number of active connections that can be allocated from this pool at the same time.
The maximum number of connections that should be kept in the pool at all times. Default value is
maxActive:100 Idle connections are checked periodically (if enabled) and connections that been idle
for longer than minEvictableIdleTimeMillis will be released. (also see testWhileIdle)
The initial number of connections that are created when the pool is started.
The maximum number of milliseconds that the pool will wait (when there are no available connections)
for a connection to be returned before throwing an exception.
The indication of whether objects will be validated before being borrowed from the pool. If the
object fails to validate, it will be dropped from the pool, and we will attempt to borrow another.
NOTE - for a true value to have any effect, the validationQuery attribute must be set to a non-null
string. In order to have a more efficient validation, see validationInterval.
The indication of whether objects will be validated before being returned to the pool. NOTE - for a
true value to have any effect, the validationQuery parameter must be set to a non-null string.
The indication of whether objects will be validated by the idle object evictor (if any). If an
object fails to validate, it will be dropped from the pool. NOTE - for a true value to have any
effect, the validationQuery attribute must be set to a non-null string. This attribute has to be set
in order for the pool cleaner/test thread is to run (also see
timeBetweenEvictionRunsMillis)
The SQL query that will be used to validate connections from this pool before returning them to the
caller. If specified, this query does not have to return any data, it just can't throw a
SQLException. The default value is null. Example values are SELECT 1(mysql), select 1 from
dual(oracle), SELECT 1(MS Sql Server)
The name of a class which implements the org.apache.tomcat.jdbc.pool.Validator interface and
provides a no-arg constructor (may be implicit). If specified, the class will be used to create a
Validator instance which is then used instead of any validation query to validate connections. The
default value is null. An example value is com.company.project.SimpleValidator.
The number of milliseconds to sleep between runs of the idle connection validation/cleaner thread.
This value should not be set under 1 second. It dictates how often we check for idle, abandoned
connections, and how often we validate idle connections.
The minimum amount of time an object may sit idle in the pool before it is eligible for eviction.
Flag to remove abandoned connections if they exceed the removeAbandonedTimeout. If set to true a
connection is considered abandoned and eligible for removal if it has been in use longer than the
removeAbandonedTimeout Setting this to true can recover db connections from applications that fail
to close a connection. See also logAbandoned.
Timeout in seconds before an abandoned(in use) connection can be removed. The default value is 60
(seconds). The value should be set to the longest running query your applications might have.
Flag to log stack traces for application code which abandoned a Connection. Logging of abandoned
Connections adds overhead for every Connection borrow because a stack trace has to be generated.
The connection properties that will be sent to our JDBC driver when establishing new connections.
Format of the string must be [propertyName=property;]*
A custom query to be run when a connection is first created.