Upgrading a Third-party JDBC Driver Using the CLI

Using the CLI scripts, you can upgrade existing JDBC drivers in the resource template of a runtime node or SystemNode. Executing the CLI scripts will update the driver across the enterprise and also automatically install, sync, and restart the corresponding nodes. The default driver for the resource template is also updated in the ActiveMatrix Administrator database.

1. Configure the new third-party JDBC driver in TIBCO_HOME using the "Configure Third-Party Driver" wizard of the TIBCO Configuration Tool (TCT).
2. Verify the updateJDBCDriver target and action in the enterprise_build.xml located in <CONFIG_HOME>\admin\amxadmin\samples\.

   <target name="updateJDBCDriver">
     <AMXAdminTask
      action="updateJDBCDriver"
      objectSelector="Enterprise"
      remote="true"
      propsFile="${instanceProperties}"
      dataFile="${dataFile}" 
      <!--
      options="dryRun"  
      -->
      failOnError="false"/>
    </target>

   Note: You cannot set objectSelector to Environment or Node.

   • remote="true": Upgrades the features for remote nodes. (that is, nodes managed by remote hosts).
   • options="dryRun": If specified, features are not installed or enabled on the node.

   Note: Database operations are not performed when options="dryRun" is used. Hence, any log messages indicating that a feature has been removed or updated can be ignored. The logs are benign.

   For more information on the other attributes, see Using Command-line Interface.
3. Verify the following data in the enterprise_data.xml located in <CONFIG_HOME>\admin\amxadmin\samples\ and modify OldFeature and NewFeature versions if needed.

   <OldFeature xsi:type="amxdata_base:FeatureID" componentID="com.tibco.tpcl.gen.oracle.jdbc.feature" version="11.2.100.001"/>
   <NewFeature xsi:type="amxdata_base:FeatureID" componentID="com.tibco.tpcl.gen.oracle.jdbc.feature" version="12.1.100.001"/>
   
   

   For example, to upgrade from 12.1.100.001 to 12.2.0.001 modify the entries as below:

   <OldFeature xsi:type="amxdata_base:FeatureID" componentID="com.tibco.tpcl.gen.oracle.jdbc.feature" version="12.1.100.001"/>
   <NewFeature xsi:type="amxdata_base:FeatureID" componentID="com.tibco.tpcl.gen.oracle.jdbc.feature" version="12.2.0.001"/>

4. Invoke the command-line interface on the build file.