springboot整合mycat连接数据库的注意事项和异常处理

最新推荐文章于 2024-08-30 10:09:47 发布

原创

最新推荐文章于 2024-08-30 10:09:47 发布 · 置顶 · 1.1k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#mycat #springboot

spring:
  # 数据源相关参数
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.jdbc.Driver
    # 格式 jdbc:mysql://ip:port/表名
    # ip: mycat的ip
    # port: mycat的端口号
    # 表名: mycat的schema.xml文件中schema标签的name属性值
    url: jdbc:mysql://192.168.11.133:8066/TESTDB?useUnicode=true&characterEncoding=UTF-8
    username: root
    password: 123456

异常1:The last packet sent successfully to the server was 0 milliseconds ago.

The last packet successfully received from the server was 1,599,393,270,299 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_131]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_131]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_131]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_131]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) ~[mysql-connector-java-5.1.8.jar:na]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_131]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_131]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_131]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_131]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) ~[mysql-connector-java-5.1.8.jar:na]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1558) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1623) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2468) ~[druid-1.1.10.jar:1.1.10]
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

处理办法: 检查mycat服务器是否开启成功

异常2:java.sql.SQLException: Unknown database ‘TEST’

2020-09-06 19:57:46.006 ERROR 10316 --- [reate-309349909] com.alibaba.druid.pool.DruidDataSource   : create connection SQLException, url: jdbc:mysql://192.168.11.133:8066/TEST?useUnicode=true&characterEncoding=UTF-8, errorCode 1049, state HY000

java.sql.SQLException: Unknown database 'TEST'
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:917) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3974) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1282) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) ~[mysql-connector-java-5.1.8.jar:na]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_131]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_131]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_131]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_131]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352) ~[mysql-connector-java-5.1.8.jar:na]
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) ~[mysql-connector-java-5.1.8.jar:na]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1558) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1623) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2468) ~[druid-1.1.10.jar:1.1.10]

处理办法: 检查url是否书写正确
格式 jdbc:mysql://ip:port/表名
ip: mycat的ip
port: mycat的端口号
表名: mycat的schema.xml文件中schema标签的name属性值

异常3:java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required

2020-09-06 20:05:14.684 ERROR 15004 --- [reate-423095039] com.alibaba.druid.pool.DruidDataSource   :</

最低0.47元/天解锁文章

200万优质内容无限畅学