【springboot+vue项目学习】ERROR 14936 --- [nio-8081-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]

Incorrect datetime value: '\xAC\xED\x00\x05sr\x00\x0Djava.time.Ser\x95]\x84\xBA\x1B"H\xB2\x0C\x00\x00xpw\x0E\x05\x

IsQiya

2853人浏览 · 2022-11-13 16:56:18

IsQiya · 2022-11-13 16:56:18 发布

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

在这里插入图片描述

初步分析应该是时间格式系统不能识别的问题

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

在这里插入图片描述
解决方案一：
mysql版本过低，提升mysql版本号

成功解决：

Vue

前往低代码交流专区

更多推荐

vue 表单验证

1、6位小写字母和数字必须包含两个字母rules: [{ required: true, message: "XXX不能为空", trigger: "blur" },{ max: 6, message: "最大长度为6位字符", trigger: "blur" },{pattern: /^(?=(?:[^a-z]*[a-z]){2})[a-z0-9]{6,6}$/, //不连续的两位字母// /^