An SQL content repository is an implementation of the Generic SQL Adapter. Its repository definition follows the SQL repository definition file syntax described in the SQL Repository Definition Tag Reference in the SQL Repository Reference chapter. In particular, an SQL content repository is characterized by the <item-descriptor> attributes described in the Content Item Attributes section.

Note the following points that are particular to SQL content repositories:

  • A repository that contains content items must include one item descriptor flagged with the folder and one or more item descriptors flagged with the content attributes of the <item-descriptor> tag in the SQL repository definition. See Folder and Content Item Descriptors.

  • The folder item descriptor and the content item descriptors must define properties that define the pathname of each folder and content item. These properties are used to retrieve the content item and identify the place of each folder or content item in the content repository’s hierarchical namespace. See Path and Item ID Attributes.