You are viewing the documentation for Blueriq 16. Documentation for other versions is available in our documentation directory.
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 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.
Supported JDBC Drivers
All supported database platforms can be found on the Platform support page.
Microsoft SQL Server
For Microsoft SQL Server, we recommend using the Microsoft JDBC Driver (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/ or the Microsoft website.
This driver uses encryption by default and therefor you either have to
- setup a truststore with the correct certificate and reference it in the jdbc url
- auto accept the certificate using the
trustServerCertificate=trueinside the jdbc url
Oracle
For Oracle, we recommend to use the ojdbc8 driver: ojdbc8.jar (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
On Tomcat, the JDBC driver is usually placed in the $CATALINA_HOME\lib folder.
https://tomcat.apache.org/tomcat-9.0-doc/jndi-datasource-examples-howto.html
JBoss EAP
For JBoss EAP the JDBC drivers should be added as a module.
Overview
Content Tools