Loading JDBC driver to System Manager

Last Updated : Aug 14, 2023 |
Prolog information
Before you begin
Ensure you download the JDBC driver .jar file compatible with the database version you want to use from the database vendor website. Ensure you are using the correct .jar file and the implementation class for that .jar file.
MS SQL server database supports the following .jar files:
Database
.jar file
MS SQL Server
mssql-jdbc-7.4.1.jre8.jar or higher
Note:
You must use the JRE8 version, because the Avaya Breeze® platform runs only on Java 8, and not other versions, such as Java 11.
  1. On the System Manager web console, click HomeElementsAvaya Breeze®ConfigurationJDBC Providers.
  2. Click New and do the following:
    ADDITIONAL INFORMATION:
    • In the Name field, type the name of your JDBC driver, which is displayed as a service name.
      For example, MS-SQL-JDBC-Driver
    • In the Class Name field, type the name of the JDBC driver class.
      For example, the MS SQL driver class is com.microsoft.sqlserver.jdbc.SQLServerDriver
    • Optional: In the Description field, type a description of the JDBC driver.
  3. To select the jar file, click Choose file and select the JDBC jar file.
    STEP RESULT:
    The driver appears on the list of Available JDBC drivers.
  4. On the System Manager web console, click Avaya Breeze®Service ManagementServices.
  5. Select the driver.
  6. Click Install and select the Context Store cluster.
  7. Click Commit to install the jar file to the cluster.
    ADDITIONAL INFORMATION:
    Restart the Context Store cluster after installing the driver.