LocalDate、LocalTime、LocalDateTime 和mysql5.7交互

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\xE3\x0A\x02\x16\x1D\x05\x14\xA‘ for column ‘update_time‘ at row 1
### The error may exist in com/zjc/mp/dao/UserMapper.java (best guess)
### The error may involve com.zjc.mp.dao.UserMapper.deleteByIdWithFill-Inline
### The error occurred while setting parameters
### SQL: UPDATE user SET age=?,update_time=?,deleted=1 WHERE id=? AND deleted=0
### 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\xE3\x0A\x02\x16\x1D\x05\x14\xA‘ for column ‘update_time‘ 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\xE3\x0A\x02\x16\x1D\x05\x14\xA‘ for column ‘update_time‘ 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\xE3\x0A\x02\x16\x1D\x05\x14\xA‘ for column ‘update_time‘ at row 1

mysql的驱动修改为5.1.37后,更新成功!

LocalDate、LocalTime、LocalDateTime 和mysql5.7交互

标签：database   date   except   pid   http   驱动   The   打开   mysql