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

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