wood burning stoves 2.0*
The moose likes Groovy and the fly likes MySQLIntegrityConstraintException -Cannot add or update a child row: a foreign key constraint fails Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Languages » Groovy
Bookmark "MySQLIntegrityConstraintException -Cannot add or update a child row: a foreign key constraint fails" Watch "MySQLIntegrityConstraintException -Cannot add or update a child row: a foreign key constraint fails" New topic
Author

MySQLIntegrityConstraintException -Cannot add or update a child row: a foreign key constraint fails

Sabarish Venkat
Ranch Hand

Joined: Jan 18, 2012
Posts: 136

Hi,
Am trying to get some order information from xml file and trying to store it in database(mysql) table. I can retrieve the order information from xml file but when am trying to insert into the table it shows error as MySQLIntegrityConstraintException.

My Grails program shown as below,


When i run the program i get an error as,


Can anyone help me to come out from this problem. Thanks in advance
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

Your order_item table requires an order_item_hdr value which is a FK to order's ID.


GenRocket - Experts at Building Test Data
Sabarish Venkat
Ranch Hand

Joined: Jan 18, 2012
Posts: 136

Thanks gregg i had looked it and got solved.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQLIntegrityConstraintException -Cannot add or update a child row: a foreign key constraint fails
 
Similar Threads
Cannot add or update a child row: a foreign key constraint fails
hibernat creating the tables without cascade
Simple But Crazy Cascade Problem
CMR & DB Foreign Key references
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException