Creating JDBC providers and data sources

Last Updated : May 15, 2025 |

About this task

Use this procedure to create Java Database Connectivity (JDBC) providers and data sources.

Important:

Skip this procedure if you use the Intersystem Cache database.

Before you begin

Ensure the following:

  • Download the JDBC driver .jar file that is compatible with the database version to use from the database vendor website.

  • Use the correct .jar file and the implementation class for that .jar file.

Refer to the System Manager guide for additional information about configuring JDBC providers and data sources.

The following table lists the database and the corresponding .jar files:

Database

.jar file

Oracle

ojdbc7.jar

PostgreSQL

postgresql-42.3.1 jar

MS SQL Server

mssql-jdbc-8.2.2.jar

Procedure

  1. Log in to System Manager.
  2. Navigate to Home > Avaya Breeze® > Configuration > JDBC Providers.
  3. Click New.
  4. In Jar, create a JDBC provider using the JDBC driver .jar file.

    In JDBC Provider Editor, specify the class name as mentioned in the JDBC Provider Class Name.

    In Jar File, select the .jar file. For example, if you are creating a JDBC provider MS SQL server TestProvider, use the MS SQL server JDBC driver mssql-jdbc-8.2.2.jar file.

  5. Navigate to Home > Avaya Breeze® > Service Management > Services.
  6. Search for the JDBC provider that you created in step 3.
  7. Select the provider and click Install.

    The Services page displays a pop-up list of clusters.

  8. Select the cluster on which you want to install the provider and click Commit.
  9. After successfully installing the JDBC provider, reboot all Avaya Breeze® instances for the cluster.
  10. Navigate to Home > Avaya Breeze® > Configuration > JDBC Sources.
  11. Add a new data source from the JDBC data source page.
  12. On the JDBC Data Source editor page, under the Basic section, select the cluster on which you installed the provider.

    The JDBC Provider drop-down list populates the installed provider name.

  13. Specify a JNDI name. You can specify the JNDI name as jdbc/<anyname>. For example, if you are creating a JDBC source for SQL, mention the JNDI name as jdbc/sql.
  14. Specify the database URL, username, and password to connect to the database. For example, jdbc:oracle:thin:<DB server IP address>:<port number>:oracledb.
  15. Under the Custom Properties section, on the Name tab, enter the database name as databaseName.
  16. In the Value tab, enter the value as configured on the MS SQL server and PostgreSQL.
  17. In the Name tab, enter the port number as portNumber.
  18. In the Value tab, enter the value as configured on the MS SQL server and PostgreSQL.
  19. In the Name tab, enter the server name as serverName.
  20. In the Value tab, enter the value as configured on the MS SQL server and PostgreSQL.
  21. In the Name tab, enter the user name as user.
  22. In the Value tab, enter the value as configured on the PostgreSQL.
  23. In the Name tab, enter the password name as password.
  24. In the Value tab, enter the value as configured on the PostgreSQL.
  25. Click Commit.
  26. On the JDBC Data Sources page, click Test Connection.

    The JDBC Data Sources page displays the status of the database connection.

  27. Reboot the Avaya Breeze® platform server after the test connection is successful.