aspose file tools*
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
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.
 
 
subject: MySQLIntegrityConstraintException -Cannot add or update a child row: a foreign key constraint fails