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>