minPoolSize of 0

[azadbolour]

I have an application that is idle most of the time, but may have bursts of activity from time to time. During the times it is idle, I'd like to have 0 connections to the database, so that the database can be quiesced. Using a serverless database like AWS Aurora, I would then only have to pay for minutes that the database is actually active, and save on the cost of operating the database.

Reading the C3P0 configuration documentation it appeared as if a minPoolSize of 0 implies the lack of a minimum, rather than a minimum of 0. Would appreciate confirmation of the meaning of a minPoolSize of 0.

Is there any way to force C3P0 to close every connection it has to the database during an idle period? Incurring the cost of opening connections during bursts of activity is tolerable for my particular use case.

Many thanks.

Azad

[swaldman]

Hi,

c3p0 has a config parameter for this, maxIdleTimeExcessConnections. You can just set this, and minPoolSize to 0, and you should get what you want.