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

API Trace View

How I Cut 22.3 Seconds Off an API Call with Sentry

Struggling with slow API calls? Dan Mindru walks through how he used Sentry's new Trace View feature to shave off 22.3 seconds from an API call.

Get a practical walkthrough of how to identify bottlenecks, split tasks into multiple parallel tasks, identify slow AI model calls, and more.

Read more →

Top comments (0)

The Most Contextual AI Development Assistant

Pieces.app image

Our centralized storage agent works on-device, unifying various developer tools to proactively capture and enrich useful materials, streamline collaboration, and solve complex problems through a contextual understanding of your unique workflow.

👥 Ideal for solo developers, teams, and cross-company projects

Learn more