loading...

Kafka Connect JDBC connector: installing a JDBC driver

rmoff profile image Robin Moffatt ・1 min read

Kafka Connect examples (6 Part Series)

1) Streaming data from Kafka to S3 - video walkthrough 2) Streaming data from Kafka to a Database - video walkthrough 3 ... 4 3) Kafka Connect JDBC Sink: tips & tricks - video walkthrough 4) Kafka Connect JDBC connector: installing a JDBC driver 5) Streaming data from Kafka to Elasticsearch - video walkthrough 6) Loading CSV data into Kafka - video walkthrough

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

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

Kafka Connect examples (6 Part Series)

1) Streaming data from Kafka to S3 - video walkthrough 2) Streaming data from Kafka to a Database - video walkthrough 3 ... 4 3) Kafka Connect JDBC Sink: tips & tricks - video walkthrough 4) Kafka Connect JDBC connector: installing a JDBC driver 5) Streaming data from Kafka to Elasticsearch - video walkthrough 6) Loading CSV data into Kafka - video walkthrough

Posted on by:

rmoff profile

Robin Moffatt

@rmoff

Robin Moffatt is a Developer Advocate at Confluent, and regular conference speaker. He also likes writing about himself in the third person, eating good breakfasts, and drinking good beer.

Discussion

markdown guide