Creating a JDBC MySQL Catalog via SQL Client, usin...
# troubleshootings
Sumit Singh
05/10/2023, 7:51 AMCreating a JDBC MySQL Catalog via SQL Client, using Flink 1.17.0 and getting below error. Any idea what might be wrong ?
[ERROR] Could not execute SQL statement. Reason:java.lang.UnsupportedOperationException: Catalog for 'org.apache.flink.connector.jdbc.dialect.MySQLDialect@5b4e61ef' is not supported yet.Sumit Singh
05/10/2023, 7:54 AMrunning below statement
Copy code
CREATE CATALOG new_catalog WITH(
'type' = 'jdbc',
'username' = 'root',
'password' = '123456',
'default-database' = 'mydb',
'base-url'='jdbc:<mysql://localhost:3306>'
);s
Samrat Deb
05/10/2023, 12:24 PMcan you check if FLINK_HOME contains
https://mvnrepository.com/artifact/org.apache.flink/flink-jdbc
or while starting
./bin/sql-client.sh-jgratitude thank you 1
m
Martijn Visser
05/10/2023, 2:35 PMCan you try with https://mvnrepository.com/artifact/org.apache.flink/flink-connector-jdbc/3.1.0-1.17 ?
gratitude thank you 1
Martijn Visser
05/10/2023, 2:37 PMI see that https://nightlies.apache.org/flink/flink-docs-release-1.17/docs/connectors/table/jdbc/ still shows 3.0.0-1.17 so I'll fix that too