Hibernate version: 3.0
Name and version of the database you are using: MySQL 4.1.16-nt

I have a mapping question that should be easy to answer for the Hibernate cracks on this boards:

I want to map the following class:



My question is: How do I map the predecessorElement property. This is a reference to another Element object that serves as the base of the current object. The object may be null. Furthermore the predecessorElement may only have one Element that it precedes.

Basically this seems to be a one-to-one association with the exception that both the actual Element and its predecessors are stored in the same table (element).

Thanks in advance for your advice.

EDIT: I just realized that I accenditally posted in the wrong forum, shame on me... Would be nice if the mods could move this thread to the Hibernate Users forum.

in your Element.hbm.xml file just write:
<many-to-one
name="Element"
class="com.mycompany.Element"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="ELEMENT_ID"
/>

cascade/update and insert values are up to your model.

Please do not forget to vote.

Thanks, this seems to work, although I think it's a little weird because technically this isn't a many-to-one mapping, but screw it ;)