You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/09/05 03:54:14 UTC
[GitHub] [incubator-doris] zhaojintaozhao opened a new issue #4537: Doris does not support Mysql JDBC(mysql-connector-jdbc) 8.0.16 or above version.
zhaojintaozhao opened a new issue #4537:
URL: https://github.com/apache/incubator-doris/issues/4537
**Describe the bug**
We known Doris uses Mysql protocol to communicate query client. Users can connect to Doris cluster through MySQL client or Mysql JDBC. Doris work properly if I select MySQL JDBC version 8.0.15.
But if I select Mysql JDBC version 8.0.16 or later, MySQL JDBC will catch a exception and can’t communicate to Doris FE.
**To Reproduce**
Steps to reproduce the behavior:
1. Use MySQL JDBC(mysql-connector-java) version 8.0.16 or later to communicate Doris to query.
2. MySQL JDBC catch an exception: “Failed to obtain JDBC Connection; nested exception is java.sql.SQLException:errCode = 2, detailMessage = Unknown system variable ‘performance_schema’] ”
3. MySQL JDBC 8.0.16 can’t connect to Doris and can’t work.
**Expected behavior**
Mysql JDBC 8.0.16 can connect to Doris and work properly just like Mysql JDBC 8.0.15
**Screenshots**
This is the stack of SQLException if use Mysql JDBC 8.0.16
java.sql.SQLException:errCode = 2, detailMessage = Unknown system variable ‘performance_schema’
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)~[mysql-connector-java-8.0.16.jar:8.0.16]
……..
**Additional context**
I have fixed this bug, Doris can support Mysql JDBC version 8.0.16 or later. I want to give the solution back to the Apache-Doris-Community.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman closed issue #4537: [BUG] Doris does not support Mysql JDBC(mysql-connector-jdbc) 8.0.16 or above version.
Posted by GitBox <gi...@apache.org>.
morningman closed issue #4537:
URL: https://github.com/apache/incubator-doris/issues/4537
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org