| Field | Type | Description | Default Value | Required |
|---|---|---|---|---|
| Max Pool Size | Number | Maximum number of connections a pool maintains at any given time | 5 |
|
| Min Pool Size | Number | Minimum number of connections a pool maintains at any given time | 0 |
|
| Acquire Increment | Number | Determines how many connections at a time to try to acquire when the pool is exhausted | 1 |
|
| Prepared Statement Cache Size | Number | Determines how many statements are cached per pooled connection. Setting this to zero disables statement caching. | 5 |
|
| Max Wait | Number | The amount of time a client trying to obtain a connection waits for it to be acquired when the pool is exhausted. Setting this value to zero (default) means wait indefinitely. This is equivalent to checkoutTimeout and cannot be overridden in additional-properties. |
0 |
|
| Max Wait Unit | Enumeration, one of: NANOSECONDS MICROSECONDS MILLISECONDS SECONDS MINUTES HOURS DAYS |
A time unit that qualifies the maxWait attribute. | SECONDS | |
| Max Idle Time | Number | Determines how many seconds a connection can remain pooled but unused before being discarded. Setting this value to zero (default) means idle connections never expire. | 0 |
|
| Additional Properties | Object | A map in which keys are the name of a pooling profile configuration property. Does not support the use of expressions. These properties cannot be used to override any of the previously specified properties (like Max Pool Size or Min Pool Size), the main property prevails if an attempt is made to override it. The map's values contain the actual assignation for each parameter. | ||
| Max Statement | Number | Defines the total number PreparedStatements a DataSource will cache. The pool destroys the least-recently-used PreparedStatement when it reaches the specified limit. When set to 0, statement caching is turned off |
||
| Test connection on checkout | Boolean | Disables connection testing on checkout to improve performance. If set to true, an operation is performed at every connection checkout to verify that the connection is valid. A better choice is to verify connections periodically using c3p0.idleConnectionTestPeriod. To improve performance, set this property to false. |
true |