KB Article #175918

JDBC channel improvement: how to tune up the database communication using JDBC channel parameters

Problem

-- how to improve JDBC communication with databases through JDBC channels ?

Resolution

* parameters here:
http://commons.apache.org/proper/commons-dbcp/configuration.html
* noted parameter is:
maxTotal 8 The maximum number of active connections that can be allocated from this pool at the same time, or negative for no limit.
* the format of this parameter and location are:
$CORE_ROOT/config/java/dbcp.properties
maxTotal=8