Updating a primary key

wSam · **Joined:** Fri Jun 23, 2006 6:28 am **Posts:** 22

Hi

I have a coposite primary key like this:

Code:

<composite-id> 
   <key-property name="fieldName" column="FIELD_NAME"/> 
   <key-many-to-one name="reportTable" class="ReportTable" column="REPORT_TABLES_ID"/> 
</composite-id> 
<property name="fieldDesc" column="FIELD_DESC"/>

But wenn i change the properties of such a Object, i can only change the value from the property "fieldDesc":

Code:

update 
  REPORT_FIELDS 
set 
  FIELD_DESC=?, 
where 
  FIELD_NAME=? and REPORT_TABLES_ID=? 

It sets only the property field "fieldDesc". How can I make, that it also updates the propertys from the composite-id? When I change the name as an example?

greets

kochcp · **Posted:** Wed Jun 28, 2006 11:56 am

From a database and object-oriented standpoint, if you need an object/entry to have different primary keys, you are making a new object/entry.

Best to delete the previous and enter a new object with the new primary keys

batmat · **Posted:** Wed Jun 28, 2006 2:26 pm

First, recall that composite id should be avoided when possible (i.e. no legacy to stick to).

Second, did you implement equals and hashCode ? http://www.hibernate.org/hib_docs/v3/re ... ompositeid
and
http://www.hibernate.org/hib_docs/v3/re ... ompositeid

I don't think it's related to your actual problem, but if you do not do this, you will hit other problem until soon :).

And final : I don't think ids are designed to change. If your entity id has to change, then I agree with kochcp, I think it's best to delete the old entry and add the new one.

wSam · **Joined:** Fri Jun 23, 2006 6:28 am **Posts:** 22

@batmat

Yes, I implemented equals and hashCode.

Ok, then i will first delete the object, and then save it again. This tables are a littlebit for nothing I know, but I cant change them.

Thanks.