Idle Pool Connection Properties

maxIdle

The maximum number of connections that can be idle without connections being released. Defaults to 20. Set this to -1 to prevent any connections being released.

minIdle

The minimum number of idle connections that can exist before new connections are added to the pool. This defaults to 0, indicating no new connections should be created.

testWhileIdle

Whether connections should be tested when idle.

If this is enabled, idle connections are tested using the Validation query. See Move the MashZone NextGen repository to a robust database solution for more information on validation queries.

timeBetweenEvictionRunsMillis

The number of milliseconds between tests of idle connections. This defaults to -1, which prevents all idle connection testing.

numTestsPerEvictionRun

The number of connections to test during any idle connection test run.

minEvictableIdleTimeMillis

The minimum number of milliseconds that a connection can be idle before being tested for eviction. Default is 3 minutes.