Hello,

I am a new hibernate guy, could someone help me about the following peoblem.

I have two tables, I am going to handling the inheritance with " table per class hierarchy"

two tables:
Users UserTypes
--------------------------- ----------------------------
UserID (PK, int) |-----------> UserTypeID(PK, int)
UserTypeID (FK, int) <---------| ....
...
--------------------------- ---------------------------

Subclass of Users:
Doctors when UserTupeID = 1
Patients when UserTypeID = 2

When I do mapping, I have following classes

class Users {
int userid;
UserType usertype;
---
}

class Doctors extends Users{ }
class Patients extends Users{ }

class UserType{
int usertypeid;
...
}

The mapping file:

<hibernat-mapping>
<class name="Users" table="users">
<id name="userid" column="UserID" type="java.lang.Integer">
<generator class="native" />
</id>

## <discriminator column="UserTypeID" type="java.lang.Integer" />
<property .... />

## <many-to-one name="usertypes" column="UserTypeID"/>

<subclass name="Doctors" discriminator-value="1" />
<subclass name="Patients" discriminator-value="2" />
</class>

<class name="UserTypes" table="usertypes">
<id name="usertypeid" column="UserTypeID"
type="java.lang.Integer">
<generator class="native" />
</id>
<property .... />
</class>
</hibernate-mapping>

I think the ## parts in the upper mapping file are not correct, becuase I duplicate the column "UserTypeID", but I have no idea how to handle that, can someone help me.

Thanks a lot
[/code][/quote]

change



to


next time use code tag