为什么我的多级继承映射不能像我所期望的那样工作呢？

Question

我有以下实体映射：

// user.cfc
component persistent="true" table="user" discriminatorColumn="userTypeID" {

    property name="id" column="userID" fieldtype="id" generator="identity";
    property name="type" fieldtype="many-to-one" cfc="userType" fkcolumn="userTypeID";

}

// admin.cfc
component extends="user" persistent="true" table="admin" joincolumn="userID" discriminatorValue="3" {

    property name="id" column="adminID" fieldtype="id" generator="identity";

}

// employee.cfc
component extends="user" persistent="true" table="employee" joincolumn="userID" discriminatorValue="0" {

    property name="id" column="employeeID" fieldtype="id" generator="identity";

}

// manager.cfc
component extends="employee" persistent="true" table="manager" joincolumn="employeeID" discriminatorValue="1" {

    property name="id" column="managerID" fieldtype="id" generator="identity";

}

// intern.cfc
component extends="employee" persistent="true" table="intern" joincolumn="employeeID" discriminatorValue="2" {

    property name="id" column="internID" fieldtype="id" generator="identity";

}

根据Henry的建议，下面是生成的hbmxml文件：

<!-- user.hbmxml -->
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class entity-name="user" lazy="true"
        name="cfc:user" table="user">
        <id name="ID" type="int">
            <column name="userID"/>
            <generator class="identity"/>
        </id>
        <discriminator column="userTypeID"/>
        <many-to-one class="cfc:userType"
            column="userTypeID" insert="false" name="type" update="false"/>
    </class>
</hibernate-mapping>


<!-- admin.hbmxml -->
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <subclass discriminator-value="3" entity-name="admin"
        extends="cfc:user" lazy="true" name="cfc:admin">
        <join table="admin">
            <key column="userID"/>
        </join>
    </subclass>
</hibernate-mapping>


<!-- employee.hbmxml -->
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <subclass discriminator-value="0" entity-name="employee"
        extends="cfc:user" lazy="true" name="cfc:employee">
        <join table="employee">
            <key column="userID"/>
        </join>
    </subclass>
</hibernate-mapping>


<!-- manager.hbmxml -->
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <subclass discriminator-value="1" entity-name="manager"
        extends="cfc:employee" lazy="true" name="cfc:manager">
        <join table="manager">
            <key column="employeeID"/>
        </join>
    </subclass>
</hibernate-mapping>


<!-- intern.hbmxml -->
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <subclass discriminator-value="2" entity-name="intern"
        extends="cfc:employee" lazy="true" name="cfc:intern">
        <join table="intern">
            <key column="employeeID"/>
        </join>
    </subclass>
</hibernate-mapping>

如果映射中不清楚，关系如下：

user
 |- admin
 |- employee
  |- manager
  |- intern

目的是让type实体上的user属性由manager和intern实体的鉴别器值填充。employee的构造函数中有代码阻止它被直接实例化，所以user总是有一个type。

当从DB读取一些已经存在的数据时，整个映射工作良好。但是，当我尝试插入新记录时，会遇到问题。

假设所涉及的表已经填充了一些记录：

user
|---------------------|
| userID | userTypeID |
|---------------------|
| 1      | 1          |
| 2      | 2          |
| 3      | 2          |
| 4      | 3          |
|---------------------|

admin
|------------------|
| adminID | userID |
|------------------|
| 1       | 4      |
|------------------|

employee
|---------------------|
| employeeID | userID |
|---------------------|
| 1          | 1      |
| 2          | 2      |
| 3          | 3      |
|---------------------|

manager
|------------------------|
| managerID | employeeID |
|------------------------|
| 1         | 1          |
|------------------------|

intern
|-----------------------|
| internID | employeeID |
|-----------------------|
| 1        | 2          |
| 2        | 3          |
|-----------------------|

如果我要创建一个新的intern实体并将其持久化，我希望插入三条记录：

INSERT user ( userID, userTypeID ) VALUES ( 5, 2 )
INSERT employee ( employeeID, userID ) VALUES ( 4, 5 )
INSERT intern ( internID, employeeID ) VALUES ( 3, 4 )

但是，实际执行的SQL如下所示：

INSERT user ( userID, userTypeID ) VALUES ( 5, 2 )
INSERT employee ( employeeID, userID ) VALUES ( 4, 5 )
INSERT intern ( internID, employeeID ) VALUES ( 3, 5 ) -- using the new userID instead of the new employeeID

最后，实际问题是：

为什么当插入到intern中时，它使用的是userID而不是employeeID？这就好像Hibernate忽略了intern上的intern属性，只使用了来自employee的joincolumn。

Answer 1

Hibernate将在用户表中使用discriminatorColumn来构造"intern“对象，因此它使用userID而不是employeeID。