I have a Many-to-one CMR field setup.
M-Tracking to 1-Part
My Tracking bean is defined along the lines:
public abstract class TrackingBean
implements EntityBean {
....
public abstract void TrackingLocal.setPart(PartLocal part)
....
}
My Part bean has a Long primary key.
Problem is the Tracking table generated in Oracle 8.1.7
defines the column representing the 'part' foreign key
PART_ID as a BLOB rather than a NUMBER.
Does anyone have an explanation ? Plus a
fix!
Note: I am using JBoss 3.2.0. A fragment of my
ejb-jar.xml is provided below (I am using xdoclet to
generate this)
Thanks in advance!
---------------------------------------------------------
<ejb-relation >
<ejb-relation-name>trackingPart</ejb-relation-name>
<ejb-relationship-role >
<ejb-relationship-role-name>tracking-tracks-part</ejb-relationship-role-name>
Many
<relationship-role-source >
<ejb-name>Tracking</ejb-name>
</relationship-role-source>
<cmr-field >
<cmr-field-name>part</cmr-field-name>
</cmr-field>
</ejb-relationship-role>
<ejb-relationship-role >
<ejb-relationship-role-name>part-has-many-trackers</ejb-relationship-role-name>
One
<relationship-role-source >
<ejb-name>Part</ejb-name>
</relationship-role-source>
</ejb-relationship-role>
</ejb-relation>