idea运行出现的bug

最新推荐文章于 2023-03-11 10:30:02 发布

咪路咪路milu

最新推荐文章于 2023-03-11 10:30:02 发布

阅读量457

点赞数 1

分类专栏： bug集中营文章标签： bug

本文链接：https://blog.csdn.net/m0_57537410/article/details/127629897

版权

bug集中营专栏收录该内容

3 篇文章 0 订阅

订阅专栏

2022-11-01 10:55:11.357 ERROR 10972 --- [nio-9665-exec-1] 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: java.sql.SQLException: Field 'id' doesn't have a default value
### The error may exist in com/example/demo/fifthUser/mapper/UserMapper.java (best guess)
### The error may involve com.example.demo.fifthUser.mapper.UserMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO sys_user  ( username, password, salt, nickname, email, phone, address )  VALUES  ( ?, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: Field 'id' doesn't have a default value
; Field 'id' doesn't have a default value; nested exception is java.sql.SQLException: Field 'id' doesn't have a default value] with root cause

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

这个问题是由于数据库字段跟请求字段不一致导致的，发生在id上面，经查证是数据库的id没有选择自增