Sorry, 

I forgot to describe that tables that I think will be required.
SIDDefinitions
        sidID   int primary key (database generated)
        definiitons blob

SIDName
        sidID   name primary key

SIDValue        
        sidID   int
        fieldName       String
        fieldValue      String
        primary key (sidID, fieldName)

Thanks,
Vidur   

Hello,

I need some help with OR mapping a CMP EntityBean.  I'm not even sure
how to do this in BMP.  The class is called SIDDefinitions. The primary
key is a class called SID and there is only one other field called
definitions -- it is a List of Definition.  Definition is an interface
and the application allows arbitrary implementations of that interface.
The primary key class, SID, has two members -- String name and a List
fields.  The elements of List are another class -- Field.  Field has two
String members -- name and value.  A schematic would look like:
SIDDefinitions
    SID
        String name
        List <Field>
            String name
            String value
    List <Definition>

How do I even begin to map this to relations?  I'm restricted to EJB
1.1.  Does anyone recognize a pattern that I can use?  Please help, I'm
totally stumped by this.

Thanks,
Vidur

Reply via email to