File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes (Hibernate operation: could not insert: Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "(Hibernate operation: could not insert:" Watch "(Hibernate operation: could not insert:" New topic
Author

(Hibernate operation: could not insert:

Neha Gap
Greenhorn

Joined: May 30, 2007
Posts: 29
Hi,

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.
Emanuel Kadziela
Ranch Hand

Joined: Mar 24, 2005
Posts: 186
Make sure you're setting the parent reference on the child object.
Neha Gap
Greenhorn

Joined: May 30, 2007
Posts: 29
The DAOs are all middlegen generated. I am not writing the code for child-parent references.

- Neha.
 
 
subject: (Hibernate operation: could not insert: