The SQL repository template contains one <item-descriptor> tag for each set of repository items that have common attributes.

item-descriptor attributes

Attribute

Description

Value

name

The item descriptor name. Must be unique within the repository. If you want to refer to the same item descriptor with more than one name, set the itemDescriptorAliases property of the Repository component.

Required

display-name

The name of the item descriptor in the ATG Control Center interface. If no display-name is specified, the name attribute is used.

String

display-name-resource

If you specify a resource bundle for this item descriptor with the <attribute name=resourceBundle> tag, the display-name-resource attribute specifies the resource bundle key that holds the display name. See Localizing SQL Repository Definitions.

String

description

An optional attribute to describe purpose of the item descriptor.

Default: value of name

description-resource

If you specify a resource bundle for this item descriptor with the <attribute name=resourceBundle> tag, the description-resource attribute specifies the resource bundle key that holds the description of the item descriptor. See Localizing SQL Repository Definitions.

String

default

Is this the default item descriptor for this repository? The default item descriptor is used for newly created repository items if a different item descriptor is not specified. If no item descriptor is designated as the default, the first item descriptor in the repository definition file is the default.

Boolean
Default: false

super-type

The item descriptor from which this item descriptor inherits. See Item Descriptor Inheritance.

Optional. An item descriptor may have zero or one super-types.

sub-type-property

The name of a property of a parent item descriptor that specifies the names of its child item descriptors. See Item Descriptor Inheritance.

String

sub-type-value

The value of its parent’s sub-type-property that triggers use of this particular type. See Item Descriptor Inheritance.

String

copy-from

The item descriptor from which this item descriptor inherits by copying. See Item Descriptor Inheritance.

String

display-property

You can set this property to the name of a repository item property. A user interface can then represent the repository item with this property. For example, a profile item descriptor might use display-property="login". Then, each repository item is represented using the value of the item’s login property.

String

version-property

A property whose value is used as a version control mechanism for this item. This property must be an int data type. The property is incremented each time the item is updated.

String

id-separator

A character used to separate elements of a multi-column repository ID when the ID is string encoded.

Character.
Default: colon (:)

id-space-names

Set this to the name of the ID space to use for this item type. An item descriptor with a single-column repository ID uses the name of the item descriptor as the name of the ID space by default. An item descriptor with a multi-column repository ID uses the name of the primary table and the names of the ID column in that table by default. See IdSpaces and the id Property in the SQL Repository Data Models chapter and the ID Generators section of the Core Dynamo Services chapter of the ATG Programming Guide for more information about ID space names and how they affect the IDs of newly generated items.

String

hidden

Hidden item types are not displayed in the ATG Control Center.

Boolean
Default: false

expert

Set this to true if this item descriptor should only be displayed to expert users.

Boolean
Default: false

text-search-properties

If a text search query does not explicitly specify a property to search, the query searches this list of property names. See Text Search Queries in the SQL Repository Queries chapter.

A comma-separated list of property names.

cache-mode

The caching mode for this item descriptor. Caching can be disabled for a single property by setting its cache-mode attribute. See the SQL Repository Caching chapter.

One of disabled, simple, locked, distributed, distributedJMS, and distributedHybrid.
Default: simple.

item-cache-size

The maximum number of items belonging to this item descriptor to store in the item cache. When the number of items requested exceeds this number, the least recently accessed item is removed from the cache. See the SQL Repository Caching chapter.

Integer
Default: 1000.

item-expire-timeout

The maximum time in milliseconds that an entry can remain in the item cache before it is refreshed. See Cache Timeout for more information.

Integer
Default: 0, which means items remain in the cache indefinitely, until otherwise invalidated.

query-expire-timeout

The maximum time in milliseconds that an entry can remain in the query cache before it is refreshed. See Cache Timeout for more information.

Integer
Default: 0, which means items remain in the cache indefinitely, until otherwise invalidated.

item-cache-timeout

The time in milliseconds that an item cache entry can remain unused before it is removed from the cache. See the SQL Repository Caching chapter.

Integer
Default: 0—items remain in the cache indefinitely, until otherwise invalidated.

query-cache-size

The maximum number of queries of this item descriptor to store in the query cache. When the number of queries issued against this item descriptor exceeds this number, the least recently used query is removed from the cache. See the SQL Repository Caching chapter.

Integer
Default: 0, effectively disabling the query cache.

Content item-descriptor Attributes

The following set of <item-descriptor> tag attributes are used in content repositories. A content repository includes one item descriptor that manages the folder hierarchy, and one or more item descriptors that define content items. A content item has a property that specifies the item’s folder parent, and a property that is used to store or reference the content data itself. The content data property is usually a java.io.File, String or a byte[] data type. Items in the content item descriptor implement the ContentRepositoryItem interface. Items in the folder item descriptor implement the FolderItem interface, as well as the MutableRepositoryItem interface. For more detail, see the SQL Content Repositories chapter.

Attribute

Description

Value

content

Are the items defined by this item descriptor ContentRepositoryItems? If you set this to true, you must also define the folder-id-property attribute, the content-property attribute and one or more of content-name-property, content-path-property, and use-id-for-path.

Boolean
Default: false

folder

Are the items defined by this item descriptor FolderItems? There can be at most one folder item descriptor in each repository. If you set this to true, you must also define the folder-id-property attribute, the content-property attribute and one or more of content-name-property, content-path-property, and use-id-for-path.

Boolean
Default: false

content-name-property

Specifies the name of a property that defines the name of this content item or folder item in the folder hierarchy. Unlike content-path-property, the value of this attribute should not include any path separator characters or the names of any parent folders.

String

content-path-property

Specifies a property of this item that defines the absolute path name of this item in the folder hierarchy. This name should include a leading path separator character.

String

use-id-for-path

Set this to true if the Repository ID for this item is the relative path name of the item in the folder hierarchy. Use this attribute if the column used to store the content-path-property happens to be the primary key for the table containing the item.

Boolean
Default: false

folder-id-property

The name of the property that specifies the ID of the folder containing this folder or content item. Both content item descriptors and folder item descriptors must specify a folder-id-property.

String

content-property

The name of the property that defines the content of a ContentRepositoryItem. If the item descriptor uses the content="true" attribute, you must set this attribute.

The property type can be File, byte[] or String:

- If byte[] or String, content is stored in the database.

- If File, the content is retrieved from the file system with the FilePropertyDescriptor.

content-length-property

An optional attribute that specifies a property that contains the number of bytes in the content. This property is used by the getContentLength() method of the ContentRepositoryItem interface.

String

last-modified-property

An optional attribute that specifies a property that contains the last modified time for that piece of content. The property’s data type should be date or timestamp. This property is used by the getContentLastModified() method of the ContentRepositoryItem interface.

String

Versioned Repository item-descriptor Attribute

The versionable item-descriptor tag attribute in the SQL repository definition file DTD is used only in versioned repositories. Versioned repositories are a feature of ATG Content Administration and are described in the ATG Content Administration Programming Guide.

item-descriptor child tags

Child tag

How many?

property

zero or more

table

zero or more

attribute

zero or more

rql-filter

zero or one

named-query

zero or more

If a <property> tag appears as a direct child of an <item-descriptor> tag (rather than a child of a <table>tag), the property is a transient property of the repository item and is not stored persistently in the database. Transient properties are readable and writable, but cannot be made queryable. See the Transient Properties section of this chapter.

 
loading table of contents...