BUG/错误集锦(1)

不会拆家的二哈

已于 2022-04-22 22:06:45 修改

阅读量1.4k

点赞数

分类专栏： Java后端文章标签： http list java

于 2022-03-31 18:00:38 首次发布

本文链接：https://blog.csdn.net/chenpp666/article/details/123879446

版权

这篇博客总结了Mybatis在插入数据时遇到的问题，包括MySQL的Data truncated错误、无法反序列化对象的问题、Invalid bound statement错误以及Field 'id'无默认值的问题。并详细解析了每个错误的原因及提供了解决方法，如检查数据类型和长度匹配、修正mapper接口与XML映射、设置主键自增等。

摘要由CSDN通过智能技术生成

文章目录

Mybatis中的instert时候,未判断空值,出现的错误
>解决MySQL报错：Data truncated for column 'xxx' at row 1/0
>Cannot deserialize instance of `java.util.ArrayList` out of START_OBJECT token错误解决
>Invalid bound statement (not found)解决方法
>如何解决Field 'id' doesn't have a default value 问题
>MYSQL:Unknown column ‘字段名‘ in ‘field list‘ 错误解决方案

Mybatis中的instert时候,未判断空值,出现的错误

2022-04-22 21:41:28.013 ERROR 1 --- [nio-9099-exec-8] 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.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
### The error may exist in class path resource [mapper/AlarmDisposeMapper.xml]
### The error may involve com.boot.reservation.mapper.AlarmDisposeMapper.