Error updating database. Cause: java.sql.SQLException: Unknown initial character set index ‘255‘ re

客官°小女子只卖身不卖艺 2024-04-07 15:00 28阅读 0赞

在进行测试的时候突然报错以下问题：

Error updating database. Cause: java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.

具体错误：

org.apache.ibatis.exceptions.PersistenceException: 
    ### Error updating database.  Cause: java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
    ### Cause: java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
    
    	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)
    	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
    	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:57)
    	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
    	at com.sun.proxy.$Proxy12.insertEncodeProperties(Unknown Source)
    	at test.MyTest.test1(MyTest.java:50)
    	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.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
    	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
    	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:69)
    	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
    	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220)
    	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53)
    Caused by: java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.

jdbc.properties文件

![294bfb1d5a79480eb936e8838fc1e484.png][]

解决方法：看错误提示是字符编码的问题，那么在url后面加上字符编码设置就可以了

jdbc.url=jdbc:mysql:///mybatis_test_db?characterEncoding=utf8

万物明朗，可可爱爱！  
愿你天天有个好心情，热爱每一段代码！  
ଘ(੭ˊᵕˋ)੭ （开心） ଘ(੭ˊᵕˋ)੭ （开心）ଘ(੭ˊᵕˋ)੭ （开心）ଘ(੭ˊᵕˋ)੭ （开心）ଘ(੭ˊᵕˋ)੭ （开心）  
  
\------不写代码不会凸的小刘

[294bfb1d5a79480eb936e8838fc1e484.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/afa4604fb2f8438aa7f53ef98aad7a3f.png

Error updating database. Cause: java.sql.SQLException: Unknown initial character set index ‘255‘ re

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关【bug】Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown error 1054

相关 Error updating database. Cause: java.sql.SQLException: Unknown initial character set index ‘255‘ re

相关 Unknown initial character set index ‘255‘ received from server. Initial client character set can be

相关 "org.springframework.dao.DuplicateKeyException: \r\n### Error updating database. Cause

相关 Unknown initial character set index '255' received from server.

相关 Unknown initial character set index ‘255‘ received from server. Initial client character set can be

相关 Mysql 连接报错:Unknown initial character set index '255' received from server. Initial ...

相关 idea连接MySQL测试报错与 Unknown initial character set index '255' received from server.

相关 java.sql.SQLException: Unknown initial character set index '45' received from server.

相关 JDBC连接MySQL：Unknown initial character set index '255' received from server.Initial client character