Hi,

I have a problem I can't figure out to solve, I'm sure I'm just stupied and it's easy to solve but I can't figure out how.

I have two tables:

TT_FEATURE and TT_FEATUREINFORMATION

In the Feature class i have a property called FeatureInformation.

So how do I do this mapping, i tried something like this, but of course it didn't work.

<joined-subclass name="Feature" table="TT_FEATURE" lazy="true">
<many-to-one name="featureInformation" column="FEATURE_ID" class="FeatureInformation" unique="true" />
</joined-subclass>

The problem is the reference between the two tables is given in the TT_FEATUREINFORMATION table, and not in the TT_FEATURE (if it was the opposite, the above would work).

Cheers,

Per

Solved it, post my result here so other stupid people like me can find the solution.

<one-to-one name="featureInformation"
class="FeatureInformation"
foreign-key="FEATURE_ID" />