Re[2]: anonymous fields

[Alexander Prozor]

Hello Raymond,
sure, I've defined this field in mapping.
there are ddl and repository_user.xml files from this project.

RB> Is "userDefinitionScreenID" a field defined in your mapping? ie. this
RB> has to be the name attribute of a field-descriptor definition. Something 
RB> like:
RB>       <field-descriptor
RB>          name="userDefinitionScreenID"
RB>          column="_idA"
RB>          jdbc-type="INTEGER"
RB>          access="anonymous"/>

RB> Maybe if you post the relevant sections of your repository_user.xml file 
RB> it could help identify the problem.



-- 
Best regards,
 Alexander                            mailto:[EMAIL PROTECTED]
   <class-descriptor
          class="efi.base.presentation.formdefinition.UserScreenDefinition"
          table="GUIComponentDefinitionTable"
   >
          <field-descriptor
        name="internal_id"
        column="internal_id"
        jdbc-type="INTEGER"
        primarykey="true"
        autoincrement="true"
        access="anonymous"
      />

      <field-descriptor
         name="name"
         column="name"
         jdbc-type="VARCHAR"
      />
      <field-descriptor
         name="type"
         column="type"
         jdbc-type="VARCHAR"
      />
      <field-descriptor
         name="id"
         column="id"
         jdbc-type="VARCHAR"
      />
      <field-descriptor
         name="value"
         column="value"
         jdbc-type="VARCHAR"
      />

          <collection-descriptor
         name="dataDefinitionRefs"
         element-class-ref="efi.base.presentation.formdefinition.DataDefinitionRef"
      >
         <inverse-foreignkey field-ref="userDefinitionScreenID"/>
      </collection-descriptor>
     
    <reference-descriptor
         name="rootControlDef"
         class-ref="efi.base.presentation.formdefinition.CompositeControlDefinition"
      >
         <foreignkey field-ref="userDefinitionScreenID"/>
      </reference-descriptor> 

   >
   </class-descriptor>
   


   <class-descriptor
          class="efi.base.presentation.formdefinition.DataDefinitionRef"
          table="DataDefinitionRefTable"
   >
          <field-descriptor
        name="internal_id"
        column="internal_id"
        jdbc-type="INTEGER"
        primarykey="true"
        autoincrement="true"
        access="anonymous"
      />

      <field-descriptor
         name="queryDefName"
         column="queryDefName"
         jdbc-type="VARCHAR"
      />
      <field-descriptor
         name="dataDefName"
         column="dataDefName"
         jdbc-type="VARCHAR"
      />
          <field-descriptor
        name="userDefinitionScreenID"
        column="userDefinitionScreenID"
        jdbc-type="INTEGER"
                access="anonymous"
      />
   </class-descriptor>


   <class-descriptor
          class="efi.base.presentation.formdefinition.CompositeControlDefinition"
          table="ControlDefinitionTable"
   >
          <field-descriptor
        name="internal_id"
        column="internal_id"
        jdbc-type="INTEGER"
        primarykey="true"
        autoincrement="true"
        access="anonymous"
      />

      <field-descriptor
         name="name"
         column="name"
         jdbc-type="VARCHAR"
      />
      <field-descriptor
         name="type"
         column="type"
         jdbc-type="VARCHAR"
      />
      <field-descriptor
         name="id"
         column="id"
         jdbc-type="VARCHAR"
      />
      <field-descriptor
         name="value"
         column="value"
         jdbc-type="VARCHAR"
      />

      <field-descriptor
         name="properties"
         column="properties_map"
         jdbc-type="VARCHAR"
         
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2Base64StringFieldConversion"
      />
      <field-descriptor
         name="dataDefName"
         column="dataDefName"
         jdbc-type="VARCHAR"
      />
      <field-descriptor
         name="modelReference"
         column="modelReference"
         jdbc-type="VARCHAR"
      />
          <field-descriptor
        name="userDefinitionScreenID"
        column="userDefinitionScreenID"
        jdbc-type="INTEGER"
                access="anonymous"
      />
          <field-descriptor
        name="selfReferenceID"
        column="selfReferenceID"
        jdbc-type="INTEGER"
                access="anonymous"
      />
          <collection-descriptor
         name="controls"
         
element-class-ref="efi.base.presentation.formdefinition.CompositeControlDefinition"
      >
         <inverse-foreignkey field-ref="selfReferenceID"/>
      </collection-descriptor>
   </class-descriptor>

CREATE TABLE GUIComponentDefinitionTable (
        internal_id INTEGER PRIMARY KEY,
        name  VARCHAR(52) NOT NULL,
        type  VARCHAR(52) NOT NULL,
        value VARCHAR(52) NOT NULL,
          id  VARCHAR(52) NOT NULL
);

CREATE TABLE DataDefinitionRefTable(
        internal_id INTEGER PRIMARY KEY,
        dataDefName VARCHAR(30) NOT NULL,
        queryDefName VARCHAR(30) NOT NULL,
        userDefinitionScreenID INTEGER,
        FOREIGN KEY (userDefinitionScreenID) REFERENCES 
GUIComponentDefinitionTable(internal_id )
);

CREATE TABLE ControlDefinitionTable (
        internal_id INTEGER PRIMARY KEY,
        name  VARCHAR(52) NOT NULL,
        type  VARCHAR(52) NOT NULL,
        value VARCHAR(52) NOT NULL,
          id  VARCHAR(52) NOT NULL,
        properties_map VARCHAR(4000),
        dataDefName VARCHAR(30) NOT NULL,
        modelReference VARCHAR(30) NOT NULL,
        userDefinitionScreenID INTEGER,
        selfReferenceID INTEGER,
        FOREIGN KEY (userDefinitionScreenID) REFERENCES 
GUIComponentDefinitionTable(internal_id )
);


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]