The "Maximum Connections" setting in the JDBC connection resource determines how many connections can be used by the TIBCO ActiveMatrix BusinessWorks Plug-in for Database and other JDBC activities. If this value is set too low, the application may fail to start due to insufficient resources. In this scenario, no error log messages will be found in the log file.

To confirm the value of "Maximum Connections" in runtime, please configure the following logger to "TRACE" in the logback.xml file:
===================================
com.tibco.bw.sharedresource.jdbc
===================================

After enabling the above logger, the following log message can be found in the log file:
===================================
com.tibco.bw.sharedresource.jdbc.runtime.connectionpool.JDBCPool - Pool of Connection created at 11:10:10:999 with N Connections
===================================
In the above log message, 'N' represents the value of "Maximum Connections."

The following is the number of connections required for each activity of the TIBCO ActiveMatrix BusinessWorks Plug-in for Database:

1 The DataEventPoller activity requires 2 connections.
2 The DataMerger and DataRequester activities each require 1 connection.

Therefore, when configuring the "Maximum Connections" for the JDBC connection resource, it should be set to a value greater than:
"Number of DataEventPoller activities" * 2 + "Number of DataMerger activities" + "Number of DataRequester activities" + "Number of JDBC activities".

How to configure "Maximum Connections" for the JDBC connection resource

Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database Version: 8.x OS: All Supported Operating Systems