Open topic with navigation

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake 6.3.0

# Updating Snowflake JDBC drivers

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.

Before you begin

- Ensure the new version of Snowflake JDBC driver .jar file is present on your local computer.
- Shutdown all TIBCO Business Studio for BusinessWorks 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 for BusinessWorks and Snowflake Plug-in applications.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake

Copyright © 2020-2024. Cloud Software Group, Inc. All Rights Reserved.