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:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
