org.apache.kafka.connect.runtime.rest.errors.BadRequestException

[makgroup]

Hi,

I am using the JDBC Connector to connect Oracle to Kafka using standalone connector. I have placed the ojdbc14.jar in /etc/kafka-connect-jdbc. I am unable to connect with following error below. Please help me

name=test-oracle-jdbc-autoincrement connector.class=io.confluent.connect.jdbc.JdbcSourceConnector tasks.max=1 connection.password = connection.url = jdbc:oracle:thin:@XXXXXXXX.chec.local:1521:XXXX connection.user = table.whitelist=ONLINE_TRANSACTION

mode=timestamp+incrementing

mode=incrementing incrementing.column.name=ID

timestamp.column.name=MODIFIED

topic.prefix=test-oracle-jdbc-

[2018-01-03 12:48:25,660] ERROR Failed to create job for ./etc/kafka-connect-jdbc/source-quickstart-oracle.properties (org.apache.kafka.connect.cli.ConnectStandalone:97) [2018-01-03 12:48:25,661] ERROR Stopping after connector error (org.apache.kafka.connect.cli.ConnectStandalone:108) java.util.concurrent.ExecutionException: org.apache.kafka.connect.runtime.rest.errors.BadRequestException: Connector configuration is invalid and contains the following 2 error(s): Invalid value java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@DevOracle.chec.local:1521:XXXXXX for configuration Couldn't open connection to jdbc:oracle:thin:@DevOracle.chec.local:1521:XXXXX Invalid value java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@DevOracle.chec.local:1521:XXXXX for configuration Couldn't open connection to jdbc:oracle:thin:@DevOracle.3.chec.local:1521:XXXXX You can also find the above list of errors at the endpoint /{connectorType}/config/validate at org.apache.kafka.connect.util.ConvertingFutureCallback.result(ConvertingFutureCallback.java:79) at org.apache.kafka.connect.util.ConvertingFutureCallback.get(ConvertingFutureCallback.java:66) at org.apache.kafka.connect.cli.ConnectStandalone.main(ConnectStandalone.java:105) Caused by: org.apache.kafka.connect.runtime.rest.errors.BadRequestException: Connector configuration is invalid and contains the following 2 error(s): Invalid value java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@DevOracle.chec.local:1521:XXXXXX for configuration Couldn't open connection to jdbc:oracle:thin:@DevOracle.chec.local:1521:XXXXX Invalid value java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@DevOracle.chec.local:1521:XXXXX for configuration Couldn't open connection to jdbc:oracle:thin:@DevOracle.chec.local:1521:XXXXXXX You can also find the above list of errors at the endpoint /{connectorType}/config/validate at org.apache.kafka.connect.runtime.AbstractHerder.maybeAddConfigErrors(AbstractHerder.java:386) at org.apache.kafka.connect.runtime.standalone.StandaloneHerder.putConnectorConfig(StandaloneHerder.java:163) at org.apache.kafka.connect.cli.ConnectStandalone.main(ConnectStandalone.java:102)

[wicknicks]

Typically if plugin.path is /usr/share/java/plugins, then the layout of the plugins directory looks like this:

/usr/share/java/plugins
    |_ kafka-jdbc-connector
        |_ kafka-jdbc-connector-x.y.z-jar
            jline-x.y.z.jar
            oracle_driver
            |_ ojdbc14.jar

where oracle_driver is a soft link to the /etc/oracle-driver directory (and this driver is the only content of this directory).

$ ls /etc/oracle-driver
ojdbc14.jar

[makgroup]

Thanks for quick response Arjun. i have created soft link. but still having same issue while bringing ./bin/connect-standalone ./etc/schema-registry/connect-avro-standalone.properties ./etc/kafka-connect-jdbc/source-quickstart-oracle.properties

[wicknicks]

Could you please tell me the value of plugin.path in your configuration, and list the contents of that directory here?

[makgroup]

here is details Arjun plugin.path=/home/nmakineni/poc/confluent-4.0.0/share/java

$ pwd /home/nmakineni/poc/confluent-4.0.0/share/java

$ ls camus confluent-common kafka kafka-connect-elasticsearch kafka-connect-hdfs kafka-connect-jdbc kafka-connect-s3 kafka-connect-storage-common kafka-rest kafka-serde-tools rest-utils schema-registry

[makgroup]

Can you any one help me here to resolve this oracle DB connectivity please. ?

[makgroup]

Thanks Team, after I have used ojdbc8.jar, issue resolved, able to connect DB

[ntmyahk]

Thanks @wicknicks your introduced

[swathi14-5]

Hi, I have used kafka on windows, configured the mongo sink connector and standalone bare properties but still facing the issue of connectivity.

Unable to connect to the server. You can also find the above list of errors at the endpoint /connector-plugins/{connectorType}/config/validate at org.apache.kafka.connect.util.ConvertingFutureCallback.result(ConvertingFutureCallback.java:115) at org.apache.kafka.connect.util.ConvertingFutureCallback.get(ConvertingFutureCallback.java:99) at org.apache.kafka.connect.cli.ConnectStandalone.main(ConnectStandalone.java:114) Caused by: org.apache.kafka.connect.runtime.rest.errors.BadRequestException: Connector configuration is invalid and contains the following 1 error(s): Unable to connect to the server.