Hibernate Repeated column mapping problem

[Vince Lee]

hi, I'm new to Hibernate, and I'm running into a bit of problem when specifying my mappings.

Currently I have a UserBean class:

 
public class UserBean {
 
private Integer userID;
private String username;
private String password;
private String firstname;
private String lastname;
private String email;
private Integer privilege;
private HashSet events = new HashSet();
private HashSet loans = new HashSet();
private HashSet rankings = new HashSet();
...
}

and my UserBean mapping file looks like:

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

<hibernate-mapping>
<class name="com.uwa.beans.UserBean" table="tblUser">
<id name="userID" column="userID">
<generator class="native"/>
</id>
<property name="username"/>
<property name="password"/>
<property name="firstname"/>
<property name="lastname"/>
<property name="email"/>
<property name="privilege"/>

<set name="events" table="tblParticipate" inverse="true">
<key column="userID"/>
<many-to-many column="eventID" class="com.uwa.beans.EventBean"/>
</set>
<set name="loans" inverse="true">
<key column="userID"/>
<one-to-many class="com.uwa.beans.LoanBean"/>
</set>
<set name="rankings" inverse="true">
<key column="userID"/>
<one-to-many class="com.uwa.beans.RankingBean"/>
</set>
</class>
</hibernate-mapping>

my RankingBean class looks like:

 
public class RankingBean {
 
private Integer jobID;
private Integer userID;
private Integer companyRank;
private Integer userRank;
private UserBean submitter;
...
}

and RankingBean's mapping file is:

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

<hibernate-mapping>
<class name="com.uwa.beans.RankingBean" table="tblRanking">
<composite-id>
<key-property name="jobID"/>
<key-property name="userID"/>
</composite-id>
<property name="companyRank"/>
<property name="userRank"/>

<many-to-one name="submitter" column="userID"/>
</class>
</hibernate-mapping>

so, the error i'm getting says :

INFO - Reading mappings from resource: com/uwa/beans/UserBean.hbm.xml
INFO - Mapping class: com.uwa.beans.UserBean -> tblUser
INFO - Mapping collection: com.uwa.beans.UserBean.events -> tblParticipate
INFO - Configured SessionFactory: null
INFO - Mapping collection: com.uwa.beans.UserBean.loans -> tblLoan
INFO - Mapping collection: com.uwa.beans.UserBean.rankings -> tblRanking
org.hibernate.MappingException: Repeated column in mapping for entity: com.uwa.beans.RankingBean column: userID (should be mapped with insert="false" update="false")
at org.hibernate.mapping.PersistentClass.checkColumnDuplication(PersistentClass.java:605)
...


I'm wondering if someone could tell me what the error is, because I seem to already have duplicated column="userID" in the events and loans collection mapping and it didn't complain there? thanks

[ October 30, 2006: Message edited by: Vince Lee ]

[Edited to include code tags - Paul Sturrock]
[ October 30, 2006: Message edited by: Paul Sturrock ]

[pascal betz]

Parsing of the config files stops after the first error is encountered. If you fix the first problem then hibernate will complain about the next error (if there are more).

- for the events/loans/rankins collections hibernate will create a column named "userId" in the events/loans/rankins tables, not in the user table. so there is no problem with duplicated columns in the user table
- it looks like the problem occur because your FK to user is also part of the PK in the rankins table
- (if not required then) do not use a composite key, use a surrogate key. easier to manage, map, code, query and so on.


pascal

[Mark Spritzler]

"userID (should be mapped with insert="false" update="false")"

This is related to mapping relationships. Just add the above(insert="false" update="false") to your userID mapping, and that should get it to work.

Mark

[Anand Wadhwani]

I'm also having this problem.
And when I try to add these attributes to the JoinColumn annotation in my JPA POJO, I get error that these are not valid attributes of JoinColumn annotation.
I'm going to try the insertable, and updatable attributes and see if that helps.
Mean while if anyone has any pointers, please share.

[Anand Wadhwani]

Hey there!
After adding insertable, updatable attributes to JoinColumn annotation, it resolved the problem.
Thank you, you guys are awesome!