Admin Data Source Configuration
| Name | Description | Default Value |
|---|---|---|
|
com.tibco.af.oms.pooledDataSource.driverClassName |
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. |
jdbc:postgresql://localhost:5432/admindbll?currentSchema=adminschemall |
|
com.tibco.af.oms.pooledDataSource.initializeSize |
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 |
|
com.tibco.af.oms.pooledDataSource.maxActive |
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 |
10000 |
|
com.tibco.af.oms.pooledDataSource.validationQuery |
The SQL query that is used to validate connections from this pool before returning them to the caller or pool |
Select 1 from dual
(SELECT 1 for postgres) |
|
com.tibco.af.oms.pooledDataSource.testOnBorrow |
The indication of whether objects are validated before being borrowed from the pool. |
False |
|
com.tibco.af.oms.pooledDataSource.testWhileIdle |
Set to true if query validation might take place when the connection is idle. |
True |
|
com.tibco.af.oms.pooledDataSource.timeBetweenEvictionRunsMillis |
The number of milliseconds to sleep between runs of the idle connection validation, abandoned cleaner, and idle pool resizing |
5000 |
|
com.tibco.af.oms.pooledDataSource.minEvictableIdleTimeMillis |
The minimum amount of time an object must sit idle in the pool before it is eligible for eviction |
5000 |
|
com.tibco.af.oms.pooledDataSource.numTestsPerEvictionRun |
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 |