Skip to content

Adding a Custom JDBC Driver

For databases that are not pre-installed or pre-configured (PostgreSQL, DB2, etc.), drop the vendor's JDBC driver JAR into QIE via Manage External Libraries and create a Database Connection using the Custom driver option.

Step 1: Install the driver JAR

  1. Download the database vendor's JDBC type-2 driver JAR (for example, postgresql-42.7.4.jar from postgresql.org/download/jdbc).
  2. In QIE, open System Configuration -> Manage External Libraries.
  3. Add the JAR, then check its box to enable it.
  4. Restart QIE so the new JAR is on the classpath.

Step 2: Create the connection

On the Database Connections page, click New and:

  • Driver: pick Custom.
  • Driver Class: the fully-qualified driver class name from the vendor's documentation (for example, org.postgresql.Driver).
  • Connection URL: the vendor's JDBC URL pattern (for example, jdbc:postgresql://<host>:5432/<database>).
  • Username / Password: credentials for the database user.
  • Validation Query: use the vendor's preferred query (for PostgreSQL the QIE default SELECT 1 works).

Click Test Query with a simple SELECT to confirm the connection.

PostgreSQL example

Field Value
Driver Custom
Driver Class org.postgresql.Driver
Connection URL jdbc:postgresql://db.example.com:5432/qie
Validation Query SELECT 1

Other databases follow the same pattern. Substitute the vendor's driver class and URL.