4个表,用户表:user(userID、userName),用户组:group(groupID、ownerID),标签表:label(labelID、labelName),用户组分类:category(groupID、ownerID、cateID)。表关系图:使用 hibernate-3.3.2.GA + HibernateSynchronizer-3.1.9出错提示:
Messages:
Foreign key (FK302BCFEBC02C5B5:category [groupID])) must have same number of columns as the referenced primary key (group [ownerID,groupID])
File: org/hibernate/mapping/ForeignKey.java
Line number: 113请教怎么解决这个问题!多谢多谢!
Messages:
Foreign key (FK302BCFEBC02C5B5:category [groupID])) must have same number of columns as the referenced primary key (group [ownerID,groupID])
File: org/hibernate/mapping/ForeignKey.java
Line number: 113请教怎么解决这个问题!多谢多谢!
实例:用户u01,创建两个群组g01、g02,群组g01里有两个分类c01、c02,群组g02里有三个分类g02、g03、g04。用户u02,创建一个群组g03,群组g03里有两个分类c01、c04。
<hibernate-mapping package="models">
<class name="Category" table="category">
<meta attribute="sync-DAO">true</meta>
<composite-id>
<key-many-to-one name="groupID" class="Group" column="groupID" />
<key-many-to-one name="ownerID" class="Group" column="ownerID" />
<key-many-to-one name="cateID" class="Label" column="cateID" />
</composite-id>
</class>
</hibernate-mapping>Group.hbm.xml文件:
<hibernate-mapping package="models">
<class name="Group" table="group">
<meta attribute="sync-DAO">true</meta>
<composite-id>
<key-many-to-one name="groupID" class="Label" column="groupID" />
<key-many-to-one name="ownerID" class="User" column="ownerID" />
</composite-id>
</class>
</hibernate-mapping>