【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

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

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版本号

成功解决：