Skip to content

What is a JDBC Driver?

A JDBC driver (Java Database Connectivity driver) is a small piece of software that allows MODLR to connect to different databases.

Essentially, a JDBC driver makes it possible to do three things:

  1. Establish a connection with a data source.
  2. Send queries and update statements to the data source.
  3. Process the results.

Adding a new JDBC Driver

To setup a new driver you will need three components

  1. The *driver*.jar file from the database provider.
  2. The class name for the JDBC
  3. A database connection URI

The above three components are documented / linked below this section for commonly used databases.

Setup Instructions

Datasource Management Page

From the Manage Datasources page click on the Manage Drivers button.

Manage Drivers Page

Click Add Driver to open the Form for uploading a new driver.

Manage Drivers Form

Add the Class name and Driver. Click Add Driver to upload the Driver.

Manage Drivers Form

The new driver should be listed on the Manage Drivers page. You can now add a new Datasource using this driver.

Manage Drivers Page