1 Reply Latest reply on Nov 14, 2002 8:50 PM by Stephen Coy

    Composite Primary Key EJB-JAR.XML

    Kevin Urciolo Newbie

      Simple question:

      How do you specify composite primary keys in EJB-JAR.XML. My example looks something like this:

      <prim-key-class>org.cmis.j2ee.ejb.registration.OperatorPK</prim-key-class>
      False
      <cmp-version>2.x</cmp-version>
      <abstract-schema-name>Operator</abstract-schema-name>
      <cmp-field><field-name>name</field-name></cmp-field>
      <cmp-field><field-name>id</field-name></cmp-field>

      However, JBoss produces this error:

      "invalid column name" when executing

      CREATE TABLE OPERATOREJB (name VARCHAR2(255), COGID NUMBER(10) NOT NULL, CONSTRAINT PK_OPERATOREJB PRIMARY KEY ())