Hi,

I'm trying to create a mapping for a hierarchy that is modeled as follows in the domain model:

A SubClass extends a SuperClass

In the database this is modeled as follows:

SUPERTABLE:
SUPERTABLEID (PK)
NAME (VARCHAR)
SUBTABLE:
SUBTABLEID (PK)
DESCRIPTION (VARCHAR)
SUPERTABLEID (FK)

Now when mapping this with an joined-subclass in the supertable.hbm.xml file, all works fine when leaving out the SUPERTABLEID. However the SUPERTABLEID in the SUPERTABLE differs from the SUBTABLEID in the SUBTABLE. I need to be able to also fill in the SUPERTABLEID in the SUBTABLE as now it is filled with null.

Regards,
Nico

The way I did it was to simply have a SUPER_TABLE_ID in both. SUBTABLEID is not necessary.

Hi,

I know this is not neccessary, nut as I'm need to start modeling from an existing DB model that is giant and already in production, I need to cover this.

I did found the solution by letting subclass referencing its superclass through the SUPERTABLEID (the FK) by pointing its own.

This way I managed to get the ID in there as it should be according to the existing Database schema. The best thing ofcourse should be a redesign of the database :), and start from the domain model instead.

Regards,
Nico