JDBC drivers
IntelliJ IDEA 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 (Ctrl+Alt+Shift+S) , IntelliJ IDEA provides a link for you to download the missing driver.
For direct download links, refer to the JetBrains JDBC drivers page.
Location for the downloaded JDBC drivers is the IntelliJ IDEA 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
Open data source properties. You can open data source properties by using one of the following options:
In the Database tool window () , click the Data Source Properties icon
.Press Ctrl+Alt+Shift+S.
In the Data Sources and Drivers dialog, click the Drivers tab, and select a driver entry that you want to modify.
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.
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.
Open data source properties. You can open data source properties by using one of the following options:
In the Database tool window () , click the Data Source Properties icon
.Press Ctrl+Alt+Shift+S.
Click the Driver link in data source settings and select Go to Driver.
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.In the Driver Files pane, click the Add icon (
) and select Custom JARs.In the file browser, navigate to the JAR file of the JDBC driver, select it, and click OK.
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.
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.
Click Apply.