Steps to change the JDBC Driver

This section explains step by step process to update the JDBC driver for a Zephyr installation running on MySQL, MSSQL, or Oracle databases.

Tip

Before proceeding, we recommend taking a snapshot or backup of the Zephyr instance.

To update the JDBC driver for a Zephyr installation:

  1. Stop the Zephyr Server Service.

  2. Take a backup of the jdbc.properties file from the location <Zephyr installation directory>\tomcat\webapps\flex\WEB-INF\classes.

  3. Go to <Zephyr installation directory>\tomcat\webapps\flex\WEB-INF\lib folder and take a backup of the lib folder.

  4. Remove the existing jar file (depends on the database used, such as MySQL, MSSQL, or Oracle) under <Zephyr installation directory>\tomcat\webapps\flex\WEB-INF\lib folder.

  5. Download the recommended jar file for the specific database being used:

    • MySQL 8.x: mysql-connector-j-8.0.32.jar

    • MSSQL: mssql-jdbc-11.2.3.jre8.jar

      1. After downloading, extract sqljdbc_11.2.3.0_enu.zip.

      2. Go to \sqljdbc_11.2.3.0_enu\sqljdbc_11.2\enu.

      3. Pick only mssql-jdbc-11.2.3.jre8.jar.

    • Oracle: ojdbc7.jar

  6. Copy the downloaded jar file and paste it into <Zephyr installation directory>\tomcat\webapps\flex\WEB-INF\lib folder.

  7. Go to <Zephyr installation directory>\tomcat\webapps\flex\WEB-INF\classes folder.

  8. Open the jdbc.properties file and locate the jarFileName = parameter.

  9. Change the value of jarFileName to reflect the name of the new jar file.

    For example, for MSSQL,

    jarFileName = sqljdbc42.jar

  10. Start the Zephyr Server service.

Note

If the Zephyr instance is part of a cluster setup, these steps must be done on all nodes.

In this section:
© 2024
Publication date: