Need help to correct @JoinColumn mapping in entity class with composite keys

[Jack Bush]

Hi All,

I am no longer able to deploy the Customer (OneToMany Unidirectional) entity class/bean after having setup composite primary key (@IdClass) as follows:

@Entity
@IdClass(CustomerPK.class)
public class Customer implements Serializable {
    
    @Id
    @Column(name="NUMBER")
    private int customerNumber;
    public int getCustomerNumber()
    {
	return customerNumber;
    }
    public void setCustomerNumber(int customerNumber)
    {
	this.customerNumber = customerNumber;
    }
 
    @Id
    @Column(name="LASTNAME")
    private String lastname;
    public String getLastname()
    {
	return lastname;
    }
    public void setLastname(String lastname)
    {
	this.lastname = lastname;
    }
    
    ....
 
    @OneToMany(cascade={CascadeType.ALL}, fetch=FetchType.EAGER)
    @JoinTable(name="CUSTOMER_HOBBY",
               joinColumns={@JoinColumn(name="CUSTOMER_ID")}, // no longer exist.
               inverseJoinColumns={@JoinColumn(name="HOBBY_ID")})
    private Collection<Hobby> hobbies = new ArrayList<Hobby>();
    public Collection<Hobby> getHobbies() 
    {
	return hobbies;
    }
    public void setHobbies(Collection<Hobby> hobbies)
    {
	this.hobbies = hobbies;
    }
    ......
}

public class CustomerPK implements java.io.Serializable {
    
   private int customerNumber;
   private String lastname;

   public CustomerPK() {}

   public CustomerPK(int customerNumber, String lastname)
   {
      this.customerNumber = customerNumber;
      this.lastname = lastname;
   }

    @Basic(optional = false)
    public int getCustomerNumber()
    {
	return customerNumber;
    }
    public void setCustomerNumber(int customerNumber)
    {
	this.customerNumber = customerNumber;
    }

    @Basic(optional = false)
    public String getLastname()
    {
	return lastname;
    }
    public void setLastname(String lastname)
    {
	this.lastname = lastname;
    }
    ....
}

Below is the application client output:

Deploying application in domain failed; Deployment ErrorException [TOPLINK-28018] (Oracle TopLink Essentials - 2.1 (Build b60e-fcs (12/23/2008))): oracle.toplink.essentials.exceptions.EntityManagerSetupException
Exception Description: predeploy for PersistenceUnit [TravelAgentDB-PU] failed.
Internal Exception: Exception [TOPLINK-7220] (Oracle TopLink Essentials - 2.1 (Build b60e-fcs (12/23/2008))): oracle.toplink.essentials.exceptions.ValidationException
Exception Description: The @JoinColumns on the annotated element [private java.util.Collection domain.Customer.hobbies] from the entity class [class domain.Customer] is incomplete. When the source entity class uses a composite primary key, a @JoinColumn must be specified for each join column using the @JoinColumns. Both the name and the referenceColumnName elements must be specified in each such @JoinColumn. -- Exception [TOPLINK-28018] (Oracle TopLink Essentials - 2.1 (Build b60e-fcs (12/23/2008))): oracle.toplink.essentials.exceptions.EntityManagerSetupException

I am running JDK 1.6.0_12, Glassfish v2.1 and Netbeans 6.5.1 on Windows XP platform.

I would appreciate if anyone could assist with completing the @JoinColumn and referenceColumnName since I am little baffled with JPA schema mapping still.

This question was posted at http://forums.sun.com/thread.jspa?threadID=5398528&tstart=0 but have not received any feedback so far.

Thanks in advance,

Jack