kafka-connector cannot connect to sqlanywhere17 with jdbc driver. i have sajdbc4.jar and libdbjdbc17.so in dirctory /usr/share/java/kafka-connect-jdbc/ { "connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector", "connection.url": "jdbc:sqlanywhere://host:port/demo?UID=rmoff?PWD=rmoffsql", "mode":"bulk", "topic.prefix":"sql-01-" }' Thanks in advance |
The problem is the connection URL is incorrectly formed. It should be of the form: jdbc:sqlanywhere:HOST=host:port;Server=<db_server_name>;DBN=demo;UID=rmoff;PWD=rmoffsql The Server parameter is optional but strongly recommended. It will be the database server engine name. |
I am lazy to install Kafka, maybe you can post an error message from Kafka's logs for us?
I think, I am not the only one in this forum, who is lazy too and will not install Kafka for you only.
Me too, I'm lazy, who's Kafka?