Installing a JDBC driver v7
Choosing and installing a JDBC driver
Which JDBC driver you use depends on what database you're using. If you're using:
EDB Postgres Advanced Server, use the EDB JDBC driver. To download the latest driver, see EDB Connectors on the EDB Downloads page. For installation instructions, see Installing and configuring EDB JDBC Connector.
PostgreSQL, use the PostgreSQL JDBC driver. To download the latest supported driver (Java 8), see the JDBC drivers section on the PostgreSQL Downloads page.
Oracle, use the freely available Oracle JDBC driver.
Microsoft SQL Server, use the freely available Microsoft SQL Server JDBC driver.
Note
For Microsoft SQL Server, if your system uses JDK/JAVA then it is recommended that you use an equal or earlier mssql-jdbc jre version than the JDK/JAVA version on your system. For example, a system with JDK/JAVA version 18 can use mssql-jdbc-11.2.0.jre18.jar, mssql-jdbc-11.2.0.jre17.jar, and so on.
Configuring the driver
After downloading the driver, create a symlink in the XDB-install-folder/lib/jdbc directory that points to the location where you installed the driver.
For Linux, create a symlink for the driver using these naming conventions:
| Driver | symlink name |
|---|---|
| EDB | edb-jdbc18.jar |
| PostgreSQL | postgresql.jar |
| Oracle | ojdbc.jar |
| Microsoft SQL Server | mssql-jdbc.jar |
| jTDS | jtds.jar |
For Windows, the drivers need to be copied to the XDB-install-folder/lib/jdbc directory and renamed using the same naming conventions.