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:
- Establish a connection with a data source.
- Send queries and update statements to the data source.
- Process the results.
Adding a new JDBC Driver
To setup a new driver you will need three components
*driver*.jarfile from the database provider.
- The class name for the JDBC
- A database connection URI
The above three components are documented / linked below this section for commonly used databases.
Manage Datasources page click on the
Manage Drivers button.
Add Driver to open the Form for uploading a new driver.
Add the Class name and Driver. Click
Add Driver to upload the Driver.
The new driver should be listed on the
Manage Drivers page. You can now add a new Datasource using this driver.