java.sql.SQLException: Unknown initial character set index ‘255‘ received from server. Initial clien

最新推荐文章于 2024-03-02 20:45:54 发布
最新推荐文章于 2024-03-02 20:45:54 发布
阅读量661 收藏 3
点赞数 1
文章标签： java intellij-idea mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_71467744/article/details/127357246
版权 
"C:\Program Files\Java\jdk1.8.0_201\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:E:\IDE2019\IntelliJ IDEA 2019.3.3\lib\idea_rt.jar=50762:E:\IDE2019\IntelliJ IDEA 2019.3.3\bin" -Dfile.encoding=UTF-8 -classpath "E:\IDE2019\IntelliJ IDEA 2019.3.3\lib\idea_rt.jar;E:\IDE2019\IntelliJ IDEA 2019.3.3\plugins\junit\lib\junit5-rt.jar;E:\IDE2019\IntelliJ IDEA 2019.3.3\plugins\junit\lib\junit-rt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\rt.jar;E:\JavaStudy\maven_java\target\test-classes;E:\JavaStudy\maven_java\target\classes;E:\maven\maven_repository\mysql\mysql-connector-java\5.1.6\mysql-connector-java-5.1.6.jar;E:\maven\maven_repository\junit\junit\4.12\junit-4.12.jar;E:\maven\maven_repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 test.ItemsTest,findAll
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
	at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1672)
	at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3425)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2045)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	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.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at mysql.dao.impl.ItemsDaoImpl.findAll(ItemsDaoImpl.java:21)
	at test.ItemsTest.findAll(ItemsTest.java:15)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:230)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:58)

java.lang.AssertionError
	at mysql.dao.impl.ItemsDaoImpl.findAll(ItemsDaoImpl.java:40)
	at test.ItemsTest.findAll(ItemsTest.java:15)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:230)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:58)


进程已结束，退出代码 -1

报错原因是：服务器收到的字符集与客户端字符集不一致所导致；

解决方法：在获取connection对象时强制客户端字符集

connection = DriverManager.getConnection("jdbc:mysql:///day23?characterEncoding=utf8","root","123456");

正常运行结果

 

