Hibernate version: 3.0.5

Name and version of the database you are using: db2 udb 8.1

Mapping documents:

<class
name="TSOrderSet"
table="TS_ORDER_SET"
schema="TS"
lazy="false"
>
<id
name="a_OrderId"
column="ORDERID"
type="string"
unsaved-value="null"
>
<generator class="sequence" >
<param name="sequence" >TS.ORDER_ID_SEQ</param>
</generator>
</id>
<property
name="a_SetId"
column="SET_ID"
type="string"
not-null="true"
/>
<map
name="a_DescriptionMap"
table="TS_SET_DESCRIPTIONS"
schema="TS"
cascade="none"
lazy="false"
>
<key
column="DESCRIPTION_ID"
/>
<index
column="LANGUAGE_ID"
type="string"
/>
<element
column="DESCRIPTION"
type="string"
not-null="true"
/>
</map>
</class>


Hibernate now expects that in my descriptiontable the orderId is in the Column DESCRIPTION_ID of the table TS_SET_DESCRIPTIONS. But
I want the SET_ID to be my key of the descriptiontable. How can I tell this to the map declaration. Looked in the Book and the online documentation.

Thanks for any help!

It is kind of standard modeling practice for foreign keys to refer to a primary key of related table, it simply has a lot of sense.

For one, if you will ever need to change value of SET_ID you do not need to update dependent objects because they are linked to surrogate key a_OrderId.


However, I suspect (just guessing), that you have a set definition table where SET_ID is the primary key, and in the TSOrder object you want to have set of descriptions associated with the set. If that is the case then I recommend to have a SomeSet class which will have normal map mapping and on the TSOrder have a field of SomeSet type, that will be mapped simply as many-to-one.

Then in the TSOrder object the desired map will be accessible as
tfOrder.getSet().getDescriptionsMap(). H will take care of the rest.

yeah, your probably right. actually its a (order - lineItem - Item) Relationship. For some reasons I was subclassing lineItem from Item, which was getting me in Trouble(I wanted to get all Items, but instead I was getting all LineItems by the command: session.load(item.class)) I think I should handle it like you said.

Thanks for your advice.

By the way: Is it possible to store an object in two different tables? Is this the discriminator thing?

Maybe this:
http://www.hibernate.org/hib_docs/v3/re ... edsubclass