Hi everyone,

I got the following error at hibernate version 2.0.3 and I have no idea what does it mean??

net.sf.hibernate.MappingException: Repeated column in mapping for collection: com.accucast4.testcase5.Customer.recipients column: RC_C_ID
at net.sf.hibernate.collection.CollectionPersister.checkColumnDuplication(CollectionPersister.java:838)
at net.sf.hibernate.collection.CollectionPersister.<init>(CollectionPersister.java:214)
at net.sf.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:216)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:627)
at com.accucast4.customerdatasource.CustomerDataSourceConfigurationFactory.addSessionManagementHolder(CustomerDataSourceConfigurationFactory.java:62)
at com.accucast4.customerdatasource.CustomerDataSourceConfigurationFactory.retrieveDataSourceCfgHolder(CustomerDataSourceConfigurationFactory.java:85)
at com.accucast4.customerdatasource.CustomerDataSourceConfigurationFactory.getSession(CustomerDataSourceConfigurationFactory.java:107)
at com.accucast3.kernel.test.TestCustomerDataSourceConfiguration.getSession(TestCustomerDataSourceConfiguration.java:32)
at com.accucast3.kernel.Kernel.getSession(Kernel.java:62)
at com.accucast3.kernel.Kernel.main(Kernel.java:75)


Does anyone have any idea?? I have tried this mapping in version 2.0.2 and I have no problem on using it.

Here is the customer mapping file:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>

<class
name="com.accucast4.testcase5.Customer"
table="CUSTOMER"
>
<id
name="custId"
type="long"
column="CUST_ID"
>
<generator class="assigned" />
</id>
<property
name="firstName"
type="java.lang.String"
column="FIRST_NAME"
length="20"
/>

<!-- bi-directional one-to-many association to Recipient -->
<map
name="recipients"
lazy="true"
inverse="true"
cascade="all"
>
<key>
<column name="RC_C_ID" />
</key>
<composite-index class="com.accucast4.testcase5.RecipientPK">
<key-property name="rcDId" type="long" column="RC_D_ID" />
<key-property name="rcCId" type="long" column="RC_C_ID" />
</composite-index>
<one-to-many
class="com.accucast4.testcase5.Recipient"
/>
</map>
</class>
</hibernate-mapping>

Thanks..

Vivian Fonger

Column RC_C_ID is repeated, first as

and then right afterwards as part of a composite-index


I'm not an expert by any means but I think the <key> and <index> tags work together for a composite foreign key if that is what you are trying to do.

Oops! Sorry, I take that back, I was thinking about foreign keys while I was writing.

Duplication of columns b/w the <key> and <index> is not supported (it has never been supported, actually ... it just happened to "work" on certain databases.

If <key> and <index> is not supported, how should I represent the relationship between Customer and Recipient?? Recipient has a foreign key to customer (RC_C_ID) and the primary key is a composite key (RC_D_ID, RC_C_ID) and I want to use MAP instead of SET. How should I map customer and recipient??

It is supported, just not with duplicate columns, you can not use the same column for both the key and the index.



You should be able to use just RC_D_ID as the index.

If I understand correctly, each customer has a Map of recipients in which case the <key> tag on RC_C_ID would narrow down the recipients to just the ones with that customer ID and then you can index them by their ID which I am guessing is the RC_D_ID?

Let me know if that is not what you are trying to do.

It works.. Thanks