CLion
 
2024.3
Shortcuts: Windows
Get CLion
Join the CLion 2025.1 Early Access Program and try out new features before they are released! Find out more
  1. Language and framework-specific guidelines
  2. Database Tools and SQL
  3. Connection to a database
  4. Configure connection
  5. JDBC drivers

JDBC drivers

Last modified: 01 November 2024

CLion does not include bundled drivers to have a smaller size of the installation package and to keep driver versions up to date for each IDE version.

You can download JDBC drivers within the IDE and manually:

  • Upon creating a new data source for your database connection in the Data Sources and Drivers dialog (CtrlAltShift0S) , CLion provides a link for you to download the missing driver.

    The Download missing driver files link

  • For direct download links, refer to the JetBrains JDBC drivers page.

Location for the downloaded JDBC drivers is the CLion configuration directory.

You can also specify your drivers for the data source instead of the provided ones. Custom JDBC drivers can be sourced from official database vendor websites, open source repositories, third-party vendors, developer communities and forums, and so on.

Change the driver version

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

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

    • Press CtrlAltShift0S.

  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.

Configure a JDBC driver for an existing data source

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

To work properly, some JDBC drivers require a path to library files along with the driver. For more information about library paths, refer to Library paths for user drivers.

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

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

    • Press CtrlAltShift0S.

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

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

    To revert changes, click the Roll back Changes icon (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 (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.

    Driver class is a driver-specific main class for a JDBC driver. For the proper driver class for the JDBC driver you use, refer to the driver's documentation.

    note

    If the field is empty, or a predefined value is different from the one your driver requires, specify the required value manually.

  7. If your custom driver requires an additional property, go to the Advanced tab in the dialog. In the properties pane, enter the additional property's name and value in the last row of Name and Value columns, where <user defined> and <value> are shown.

  8. Click Apply.

tip

For more information about about JDBC driver settings, refer to the dialog reference topic.

See also

Reference