m0_71467744
关注
  • 1
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK
09-29
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK ……
java.sql.SQLException: 结果集已耗尽
08-02
NULL 博文链接：https://listen-raining.iteye.com/blog/1962065
Unknown initial character set index ‘255‘ received from server. Initial client character 解决方法
最新发布
weixin_44417289的博客
03-02 384
Unknown initial character set index '255' received from server. Initial client character 解决方法。 整了一天，终于能弄了。原因就是大多数博主所说的字符集不匹配，mysql 和jdbc不匹配。解决方法就是删掉WEBINF下面的connector，换成匹配自己mysql版本的JDBC
java.sql.SQLException: 内部错误: Unable to construct a Datum from the specified input
01-21
Q: I am working with Oracle database 8.1.7 and I have written a JAVA code to update the table which contains one BLOB field . I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
java.sql.SQLException: null,  message from server: “Host ‘%’ is not allowed to connect to
12-14
在阿里云 SUSE linux配置完mysql后，服务器端本身是可以访问数据库的如图： 但是在客户端不可以，服务启动时报错： java.sql.SQLException: null,  message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错： 解决方法： 1，登陆服务器 mysql> use mysql; //用mysql database 2，查询user表如下： 3，mysql> update user set host=’%’ where u
Unknown initial character set index '45' received from server
e891377的专栏
10-08 1506
出现这个数据库连接异常，可能是你们数据库太新，所以更新一下JDBC连接驱动，原来的是5.0.4 ，现在换成5.1.47.连接成功。 Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'chara ...
连接Mysql数据库的报错: java.sql.SQLException: Unknown initial character set index ‘255’ received from server
weixin_61635597的博客
10-19 3012
连接Mysql数据库的报错: java.sql.SQLException: Unknown initial character set index ‘255’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.原因及其解决方案
java.sql.SQLException: Unknown initial character set index '255' received from server. .....
热门推荐
flashtown的博客
08-18 1万+
开始出现错误（1） java.sql.SQLException:Unknowninitialcharactersetindex'255'receivedfromserver.Initialclientcharactersetcanbeforcedviathe'characterEncoding'property.错误提示 根据提示在连接数据库时增加编码 ...
java.sql.SQLException: Unknown initial character set index ‘255‘ received from server.
Bug君的博客
07-29 4679
解释：未知字符 原因：MySQL驱动和数据库字符集设置不搭配，默认字符集已从latin1变成utf8mb4，因而系统变量受到影响 解决： 方法1： 在数据库后面说明字符集 jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=utf8 方法2： 升 ...
Unknown initial character set index '45' received from server. Initial client ch
u013562120的博客
08-28 1074
Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'characterEncoding' property. 解决方案：最初遇到这个问题，到网上查了一下，很多人都说是编码问题，并且好像符合错误的描述，但是经过我的不断...
java.sql.SQLException: Unknown initial character set index '45' received from server.
keyboard专栏
07-09 2373
启动tomcat，链接mysql出现如下的错误，查询日志因为mysql大小写问题，程序里组装的mysql都是大写的sql，执行到mysql，mysql找不到对应的大写的mysql的表。 java.sql.SQLException: Unknown initial character set index '45' received from server. Initial client charac...
java.sql.SQLException: Unknown initial character set index '255' received from server.
weixin_43256484的博客
04-22 1539
这是由于mysql-connector-java 的版本问题造成的 问题发生在mysql 8.0的更改中:默认字符集已从latin 1更改为utf8mb4 这些系统变量受到影响： character_set_server and character_set_database系统变量的默认值从latin1 to utf8mb4. the collation_server and collation_...
解决问题：Cause: java.sql.SQLException: Unknown initial character set index ‘255‘ received from server.
qq_41626421的博客
07-11 474
/改成这句，就可以了。解决：//jdbc.url = "jdbc:mysql://localhost:3306/spring_db" 如果使用这句就会报错。
Unknown initial character set index ‘45‘ received from server.java.sql.SQLException: Unknown initial
此时彼刻的蜗牛
10-22 553
Unknown initial character set index ‘45’ received from server.java.sql.SQLException: Unknown initial character set index ‘45’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property. 解决方案： 1.MySQL版本低，需要升级 如果安装的
java.sql.SQLException Unknown initial character set index 45 received from server. Initial client
EraWalker的博客
06-04 711
java.sql.SQLException: Unknown initial character set index ‘45’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property. 问题出现原因大多数使用了MySQL5.5的其他一些版本，java项目的部分jar包连接就会出现问题。比如今天看到出问题的就是 MySQL5.5 MariaDB 解决办法： 官方下
java.sql.SQLException: Unknown initial character set index ‘255‘ received from server.（获取连接对象时）
weixin_49675807的博客
08-06 482
原因： 1.MySQL v.8.0默认字符集已从 latin1 更改为 utf8mb4导致一些系统变量改变 2.mysql-connector-java 新版本也会将mysql默认字符集已从 latin1 更改为 utf8mb4导致一些系统变量改变. 解决方法：url=jdbc:mysql://localhost:3306/数据库名?characterEncoding=latin1&useConfigs=maxPerformance 有误请指正，谢谢。 ...
mysql问题，Unknown initial character set index '45' received from server
YueQingFeng445的博客
06-07 1832
mySQL安装后出现问题，eclipse编写插入汉字代码，出现标题错误和数据库中两个问号的问题。1.文件修改    复制my-default.ini文件，重命名为my.ini；这样根目录下就有两个.ini文件了，一个是my-default.ini，一个是my.ini。接下来我们只需修改my.ini里面的内容就行了；2.修改my.ini添加两行：default-character-set=utf8 ...
Unknown initial character set index '45'
旅行的胶布的专栏
12-19 325
测试后发现是mysql的my.cnf中 [mysqld] character_set_server=utf8 #修改为对应的字符集编码 collation_server=utf8_general_ci #修改为对应的编码 做如上修改即可解决， ...
Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Unknown initial character set index '255'
06-01
这个错误通常是由于 JDBC 驱动程序无法识别数据库字符集引起的。这可能是由于以下原因之一导致的： 1. JDBC 驱动程序版本过旧，无法识别数据库字符集。 2. 数据库字符集设置不正确或不兼容 JDBC 驱动程序。...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值