confluentinc / kafka-connect-jdbc

Kafka Connect connector for JDBC-compatible databases
Other
1.01k stars 954 forks source link

JDBC driver error for Oracle Database #708

Open shirish86 opened 4 years ago

shirish86 commented 4 years ago

Hi, I am facing issue " No suitable driver found for jdbc:oracle:thin:@host:1521/xe" while running connect-standalone for source as well as sink options.

below files are present in plugin path

slf4j-api-1.7.26.jar zookeeper-3.4.14.jar zkclient-0.10.jar spotbugs-annotations-3.1.8.jar netty-3.10.6.Final.jar jsr305-3.0.2.jar jline-0.9.94.jar common-utils-5.3.0.jar audience-annotations-0.5.0.jar sqlite-jdbc-3.25.2.jar postgresql-9.4-1206-jdbc41.jar jtds-1.3.1.jar kafka-connect-jdbc-5.3.0.jar ojdbc8-12.2.0.1.jar

Also same path has been mentioned in the variable plugin.path of connect-standalone.properties

Please help to get out of this error as I am facing it with all the ways.

bmoe24x commented 4 years ago

Are you confident that your ojdbc8 jar is in the same directory as the sink jar? For further reading this should be of use