user manual

160 BES Developer’s Guide
Container-Managed Persistence in Borland Enterprise Server
.
.
<cmp2-info>
<cmp-field>
<field-name>orderNumber</field-name>
<column-name>ORDER_NO</column-name>
</cmp-field>
<cmp-field>
<field-name>line</field-name>
<column-name>LINE</column-name>
</cmp-field>
<cmp-field>
<field-name>item</field-name>
<column-name>ITEM</column-name>
</cmp-field>
<cmp-field>
<field-name>quantity</field-name>
<column-name>QUANTITY.QUANTITY</column-name>
</cmp-field>
<cmp-field>
<field-name>color</field-name>
<column-name>QUANTITY.COLOR</column-name>
</cmp-field>
<cmp-field>
<field-name>size</field-name>
<column-name>QUANTITY.SIZE</column-name>
</cmp-field>
Next, we specify the linking column between LINE_ITEM and QUANTITY by using a
<table-ref> element.
<table-ref>
<left-table>
<table-name>LINE_ITEM</table-name>
<column-list>
<column-name>LINE</column-name>
</column-list>
</left-table>
<right-table>
<table-name>QUANTITY</table-name>
<column-list>
<column-name>LINE</column-name>
</column-list>
</right-table>
</table-ref>
</cmp2-info>
</entity>
Specifying relationships between tables
To specify relationships between tables, you use the <relationships> element
in ejb-borland.xml. Within the <relationships> element, you define an <ejb-
relationship-role> containing the role's source (an entity bean) and a <cmr-