JDBC Drivers

Some plugins require a JDBC driver to be added to the namespace. For example, before you can run a pipeline with a MySQL batch source plugin, you need to add the supported MySQL driver to the namespace. You can add JDBC drivers to a namespace from the CDAP Hub, the Namespace Admin page, or the Add entity page. You can also delete unneeded JDBC drivers from the Namespace Admin page.

Adding a JDBC Driver from the Hub

To add a JDBC driver from the Hub, follow these steps:

  1. From the CDAP Hub, search for the driver you want to add to the namespace.

  2. Click the tile for the driver you want to add.

  3. To get information about where to download the JAR file, click 1. Download.

  4. To upload the JAR file, click 2. Deploy.

  5. Upload the JAR file and click Next.

  6. Verify the Class Name and Version of the driver.

  7. (Optional) Edit the Name of the driver.

  8. Click Finish.
    The driver is added to the namespace.

Adding a JDBC Driver from the Namespace Admin Page

To add a JDBC driver from the Namespace Admin page, follow these steps:

  1. Download the driver you want to use. For example, to download the JDBC driver for MySQL, go to dev.mysql.com and download the JAR file.

  2. In CDAP, click the hamburger menu and then click Namespace Admin.
    The Namespace Admin page appears.

  3. From the Namespace Admin page, click Drivers.

  4. Upload the JAR file and click Next.
    The driver version is added to the Version field.

  5. Enter the Name and Class Name of the driver.

  6. Click Finish.
    The driver is added to the namespace:

Adding a JDBC Driver from the Add Entity Page

To add a JDBC driver from the Add Entity page, follow these steps:

  1. Download the driver you want to use. For example, to download the JDBC driver for MySQL, go to dev.mysql.com and download the JAR file.

  2. In the Pipeline Studio, click the green plus sign.

    The Add entity page appears.

  3. From the Add entity page, click Upload in the Drivers box.

  4. Upload the JAR file and click Next.
    The driver version is added to the Version field.

  5. Enter the Name and Class Name of the driver.

  6. Click Finish.
    The driver is added to the namespace:

Deleting a JDBC Driver

To delete a JDBC driver from a namespace, follow these steps:

  1. In CDAP, click the hamburger menu and then click Namespace Admin.
    The Namespace Admin page appears.

  2. From the Namespace Admin page, click Drivers.

  3. Locate the driver you want to delete.

  4. Click the three buttons on the right and click Delete.

    The driver is deleted from the namespace.

Viewing Error Messages

If you receive an error while adding the JDBC driver, you can get additional details by clicking the arrows to the right of the message: