英文:
clickhouse using JDBC engine error "No suitable driver found"
问题
以下是翻译好的部分：
我已经使用JDBC引擎创建了我的ClickHouse表。但是当我运行一个查询时，会调用以下错误：
DB::Exception: 收到来自远程服务器的错误：
/identifier_quote?connection_string=jdbc%3Amysql%3A%2F%2F10.117.130.95%3A3306%2F%3Fuser%3Droot%26password%3D**。
HTTP状态代码：500 服务器错误，正文：No suitable driver found for jdbc:mysql://10.117.130.95:3306/?user=root&password=** (version 20.5.2.7 (official build))
这是我的引擎设置：
engine = JDBC('jdbc:mysql://10.117.130.95:3306/?user=root&password=**','pma','t_dept');
英文:
I have created my clickhouse table using JDBC engine. But when id run a query, it calls
DB::Exception: Received error from remote server:
/identifier_quote?connection_string=jdbc%3Amysql%3A%2F%2F10.117.130.95%3A3306%2F%3Fuser%3Droot%26password%3D**.
HTTP status code: 500 Server Error, body: No suitable driver found for jdbc:mysql://10.117.130.95:3306/?user=root&password=** (version 20.5.2.7 (official build))
this is my engine set:
engine = JDBC('jdbc:mysql://10.117.130.95:3306/?user=root&password=**','pma','t_dept');
答案1
得分: 1
在您的类路径中需要有一个mysql jdbc驱动程序jar文件。
Mysql将其称为“Mysql Connector”，谷歌弹出一个8.0.21版本，在此链接：https://dev.mysql.com/downloads/connector/j/，然而和任何链接/带版本的文件一样，您可能需要进行自己的搜索/调整，以适应您正在使用的mysql数据库。（一般情况下，但并不总是在驱动程序方面稍微落后于数据库版本是可以的）。
英文:
There needs to be a mysql jdbc driver jar file present in your classpath.
MySql refers to it as a 'Mysql Connector' and google pops up a version 8.0.21 here : https://dev.mysql.com/downloads/connector/j/ however as with any link / versioned file, you may need to perform your own search / adjust for the mysql database that you're using. (Generally, but not always being slightly behind on the driver side vs database version is ok).
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论