Steps to change the JDBC Driver

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

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 (depending 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:

     • MySQL 8.x (JDBC Driver: mysql-connector-j-8.0.32.jar)

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

     • After downloading extract, the sqljdbc_11.2.3.0_enu.zip ->then go to \sqljdbc_11.2.3.0_enu\sqljdbc_11.2\enu folder -> and 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.