0 Replies Latest reply on Aug 22, 2007 10:28 AM by Jonathan Courtoy

    Foreign key in a composite primary key

    Jonathan Courtoy Newbie

      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