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.
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