java - 外键约束失败 该怎么解决

Question

WARNING]
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is 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 (lgip.tb_intention, CONSTRAINT fk_intention_user FOREIGN KEY (firm_id) REFERENCES tb_user (id))

The error may involve com.nstc.lgip.idao.TbIntentionMapper.insert-Inline

The error occurred while setting parameters

SQL: insert into tb_intention (id, firm_id, industry_type ) values (?, ?, ? )

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (lgip.tb_intention, CONSTRAINT fk_intention_user FOREIGN KEY (firm_id) REFERENCES tb_user (id))

; SQL []; Cannot add or update a child row: a foreign key constraint fails (lgip.tb_intention, CONSTRAINT fk_intention_user FOREIGN KEY (firm_id) REFERENCES tb_user (id)); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (lgip.tb_intention, CONSTRAINT fk_intention_user FOREIGN KEY (firm_id) REFERENCES tb_user (id))

Answer 1

입력하신 Firm_id는 tb_user 테이블에 해당하는 ID가 없습니다. . . . . . .

Answer 2

외래 키 테이블은 기본 키 테이블에 대해 왼쪽 링크 쿼리를 수행하고 일부 ID가 기본 키 테이블에 존재하지 않음을 확인한 후 해당 ID를 삭제할지 유지할지 결정할 수 있습니다.