Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A JDBC driver (Java Database Connectivity) is a way for Java programs to connect to databases. When you run the Blueriq installer, a H2 JDBC PostgreSQL driver is configured out-of-the-box. While this driver is great for development, we don't recommend nor support to use this database in a production environment. On this page you find instructions how to install a JDBC driver for your database and application server for the different database brands.

Supported JDBC Drivers

All supported database platforms can be found on the Platform support page.

...

For Microsoft SQL Server, we recommend using the Microsoft JDBC Driver 12.2.0. (the recommended version can be found at the platform support page). This driver can be found at maven central https://repo1.maven.org/maven2/com/microsoft/sqlserver/mssql-jdbc/12.2.0.jre11/ or the Microsoft website

This driver uses encryption by default and therefor you either have to

...

For Oracle, we recommend to use the ojdbc8 driver: ojdbc8.jar version 21.9.0.0. (the recommended version can be found at the platform support page). The ojdbc8 driver can be downloaded from the Oracle website.

PostgreSQL

For PostgreSQL use the JDBC driver

...

(the recommended version can be found at the platform support page) which can be found at https://jdbc.postgresql.org/.

Application servers

Tomcat

...