JDBC连接Mysql8.0驱动版本过低报错

旧城等待， 2022-12-22 11:28 234阅读 0赞

JDBC连接Mysql8.0.11版本出现问题,不停循环报错 错误信息如下:

## 报错信息: ##

Fri Mar 29 21:39:01 CST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    ERROR [Druid-ConnectionPool-Create-2085079540] - create connection SQLException, url: jdbc:mysql://localhost:3306/phone, errorCode 0, state 08001
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
    	at sun.reflect.GeneratedConstructorAccessor36.newInstance(Unknown Source)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
    	at com.mysql.jdbc.Util.getInstance(Util.java:387)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2332)
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
    	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
    	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
    	at sun.reflect.GeneratedConstructorAccessor27.newInstance(Unknown Source)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
    	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
    	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513)
    	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578)
    	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2451)
    Caused by: java.lang.NullPointerException
    	at com.mysql.jdbc.ConnectionImpl.getServerCharset(ConnectionImpl.java:3005)
    	at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1916)
    	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1845)
    	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1215)
    	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2255)
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
    	... 12 more

## 解决方案: ##

Mysql是8.0版本的 ,但是项目中用的jdbc驱动包5.1.31,将jdbc驱动包改为8.0.13后不再报错