0 Replies Latest reply on May 13, 2003 11:28 PM by dab

    Why are my CMR fields generated as BLOBs?

    dab Newbie

      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>