search

lensesio / fast-data-dev

Kafka Docker for development. Kafka, Zookeeper, Schema Registry, Kafka-Connect, , 20+ connectors
https://lenses.io
Apache License 2.0
2.02k stars 331 forks source link

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

Open oguzhannkayaa opened 4 years ago

oguzhannkayaa commented 4 years ago

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:

45jjmalaluan commented 3 years ago

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.