Hey
I'm kind of new to Hibernate, and I'm trying to join 2 table just to get 1 value extra for a class.
The class is Game, which finds its info from the GameConfig table. This table has a statusID which REFERENCES the gamestatusses table.
Gamestatusses has: statusID, statusName.
I tried:
Code:
<class name="Game" table="gameconfig">
<id name="Id" column="ID">
<generator class="native" />
</id>
<property name="MinAge" column="minAge" />
<property name="MaxAge" column="maxAge" />
<join table="gamestatusses" >
<key column="statusID" property-ref="statusID" />
<property name="Status" column="status"/>
</join>
</class>
This is probably basics but anyway... help?
I just need the name of the status given the ID.
Thanks in advance!