java - 实体映射中的重复列，oneToMany 关系

Question

我正在尝试在两个表之间建立一对多关系。我有一个名为 users 的表，其中包含许多 user_history 条目。我在 mysql 中定义了这些表，并使用 intellij hibrernate 支持生成了实体。问题是，当我想在数据库中插入某些内容时，我收到以下错误实体映射中的重复列:com.UserHistoryEntity

用户:

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>

    <class name="com.UsersEntity" table="users" schema="" catalog="protein_tracker">
        <id name="id">
            <column name="id" sql-type="int" not-null="true"/>
        </id>
        <property name="name">
            <column name="name" sql-type="varchar" length="45" not-null="true"/>
        </property>
        <property name="total">
            <column name="total" sql-type="int" not-null="true"/>
        </property>
        <property name="goal">
            <column name="goal" sql-type="int" not-null="true"/>
        </property>
        <set name="userHistoriesById" inverse="true">
            <key>
                <column name="id_user" not-null="true"/>
            </key>
            <one-to-many not-found="ignore" class="com.UserHistoryEntity"/>
        </set>
    </class>
</hibernate-mapping>

用户历史记录:

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>

    <class name="com.UserHistoryEntity" table="user_history" schema="" catalog="protein_tracker">
        <id name="id">
            <column name="id" sql-type="int" not-null="true"/>
        </id>
        <property name="entryDate">
            <column name="entry_date" sql-type="datetime" not-null="true"/>
        </property>
        <property name="entry">
            <column name="entry" sql-type="varchar" length="45" not-null="true"/>
        </property>
        <property name="idUser">
            <column name="id_user" sql-type="int" not-null="true"/>
        </property>
        <many-to-one name="usersByIdUser" class="com.UsersEntity">
            <column name="id_user" not-null="true"/>
        </many-to-one>
    </class>
</hibernate-mapping>

如何解决这个问题？

Answer 1

将 usersByIdUser 的多对一映射标记为 insertable = false 和 updatetable = false。这使得关系只能由您映射的单个属性 idUser 进行管理。