1 Reply Latest reply on Sep 19, 2002 2:39 PM by Dain Sundstrom

    MAPPING IDENTIFYING RELATIONSHIPS

    Gianluca Chini Newbie

      Hi, I can't map identifying relationship.

      I have problems with foreign key fields that are also primary key.
      Jboss seems to work improperly in this case. In fact in the SQL command treats the CMP field of the relation as a column in the database that throws an exception (column not found).
      For example consider a superclass person that is mapped on a table person wich has a PK field called PERSON_ID.
      Another class Employee extends person and is mapped on the table EMPLOYEE that has a field PERSON_ID that is both PK and FK (to the table PERSON).
      This is the SQL comnmand in the log:
      SELECT PERSON_ID, OWN_NUMBER, person FROM EMPLOYEE

      Thank you