Each Datasource is implemented as a connection manager that can be configured via some additional properties described in the following table. Refer to the Oracle1.properties file to see an example of settings. All these settings have default values and are not required.
| Property Name | Description | Default Value |
|---|---|---|
| jdbc.connchecklevel | JDBC connection checking level: 0 (no check), 1 (check connection), higher (call the test statement) | 1 |
| jdbc.connmaxage | maximum age for jdbc connections | 30 minutes |
| jdbc.connteststmt | test statement | select 1 |
| jdbc.minconpool | Minimum number of connections in the pool | 0 |
| jdbc.maxconpool | Maximum number of connections in the pool | -1 (no max boundary) |
jdbc.connteststmt is not used when jdbc.connchecklevel is equal to 0 or 1.
jdbc.minconpool is used at DataSource creation time. Modifying this property during runtime has no effect on already-created DataSources.
jdbc.maxconpool can be dynamically increased or decreased.