JDBC drivers

1. Open data source properties. You can open data source properties by using one of the following options:

   • Navigate to File | Data Sources....

   • Press .

   • In the Database Explorer ( View | Tool Windows | Database Explorer), click the Data Source Properties icon ().

   

2. In the Data Sources and Drivers dialog, click the Drivers tab, and select a driver entry that you want to modify.

3. Click the Driver link in data source settings.

   Some data sources have a list with drivers for different versions (for example, MySQL). In these cases, select Go to driver from the list.

4. In the Driver files pane, click the version number, and select the driver version that you need.

You can add libraries to the existing driver or replace the driver completely.

1. Open data source properties. You can open data source properties by using one of the following options:

   • Navigate to File | Data Sources....

   • Press .

   • In the Database Explorer ( View | Tool Windows | Database Explorer), click the Data Source Properties icon ().

   

2. Click the Driver link in data source settings and select Go to Driver.

3. Click the provided driver entry, and click Remove ().

   To revert changes, click the Roll back Changes icon () that is in the lower-right part of the window.

4. In the Driver Files pane, click the Add icon () and select Custom JARs….

5. In the file browser, navigate to the JAR file of the JDBC driver, select it, and click OK.

6. In the Class field, specify the value that you want to use for the driver.

7. Click Apply.