Updating Snowflake JDBC driver

Snowflake JDBC drivers are updated and released frequently, when you get a newer version of JDBC driver from Snowflake, you can replace the installed older version Snowflake JDBC driver in your installation environment using the snowflakejdbcupdate utility which is located in the BW_HOME/bw/palettes/snowflake/<version>/bin directory.

Prerequisites

  • Ensure the new version of Snowflake JDBC driver .jar file is present on your local computer.
  • Shutdown all TIBCO Business Studio and Snowflake plug-in applications.

Procedure

  1. Navigate to the bin folder where the plug-in is installed. For example, C:\tibco\bw\palettes\snowflake\version_number\bin.
  2. On the command line enter the following commands:
    • On Windows: snowflakejdbcupdate.exe
    • On Linux: ./snowflakejdbcupdate
    • On mac OS: ./snowflakejdbcupdate
  3. On executing the command, the following message is displayed: Please specify absolute path of the snowflake JDBC jar
  4. Specify the absolute path of the snowflake-jdbc-<version>.jar

    A BUILD SUCCESSFUL message appears, which indicates the Snowflake JDBC driver is updated successfully.

  5. If updating the Snowflake JDBC driver in a deployed environment, further steps are required so that the update is successful.
    • Set the bw.appnode.clean.config.folder.on.startup property as true in the config.ini file of appnode.

What to do next

Restart TIBCO Business Studio and Snowflake Plug-in applications.