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 scans 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 scans 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.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.
resourcetemplate=true
If you set
options = enableJdbcTestConnection
in the
resourcetemplate_build.xml file for create or update target then this overrides the TRA property set and the test connection is performed.