Sun Java System Application Server Platform Edition 8.1 2005Q2 Update 2 Developer's Guide

- Previous: column-name
- Next: commit-option

## column-pair

Specifies the pair of columns that determine the relationship between two database tables. Each `column-pair` must contain exactly two `column-name` subelements, which specify the column’s names. The first `column-name` element names the table that this bean is mapped to, and the second `column-name` names the column in the related table.

### Superelements

cmr-field-mapping, secondary-table (`sun-cmp-mappings.xml`)

### Subelements

The following table describes subelements for the `column-pair` element.

Table A–29 `column-pair` Subelements

Element | Required | Description
--- | --- | ---
column-name | two | Specifies the name of a column from the primary table, or the qualified table name (TABLE.COLUMN) of a column from a secondary or related table.

- Previous: column-name
- Next: commit-option

- © 2010, Oracle Corporation and/or its affiliates