DEV Community

Robin Moffatt for Confluent

Posted on • Edited on

3

Kafka Connect JDBC connector: installing a JDBC driver

Ever hit that pesky "SQLException: No suitable driver found…" in Kafka Connect's JDBC connector? You're not alone 😅

💥I wrote up and recorded a quick tutorial on how to fix it, both local and Docker. Enjoy!
🎥https://rmoff.dev/fix-jdbc-driver-video
✍️https://rmoff.dev/fix-jdbc-driver

Getting this error?

Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@10.10.10.10:1954/MYSERVICE
Enter fullscreen mode Exit fullscreen mode

tl;dr:

  • Put the JDBC driver in the same folder as the Kafka Connect JDBC plugin.
  • Restart the Kafka Connect worker

Alt Text

The tutorial shows how to do it with both a 'bare metal' install of Apache Kafka or Confluent Platform, as well as on Docker.

🎥https://rmoff.dev/fix-jdbc-driver-video
✍️https://rmoff.dev/fix-jdbc-driver

Tutorial covers:

  • Determining the Kafka Connect JDBC plugin folder
  • How to find the Kafka Connect worker log
  • Viewing the data in Confluent Control Center
  • Installing JDBC driver for Kafka Connect running on Docker
  • Docker - Installing the JDBC driver at runtime vs baking an image
  • Listing installed Kafka Connect plugins
  • Using kafkacat to view the topics and data

Image of Datadog

Create and maintain end-to-end frontend tests

Learn best practices on creating frontend tests, testing on-premise apps, integrating tests into your CI/CD pipeline, and using Datadog’s testing tunnel.

Download The Guide

Top comments (0)

Postmark Image

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up