Database Configuration (com.soa.database.config)

Configuration for database connections. There are some common, and a number of vendor-specific, properties.

Database User Name (username)

The user name to use to connec to the database.

Database Password (password)

The password used to connect to the database.

Publish This Configuration (canPublish)

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 (name)

Name

id (id)

ID

type (type)

Type

Admin Username (adminUsername)

Admin Username

driver (driver)

Driver

url (url)

URL

Max Active Connections (maxPoolSize)

The maximum number of active connections in the connection pool

Min Active Connections (minPoolSize)

The minimum number of active connections in the connection pool

Max Connection Wait Time (maxWait)

The maximum time to wait, in milliseconds, to get a connection from the pool

Validation Query (validationQuery)

Optional validation query for a connection in order to determine if it is still valid

Log Abandoned Connections (logAbandoned)

Logs abandoned connections to log file

Remove Abandoned Connections (removeAbandoned)

Removes abandoned connections from pool. logAbandoned must be true for this to work

Encrypt Values (encryptValues)

Encrypts Database Password

Use Tracking Connections (useTrackingConnections)

Use tracking connections

Database Configuration ()

Configuration for database connections. There are some common, and a number of vendor-specific, properties.

Eviction Interval (timeBetweenEvictionRunsMillis)

Indicates how long the eviction thread should sleep before 'runs' of examining idle objects. When non-positive, no eviction thread will be launched.

Test while idle (testWhileIdle)

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

Test on return (testOnReturn)

The indication of whether objects will be validated before being returned to the pool.

number of connections to test (numTestsPerEvictionRun)

Determines the number of objects examined in each run of the idle object evictor. This setting has no effect unless timeBetweenEvictionRunsMillis 0

Minimum idle time (minEvictableIdleTimeMillis)

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

Maximum idle connections (maxIdle)

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

Test on Borrow (testOnBorrow)

The indication of whether objects will be validated before being borrowing from the pool.

Last in First out (lifo)

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.

Soft Minimum Evictable Idle Time (softMinEvictableIdleTimeMillis)

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

Default Catalog (defaultCatalog)

The default 'catalog' of connections created by this pool.

Validation Query Timeout (validationQueryTimeout)

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.

Connection Initializtion SQLs (connectionInitSqls)

Semicolon separated list of SQL statements executed when a physical connection is first created.

Cache State (cacheState)

Controls if the pooled connections cache some state rather than query the database for current state to improve performance

Pool Prepared Statements (poolPreparedStatements)

Prepared statement pooling for this pool.

Maximum Open Prepared Statements (maxOpenPreparedStatements)

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

Maximum Connection Lifetime (maxConnLifetimeMillis)

Sets the maximum permitted lifetime of a connection in milliseconds. A value of zero or less indicates an infinite lifetime

Rollback on Return (rollbackOnReturn)

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

Return Autocommit state (enableAutoCommitOnReturn)

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

Default Query Timeout (defaultQueryTimeout)

The default query timeout that will be used for Statements created from this connection

Default Autocommit state (defaultAutoCommit)

Default auto-commit state of connections created by this pool

Encryption Type (encryptionType)

Encryption type

Default: SK

Truststore file location (trustStore)

MS-SQL truststore file location

Truststore password (trustStorePassword)

MS-SQL truststore password