Manage JDBC Drivers

This section explains how you can add, view, or update the JDBC driver through EXAoperation interface.

The procedure given in the section is not applicable for the JDBC driver that comes pre-installed with Exasol.

Add JDBC Driver

Do the following to add a JDBC driver:

  1. Log in to EXAoperation user interface as an Administrator user.
  2. Select Configuration > Software and click the JDBC Drivers tab.
  3. Click Add to add the JDBC driver details.
  4. Enter the following details for the JDBC properties:
    • Driver Name: <driver name>
    • Main Class: <driverclass>
    • Prefix: <driver prefix>
    • Disable Security Manager: This is an optional field. This allows the JDBC Driver to access certificate and additional information.
    • Comment: This is an optional field.
  5. Click Add to save the settings.
  6. Select the radio button next to the driver from list of JDBC driver.
  7. Click Choose File to locate the downloaded driver and click Upload to upload the JDBC driver.

    The JDBC driver file must be compiled with Java 8 or older.

View JDBC Driver Versions

To view the JDBC driver version, select Configuration > Software and click the JDBC Drivers tab.

View JDBC Driver version

Update JDBC Driver Version

Do the following to update the JDBC driver:

  1. Download the latest JDBC driver from your preferred vendor's download page.
  2. Log in to EXAoperation user interface as an Administrator.
  3. Go to Configuration > Software and click the JDBC Drivers tab.
  4. Click Choose File, select the JDBC driver file you downloaded, and click Open.
  5. Next, click Upload.

The JDBC driver is updated.