bcp.1.1.0.source-code.dbcp-1.1.xsd Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of dbcp Show documentation
Show all versions of dbcp Show documentation
Wrapper of the "Apache Commons DBCP" library that provides a simple API to describe and initialize a JDBC Database Connection Pool.
The connection URL to be passed to the JDBC driver to establish a connection.
The fully qualified Java class name of the JDBC driver to be used.
The default "catalog" property of connections created by this pool. (Default: null).
The default "auto-commit" state of connections created by this pool. (Default: true).
The default "read-only" state of connections created by this pool. (Default: false).
The default query timeout (in milliseconds) that will be used for Statement(s) created from this connection. (Default: vendor specific).
The default TransactionIsolation state of connections created by this pool. (Default: vendor specific).
Transactions are not supported.
Dirty reads, non-repeatable reads and phantom reads can occur.
Dirty reads are prevented; non-repeatable reads and phantom reads can occur.
Dirty reads and non-repeatable reads are prevented; phantom reads can occur.
Dirty reads, non-repeatable reads and phantom reads are prevented.
The connection properties that will be sent to the JDBC driver when establishing a connection.
NOTE: The "user" and "password" properties will be passed explicitly, so they do not need to be included here.
The list of SQL statements to be executed when a physical connection is first created.
The initial number of connections that are created when the pool is started. (Default: 0).
The maximum number of idle and borrowed connections that can be active in this pool at the same time; or INDEFINITE for no limit. (Default: 8).
The maximum number of connections that can remain idle in the pool, without extra ones being released; or INDEFINITE for no limit. (Default: 8).
The minimum number of connections that can remain idle in the pool, without extra ones being created; or zero to create none. (Default: 9).
The maximum number of open statements that can be allocated from the statement pool at the same time.
The value of INDEFINITE disables pooling of prepared statements. (Default: INDEFINITE).
A "lifo" queue will dequeue the most recently used connection in the idle instance pool ("last in"), if there are idle connections available.
A "fifo" queue will dequeue connections from the idle instance pool in the order that they are returned to the pool. (Default: lifo).
Controls whether pooled connections cache some state to improve performance, rather than always query the database for current state. (Default: false).
The maximum number of milliseconds that the pool will wait (when there are no connections available) for a connection to be returned before throwing an exception. (Default: INDEFINITE).
The maximum number of milliseconds permitted for the lifetime of a connection. (Default: INDEFINITE).
Sets the value of the flag that controls whether or not connections being returned to the pool will be checked
and configured with Connection.setAutoCommit(true) if the auto commit setting is {@code false} when the
connection is returned. (Default: true).
Specifies whether a connection will be rolled back when it is returned to the pool if auto
commit is not enabled and the connection is not read only. (Default: true).
Specifies parameters for automatic removal of abandoned connections.
Setting these values can recover db connections from poorly written applications which fail to close a connection.
Omit this element to disable removal of abandoned connections.
Specifies the phase in which connections will be tested for removal eligibility.
On "borrow" means connections may be removed when attempted to be borrowed from the pool.
On "maintenance" means connections may be removed during pool maintenance.
Timeout in seconds before an abandoned connection can be removed.
A connection is considered abandoned and eligible for removal if it has been idle longer than this timeout.
If the connection pool implements org.apache.commons.pool2.UsageTracking, configure
whether the connection pool should record a stack trace every time a
method is called on a pooled connection and retain the most recent stack
trace to aid debugging of abandoned connections. (Default: false).
Specifies if the PoolGuard allows access to the underlying connection. (Default: false).
Configuration for eviction of stale connections.
Omit this element to disable eviction for this pool.
The number of milliseconds to sleep between runs of the idle object evictor thread.
The number of objects to examine during each run of the idle object evictor thread (if any).
The minimum number of milliseconds an object may sit idle in the pool before it is eligible for eviction by the idle object evictor (if any). (Default: 1800000).
The minimum number of milliseconds a connection may sit idle in the pool before it is eligible for eviction
by the idle object evictor, with the extra condition that at least "minIdle" connections remain in the pool.
Note that <minIdleTime> takes precedence over this parameter. (Default: INDEFINITE).
Specifies the EvictionPolicy implementation to use by the idle object evictor.
The SQL query that will be used to validate connections from this pool before returning them to the caller.
If specified, this query must be an SQL SELECT statement that returns at least one row. (Default: vendor specific).
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 the pool will attempt to borrow another.
NOTE: For a true value to have any effect, the <query> parameter must be set to a non-null string. (Default: true).
The indication of whether objects will be validated before being returned to the pool.
NOTE: For a true value to have any effect, the <query> parameter must be set to a non-null string. (Default: false).
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 <query> parameter must be set to a non-null string. (Default: false).
The indication of whether validation must "fail immediately" for connections that have previously thrown SQLExceptions
with SQL_STATE indicating fatal disconnection errors. Omit this element to disable "fail immediately".
A space-delimited list of SQL_STATE codes considered to signal fatal conditions.
Overrides the defaults in org.apache.commons.dbcp2.Utils.DISCONNECTION_SQL_CODES
(plus anything starting with org.apache.commons.dbcp2.Utils.DISCONNECTION_SQL_CODE_PREFIX).
Whenever connections created by this datasource generate exceptions with SQL_STATE
codes in this list, they will be marked as "fatally disconnected" and subsequent
validations will fail fast (no attempt at isValid or validation query).
Specifies logging parameters for this connection pool.
Omit this element for default logging.
The minimum level of log messages to log.
When <maxConnectionLifetime> is set to limit connection lifetime, this property determines whether
or not to generate log messages when the pool closes connections due to the maximum lifetime being exceeded
for a connection. Set this property to false to suppress log messages when connections expire. (Default: false).
Flag to log stack traces for application code which abandoned a Statement or Connection.
Logging of abandoned Statement(s) and Connection(s) adds overhead when opening a Connection
or creating a new Statement, because a stack trace has to be generated. (Default: false).
© 2015 - 2025 Weber Informatics LLC | Privacy Policy