com.mysql.cj.jdbc.Driver驱动类连不上doris #1427

Activity

1. imay commented on Jul 4, 2019

   

   imay

   on Jul 4, 2019

   Contributor

   More actions

   Can you upload error SQL?
2. ltylty commented on Jul 4, 2019

   

   ltylty

   on Jul 4, 2019

   Author

   More actions

   @imay
   Caused by: java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required
   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
   at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:79)
   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
   at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455)
   at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
   at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
   at java.sql.DriverManager.getConnection(DriverManager.java:664)
   at java.sql.DriverManager.getConnection(DriverManager.java:247)
   at cn.hutool.db.ds.simple.SimpleDataSource.getConnection(SimpleDataSource.java:185)
   at cn.hutool.db.dialect.DriverUtil.identifyDriver(DriverUtil.java:50)
   ... 105 common frames omitted
   Caused by: com.mysql.cj.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
   at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:205)
   at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1449)
   at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
   at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:955)
   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825)
   ... 112 common frames omitted
3. imay commented on Jul 4, 2019

   

   imay

   on Jul 4, 2019

   Contributor

   More actions

   This problem is probably fixed by #1349 , you can try our master branch to see if it is fixed
4. morningman

   added

   help wanted

   on Jul 5, 2019
5. ltylty commented on Jul 5, 2019

   

   ltylty

   on Jul 5, 2019

   Author

   More actions

   @imay com.mysql.cj.jdbc.Driver work fine on master branch, thank you.
6. ltylty commented on Jul 5, 2019

   

   ltylty

   on Jul 5, 2019

   Last edited by ltylty

   Author

   More actions

   @imay
   有个bug，jdbc的url配置成
   jdbc:mysql://{}:{}/{}?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
   会报错
   Caused by: java.sql.SQLSyntaxErrorException: Unknown character set: 'utf8mb4'
   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
   at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
   at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455)
   at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
   at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
   at java.sql.DriverManager.getConnection(DriverManager.java:664)
   at java.sql.DriverManager.getConnection(DriverManager.java:247)
   at cn.hutool.db.ds.simple.SimpleDataSource.getConnection(SimpleDataSource.java:185)
   at cn.hutool.db.dialect.DriverUtil.identifyDriver(DriverUtil.java:50)
   ... 109 common frames omitted

   配置成jdbc:mysql://{}:{}/{}?serverTimezone=GMT%2B8 可以正常连接。
7. hf200012

   closed this as completedon Apr 25, 2022
8. luwei16

   added a commit that references this issue on Apr 7, 2023

   [feature](selectdb-cloud) Add smoke test case for oss internal endpoi…

   ...

   e6aac18
9. swjtu-zhanglei

   added a commit that references this issue on Jul 25, 2023

   [feature](selectdb-cloud) Add smoke test case for oss internal endpoi…

   ...

   2275273