Meaningless Drivel is fun!
The moose likes Object Relational Mapping and the fly likes hibernateTemplate.saveOrUpdate(...) issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "hibernateTemplate.saveOrUpdate(...) issue" Watch "hibernateTemplate.saveOrUpdate(...) issue" New topic

hibernateTemplate.saveOrUpdate(...) issue

Benson Fung
Ranch Hand

Joined: Apr 10, 2003
Posts: 214

I currently have a hibernate issue. Please help.

Scenario :

I have 2 tables like

Table A : pk = ida

Table B : pk = idb

In table A, there is a foreign key of Table B, called idfkb

And the object design is

Class A
Integer ida;
B b;

Class B
Integer idb;

I would like to insert an A record into the database with the existence of B record.

When I call hibernateTemplate.saveOrUpdate(A record), it throws exception that there is a duplicate value constraints. I believe the reason is because B record is already exist in B table, and the method saveOrUpdate will insert a record into A table and also insert the child record into B table.

For this scenario, is there any alternatives to insert A record with the existence of B record? please help.

Hebert Coelho
Ranch Hand

Joined: Jul 14, 2010
Posts: 754

How are you saving this values?

[] [Full WebApplication JSF EJB JPA JAAS with source code to download] One Table Per SubClass [Web/JSF]
Benson Fung
Ranch Hand

Joined: Apr 10, 2003
Posts: 214

Assume the B record already exists in the table. I need to insert a new record of A with a foreign key to B record. Then use hibernateTemplate.saveOrUpdate(...) to save the values.

abani patra
Ranch Hand

Joined: Oct 11, 2011
Posts: 70
Please use cascade=all for the mapping to B class so your problem will be solved.
I agree. Here's the link:
subject: hibernateTemplate.saveOrUpdate(...) issue
It's not a secret anymore!