【springboot+vue项目学习】ERROR 14936 --- [nio-8081-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]
2022-11-13 10:19:57.016 ERROR 14936 --- [nio-8081-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: ### Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '\xAC\xED\x00\x05sr\x00\x0Djava.time.Ser\x95]\x84\xBA\x1B"H\xB2\x0C\x00\x00xpw\x0E\x05\x00\x00\x07\xE6\x0B\x0D\x0A\x13885\x09\xC0' for column 'createDate' at row 1 ### The error may exist in com/xxxx/server/mapper/PositionMapper.java (best guess) ### The error may involve com.xxxx.server.mapper.PositionMapper.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO t_position ( name, createDate ) VALUES ( ?, ? ) ### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '\xAC\xED\x00\x05sr\x00\x0Djava.time.Ser\x95]\x84\xBA\x1B"H\xB2\x0C\x00\x00xpw\x0E\x05\x00\x00\x07\xE6\x0B\x0D\x0A\x13885\x09\xC0' for column 'createDate' at row 1 ; Data truncation: Incorrect datetime value: '\xAC\xED\x00\x05sr\x00\x0Djava.time.Ser\x95]\x84\xBA\x1B"H\xB2\x0C\x00\x00xpw\x0E\x05\x00\x00\x07\xE6\x0B\x0D\x0A\x13885\x09\xC0' for column 'createDate' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '\xAC\xED\x00\x05sr\x00\x0Djava.time.Ser\x95]\x84\xBA\x1B"H\xB2\x0C\x00\x00xpw\x0E\x05\x00\x00\x07\xE6\x0B\x0D\x0A\x13885\x09\xC0' for column 'createDate' at row 1] with root cause
![【springboot+vue项目学习】ERROR 14936 --- [nio-8081-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]](https://img-blog.csdnimg.cn/5175938be76d4dff92fed68a13d5e0aa.png)
初步分析应该是时间格式系统不能识别的问题
Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '\xAC\xED\x00\x05sr\x00\x0Djava.time.Ser\x95]\x84\xBA\x1B"H\xB2\x0C\x00\x00xpw\x0E\x05\x00\x00\x07\xE6\x0B\x0D\x0A\x13885\x09\xC0' for column 'createDate' at row 1
![【springboot+vue项目学习】ERROR 14936 --- [nio-8081-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]](https://img-blog.csdnimg.cn/d8bd639dbc8c45a1bf8f49c655cf4f3e.png)
解决方案一：
mysql版本过低，提升mysql版本号
![【springboot+vue项目学习】ERROR 14936 --- [nio-8081-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]](https://img-blog.csdnimg.cn/b490376021c94cc7bb41e1470d8bbe50.png)
成功解决：
![【springboot+vue项目学习】ERROR 14936 --- [nio-8081-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]](https://img-blog.csdnimg.cn/ab878b5311114051a581af4f20700740.png)
![【springboot+vue项目学习】ERROR 14936 --- [nio-8081-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]](https://img-blog.csdnimg.cn/a765f25b1dea49cab3b794e1d8c43703.png)
文章版权声明：除非注明，否则均为主机测评原创文章，转载或复制请以超链接形式并注明出处。
还没有评论，来说两句吧...