Data Integration

Set additional ADC Datasource connection properties

Save PDF

Table of Contents

Set additional ADC Datasource connection properties

Save PDF

Last Updated: October 26, 2026
1 minute read

Corticon
Version 7.3
Documentation

There are additional properties you might want to set for an ADC Datasource connection.

Note: It is a good practice to test your connection before and after changing additional properties.

Connection Pooling

Corticon uses C3P0, an open source JDBC connection pooling product, for connection pooling. The following properties let you tune connection pooling that will be used when connecting to a Database through ADC or Batch Processing:

Table 1. C3PO properties for the Datasource Pool
Property Name	Default value	Comment
`com.corticon.server.database.c3p0.minpoolsize`	`1`	Minimum number of Connections a pool will maintain at any given time.
`com.corticon.server.database.c3p0.maxpoolsize`	`100`	Maximum number of Connections a pool will maintain at any given time.
`com.corticon.server.database.c3p0.maxidletime`	`1800`	Seconds a Connection can remain pooled but unused before being discarded. Zero means idle connections never expire.
`com.corticon.server.database.c3p0.maxstatements`	`500`	The size of c3p0's global PreparedStatement cache. If both `maxStatements` and `maxStatementsPerConnection` are zero, statement caching will not be enabled. If `maxStatements` is zero but `maxStatementsPerConnection` is a non-zero value, statement caching will be enabled, but no global limit will be enforced, only the per-connection maximum. `maxStatements` controls the total number of Statements cached, for all Connections.

These properties are set for a connection in the brms.properties file of the project associated with the ADC or batch connection. Be sure to migrate the settings to runtime servers.