Hi Team,
Getting subject error message while trying to create Kafka-JDBC connector.
Able to execute initial steps successfully from Kafka Connect Tutorial —
Confluent Platform
However it fails on executing below command.
curl -X POST -H "Content-Type: application/json" --data '{ "name":
"quickstart-jdbc-source", "config": { "connector.class":
"io.confluent.connect.jdbc.JdbcSourceConnector", "tasks.max": 1,
"connection.url":
"jdbc:mysql://127.0.0.1:3306/connect_test?user=confluent&password=confluent",
"mode": "incrementing", "incrementing.column.name": "id",
"timestamp.column.name": "modified", "topic.prefix": "quickstart-jdbc-",
"poll.interval.ms": 1000 } }' http://192.168.99.100:28082/connectors
Error message
{"error_code":400,"message":"Connector configuration is invalid and contains
the following 2 error(s):\nInvalid value java.sql.SQLException: No suitable
driver found for
jdbc:mysql://127.0.0.1:3306/connect_test?user=confluent&password=confluent for
configuration Couldn't open connection to
jdbc:mysql://127.0.0.1:3306/connect_test?user=confluent&password=confluent\nInvalid
value java.sql.SQLException: No suitable driver found for
jdbc:mysql://127.0.0.1:3306/connect_test?user=confluent&password=confluent for
configuration Couldn't open connection to
jdbc:mysql://127.0.0.1:3306/connect_test?user=confluent&password=confluent\nYou
can also find the above list of errors at the endpoint
`/{connectorType}/config/validate`"}root@default:/#
Please advise over come the issue.
Thanks and regards
Jagannath S Bilgi
