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

[Sabarish Venkat]

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,

   def Order = new XmlParser().parse("MyXml.xml")
   def set1 = sql.dataSet("order_item")
   def set2 = sql.dataSet("order_header")

    Order.order_item.each {
               // retriving order information and storing
    }

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

When i run the program i get an error as,

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` FOREIGN KEY (`ORDER_ID`) REFERENCES `
order_header` (`ORDER_ID`))
Caught: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationExcepti
on: Cannot add or update a child row: a foreign key constraint fails (`ecommerce
/order_item`, CONSTRAINT `ORDER_ITEM_HDR` FOREIGN KEY (`ORDER_ID`) REFERENCES `o
rder_header` (`ORDER_ID`))
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cann
ot add or update a child row: a foreign key constraint fails (`ecommerce/order_i
tem`, CONSTRAINT `ORDER_ITEM_HDR` FOREIGN KEY (`ORDER_ID`) REFERENCES `order_hea
der` (`ORDER_ID`))
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
        at com.mysql.jdbc.Util.getInstance(Util.java:384)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
        at db2xml.XMLToDatabase$_main_closure2.doCall(XMLToDatabase.groovy:52)
        at db2xml.XMLToDatabase.main(XMLToDatabase.groovy:38)

Can anyone help me to come out from this problem. Thanks in advance

[Gregg Bolinger]

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

[Sabarish Venkat]

Thanks gregg i had looked it and got solved.