springboot+mybatis com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException异常解决方案

最新推荐文章于 2024-06-15 16:52:58 发布

niceguy_smile

最新推荐文章于 2024-06-15 16:52:58 发布

阅读量1.5k

点赞数 1

分类专栏： springboot mybatis 文章标签： springboot mybatis

本文链接：https://blog.youkuaiyun.com/smile_foreach/article/details/102972169

版权

在尝试使用SpringBoot和MyBatis插入数据时遇到MySQL的IntegrityConstraintViolationException，错误提示为Duplicate entry '219' for key 'PRIMARY'。问题出在尝试插入已存在的主键值。解决方案是在模型类中添加@GeneratedValue(strategy = GenerationType.IDENTITY)注解，允许数据库自增主键。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

## Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '219' for key 'PRIMARY'
### The error may involve com.atguigu.gmall.manage.mapper.PmsBaseAttrValueMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO pms_base_attr_value ( id,value_name,attr_id ) VALUES( ?,?,? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '219' for key 'PRIMARY'
; SQL []; Duplicate entry '219' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '219' for key 'PRIMARY'
org.springframework.dao.DuplicateKeyException:
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '219' for key 'PRIMARY'
### The error may involve com.atguigu.gmall.manage.mapper.PmsBaseAttrValueMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO pms_base_attr_value ( id,value_name,attr_id ) VALUES( ?,?,? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '219' for key 'PRIMARY'
; SQL []; Duplicate entry '219' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '219' for key 'PRIMARY'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)

最低0.47元/天解锁文章