Upgrading JDBC Drivers

If, as part of this upgrade of ActiveMatrix BPM, you have upgraded the database version used to host any of the following:

  • the ActiveMatrix Administrator database tables
  • the ActiveMatrix BPM database tables
  • BDS Case Data Store tables (if they are hosted separately from the ActiveMatrix BPM database)

you must upgrade the JDBC driver used by that database.

Procedure

  1. Make sure that the .jar files for the required JDBC drivers are available on the primary machine. (See JDBC Drivers.)
  2. Stop the TIBCO Host instance.
  3. In TIBCO Configuration Tool, run the Configure Third-Party Driver Wizard.
  4. Configure the JDBC driver needed for the database server that will be used to host the database.
  5. Start the TIBCO Host instance.
  6. Using the ActiveMatrix Administrator CLI, run the "updateJDBCDriver" action. For example:
    1. Open the CONFIG_HOME/admin/enterpriseName/samples/enterprise_data.xml file in a text editor.
    2. Locate the <OldFeature> and <NewFeature> entries for the appropriate jdbc.feature and update the version strings to the appropriate version numbers. For example, if you have upgraded from using Microsoft SQL Server 2012 with TIBCO enabled JDBC driver for Microsoft SQL Server 4.2.0, to Microsoft SQL Server 2016 with TIBCO enabled JDBC driver for Microsoft SQL Server 6.0.0: 
      <OldFeature xsi:type="amxdata_base:FeatureID" componentID="com.tibco.tpcl.gen.sqlserver.jdbc.feature" version="4.2.0.001"/>
<NewFeature xsi:type="amxdata_base:FeatureID" componentID="com.tibco.tpcl.gen.sqlserver.jdbc.feature" version="6.0.0.001"/>
    3. Save your changes to the file.
    4. Run the command:
      ant -f CONFIG_HOME/admin/enterpriseName/samples/enterprise_build.xml updateJDBCDriver
    For more information about the "updateJDBCDriver" action, see "Using Command-Line Interface (CLI)" in the SOA Administration guide.
  7. If necessary, repeat steps 1 to 6 for the other databases.