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

最新推荐文章于 2024-12-09 11:16:16 发布

原创最新推荐文章于 2024-12-09 11:16:16 发布 · 1w 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#测试 #数据库 #java #reference #exception #nested

java 同时被 3 个专栏收录

69 篇文章

订阅专栏

数据库

14 篇文章

订阅专栏

java测试

8 篇文章

订阅专栏

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

测试报错

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`))