Hibernate: foreign key has the wrong number of columns

Question

I defined a many-to-many relationship between my user and permission entity classes. The user has a primary key consisting of the username and countyId, and my permission table has the usual integer identifier. The UserPermission table has three foreign keys as the primary key: username, countyId and permissionId.

Since this is an outdated database, I will not have the opportunity to do the right thing (™) and make an integer primary key for the user.

I defined many-to-many relationships like this in User.class:

@ManyToMany(targetEntity=Permission.class, cascade={ CascadeType.PERSIST, CascadeType.MERGE } ) @JoinTable(name="tblUserPermission", joinColumns = { @JoinColumn(name="username"), @JoinColumn(name="countyId") }, inverseJoinColumns = { @JoinColumn(name="permissionId") }) private Collection<Permission> permissions; 

Permission.class says the following:

 @ManyToMany( cascade = {CascadeType.PERSIST, CascadeType.MERGE}, mappedBy = "permissions", targetEntity = User.class ) private Collection<User> users; 

I thought this was the way to go, but when I launch my Spring context that uses Hibernate 3, I get:

 Caused by: org.hibernate.AnnotationException: A Foreign key refering com.mydomain.data.entities.User from com.mydomain.data.entities.Permission has the wrong number of column. should be 1 

How did I make a mistake in my annotation? It should be 2, not 1.

---

Update:

Arthur suggested adding the reference name ColumnName, but this gave me a new exception:

 Caused by: org.hibernate.AnnotationException: referencedColumnNames(username, countyId) of com.mydomain.data.entities.Permission.permissions referencing com.mydomain.data.entities.User not mapped to a single property 

At his request, follow the code: Permission.Class:

 package com.mydomain.data.entities; import java.io.Serializable; import java.util.Collection; import javax.persistence.*; import org.hibernate.annotations.ForeignKey; @Entity @Table(name = "tblPermission") public class Permission extends PublishableEntityImpl implements Serializable, Cloneable { private static final long serialVersionUID = 7155322069731920447L; @Id @Column(name = "PermissionId", length = 8, nullable = false) private String PermissionId = ""; @ManyToOne(fetch=FetchType.LAZY) @JoinColumn(name = "CountyId", nullable = false) @ForeignKey(name="FK_CountyID") private County county; @Column(name = "Permission", nullable = true) private Integer permission = 1; @ManyToMany( cascade = {CascadeType.PERSIST, CascadeType.MERGE}, mappedBy = "Permissions", targetEntity = Item.class ) private Collection<Item> items; @ManyToMany( cascade = {CascadeType.PERSIST, CascadeType.MERGE}, mappedBy = "Permissions", targetEntity = User.class ) private Collection<User> users; /** Getters and Setters **/ } 

and User.class

 package com.mydomain.data.entities; import java.util.*; import java.io.Serializable; import javax.persistence.*; import org.hibernate.annotations.ForeignKey; import org.hibernate.annotations.IndexColumn; import org.springframework.security.core.GrantedAuthority; import org.springframework.security.core.authority.GrantedAuthorityImpl; import org.springframework.security.core.userdetails.UserDetails; @Entity @Table(name = "tblUser") public class User extends PublishableEntityImpl implements Serializable, Cloneable { @Id @Column(name = "CountyId", nullable = false) private Integer countyId; @Id @Column(name = "Username", length = 25, nullable = false) private String username; @ManyToOne(fetch=FetchType.LAZY) @JoinColumn(name = "CountyId", nullable = false, insertable=false, updatable=false) @ForeignKey(name="FK_CountyID") private County county; @Column(name = "Name", length = 50, nullable = true) private String name; @Column(name = "Password", length = 30, nullable = true) private String password; @Column(name = "Role", nullable = false) private Integer role; @ManyToMany(targetEntity=Permission.class, cascade={ CascadeType.PERSIST, CascadeType.MERGE } ) @JoinTable(name="tblUserPermission", joinColumns = { @JoinColumn(name="Username", referencedColumnName="Username"), @JoinColumn(name="CountyId", referencedColumnName="CountyId") }, inverseJoinColumns = { @JoinColumn(name="PermissionId", referencedColumnName="PermissionId") }) private Collection<Permission> permissions; @OneToMany(fetch=FetchType.LAZY, mappedBy="county") @IndexColumn(name="version") private List<Version> versions; /** Getters and setters **/ } 

Greetings

Nick

Answer 1

To resolve the reference exception ColumnName

In user put

 @ManyToMany(cascade={CascadeType.PERSIST, cascadeType.MERGE}) private Collection<Permission> permissions; 

And in resolution

 @ManyToMany(mappedBy="permissions") @JoinTable(name="tblUserPermission", joinColumns={@JoinColumn(name="permissionId", referencedColumnName="permissionId")}, inverseJoinColumns={ @JoinColumn(name="username", referencedColumnName="username"), @JoinColumn(name="countyId", referencedColumnName="countyId")}) private Collection<User> users; 

Class userid

 public class UserId implements Serializable { private String username; private Integer countyId; // getter and setter's public boolean equals(Object o) { if(o == null) return false; if(!(o instanceof UserId)) return false; UserId id = (UserId) o; if(!(getUsername().equals(id.getUsername())) return false; if(!(getCountyId().equals(id.getCountyId())) return false; return true; } public int hachcode() { // hashcode } } 

Then in the User class put

 @Entity @Table(name="tblUser") @IdClass(UserId.class) public class User ... { @Id private String username; @Id private Integer countyId; } 

Yours faithfully,