<!ELEMENT property (<derivation>?, (<option> | <attribute>)*)>
Parent: <item-descriptor>, <<table>>
A <property> tag can be a child of the <item-descriptor> tag or a <table> tag:
If a child of an <item-descriptor> tag,
<property>defines a transient property of the repository item. Because such a transient property is not associated with any database table, it is not stored when the repository item is updated in the database. Transient properties are readable and writable, but are not queryable. See the Transient Properties section of this chapter.If a child of a <table> tag,
<property>defines a persistent property in a repository item. A<property>tag that is a direct child of an<item-descriptor>tag defines a transient characteristic of a repository item. Because such a transient property is not associated with any database table, it is not stored when the repository item is updated in the database.
Attributes
Attribute | Description |
|---|---|
| The property name (required) |
| The caching mode for this property, one of the following:
A property’s caching mode supersedes the item descriptor’s caching mode. To restore the default caching mode, set |
| One or more of the following, separated by commas:
|
| Specifies a category that this property shares with other item properties. Item properties that belong to the same category can be grouped together in a user interface, rather than in alphabetical order according to their |
| If a resource bundle is specified for this property with the tag |
| The column name or names in the SQL database Default: value of |
| If |
| The |
| Required unless
See Data Type Mappings: Java and SQL in this section for information about how these values map to Java and SQL data types. |
| A default value for the property if none is supplied when the repository item is created. A default value cannot be set for multi-valued properties. |
| Optionally describes this property. Default: value of |
| If a resource bundle is specified for this property with the tag |
| Optional, used to identify the property in the user interface. Default: value of |
| If a resource bundle is specified for this property with the tag |
| The Java class name of a |
| Boolean Default: |
| Specifies a group shared with other properties so they can be loaded in the same You can set the group for a property to add or remove properties from these default groups. This gives you a simple way to optimize the SQL generated by the repository. |
| Boolean, if Default: |
| The If the value of this property is another repository item, specifies the item descriptor type of that repository item. Required if the |
| The Java class of a user-defined property. See User-Defined Property Types. Do not use this attribute for |
| Boolean, can be Default: |
| Boolean Default: |
| The Nucleus address of another repository, specifies that this property’s value refers to one or more repository items in the specified repository. If you specify a relative path, it is relative to this repository. See Linking between Repositories. |
| Boolean, must be set to Default: |
| The SQL type of the corresponding column if it is different from the default type for the |
| Boolean Default: |
| Typically used for XML file combination, where elements with the same ID are regarded as the same element. |
Data Type Settings
The data-type attribute in a <property> tag defines the data type of a repository item property. A data type can be a primitive type or refer to an item descriptor type. If you want to define a property that refers to another item, use the item-type attribute to refer to that item’s item descriptor.
For multi-valued types, set data-type to array, list, set, or map. If the elements referenced by this property are primitives or user-defined property types, set their data type with the component-data-type attribute. Note that the SQL repository does not support multi-valued properties that reference binary type elements. If a multi-valued property references repository items, specify their item type with the property’s component-item-type attribute. For user-defined properties, use the property-type attribute to specify the Java class of the property’s type.
Data Type Mappings: Java and SQL
The following table shows how the data-type attribute names for the primitive types correspond to Java object types and SQL data types. Some SQL data types vary according to your SQL implementation. You can explicitly specify a SQL data type mapping by setting the sql-type attribute.
data-type value | Java object type | Recommended SQL data type |
|---|---|---|
|
| none |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| none |
|
|
|
|
| none |
|
| none |
|
|
|
|
|
|
|
|
|
CLOB and BLOB constraints
If you plan to use BLOBs (Binary Large Objects) or CLOBs (Character Large Objects), be sure that your database and JDBC driver work with the data and queries you plan to use. Comparison queries (=, !=, <, <=, >, >=) do not work with BLOBs or CLOBs. Also, Oracle versions before 9.2 do not support pattern-match queries (CONTAINS, STARTS_WITH, ENDS_WITH) against CLOBs.
