[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Foreign key in a composite primary key

[jonathan12]

Hello,

I use an entity "Commentaire" with a composite primary key and in this key, I have a foreign key on another entity (Journal).


  | @NamedQueries( {
  | 	@NamedQuery(name="commentaire.findAll",
  | 				query="FROM Commentaire"),
  | 	@NamedQuery(name="commentaire.findByActivite",
  | 				query=	"FROM Commentaire " +
  | 						"WHERE actif = :activite"),
  | 	@NamedQuery(name="commentaire.findByDate",
  | 				query=	"FROM Commentaire " +
  | 						"WHERE date = :date"),
  | 	@NamedQuery(name="commentaire.findByGestionnaire",
  | 				query=	"FROM Commentaire " +
  | 						"WHERE gestionnaire = :gestionnaire"),
  | 	@NamedQuery(name="commentaire.findByMouvement",
  | 				query=	"FROM Commentaire " +
  | 						"WHERE annee = :annee AND journal.idJournal = :idJournal AND chrono = :chrono")
  | 						
  | })
  | @Entity
  | @IdClass(CommentairePk.class)
  | @Table(name="SCHEMA.COMMENTAIRE")
  | public class Commentaire implements Serializable {
  | 	private static final long serialVersionUID = -2679761258372320963L;
  | 	
  | 	private String annee;
  | 	private Journal journal;
  | 	private int chrono;
  | 	private String gestionnaire;
  | 	private Date date;
  | 	private String commentaire;
  | 	private Boolean actif;
  | 	private SysInfo sysInfo;
  | 	
  | 	@Id
  | 	public String getAnnee() {
  | 		return annee;
  | 	}
  | 	public void setAnnee(String annee) {
  | 		this.annee = annee;
  | 	}
  | 	
  | 	@ManyToOne(cascade={CascadeType.ALL})
  | 	@JoinColumn(name="IDJOURNAL")
  | 	@Id
  | 	public Journal getJournal() {
  | 		return journal;
  | 	}
  | 	public void setJournal(Journal journal) {
  | 		this.journal = journal;
  | 	}
  | 	
  | 	@Id
  | 	public int getChrono() {
  | 		return chrono;
  | 	}
  | 	public void setChrono(int chrono) {
  | 		this.chrono = chrono;
  | 	}
  | 	
  | 	@Id
  | 	public String getGestionnaire() {
  | 		return gestionnaire;
  | 	}
  | 	public void setGestionnaire(String gestionnaire) {
  | 		this.gestionnaire = gestionnaire;
  | 	}
  | 	
  | 	@Id
  | 	public Date getDate() {
  | 		return date;
  | 	}
  | 	public void setDate(Date date) {
  | 		this.date = date;
  | 	}
  | 
  | ....
  | }
  | 


But when I launch my test on this entity, I have this exception :
org.hibernate.QueryException: could not resolve property: idJournal

When I remove journal from the primary key, it's all right.

Someone has a solution ?

Thank you

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4076892#4076892

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4076892