java - hibernate 映射中的另一个重复列

Question

Hibernate 给了我以下异常

 org.hibernate.MappingException: Repeated column in mapping for entity: Pricelist column: ID_OFFER (should be mapped with insert="false" update="false")

但我确实找不到对 ID_OFFER 的重复引用。这是涉及的两个映射文件。

Offer.hbm.xml

<hibernate-mapping>
 <class name="Offer" table="OFFERS">
  <id name="idOffer" type="java.lang.Long">
   <column name="ID_OFFER" not-null="true" precision="10" scale="0"
    sql-type="NUMBER" unique="true"/>
   <generator class="native">
    <param name="sequence">OFFERS_SEQ</param>
   </generator>
  </id>
  <property generated="never" lazy="false" name="name" type="string">
   <column name="name" not-null="true" sql-type="VARCHAR2" unique="true"/>
  </property>
  <set name="pricelists" sort="unsorted" table="PRICELISTS">
   <key not-null="true">
    <column name="ID_OFFER" not-null="true" precision="10" scale="0" sql-type="NUMBER"/>
   </key>
   <one-to-many class="Pricelist"/>
  </set>
 </class>
</hibernate-mapping>

Pricelist.hbm.xml

<hibernate-mapping>
 <class name="Pricelist" table="PRICELISTS">
  <id name="idPricelist" type="java.lang.Long">
   <column name="ID_PRICELIST" not-null="true" precision="10" scale="0" sql-type="NUMBER"/>
   <generator class="native">
    <param name="sequence">PRICELISTS_SEQ</param>
   </generator>
  </id>
  <property name="name" type="string">
   <column length="255" name="NAME" not-null="true" sql-type="VARCHAR2"/>
  </property>
  <property name="versionMajor" type="integer">
   <column name="VERSION_MAJOR" not-null="true" precision="5" scale="0" sql-type="NUMBER"/>
  </property>
  <property name="versionMinor" type="integer">
   <column name="VERSION_MINOR" not-null="true" precision="5" scale="0" sql-type="NUMBER"/>
  </property>
  <many-to-one class="Offer" name="offer">
   <column name="ID_OFFER" not-null="true" precision="10" scale="0" sql-type="NUMBER"/>
  </many-to-one>
  <many-to-one class="PricelistStatus" name="status">
   <column name="ID_STATUS_PRICELIST" not-null="true" precision="10"
    scale="0" sql-type="NUMBER"/>
  </many-to-one>
  <property name="validFrom" type="calendar">
   <column name="INIT_TIMESTAMP" not-null="true" scale="6" sql-type="TIMESTAMP"/>
  </property>
  <property name="validUntil" type="calendar">
   <column name="END_TIMESTAMP" not-null="false" scale="6" sql-type="TIMESTAMP"/>
  </property>
 </class>
</hibernate-mapping>

我要疯了。任何人都可以看到应该在哪里重复对 ID_OFFER 列的引用吗？请注意:我的架构的两个表都有一个名为这样的列:OFFERS.ID_OFFER，它是表 OFFERS 和 PRICELIST.ID_OFFER 的主键，它有一个外键约束，显然引用了 OFFERS.ID_OFFER。

Answer 1

您忘记将此列映射为拥有方(Offer.hbm.xml 文件)

<set name="pricelists" sort="unsorted" table="PRICELISTS">
   <key not-null="true">
      <column name="ID_OFFER" not-null="true" precision="10" scale="0" sql-type="NUMBER"/>
   </key>
   <one-to-many class="Pricelist"/>
</set>

它应该看起来像(看看inverse="true"):

<set name="pricelists" sort="unsorted" table="PRICELISTS" inverse="true">
   <key not-null="true">
      <column name="ID_OFFER" not-null="true" precision="10" scale="0" sql-type="NUMBER"/>
   </key>
   <one-to-many class="Pricelist"/>
</set>