Hibernate version:3.2.6.ga, Hibernate EntityManager: 3.3.2 GA
Mapping documents:
I have a problem with mappings (Hibernate + JPA, many-to-many)
The schema as follows:
http://www.nabble.com/file/p16299222/entity.jpg
NormvativasIdiomas.java
Code:
@Column(name = "NID_TITOL", nullable = false)
private String nidTitol;
@Column(name = "NID_ENLLAC")
private String nidEnllac;
@JoinTable(name = "NORMATIVAS_PARAULES", joinColumns = {
@JoinColumn(name = "NOP_ID", referencedColumnName = "NID_ID"),
@JoinColumn(name = "NOP_IDIOMA", referencedColumnName =
"NID_IDIOMA")
},
inverseJoinColumns = {
@JoinColumn(name = "NOP_ID_PARAULE",
referencedColumnName = "PCA_ID")
,
@JoinColumn(name = "NOP_IDIOMA",
referencedColumnName = "PCA_ID_IDIOMA")
}
)
@ManyToMany()
private Collection<ParaulesClau> paraulesClauCollection;
paraulesClau.java
Code:
@EmbeddedId
protected ParaulesClauPK paraulesClauPK;
@Column(name = "PCA_NOM", nullable = false)
private String pcaNom;
@ManyToMany(mappedBy = "paraulesClauCollection")
private Collection<NormativaIdiomes> normativaIdiomesCollection;
Code between sessionFactory.openSession() and session.close():Code:
static
public java.util.List getListData(Class classBean, String strKey, Object value)
{
java.util.List result = new java.util.ArrayList();
Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(classBean);
if (strKey != null) {
criteria.add(Restrictions.like(strKey, value));
}
result = criteria.list();
tx.commit();
session.close();
return result;
}
Full stack trace of any exception that occurs:Code:
Hibernate Initialization Error
Repeated column in mapping for collection: cap.etributs.entity.NormativaIdiomes.paraulesClauCollection column: NOP_IDIOMA
org.hibernate.MappingException: Repeated column in mapping for collection: cap.etributs.entity.NormativaIdiomes.paraulesClauCollection column: NOP_IDIOMA
at org.hibernate.mapping.Collection.checkColumnDuplication(Collection.java:306)
at org.hibernate.mapping.Collection.checkColumnDuplication(Collection.java:329)
Name and version of the database you are using:Oracle 8i
I haven't any mapping hbm file.
Thanks!