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

asked 15 Apr, 04:01

salwa's gravatar image

salwa
25447
accept rate: 0%

3

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.

(15 Apr, 04:07) Vlad
Replies hidden

Me too, I'm lazy, who's Kafka?

(15 Apr, 17:22) Breck Carter

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.

permanent link

answered 15 Apr, 08:23

Chris%20Keating's gravatar image

Chris Keating
5.7k3495
accept rate: 33%

edited 15 Apr, 11:18

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×83

question asked: 15 Apr, 04:01

question was seen: 109 times

last updated: 15 Apr, 17:22