Loading JDBC driver to System Manager

Last Updated : Aug 14, 2023 |

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.

Procedure

  1. On the System Manager web console, click Home > Elements > Avaya Breeze® > Configuration > JDBC Providers.
  2. Click New and do the following:

    • 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.

    The driver appears on the list of Available JDBC drivers.

  4. On the System Manager web console, click Avaya Breeze® > Service Management > Services.
  5. Select the driver.
  6. Click Install and select the Context Store cluster.
  7. Click Commit to install the jar file to the cluster.

    Restart the Context Store cluster after installing the driver.