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.