添加商品DAO层测试的时候调试失败。

来源：8-1 商品添加之Dao层的实现

韬1430337

2020-11-03

这是批量添加图片的测试，不太懂怎么操作，而后面的那个productDao测试也发生了类似的错误，好像都是数据的异常
org.springframework.dao.DataIntegrityViolationException:

Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`020`.`tb_product_img`, CONSTRAINT `fk_proimg_product` FOREIGN KEY (`product_id`) REFERENCES `tb_product` (`product_id`))

The error may exist in file [E:\works\o2o\target\classes\mapper\ProductImgDao.xml]

The error may involve com.imooc.o2o.dao.ProductImgDao.batchInsertProductImg-Inline

The error occurred while setting parameters

SQL: INSERT INTO tb_product_img(img_addr,img_desc,priority, create_time,product_id) VALUES ( ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ? )

Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`020`.`tb_product_img`, CONSTRAINT `fk_proimg_product` FOREIGN KEY (`product_id`) REFERENCES `tb_product` (`product_id`))

; Cannot add or update a child row: a foreign key constraint fails (020.tb_product_img, CONSTRAINT fk_proimg_product FOREIGN KEY (product_id) REFERENCES tb_product (product_id)); nested exception is java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (020.tb_product_img, CONSTRAINT fk_proimg_product FOREIGN KEY (product_id) REFERENCES tb_product (product_id))
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:246)

写回答

2回答

翔仔

2020-11-04

Cannot add or update a child row: a foreign key constraint fails (020.tb_product_img, CONSTRAINT fk_proimg_product FOREIGN KEY (product_id) REFERENCES tb_product (product_id))

说的是同学的productImg里面的productId在tb_product里面不存在，也就是没法分辨图片是属于哪个商品的，需要你添加对应的product_id并且product_id在tb_product存在才可以

韬1430337

提问者

2020-11-03

### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`020`.`tb_product`, CONSTRAINT `fk_product_procate` FOREIGN KEY (`product_category_id`) REFERENCES `tb_product_category` (`product_category_id`))

### The error may exist in file [E:\works\o2o\target\classes\mapper\ProductDao.xml]

### The error may involve com.imooc.o2o.dao.ProductDao.insertProduct-Inline

### The error occurred while setting parameters

### SQL: INSERT INTO tb_product(product_name,product_desc,img_addr, normal_price,promotion_price,priority,create_time, last_edit_time,enable_status,product_category_id, shop_id) VALUES (?,?,?, ?,?,?,?, ?,?,?, ?)

### Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`020`.`tb_product`, CONSTRAINT `fk_product_procate` FOREIGN KEY (`product_category_id`) REFERENCES `tb_product_category` (`product_category_id`))

; Cannot add or update a child row: a foreign key constraint fails (`020`.`tb_product`, CONSTRAINT `fk_product_procate` FOREIGN KEY (`product_category_id`) REFERENCES `tb_product_category` (`product_category_id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`020`.`tb_product`, CONSTRAINT `fk_product_procate` FOREIGN KEY (`product_category_id`) REFERENCES `tb_product_category` (`product_category_id`))

这个是商品添加调试的信息，控制台并没有报错

Java双版本（SSM到SpringBoot）校园商铺全栈开发

SSM商铺V1.0，解决毕设痛点；SpringBoot商铺V2.0，满足工作刚需

5113 学习 · 8144 问题

查看课程

相似问题

在测试里添加商品时候失败

回答 10

老师,在验证商品添加的service中报错,dao层验证都是OK的呢

回答 1

Service层测试成功能取出第一大类中的所有商铺，Controller层测试返回的是一个空的json

回答 2

老师你好，商品添加 productStr转成实体product，mapper.readValue(productStr, Product.class)问题

回答 2

外键约束失败！

回答 5

打开慕课网App查看更多内容