All repository item properties are described in the XML repository definition with <property> tags. You can explicitly map an item property to a database column name through the column-names attribute; otherwise, the property name and database column name are assumed to be the same. For example, you can map the login property to the login_name property as follows:

<property name="login" column-names="login_name" data-types="string"/>

The column-names attribute of a property specifies the database column that stores the property. Each property must also define its data type with the data-types attribute. In the case of a multi-column id property, the data-types attribute is a comma-separated list of data types, each entry of which corresponds to an entry in the column-names attribute. Each column can have a different data type. If no data type is specified, the string data type is used by default. The valid data type names and their Java and SQL representations are listed in the Data Type Correspondences section of SQL Repository Definition Tag Reference in the SQL Repository Reference chapter.

loading table of contents...