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. After running the scripts, the drivers are updated across the enterprise and the nodes are synced and restarted. 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. Put a file at a special location in the feature's path with the driver name and version.
3. Add the feature to the node. See Adding a Feature to a Node.
4. Delete the resource instances that use this driver and re-create resource templates.
5. Remove the old driver from all these nodes. See Removing Features from a Node.
6. Add 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/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, refer to the section Using Command-line Interface.

7. Add the following data in the enterprise_data.xml located in <CONFIG_HOME>\admin\amxadmin\samples\.

   <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"/>

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