Hi,

I have mapped an existing table like following, where a member references an other instance of the same class.

When I load a row where FATHER=0, I get a "no row for the given identifier exists" exception, because '0' is a magic number which mean "no parent" in the database.

I know it's a poor database design but I can't change it... So I would like to set my property to null where no row exists for a given foreign key.

How should I proceed ?

Thanks


Hibernate version: 1.0.2.0

Mapping documents:

<class name="Person" table="PERSON">
<id name="Id" type="Int32" column="ID_PERSON">
<generator class="native" />
</id>
<property name="Name" column="NAME" type="String" length="50" not-null="true" />
<many-to-one name="Father" column="FATHER" class="Person" />
</class>

This is not currently supported by NHibernate. You may be able to work around it using a view which would map 0 to NULL.

Thank you Sergey, I will make pressure on tha dba to use NULL instead of 0... I think it's better for updates.