[news.eclipse.rt.eclipselink] Converting from Hibernate composite-elemen

[david1260@xxxxxxxxx (David J Rericha)]

Dear members,

I cannot seem to figure out how to convert composite-element mappings from 
Hibernate to JPA (I am using xml rather than annotations).  The senario 
should not be too uncommon:  I have patient entities in a many-to-many 
association with diagnosis (Icdm) entities.  However, the join table, 
patient_icdm, needs to have additional qualifying fields, i.e. sequence, 
date of diagnosis, etc.  The only way I have seen to do this in JPA is to 
map the PersonIcdm object as an entity.  The current table created with 
the composite-element mapping does not have a primary key ( Hibernate 
creates a run-time composite-primary-key for deletes comprised of all the 
fields of the composite-element ).  In order to do this in JPA, the 
elements of the primary-key class have to be primitives or 
primitive-wrappers, or Dates.  But this join-object is joining entities: 
Person and Diagnosis.  How do I go about this? Here are my objects and 
mappings:

public class Patient implements Serializable
{
 private long id;
 private String firstName;
 private String lastName;
 private Address address;
 private List<PatientIcdm> PatientIcdms = new ArrayList<PatientIcdm>();
 private static final long serialVersionUID = 1L;

 public Patient()
 {
   super();
 }

 public long getId()
 {
   return this.id;
 }

 public void setId( long id )
 {
   this.id = id;
 }

 public String getFirstName()
 {
   return this.firstName;
 }

 public void setFirstName( String firstName )
 {
   this.firstName = firstName;
 }

 public String getLastName()
 {
   return this.lastName;
 }

 public void setLastName( String lastName )
 {
   this.lastName = lastName;
 }

 public Address getAddress()
 {
   return this.address;
 }

 public void setAddress( Address address )
 {
   this.address = address;
 }

 public String toString()
 {
   return firstName + " " + lastName;
 }

 public List<PatientIcdm> getPatientIcdms()
 {
   return patientIcdms;
 }

 public void setPatientIcdms( List<PatientIcdm> patientIcdms )
 {
   this.patientIcdms = patientIcdms;
 }
}

public class PatientIcdm
{
 private int sequence;
 private Patient patient;
 private Icdm icdm;
 
 public int getSequence()
 {
   return sequence;
 }
 public void setSequence( int sequence )
 {
   this.sequence = sequence;
 }
 public Patient getPatient()
 {
   return patient;
 }
 public void setPatient( Patient Patient )
 {
   this.patient = patient;
 }
 public Icdm getIcdm()
 {
   return icdm;
 }
 public void setIcdm( Icdm icdm )
 {
   this.icdm = icdm;
 }
}

public class Icdm
{
 private int icdmId;
 private String name;
 private String description;
 
 public String getName()
 {
   return name;
 }
 public void setName( String name )
 {
   this.name = name;
 }
 public String getDescription()
 {
   return description;
 }
 public void setDescription( String description )
 {
   this.description = description;
 }
 public int getIcdmId()
 {
   return icdmId;
 }
 public void setIcdmId( int icdmId )
 {
   this.icdmId = icdmId;
 }
}

hibernate.hbm.xml:

<bag name="patientIcdms" table="patient_icdm" 
cascade="save-update,delete,evict,refresh" order-by="paticdm_seq_nbr">
     <key column="paticdm_pat_id"/>
     <composite-element class="com.moms.models.PatientIcdm">
       <many-to-one name="icdm" column="paticdm_icdm_id" 
class="com.moms.models.Icdm" cascade="save-update,evict,refresh"/>
       <property name="sequence" column="paticdm_seq_nbr" type="int"/>
     </composite-element>
</bag>

orm.xml:

<entity-mappings>
<entity class="quickstart.demo.model.Person" access="PROPERTY">
   <table name="person">
   </table>
   <attributes>
     <id name="id">
     	<column name="person_id"/>
       <generated-value generator="person_seq" strategy="SEQUENCE" />
       <sequence-generator name="person_seq" allocation-size="1" 
initial-value="1" />
     </id>
     <basic name="firstName">
     </basic>
     <basic name="lastName">
     	<column column-definition="type text"/>
     </basic>
     <many-to-one name="address" fetch="LAZY">
       <join-column name="address_id" referenced-column-name="address_id" 
/>
       <cascade>
         <cascade-all />
       </cascade>
     </many-to-one>
   </attributes>
 </entity>

 <entity class="quickstart.demo.model.Icdm" access="PROPERTY">
   <table name="icdm"></table>
   <attributes>
     <id name="icdmId">
       <column name="icdm_id" />
       <generated-value generator="icdm_seq" strategy="SEQUENCE" />
       <sequence-generator name="icdm_seq" allocation-size="1" 
initial-value="1" />
     </id>
     <basic name="name" />
     <basic name="description" />
   </attributes>
 </entity>
 
</entity-mappings>