java测试数据库问题导致报错

最新推荐文章于 2025-05-21 15:14:17 发布

贼船叔叔

最新推荐文章于 2025-05-21 15:14:17 发布

阅读量1w

点赞数

CC 4.0 BY-SA版权

分类专栏： java测试 java 数据库文章标签：测试数据库 java reference exception nested

本文链接：https://blog.youkuaiyun.com/GeneralYY0/article/details/7263625

java 同时被 3 个专栏收录

69 篇文章

订阅专栏

数据库

14 篇文章

订阅专栏

java测试

8 篇文章

订阅专栏

在进行Java测试过程中，遇到了数据库报错：DataIntegrityViolationException，具体原因是外键约束失败，涉及表`for_course_record`的`FK_Reference_108`约束，无法添加或更新子记录，因为违反了`school_curriculum_content`表的外键约束。错误可能与ForCourseRecordMapper的insertSelective方法有关。

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

测试报错

org.springframework.dao.DataIntegrityViolationException:
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`superschool`.`for_course_record`, CONSTRAINT `FK_Reference_108` FOREIGN KEY (`SOURCE_COURSE_ID`) REFERENCES `school_curriculum_content` (`ID`))
### The error may involve com.superschool.dao.ForCourseRecordMapper.insertSelective-Inline
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`superschool`.`for_course_record`, CONSTRAINT `FK_Reference_108` FOREIGN KEY (`SOURCE_COURSE_ID`) REFERENCES `school_curriculum_content` (`ID`))
; SQL []; Cannot add or update a child row: a foreign key constraint fails (`superschool`.`for_course_record`, CONSTRAINT `FK_Reference_108` FOREIGN KEY (`SOURCE_COURSE_ID`) REFERENCES `school_curriculum_content` (`ID`)); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`superschool`.`for_course_record`, CONSTRAINT `FK_Reference_108` FOREIGN KEY (`SOURCE_COURSE_ID`) REFERENCES `school_curriculum_content` (`ID`))

原因：表：`superschool`.`for_course_record`, 的外键字段：school_curriculum_content_id （但是写错啦，写成了：SOURCE_COURSE_ID字段）进行了外键约束，主键表示是`school_curriculum_content` (`ID`))