SQL Repository Reference

This chapter includes reference information about the SQL repository:

SQL Repository Definition Tag Reference
DTD for SQL Repository Definition Files
Sample SQL Repository Definition Files
Configuring the SQL Repository Component

ATG Repository Guide

Documentation Home

Contents
Search

loading table of contents...

Introduction
Repository API
- Repository Architecture
- Repository Items
- Item Descriptors
- MutableRepository
- Core Repository API Elements
- Cloning Repository Items
Repository Queries
- Repository Query API
  - atg.repository.QueryBuilder
  - atg.repository.QueryOptions
- Repository Query Examples
- Repository Queries in the ATG Control Center
- Repository Query Language
SQL Repository Overview
SQL Repository Architecture
- Repositories and Transactions
  - Managing Transactions
- Repository Definition Files
  - Default Values and XML File Combination
- SQL Repository Items
- SQL Repository Item Descriptors
SQL Repository Data Models
- Primary and Auxiliary Tables
- id Property
- Auxiliary Tables
  - References Constraints
- Properties and Database Columns
- One-to-Many Relationships: Multi-Valued Properties
- Operating on Multi-Valued Properties
- Many-to-Many Relationships
- Default Item Descriptor
- Cascading Data Relationships
- Item Descriptor Inheritance
- Derived Properties
- Repository Items and Session Backup
SQL Repository Item Properties
- Enumerated Properties
  - enumerated
  - enumerated String
- Required Properties
- Unique Properties
- Date and Timestamp Properties
  - Last-Modified Properties
- Null Properties
- Grouping and Sorting Properties
- Property Validation with a Property Editor Class
- Maintaining Item Concurrency with the Version Property
- Repository Items as Properties
- Transient Properties
- Assigning FeatureDescriptorValues with the <attribute> Tag
  - Attributes Used in the ACC
- Linking between Repositories
- SQL Types and Repository Data Types
- User-Defined Property Types
- Property Fetching
- Handling Large Database Columns
SQL Repository Queries
- Repository Filtering
  - <rql-filter>
  - filterQuery and rqlFilterString Properties
- Overriding RQL-Generated SQL
- Parameterized Queries
- Named Queries
  - Named Queries in an SQL Repository Definition File
  - Java Code Access to Named Queries
- Text Search Queries
  - Simulating Text Search Queries
- Wildcards in Queries
- Not Queries and Null Values
- Outer Joins
- Table Ownership Issues
  - Constraints
  - Setting Ownership at the Repository Level
- Unsupported Queries in the SQL Repository
Localizing SQL Repository Definitions
- Defining a Resource Bundle
- Localizing Properties
- Localizing Enumerated Properties
SQL Repository Caching
- Item and Query Caches
  - Item Caches
  - Query Caches
- Caching Modes
- Simple Caching
- Locked Caching
- Distributed Caching Modes
  - Simple versus Distributed Caching
  - Distributed Caching Mode Options
- Distributed TCP Caching
- Distributed JMS Caching
  - Distributed JMS Caching Setup
- Distributed Hybrid Caching
- Distributed External Caching
- Cache Configuration
- Monitoring Cache Usage
- Caching by Repository IDs
- Restoring Item Caches
- Preloading Caches
- Enabling Lazy Loading
- Cache Flushing
- Cache Invalidation Service
External SQL Repository Caching
- Choosing Repository Items for External Caching
- Configuring Repository Items for External Caching
- External Cache Naming
- External Caching Statistics
Developing and Testing an SQL Repository
- Adding Items
- Updating Items
- Removing Items
  - Removing References to Items
- Querying Items
- Importing and Exporting Items and DDLs
- startSQLRepository
- Using Operation Tags in the Repository Administration Interface
- Debug Levels
- Modifying a Repository Definition
SQL Repository Reference
- SQL Repository Definition Tag Reference
- DTD for SQL Repository Definition Files
- Sample SQL Repository Definition Files
- Configuring the SQL Repository Component
  - Registering a Content Repository
  - SQL Repository Component Properties
SQL Content Repositories
- Setting Up an SQL Content Repository
- Creating an SQL Content Repository Definition
- Content Repository Example
- Configuring an SQL Content Repository
Repository Loader
- Repository Loader Architecture
- Repository Loader Components
- Repository Loader Administration
- RLClient
- Importing Versioned Repository Data
- Repository Loader Example
Repository Web Services
- GetRepositoryItem Web Service
- PerformRQLQuery Web Service
- PerformRQLCountQuery Web Service
- Repository Web Service Security
Composite Repositories
- Use Example
- Primary and Contributing Item Descriptors
- Item Inheritance and Composite Repositories
- Transient Properties and Composite Repositories
- Non-Serializable Items and Composite Repositories
- Property Derivation
- Configuring a Composite Repository
- Composite Repository Queries
- Composite Repository Caching
- Composite Repository Definition Tag Reference
- DTD for Composite Repository Definition Files
- Sample Composite Repository Definition File
Secured Repositories
- Features and Architecture
- Creating a Secured Repository
- Secured Repository Example
- ACL Syntax
  - Standard Access Rights
  - ACL Examples
- Secured Repository Definition File Tag Reference
- DTD for Secured Repository Definition File
- Performance Considerations
- Exceptions Thrown by the Secured Repository
LDAP Repositories
- Overview: Setting Up an LDAP Repository
- LDAP Directory Primer
- LDAP Repository Architecture
- Repository Views in the LDAP Repository
  - Repository View Definition
  - LDAP Repository View Example
- LDAP Repository Queries
  - ID Matching Queries
  - Unsupported Queries in the LDAP Repository
- Configuring LDAP Repository Components
- LDAP Repository Definition Tag Reference
- Sample LDAP Repository Definition File
- DTD for LDAP Repository Definition Files
Index

Search Terms