Configuration for database connections. There are some common, and a number of vendor-specific, properties.
The user name to use to connec to the database.
The password used to connect to the database.
Can this configuration be published? This flag is used to indicate whether a given configuration is complete and may be published as a DataSource into OSGi.
Name
ID
Type
Admin Username
Driver
URL
The maximum number of active connections in the connection pool
The minimum number of active connections in the connection pool
The maximum time to wait, in milliseconds, to get a connection from the pool
Optional validation query for a connection in order to determine if it is still valid
Logs abandoned connections to log file
Removes abandoned connections from pool. logAbandoned must be true for this to work
Encrypts Database Password
Use tracking connections
Indicates how long the eviction thread should sleep before 'runs' of examining idle objects. When non-positive, no eviction thread will be launched.
Indicates whether or not idle objects should be validated using the factory's PoolableObjectFactory.validateObject(T) method. Objects that fail to validate will be dropped from the pool. This setting has no effect unless timeBetweenEvictionRunsMillis > 0.
The indication of whether objects will be validated before being returned to the pool.
Determines the number of objects examined in each run of the idle object evictor. This setting has no effect unless timeBetweenEvictionRunsMillis > 0
Specifies the minimum amount of time that an object may sit idle in the pool before it is eligible for eviction due to idle time. When non-positive, no object will be dropped from the pool due to idle time alone. This setting has no effect unless > 0
Controls the maximum number of objects that can sit idle in the pool at any time. When negative, there is no limit to the number of objects that may be idle at one time
The indication of whether objects will be validated before being borrowing from the pool.
True means that borrowObject returns the most recently used ('last in') connection in the pool (if there are idle connections available). False means that the pool behaves as a FIFO queue - connections are taken from the idle instance pool in the order that they are returned to the pool.
The minimum amount of time 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 minEvictableIdleTimeMillis takes precedence over this parameter
The default 'catalog' of connections created by this pool.
Sets the validation query timeout, the amount of time, in seconds, that connection validation will wait for a response from the database when executing a validation query. Use a value less than or equal to 0 for no timeout.
Semicolon separated list of SQL statements executed when a physical connection is first created.
Controls if the pooled connections cache some state rather than query the database for current state to improve performance
Prepared statement pooling for this pool.
The maximum number of open statements that can be allocated from the statement pool at the same time, or negative for no limit. Since connection usually only uses one or two statements at a time, this is mostly used to help detect resource leaks
Sets the maximum permitted lifetime of a connection in milliseconds. A value of zero or less indicates an infinite lifetime
Controls if 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
Controls whether or not connections being returned to the pool will checked and configured with Connection.setAutoCommit(true) if the auto commit setting is false when the connection is returned
The default query timeout that will be used for Statements created from this connection
Default auto-commit state of connections created by this pool
Encryption type
Default: SK
MS-SQL truststore file location
MS-SQL truststore password