Comments (9)
This article explains how to address the driver issue: https://www.confluent.io/blog/kafka-connect-deep-dive-jdbc-source-connector/#no-suitable-driver-found
Which specific Docker Compose are you using?
from demo-scene.
Hi @rmoff
I was using this docker file: https://github.com/confluentinc/demo-scene/blob/master/kafka-connect-single-message-transforms/docker-compose.yml
I will get back to you,
Thanks
from demo-scene.
My guess is the URL has changed.
╰─$ curl https://cdn.mysql.com/Downloads/Connector-J/mysql-connector-java-8.0.23.tar.gz
Not found
from demo-scene.
Yes, I found it..Its achieved at below address:
https://downloads.mysql.com/archives/get/p/3/file/mysql-connector-java-8.0.23.tar.gz
OR
we can use the current version if that works:
https://dev.mysql.com/downloads/file/?id=509727 (this one is 8.0.28)
Please suggest
from demo-scene.
If the former is a stable URL then I'd use that. Can you submit a PR to fix this please?
from demo-scene.
Thanks. I will use that URL, try out myself and then submit the PR asap.
Thanks for your support,
Best
from demo-scene.
Created the pull request.
The new URL works just fine.
from demo-scene.
Please do not merge the pull request, strange that the URL works but I am still getting the error of
ava.sql.SQLException: No suitable driver found for jdbc:mysql://mysql:3306/demo\n\tat java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)\n\tat java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)\n\tat io.confluent.connect.jdbc.dialect.GenericDatabaseDialect.getConnection(GenericDatabaseDialect.java:227)\n\tat io.confluent.connect.jdbc.util.CachedConnectionProvider.newConnection(CachedConnectionProvider.java:83)\n\tat io.confluent.connect.jdbc.util.CachedConnectionProvider.getConnection(CachedConnectionProvider.java:52)\n\t... 13 more\n"
One of the thing I came to know is on my mac
When I run the docker file:
The connector plugs are supposed to be downloaded at the
/usr/share/java,/usr/share/confluent-hub-components,/data/connect-jars
But when i go to these folders /usr/shared the above sub folders are not there
from demo-scene.
This is now fixed with 8d36761#diff-4ddeba694c7e636b8aeb3e1e83a62402b38223b80d5a070f44880d0ca05cb6dbR115-R117
When the container boots up you should see the MySQL JAR being downloaded successfully:
…
kafka-connect | Downloading component Kafka Connect Simulator 0.1.120, provided by Jeremy Custenborder from Confluent Hub and installing into /usr/share/confluent-hub-components
kafka-connect | Adding installation directory to plugin path in the following files:
kafka-connect | /etc/kafka/connect-distributed.properties
kafka-connect | /etc/kafka/connect-standalone.properties
kafka-connect | /etc/schema-registry/connect-avro-distributed.properties
kafka-connect | /etc/schema-registry/connect-avro-standalone.properties
kafka-connect |
kafka-connect | Completed
kafka-connect | % Total % Received % Xferd Average Speed Time Time Time Current
kafka-connect | Dload Upload Total Spent Left Speed
100 3941k 100 3941k 0 0 5874k 0 --:--:-- --:--:-- --:--:-- 5865k
kafka-connect | MySQL JDBC driver should now be present here:
kafka-connect | total 2828
kafka-connect | -rw-r--r-- 1 appuser appuser 267994 Dec 1 2020 CHANGES
kafka-connect | -rw-r--r-- 1 appuser appuser 186 Dec 1 2020 INFO_BIN
kafka-connect | -rw-r--r-- 1 appuser appuser 136 Dec 1 2020 INFO_SRC
kafka-connect | -rw-r--r-- 1 appuser appuser 100771 Dec 1 2020 LICENSE
kafka-connect | -rw-r--r-- 1 appuser appuser 1245 Dec 1 2020 README
kafka-connect | -rw-r--r-- 1 appuser appuser 88878 Dec 1 2020 build.xml
kafka-connect | -rw-r--r-- 1 appuser appuser 2415211 Dec 1 2020 mysql-connector-java-8.0.23.jar
kafka-connect | drwxr-xr-x 8 appuser appuser 4096 Dec 1 2020 src
kafka-connect | Launching Kafka Connect worker
…
from demo-scene.
Related Issues (20)
- Message not sent from kafka to elasticsearch when not using ksqldb HOT 1
- Updating community-components-only repo HOT 2
- Add .env to .gitignore In pipeline to cloud HOT 2
- Just a question, not an issue HOT 1
- The "Pickup Data" demo should have a link to a recording of the talk HOT 4
- How to convert a Avro record HOT 1
- Pickup data adventure: webpack-dev-server requires localhost HOT 2
- getting-started-with-ccloud-java throw an exception when run `java -cp target/getting-started-with-ccloud-1.0.jar io.confluent.cloud.demo.ProducerApp`
- Flatten nested JSON data fields and whitelist them and Flatten SMT fails on arrays HOT 2
- Not real issue, but a question HOT 5
- Cast$Value Transform not working with String -> Float64? HOT 1
- multiple chunks using aws-chunked is not supported & Part upload failed HOT 1
- Partitioning with keys (Grouping by the key) in S3 sink kafka connect HOT 1
- kafka-connect-zero-to-hero: unable to docker-compose in M1 Mac HOT 2
- build-a-streaming-pipeline's ksqldb and schema-registry meet 2 starter issue.
- pacman streaming demo: update instructions to include AWS CLI assume cmd
- No suitable Driver
- Incorrect syntax on kpi-dashboard/dashboard_table.sql
- container like schema-registry and kafka-connect has no matching manifest for linux/arm64/v8
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from demo-scene.