does Sqlanywhere17 support Apache Kafka

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

jdbc

asked 15 Apr '21, 04:01

salwa
25●5●5●7
accept rate: 0%

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 '21, 04:07) Vlad

Replies hidden

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

(15 Apr '21, 17:22) Breck Carter

flat view

One Answer:

active answers oldest answers newest answers popular answers

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 '21, 08:23

Chris Keating
6.9k●43●115
accept rate: 30%

edited 15 Apr '21, 11:18

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

jdbc ×86

question asked: 15 Apr '21, 04:01

question was seen: 541 times

last updated: 15 Apr '21, 17:22

SAP SQL Anywhere

does Sqlanywhere17 support Apache Kafka

Follow this question

Related questions