Reading data from aws ec2 instance using confluent platform on local machine.

we are using confluent platform on local machine and trying to read the data from aws ec2 instance we provided credentials like hostname, DB name, pwd etc. and using JDBC source connector. Connector config is

name=test
connector.class=io.confluent.connect.jdbc.JdbcSourceConnector
connection.url=jdbc:mysql://ff.sdh,js:abcd/DB?user=prince&password=prince123
table.whitelist=ppp
mode=incrementing

After running connect standalone got error like:

Invalid value java.sql.SQLNonTransientConnectionException: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near.

Tagged:

Comments

  • The my sql connection should be like below
    jdbc:mysql://localhost:3306/kafka_demo?user=root&password=password
    kafka_dem is database.

    Please check your connection once and try

Sign In or Register to comment.