Re: Problem with n:m association

[Thomas Franke]

Thomas Papke wrote:
Did you use a Non-Decomposed mapping or manual-decomposing mapping with 
a object as relation 
We use non-decomposed mappings and haven't any mappings for the 
intersection tables.
Do you have one or more mappings for your tables?
Sometimes there are problems, when there are differences between the 
mappings for the same table.

Here is one example:
<class-descriptor
class="de.mhr.wis.DBAdapter.rawdata.masterdata.AdressIdAndName"
table="adressen"
>
 <field-descriptor id="1"
  name="adressen_id"
  column="adressen_id"
  jdbc-type="INTEGER"
  primarykey="true"
  autoincrement="true"
  access="readonly"
  sequence-name="ADRESSEN_ID_SEQ"
  />
  <field-descriptor id="2"
   name="name"
   column="name"
   jdbc-type="VARCHAR"
   nullable="true"
   />
 <collection-descriptor
  name="adressarten"
  collection-class=
    "org.apache.ojb.broker.util.
     collections.ManageableArrayList"
  element-class-ref=
    "de.mhr.wis.DBAdapter
    .ojbAdapter.administration.OjbAdressart"
  auto-retrieve="false"
  auto-update="false"
  indirection-table="adressen_adressart"
  >
  <fk-pointing-to-this-class column="adressen_id"/>
  <fk-pointing-to-element-class column="adressart_id"/>
 </collection-descriptor>
</class-descriptor>
<class-descriptor
                
class="de.mhr.wis.DBAdapter.ojbAdapter.administration.OjbAdressart"
                table="adressart"
        >
                <field-descriptor
                        name="adressartId"
                        column="adressart_id"
                        jdbc-type="INTEGER"
                        primarykey="true"
                        autoincrement="true"
                        access="readonly"
                        sequence-name="ADRESSART_ID_SEQ"
                />
                <field-descriptor
                        name="adressartName"
                        column="adressart_name"
                        jdbc-type="VARCHAR"
                        nullable="true"
                />
                <field-descriptor
                        name="adresstypName"
                        column="adresstyp_name"
                        jdbc-type="VARCHAR"
                        nullable="true"
                />
                <field-descriptor
                        name="adressart"
                        column="adressart"
                        jdbc-type="INTEGER"
                        nullable="true"
                />
                <field-descriptor
                        name="adresstyp"
                        column="adresstyp"
                        jdbc-type="INTEGER"
                        nullable="true"
                />
                
        </class-descriptor>
regards
Thomas


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