Hibernate version: 3.0


Is it possible to update the primary key of a table using Hibernate? Specifically, can one update a composite key of a child using the parent object in a <one-to-many> mapping?

If yes, can someone please direct me to the correct place in the ref manual (I've tried in vain) or somewhere else ?

Thanks in advance.

hibernte does not allow you to update primary keys.

It is best to delete the old child and create a new one with a new primary key.

Hi devu, it already was discussed before. Based in relational theory the primary key could not be changed, it is for definition, maybe you must consider to delete an object and to create another.

Halcon,

Can you please direct me to the post or atleast the search string for it? My efforts to find the post (before posting mine) have been fruitless.

I might have missed it because I'm not a regular around here.


You're definitely making sense with regards the relational perspective.
But that's the way the datamodel (out of my hands) has been set up.

Here it is

TB_CALENDAR
=======
CAL_ID - PK


TB_CAL_DETLS
==========
CAL_ID - PK
CAL_DT - PK
DAY_TYPE_ID -PK
CREATED_BY
MODIFIED_BY

TB_CAL_DAY_TYPE
============
DAY_TYPE_ID - PK
DAY_TYPE_DESC

(for this table examples are 1- start of year, 2 - end of year and so on)

So in the table TB_CAL_DETLS, the user can change the date for start of the year and end of the year and so on.... which changes the primary key...

As for the reason, why it can't be deleted and re-inserted, that would lose the original CREATED_BY(unless its managed through code, which I am now considering) as all these updates happen through GUI and the original creator of the calendar and its modifier might be different people.




Thanks again,

Devu.

Found it...

http://www.hibernate.org/117.html#A28

Looks like I'll have to manage it through code....

Thanks anyway...

Hi devu, sorry for my delayed reply, but I lost your post, I hope you have found the adequate response.

Bye