I have two tables with bi-directional association between the two. The hbm.xml files, DAOs, model classes and interfaces are all generated by middlegen. I'm constructing the objects of these generated model classes using Spring's ApplicationContext. The child object has a reference to the parent object in the spring config xml file. I try to insert an object of type child using hibernate's generated DAOs and get the following error
<error message="(Hibernate operation: could not insert: [child]): data integrity violated by SQL 'insert into child nested exception is java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails (``, CONSTRAINT `FK9EB1B4A760778BE5` FOREIGN KEY (`parentID`) REFERENCES `parent` (`parent_id`))" type="org.springframework.dao.DataIntegrityViolationException">org.springframework.dao.DataIntegrityViolationException: (Hibernate operation: could not insert: ): data integrity violated by SQL '
Any and all help would be greatly appreciated. - Neha.