Problem

-- The file dbcp.properties is used to customize some parameters like the pools in a JDBC channel

-- The file located in the Integrator/solutions/config/b2bx/dbserver is not taken into account by B2Bi/Integration.

Resolution

* starting Integrator 3.6.0_SP10, Integrator now is now able to override db properties by using the dbcp properties file

1. Copy the file Integrator/solutions/config/b2bx/dbserver/dbcp.properties in Integrator/config/java

2. Modify the following lines by adding a prefix dbcp:

maxWait=-1
testOnReturn=true
initialSize=100
maxActive=1000
minIdle=100

replaced by

dbcp.maxWait=-1
dbcp.testOnReturn=true
dbcp.initialSize=100
dbcp.maxActive=1000
dbcp.minIdle=100

3. modif the dbcp settings according to your need *

4. restart Integrator tasks

* for instance, you can increase the maxActive parameter to get rid of the error "org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object"

Please refer to https://support.axway.com/kb/58596/language/en for further information