TRA Properties for JDBC Test Connection

You can set the following properties from the SystemNode TRA file or Administrator UI.

The following property specifies possible sources from where the ActiveMatrix Administrator searches for drivers to make a JDBC connection. 
java.property.com.tibco.admin.jdbc.testconnection.driver.scan.mode=BOTH

Default value is BOTH. It has three possible values:

Value Description
TPCL ActiveMatrix Administrator scans only installed third-party drivers by using the Configure Third-Party Driver option in TCT.
FSLOC Administrator will scan only the file system location provided by the property java.property.com.tibco.admin.jdbc.testconnection.driver.filesystem.location.
BOTH (Default) In case of scan mode "BOTH", Administrator will scan the file system location first followed by installed third-party drivers in the <TIBCO_HOME>.
Note:

TIBCO recommends that you keep only one database driver version JAR in the file system location provided for each database that you want to use. If there are more than one driver JAR files, the first in the list is used to make the database test connection.

Specifying Path to JDBC Driver

You can use the following property to provide the path to JDBC drivers located on a file system folder and these drivers need not be installed in <TIBCO_HOME>. 
java.property.com.tibco.admin.jdbc.testconnection.driver.filesystem.location=C:\\PATH\\TO\\FOLDER\\CONTAINING\\JDBCDRIVER

This property is used when java.property.com.tibco.admin.jdbc.testconnection.driver.scan.mode=BOTH or FSLOC.

Disabling JDBC Test Connection

By default, JDBC test connection feature is enabled. To disable this feature set the following property in SystemNode TRA file: 

java.property.com.tibco.admin.jdbc.disable.validate.connection.for.resourcetemplate=true
By default, this value is false. If this TRA property is set to true, JDBC test connection is disabled while creating or updating a resource template using CLI. If this property is set to false then test connection is performed while creating or updating resource template.
Note: This property does not disable test connection from Administrator UI.

If you set options = enableJdbcTestConnection in the resourcetemplate_build.xml file for create or update target then this will override the TRA property set and the test connection is performed.