"No suitable driver found for configuration". for MSSQL connection

[oguzhannkayaa]

I am trying to run in Centos 7 environment. connect-distributed.properties:

plugin.path=/opt/connectors/kafka-connect-jdbc/

name=source-sqlserver-user connector.class=io.confluent.connect.jdbc.JdbcSourceConnector tasks.max=1 topic.prefix=my-timestamp connection.url=jdbc:sqlserver://127.0.0.1:1433;database=databasenam e;username=username;password=password

version: '2' services: kafka-cluster: image: landoop/fast-data-dev:cp3.3.0 environment: ADV_HOST: 127.0.0.1
RUNTESTS: 0
volumes: - /mssql-jdbc-7.4.1.jre12.jar:/opt/confluent-3.3.0/share/java/kafka-connect-jdbc/mssql-jdbc-7.4.1.jre12.jar
ports: - 2181:2181 # Zookeeper - 3030:3030 # Landoop UI - 8081-8083:8081-8083 # REST Proxy, Schema Registry, Kafka Connect ports - 9581-9585:9581-9585 # JMX Ports - 9092:9092 # Kafka Broker

[45jjmalaluan]

Hi,

I'm getting the same exception. Any resolution at this time?

Caused by: java.sql.SQLException: No suitable driver found for jdbc:db2://127.0.01:50000/testdb at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:208) at io.confluent.connect.jdbc.dialect.GenericDatabaseDialect.getConnection(GenericDatabaseDialect.java:227) at io.confluent.connect.jdbc.source.JdbcSourceConnectorConfig$TableRecommender.validValues(JdbcSourceConnectorConfig.java:653)

Thanks.