oraclejdbcapache-kafkaapache-kafka-connectconfluent-platform

Unable to set CLASSPATH with confluent CLI : java.sql.SQLException: No suitable driver found for jdbc:oracle:thin

I want to use JDBC connector on confluent. It doesnt work when I start connect with Confluent CLI.

confluent local start connect

and it gives this error:

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

I stop connect and start manually connect-distributed or standalone it gives same error

./bin/connect-distributed etc/schema-registry/connect-avro-distributed.properties

but when I set CLASSPATH then above code is working fine and transfer data to Oracle.

export CLASSPATH=/home/my_confluent/confluent-5.4.1/share/java/kafka-connect-jdbc/ojdbc6.jar

But still I can not do same thing with connect service.

When I up my confluent connect 

confluent local start connect

it gives same error.

Solution

  • Finally I found the solution after many tries.

    I copied ojdbc6.jar file into /home/ersin/confluent-5.4.1/share/java/kafka/ folder and restart connect service and boom it works like a charm.

    for your information