Admin Data Source Configuration
Name | Description | Default Value |
---|---|---|
|
The JDBC driver class to use |
org.postgresql.Driver
|
com.tibco.af.oms.pooledDataSource.host
|
The host machine where the database is available |
localhost
|
com.tibco.af.oms.pooledDataSource.username
|
The user name that is given when connecting to the database |
adminuserll
|
com.tibco.af.oms.pooledDataSource.password
|
The password to be given when connecting to the database |
adminuserll
|
com.tibco.af.oms.pooledDataSource.url
|
The URL connection string for the database This is constructed using the values given for the host, port, and database. |
|
|
The initial size of the database connection pool | 2
|
com.tibco.af.oms.pooledDataSource.maxIdle
|
The maximum number of connections that might be kept in the idle pool if the pool sweeper is enabled |
11
|
|
The maximum number of active connections that can be allocated from this pool at the same time |
12
|
com.tibco.af.oms.pooledDataSource.maxWait
|
The maximum number of milliseconds that the pool waits for a connection to be returned before throwing an exception |
|
|
The SQL query that is used to validate connections from this pool before returning them to the caller or pool |
Select 1 from dual
|
|
The indication of whether objects are validated before being borrowed from the pool. |
False
|
|
Set to true if query validation might take place when the connection is idle. |
True
|
|
The number of milliseconds to sleep between runs of the idle connection validation, abandoned cleaner, and idle pool resizing |
5000
|
|
The minimum amount of time an object must sit idle in the pool before it is eligible for eviction |
5000
|
|
Pooled Data Source Tests Per Eviction Run | 5
|
com.tibco.af.oms.pooledDataSource.defaultAutoCommit
|
Pooled Data Source Default Auto Commit | false
|
com.tibco.af.oms.pooledDataSource.rollbackOnReturn
|
Pooled Data Source Rollback On Return | false
|
com.tibco.af.oms.pooledDataSource.commitOnReturn
|
Pooled Data Source Commit On Return | false
|
com.tibco.af.oms.dataSource.pooledDataSource.connectionProperty
|
Pooled Database Connection Property | true
|
com.tibco.af.oms.dataSource.pooledDataSource.customProperty
|
Pooled Database Custom Property |
|