Configuration of Database Connection Pool

The iProcess Connector for ActiveMatrix BusinessWorks uses a pool of database connections to ensure best performance when handling database updates using the SSOLite stored procedures. It provides facilities that enable you to tailor some of the parameters used for this database connection pooling.

Note: The pool used by iProcess Connector for ActiveMatrix BusinessWorks is separate from the database pool used by the iProcess Java Plug-in and described in TIBCO iProcess Java Plug-in User Guide.

The default values for the attributes which control the way each pool behaves are configured in the file SWDIR\java\jmx\config.xml and these values are used when the iProcess Engine starts up.

As well as being able to define defaults for many parameters associated with the database pooling mechanism used by the iProcess Connector for ActiveMatrix BusinessWorks, there are further facilities which enable you to dynamically change the values at run-time. This is not done by changing the java\jmx\config.xml file but by configuring DBPoolMBean through the Java Monitoring & Management Console. Changes made in this way are not preserved if iProcess Engine is shut down and restarted.

Note: For more information, see the Apache Commons Pool 1.4 API documentation. This is supplied on the iProcess Technology Plug-ins installation media in the \pooling folder. Click the index.html file to open the document, and then click the GenericObjectPool class.

Changing the following parameters is supported:

MaxActive=8
WhenExhaustedAction=1
MaxWait=-1
MaxIdle=8
MinIdle=0
TestOnBorrow=false
TestOnReturn=false
TimeBetweenEvictionRunsMillis=900000
NumTestsPerEvictionRun=3
MinEvictableIdleTimeMillis=1800000
TestWhileIdle=false
SoftMinEvictableIdleTimeMillis=-1
Lifo=true
Warning:

The values given in the list above are the supplied defaults. For details about each of these parameters, see GenericObjectPool in the Apache Commons Pool 1.4 API documentation.

Note that changing any of the above values is normally done as part of a tuning exercise to improve performance. It is not possible to recommend alternative values without examining the performance characteristics of a particular system. You must carry out any changes with great care, to avoid affecting the performance of your system adversely.

Note: The following values that are available must not be changed.
ConnectionURL
DriverName
HeartBeatSQL