Hi team, while inserting data from kafka into mariadb, i get the error “java.sql.SQLException: No suitable driver found for jdbc:mysql” even when the jar files are fully loaded and visible with a curl call.
Below is my setup
{
“name”: “mysql-sync”,
“config”: {
“connector.class”: “io.confluent.connect.jdbc.JdbcSinkConnector”,
“tasks.max”: “1”,
“topics”: “r_21_0_202407,r_21_0_202408”,
“connection.url”: “jdbc:mariadb://IP:3306/db?user=db_user&password=db_pass”,
“database.driver”: “org.mariadb.jdbc.Driver”,
“insert.mode”: “upsert”,
“primary.key.mode”: “record_key”,
“primary.key.fields”: “seq_no”,
“auto.create”: “true”,
“auto.evolve”: “true”,
“delete.enabled”: “false”,
“table.name.format”: “${topic:split(‘\.’,2)[2]}”,
“key.converter”: “org.apache.kafka.connect.json.JsonConverter”,
“key.converter.schemas.enable”: “false”,
“value.converter”: “org.apache.kafka.connect.json.JsonConverter”,
“value.converter.schemas.enable”: “false”,
“errors.tolerance”: “all”,
“errors.log.enable”: “true”,
“errors.log.include.messages”: “true”,
“errors.deadletterqueue.topic.name”: “”
}
}
curl http://localhost:8083/connector-plugins | jq
** % Total % Received % Xferd Average Speed Time Time Time Current**
** Dload Upload Total Spent Left Speed**
100 2065 100 2065 0 0 129k 0 --:–:-- --:–:-- --:–:-- 134k
[
** {**
** “class”: “com.clickhouse.kafka.connect.ClickHouseSinkConnector”,**
** “type”: “sink”,**
** “version”: “clickhouse-jdbc 0.6.0 (revision: cb8e198)”**
** },**
** {**
** “class”: “com.clickhouse.kafka.connect.ClickHouseSinkConnector”,**
** “type”: “sink”,**
** “version”: “v1.3.0”**
** },**
** {**
** “class”: “io.confluent.connect.jdbc.JdbcSinkConnector”,**
** “type”: “sink”,**
** “version”: “10.8.4”**
** },**
Urgently need a solution, anyone?