MySQLIntegrityConstraintException - “Cannot add or update a child row: a foreign key constraint fails” in Grails

Question

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 program contains as below, `def Order = new XmlParser().parse("MyXml.xml")` `def set1 = sql.dataSet("order_item")` `def set2 = sql.dataSet("order_header")` `Order.order_item.each {` `// retrieving order information and storing` `}` `set1.add(Column_Name1:order_id,Column_Name2:field2,Column_Name3:field3)` `set2.add(Column_Name1:order_id)` I listed the error in detail below WARNING: Failed to execute: insert into order_item (order_id, order_item_seq_id, order_item_type_id, product_id, prod_catalog_id, quantity, unit_price, unit_lis t_price, item_description, status_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) beca use: Cannot add or update a child row: a foreign key constraint fails (`ecommerc e/order_item`, CONSTRAINT `ORDER_ITEM_HDR` FORE…

Accepted Answer

At first the foreign key constraint table to be updated initially then the specific table to should me updated. A small change in the above code is

`set2.add(Column_Name1:order_id)` `set1.add(Column_Name1:order_id,Column_Name2:field2,Column_Name3:field3)`

The set 2 should updated first and then the set 1.

Now it got worked for me. Thanks for all.

MySQLIntegrityConstraintException - “Cannot add or update a child row: a foreign key constraint fails” in Grails

Solution

Problem