MySql query exception

Question

When i am trying to insert values in MySQL table through java code, I am getting the exception:

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (icd_app_suite/mapper, CONSTRAINT FK_mapper_1 FOREIGN KEY (user_id) REFERENCES user_detail (user_id) ON DELETE CASCADE ON UPDATE CASCADE)

What can be the cause?

Marco · Accepted Answer · 2011-09-19 10:56:41Z

3

The error is clear: you're inserting (or updating) a row which doesn't respect a foreign key in referenced table.
So you first have to insert father record, then child record.
Probably you're adding a record on user_detail table with ID field not present in user table

answered Sep 19, 2011 at 10:56

Marco

57.7k15 gold badges135 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bohemian · Accepted Answer · 2011-09-19 10:56:44Z

0

You are inserting a row with a value in the user_id column that is not found in the user_id column of the user_detail table

answered Sep 19, 2011 at 10:56

Bohemian♦

427k103 gold badges604 silver badges750 bronze badges

Collectives™ on Stack Overflow

MySql query exception

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related