mybatis报错SqlException解决不了啊

错误日志是这样的,我检查不出来

-------------------------------------------------------------------------------
Test set: com.future.user.UserTest
-------------------------------------------------------------------------------
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 2.145 sec <<< FAILURE!
test(com.future.user.UserTest)  Time elapsed: 1.782 sec  <<< ERROR!
org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
### The error may exist in com/future/user/UserMapper.xml
### The error may involve com.future.user.User.addUser
### The error occurred while executing an update
### Cause: java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
    at com.future.user.UserTest.test(UserTest.java:21)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:78)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:567)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
    at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252)
    at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141)
    at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:78)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:567)
    at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189)
    at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165)
    at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85)
    at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115)
    at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75)
Caused by: java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
    at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:201)
    at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:196)
    at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:93)
    at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:403)
    at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:89)
    at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:138)
    at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:60)
    at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
    at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
    at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
    at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
    at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
    ... 31 more
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:78)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:83)
    at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:128)
    at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2201)
    at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2225)
    at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1391)
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:993)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:852)
    ... 49 more

其中at com.future.user.UserTest.test(UserTest.java:21)对应的代码长这样

User user = new User("fan12121", "asasa212");
int count =sqlsession.insert("com.future.user.User.addUser", user);

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除
收藏举报

2条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
CSDN专家-sinJack 2021-09-19 16:40
关注
把数据库配置url发出来，我给你改

主要是设置时区问题：serverTimezone=UTC

driver=com.mysql.cj.jdbc.Driver url=jdbc:mysql://localhost:3306/你使用的数据库?serverTimezone=UTC user=root password=你的密码
本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(1条)

报告相同问题？

关注问题

mybatis报错SqlException解决不了啊 java java-ee mysql 有问必答
2021-09-19 16:32

回答 2 已采纳把数据库配置url发出来，我给你改主要是设置时区问题：serverTimezone=UTC driver=com.mysql.cj.jdbc.Driver url=jdbc:mysql://loca
mybatis传参报错 java.sql.SQLException: 无效的列索引 java sql xml 有问必答
2022-03-07 14:57

回答 4 已采纳接口怎么写的。用@Param()指定一下。 method(@Param("sale") SaleContractSettle sale) <if test="sale.qysSignStatu
mybatis获取数据库内容报错：Cause: java.sql.SQLException: No value specified for parameter 1 java 前端后端
2022-04-09 23:02

回答 1 已采纳参数1 没有指定,你是getUserList方法中需要传入参数吗? 如果你是需要传入参数,但有时候又可以不需要参数那么就把参数写成可变参数吧! 欢迎采纳!
mybatis报错整理
2022-01-07 23:21

王茂茂️的博客 mybatis报错整理
spring+Mybatis+Druid 报错ERROR {dataSource-1} init error java.lang.NullPointerException: null java spring boot 后端
2022-02-12 17:48

回答 1 已采纳循环依赖了，既然你自定义了datasource，启动类移除掉数据源的自动装配，@SpringBootApplication(exclude = DataSourceAutoConfiguration.
mybatis中文插入数据库报错 java spring
2020-01-08 19:07

回答 1 已采纳 https://blog.csdn.net/l1509214729/article/details/80781740
mybatis update操作报错 mysql 单元测试
2017-06-27 11:51

回答 6 已采纳 ``` update business b SET b.img_file_name=#{imgFileName},b.title=#{title},b.subtitle
MyBatis报错: Cause: java.lang.StringIndexOutOfBoundsException: String index out of range: -66 的解决方案
2023-12-18 17:14

Unity官方的博客 SpringBoot MyBatis报错: Cause: java.lang.StringIndexOutOfBoundsException: String index out of range: -66 的解决方案
mysql8.0 with as在navicat中可以使用，但是在mybatis却报错 java mysql 有问必答
2021-09-22 11:38

回答 2 已采纳看看你的数据库连接池配置文件有没有问题
java多线程批量插入数据报错 java mysql spring boot
2022-04-24 18:32

回答 11 已采纳如果你是springboot项目，像你说的那个批量处理数据什么的，你就用他自带的多线程方法ThreadPoolTaskExecutor，去处理，最后.join的方式加入到主线程，你只需要处理数据网数据
spring boot 2.5.14整合mybatisplus3.5.1时使用@Transactional出现异常 java spring boot 数据库
2022-08-09 18:55

回答 5 已采纳 at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1394)看到了这句，如果设置了只读的话，插入数据就会报错。检查一
mybatis报错SQLException、syntax error、expect IDENTIFIER, actual IDENTIFIER pos
2022-01-20 17:24

栗青的博客 Cause: java.sql.SQLException: sql injection violation, syntax error: > syntax error, error in :'ar u left join zzlc$user_car_file ', expect > IDENTIFIER, actual IDENTIFIER pos 45, line 1,
MybatisPlus操作数据库报错：sql injection violation java spring spring boot
2022-02-16 21:32

回答 2 已采纳问题在于我之前在配置文件中配置了druid.filter.wall.config.update-allow=false,所以导致无法修改，sql语句没有问题，改成true后问题解决
Mybatis报错java.sql.SQLException: Column ‘IS_GENERATEDCOLUMN‘ not found
2023-04-28 17:05

0xwang的博客 mybatis
Mybatis insert报错 Cause: java.sql.SQLException: SQL String cannot be empty
2022-01-28 14:04

橘子nana的博客 Mybatis insert报错 Cause: java.sql.SQLException: SQL String cannot be empty 1、错误描述场景复现：使用Mybatis去传入list批量插入时，使用代码如下: mapper void insertTest(List<Test> list); ...
没有解决我的问题, 去提问

问题事件

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
系统已结题 9月27日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
已采纳回答 9月19日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
创建了问题 9月19日

悬赏问题

¥15 echarts动画效果失效的问题。官网下载的例子。
¥60 许可证msc licensing软件报错显示已有相同版本软件，但是下一步显示无法读取日志目录。
¥15 Attention is all you need 的代码运行
¥15 一个服务器已经有一个系统了如果用usb再装一个系统，原来的系统会被覆盖掉吗
¥15 使用esm_msa1_t12_100M_UR50S蛋白质语言模型进行零样本预测时，终端显示出了sequence handled的进度条，但是并不出结果就自动终止回到命令提示行了是怎么回事：
¥15 前置放大电路与功率放大电路相连放大倍数出现问题
¥30 关于<main>标签页面跳转的问题
¥80 部署运行web自动化项目
¥15 腾讯云如何建立同一个项目中物模型之间的联系
¥30 VMware 云桌面水印如何添加

mybatis报错SqlException解决不了啊

2条回答 默认 最新

问题事件

悬赏问题

2条回答默认最新