mybatis报错 ----》Unknown character set index for field '255' received from server.

最新推荐文章于 2022-05-19 16:48:32 发布

andy天空

最新推荐文章于 2022-05-19 16:48:32 发布

阅读量1.2k

点赞数

分类专栏：报错

本文链接：https://blog.csdn.net/weixin_41716115/article/details/99699357

版权

报错专栏收录该内容

5 篇文章 0 订阅

订阅专栏

2019-08-17 23:15:32.397 DEBUG 3436 --- [p2009072026-100] o.s.b.w.f.OrderedRequestContextFilter    : Bound request context to thread: Request(GET //localhost:8001/dept/get/1)@25630d02
2019-08-17 23:15:34.565 ERROR 3436 --- [p2009072026-100] com.alibaba.druid.pool.DruidDataSource   : testWhileIdle is true, validationQuery not set
2019-08-17 23:15:34.581 INFO 3436 --- [p2009072026-100] com.alibaba.druid.pool.DruidDataSource   : {dataSource-2} inited
2019-08-17 23:15:34.601 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource   : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

java.sql.SQLException: Unknown character set index for field '255' received from server.
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.getCharsetNameForIndex(Connection.java:3448) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Field.<init>(Field.java:191) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.MysqlIO.unpackField(MysqlIO.java:659) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:382) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1970) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1387) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1727) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.loadServerVariables(Connection.java:4317) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3936) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2683) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.<init>(Connection.java:1531) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) ~[mysql-connector-java-5.0.4.jar:na]
   at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1464) ~[druid-1.0.31.jar:1.0.31]
   at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1529) ~[druid-1.0.31.jar:1.0.31]
   at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2109) ~[druid-1.0.31.jar:1.0.31]

2019-08-17 23:15:34.606 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

java.sql.SQLException: Unknown character set index for field '255' received from server.
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.getCharsetNameForIndex(Connection.java:3448) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Field.<init>(Field.java:191) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.MysqlIO.unpackField(MysqlIO.java:659) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:382) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1970) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1387) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1727) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.loadServerVariables(Connection.java:4317) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3936) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2683) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.Connection.<init>(Connection.java:1531) ~[mysql-connector-java-5.0.4.jar:na]
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) ~[mysql-connector-java-5.0.4.jar:na]
   at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1464) ~[druid-1.0.31.jar:1.0.31]
   at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1529) ~[druid-1.0.31.jar:1.0.31]
   at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2109) ~[druid-1.0.31.jar:1.0.31]

2019-08-17 23:15:34.612 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.619 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.625 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.637 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.643 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.650 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.656 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.663 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.669 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.674 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.680 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.685 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.690 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.697 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.703 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.710 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.715 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.720 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.726 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.731 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.737 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.744 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.750 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.756 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.762 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.768 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.776 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.781 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:15:34.789 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:16:04.797 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:16:34.804 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:17:04.813 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

2019-08-17 23:17:34.819 ERROR 3436 --- [reate-732231646] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://localhost:3306/clouddb01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state S1000

#######################################################################################

连接数据库时，出现Unknown character set index for field '255' received from server.

原因是MySQL版本高，mysql的jar版本低造成mysql与jar的编码错乱引起的，我的MYSQL是8.0.16版本

MYSQL 5.5 之前， UTF8 编码只支持1-3个字节;从MYSQL5.5开始，可支持4个字节UTF编码utf8mb4;

如图：

参考文档

https://blog.csdn.net/oldinaction/article/details/50489056

andy天空

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
mybatis报错 ----》Unknown character set index for field '255' received from server.

2019-08-17 23:15:32.397 DEBUG 3436 --- [p2009072026-100] o.s.b.w.f.OrderedRequestContextFilter : Bound request context to thread: Request(GET //localhost:8001/dept/get/1)@25630d022019-08-17 23:15:...
复制链接

扫一扫