文章最前: 我是Octopus,这个名字来源于我的中文名--章鱼;我热爱编程、热爱算法、热爱开源。所有源码在我的个人github ;这博客是记录我学习的点点滴滴,如果您对 Python、Java、AI、算法有兴趣,可以关注我的动态,一起学习,共同进步。
相关文章:
- DuplicateKeyException异常处理:java向数据库插入数据异
- springboot的UnsatisfiedDependencyException异常问题
- org.springframework.dao.DataIntegrityViolationException
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'current_state'
- java中出现这种错误: "error": "Internal Server Error",
- The Tomcat connector configured to listen on port 8888 failed to start
- java.nio.charset.MalformedInputException错误解决
- org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.geekplus.dao
文章目录
1.问题描述
{
"timestamp": "2019-07-15T08:06:58.223+0000",
"status": 500,
"error": "Internal Server Error",
"message": "\r\n### Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1561910400000' for column 'start_time' at row 1\r\n### The error may involve com.geekplus.playback.dao.PlaybackMapper.addPlayback-Inline\r\n### The error occurred while setting parameters\r\n### SQL: INSERT INTO playback(project_id, start_time, end_time, current_state) VALUES (?,?,?,?)\r\n### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1561910400000' for column 'start_time' at row 1\n; ]; Data truncation: Incorrect datetime value: '1561910400000' for column 'start_time' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1561910400000' for column 'start_time' at row 1",
"path": "/playback/addPlayback"
}
2.问题解决
出现这种问题是服务器的字段与存储的字段不同,就会出现错误!更改数据库的字段就能解决该问题。