java.sql.SQLException: Field 'id' doesn't have a default value

参考网址：https://blog.csdn.net/qq_42680327/article/details/90731183

---

 

1.报错信息：

　　java.sql.SQLException: Field 'id' doesn't have a default value

　　java.sql.SQLException:字段“id”没有默认值

2.报错原因：

　　"configId"为主键。主键自增。此种情况下，入参中不需要传参主键的值。

3.报错解决办法：

　　入参改为：

{
"areaId": "000001",
"areaName": "新增地区1",
"beginTime": "2021-01-01 01:01:01",
"createdstamp": "2021-01-01 00:00:00",
"draftTime": "2021-01-01 00:00:00",
"endTime": "2021-01-01 00:00:00",
"lastupdatedstamp": "2021-01-01 00:00:00",
}

4.报错出现情况：

　　新增或更新接口：新增时会报错，不能新增数据，但是更新时完全没问题。

　　入参：

{
"areaId": "000001",
"areaName": "新增地区1",
"beginTime": "2021-01-01 01:01:01",
"configId": "2422422422422422424",
"createdstamp": "2021-01-01 00:00:00",
"draftTime": "2021-01-01 00:00:00",
"endTime": "2021-01-01 00:00:00",
"lastupdatedstamp": "2021-01-01 00:00:00",
}