Many-to-one mapping issue

[Alana Sparx]

Hi all

I'm writing a hibernate mapper for an existing database, and only need to use a handful of objects from this db.

When I run my test, I keep getting the following error:
Foreign key (FK5E0F67F881B2AA8:group [group_code]))
must have same number of columns as the
referenced primary key (group [ec_env,group_code])

The group.hbm.xml lookslike

<hibernate-mapping>
  <class
    name="com.model.billing.Group"
    table="group"
    >
    <composite-id >
      <key-property name="enviromentCode" column="ecEnv" />
      <key-property name="groupNumber" column="groupCode" />
    </composite-id>
    <property
      name="webBill"
      column="webBill"
      update="false"
    />
  </class>    
</hibernate-mapping>

The group model object & xdoclet tags looks like:

 
public class Group extends BillingObject implements Serializable{
 
  protected final Log LOG = LogFactory.getLog(this.getClass());

  private Boolean webBill;
  private String groupNumber;
  private String enviromentCode;
  private Set<Bill> bills = new LinkedHashSet<Bill>();
  private Set<CcRecipient> recipients = new LinkedHashSet<CcRecipient>();

    /**
     * @hibernate.set
     *     table="ccrecipient"
     *      lazy="true"
     *      inverse="true"
     *      cascade="all"
     * @hibernate.key
     *      column="groupCode"
     * @hibernate.many-to-many
     *     column="groupCode"
     *      class="com.model.billing.CcRecipient"
     */
    public Set<CcRecipient> getCcRecipient() { return this.recipients; }
    public void setCcRecipient(Set<CcRecipient> recipients) { LOG.warn("adding recipients to Billing database is disabled"); }
    public void addCcRecipient(CcRecipient recipient) {
        
        LOG.warn("adding new recipient to Billing database is disabled");
    }
 


/**       
     * @hibernate.set
     *      lazy="true"
     *      inverse="true"
     *      cascade="all"
     * @hibernate.key
     *      column="groupCode"
     * @hibernate.one-to-many
     *      class="com.model.billing.Bill"
     */
    public Set<Bill> getBills() { return this.bills; }
    public void setBills(Set<Bill> bills) { LOG.warn("adding bills to          Billing database is disabled"); }
    public void addBill(Bill bill) {
        
        LOG.warn("adding new bill to Billing database is disabled");
    }
 

/**       
     * @hibernate.composite-id 
     */
    public String getEnviromentCode() {return enviromentCode;}
    public void setEnviromentCode(String enviromentCode) { this.enviromentCode = enviromentCode;}
    
    /**       
     * @hibernate.composite-id
     */
public String getGroupNumber() {return groupNumber;}
public void setGroupNumber(String groupNumber) {this.groupNumber = groupNumber;}
   

The composite key of group is a foreign key of two other db objects that I haven't modelled, could this be the issue?

[Shailesh Kini]

Hi Alana,

From what I understand you have a composite key as a primary key for your Group Entity. If CcRecepient has a foreign key constraint on Group it has be be on both those keys(group_code and ecEnv). The composite key defines uniqueness in our Group table. I think you cannot just use groupCode but should use the composite key.

Hope this helps.