Git Product home page Git Product logo

Comments (9)

rmoff avatar rmoff commented on June 1, 2024

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.

Muks-CFLT avatar Muks-CFLT commented on June 1, 2024

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.

rmoff avatar rmoff commented on June 1, 2024

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.

Muks-CFLT avatar Muks-CFLT commented on June 1, 2024

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.

rmoff avatar rmoff commented on June 1, 2024

If the former is a stable URL then I'd use that. Can you submit a PR to fix this please?

from demo-scene.

Muks-CFLT avatar Muks-CFLT commented on June 1, 2024

Thanks. I will use that URL, try out myself and then submit the PR asap.

Thanks for your support,

Best

from demo-scene.

Muks-CFLT avatar Muks-CFLT commented on June 1, 2024

Created the pull request.

The new URL works just fine.

from demo-scene.

Muks-CFLT avatar Muks-CFLT commented on June 1, 2024

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.

rmoff avatar rmoff commented on June 1, 2024

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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.