Yes. That looks good except you will also need to define the compound
primary key for the join table.
On 4/20/07, Paulo Henrique Trecenti <[EMAIL PROTECTED]> wrote:
Like that's
<Table tableName="RESERVE" typeName="Reserve">
<Column columnName="ID" propertyName="reserveID" primaryKey="true"
/>
<Column columnName="ROOM_ID" propertyName="roomID" />
<Column columnName="EMAIL" propertyName="email"/>
<Column columnName="DATEHOUR" propertyName="dateHour"/>
<Column columnName="REASON" propertyName="reasom"/>
</Table>
<Table tableName="EQUIPMENT" typeName="Equipment">
<Column columnName="ID" propertyName="equipmentID"
primaryKey="true"
generated="true" />
<Column columnName="NAME" propertyName="name" />
<Column columnName="QUANTITY" propertyName="quantity"/>
<Column columnName="TYPE" propertyName="type"/>
</Table>
<Table tableName="RESERVE_EQUIPMENTS" >
<Column columnName="RESERVE_ID" propertyName="reserveID" />
<Column columnName="EQUIPMENT_ID" propertyName="equipmentID" />
</Table>
<Relationship name="reserveEquipments" primaryKeyTable="RESERVE"
foreignKeyTable="RESERVE_EQUIPMENTS" many="true">
<KeyPair primaryKeyColumn="ID" foreignKeyColumn="RESERVE_ID" />
</Relationship>
<Relationship name="equipmentReserves" primaryKeyTable="EQUIPMENT"
foreignKeyTable="RESERVE_EQUIPMENTS" many="true">
<KeyPair primaryKeyColumn="ID" foreignKeyColumn="EQUIPMENT_ID" />
</Relationship>
2007/4/20, Kevin Williams <[EMAIL PROTECTED]>:
>
> Hello Paulo,
>
> The RDB DAS does not yet directly support many to many
relationships. YOu
> can work around this by using two 1:m relationships where both Reserve
and
> Equipment has 1:m relationship with Reserve_Equipment. So, you have to
> directly model the junction table.
>
> --Kevin
>
>
> On 4/20/07, Paulo Henrique Trecenti <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> > I'm try using the DAS Relationship but I can not undestand, in my case
I
> > try
> > make this
> >
> > _________ __________
> > | Reserve | *_________*| Equipment |
> > |________| | |__________|
> > |
> > _______|____________
> > | Reserve_Equipments |
> > |__________________ |
> >
> > Ok, one Reserve have many equipments, one equipment can be used by
many
> > Reservers then I have a relatonship many to many.
> > My config file is
> >
> > <Table tableName="RESERVE" typeName="Reserve">
> > <Column columnName="ID" propertyName="reserveID"
> primaryKey="true"
> > />
> > <Column columnName="ROOM_ID" propertyName="roomID" />
> > <Column columnName="EMAIL" propertyName="email"/>
> > <Column columnName="DATEHOUR" propertyName="dateHour"/>
> > <Column columnName="REASON" propertyName="reasom"/>
> > </Table>
> >
> > <Table tableName="EQUIPMENT" typeName="Equipment">
> > <Column columnName="ID" propertyName="equipmentID"
> > primaryKey="true"
> > generated="true" />
> > <Column columnName="NAME" propertyName="name" />
> > <Column columnName="QUANTITY" propertyName="quantity"/>
> > <Column columnName="TYPE" propertyName="type"/>
> > </Table>
> >
> > <Relationship name="reserveEquipments" primaryKeyTable="RESERVE"
> > foreignKeyTable="EQUIPMENT" many="true">
> > <KeyPair primaryKeyColumn="ID" foreignKeyColumn="EQUIPMENT_ID"
> />
> > </Relationship>
> >
> > This is correct ? If yes how I can insert into table
RESERVE_EQUIPMENTS
> > using DataObject with ChangeSummary ?
> >
> > --
> > Paulo Henrique Trecenti
> >
>
--
Paulo Henrique Trecenti
