ATG Repository Guide
.
Documentation Home
Feedback
Highlighting
Prev
Up
Next
rql-query
Child of:
named-query
rql-query child tags
Child tag
How many?
rql
one
Contents
Search
Introduction
Repository API
Repository Architecture
Repository Items
Item Descriptors
MutableRepository
Core Repository API Elements
atg.repository.Repository
atg.repository.RepositoryView
atg.repository.RepositoryItem
atg.repository.MutableRepository
atg.repository.PropertiesChangedEvent
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
RQL Overview
Comparison Queries
Text Comparison Queries
Property of Property Queries
Logical Operators
Collection Queries
Includes Item Queries
Is Null Queries
Count Expressions
All Query
Full Text Search Queries
ID-based Queries
Order By Directives
Range Directives
Parameters in Queries
Parameterized Field Queries
RQL Examples
RQL Grammar
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
Single Column and Multi-Column Repository IDs
IdSpaces and the id Property
Database Sequences and Repository IDs
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
Cascade Insert
Cascade Update
Cascade Delete
Cascade Delete Order
Cascade Example
Item Descriptor Inheritance
Advantages of Item Descriptors Inheritance
Queries and Item Descriptor Inheritance
Item Descriptor Inheritance with the copy-from Attribute
Limitations of SQL Repository Inheritance
Derived Properties
Override Properties
Properties Derived from the Same Item
Complex Derivations
Derivation Methods
Repository Items and Session Backup
SQL Repository Item Properties
Enumerated Properties
Choosing Option Codes
Required Properties
Unique Properties
Date and Timestamp Properties
Last-Modified Properties
Null Properties
Sorting Properties
Property Validation with a Property Editor Class
Maintaining Item Concurrency with the Version Property
Repository Items as Properties
Multiple Item Properties
Adding an Item to a Multi-Item Property
Querying Subproperties
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
Identifying a User-Defined Property Type
Using the property-type Attribute
Implementing a User-Defined Property Type
Property Conversion Methods
Null Values in User-Defined Property Types
User-Defined Properties and the ACC
User-Defined Property Type Examples
Property Fetching
Handling Large Database Columns
SQL Repository Queries
Repository Filtering
Using <rql-filter>
Using the filterQuery and rqlFilterString Properties
Overriding RQL-Generated SQL
Parameterized Queries
Parameterized Query API
Query Types that Support Parameters
QueryCache and Parameterized Queries
Parameterized Query Example
Named Queries
Defining Named Queries
Defining Named Queries in the SQL Repository Definition File
Defining and Accessing Named Queries in Java Code
RQL Named Queries
SQL Named Queries
Stored Procedures
Using Stored Procedures with Oracle Databases
Named Queries and Item Inheritance
Named Query API
Text Search Queries
Simulating Text Search Queries
Wildcards in Queries
Not Queries and Null Values
Outer Joins
Table Ownership Issues
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
Setting Caching Mode
Disabling Caching
Inherited Caching Modes
Simple Caching
Locked Caching
ClientLockManager
ServerLockManager
Processing Lock Requests
Isolation Levels
Locking Exceptions
Resolving Lock Contention
Monitoring Lock Managers
Locking Scenarios and Workflows
Distributed Caching Modes
Simple versus Distributed Caching
Distributed Caching Mode Options
Distributed TCP Caching
Distributed TCP Caching Setup
Restoring Subscriber Data
Invalidating Cached Items
Disabling Automatic Updates to das_gsa_subscriber
Distributed JMS Caching
Distributed JMS Caching Setup
Distributed Hybrid Caching
Distributed Hybrid Caching Setup
Distributed Hybrid Caching Initialization
Optimizing Performance
Monitoring Cache Manager Activity
Cache Configuration
Query Cache Tuning
Item Cache Tuning: ATG Commerce
Cache Timeout
Monitoring Cache Usage
Caching by Repository IDs
Restoring Item Caches
Preloading Caches
Enabling Lazy Loading
Lazy Loading Settings
Integration with Batch Loading
Using Preloading Hints in Lazy-Loaded Queries
Cache Flushing
Flushing All Repository Caches
Flushing Item Caches
Flushing Query Caches
Developing and Testing an SQL Repository
Adding Items
Adding Items with Composite IDs
Adding Items without Specifying IDs
Adding Items to Multi-Item Properties
Updating Items
Removing Items
Removing References to Items
Querying Items
Importing and Exporting Items and DDLs
startSQLRepository
Requirements
Syntax
Exporting Repository Data
Importing Repository Data
Importing to a Versioned Repository
SQL Repository Test Example
Using Operation Tags in the Repository Administration Interface
Debug Levels
Modifying a Repository Definition
SQL Repository Reference
SQL Repository Definition Tag Reference
DOCTYPE (SQL Repository)
gsa-template
header (SQL Repository)
item-descriptor (SQL Repository)
table
property (SQL Repository)
Data Type Correspondences
option (SQL Repository)
attribute (SQL Repository)
derivation
expression
rql-filter
Named Query Tags
named-query
rql-query
rql
sql-query
sql
input-parameter-types
returns
dependencies
Development Operation Tags
transaction
rollback-transaction
import-items
add-item
update-item
query-items
print-item
set-property
remove-item
remove-all-items
export-items
load-items
dump-caches
print-ddl
Document Type Definition for SQL Repository Definition Files
Sample SQL Repository Definition Files
Simple One-to-One
One-to-One with Auxiliary Table
One-to-Many with an Array
One-to-Many with a Set
One-to-Many with a Map
One-to-Many Mapping to Other Repository Items
Ordered One-to-Many
Many-to-Many
Multi-Column Repository IDs
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
Folder and Content Item Descriptors
Path and Item ID Attributes
Defining Content Item Descriptors
Content Attributes and Properties
Storing Content on a File System
Content Repository Example
Book Item Type Properties
Locating the Content with Path and Folder Properties
Book Example Repository Definition File
Book Example SQL Table Creation Statements
Adding Content to the Content Repository
Accessing Items in the Content Repository
Configuring an SQL Content Repository
Repository Loader
Repository Loader Architecture
Repository Loader Components
FileSystemMonitorScheduler
FileSystemMonitorService
LoaderManager
TypeMapper and TypeMappings
Content Handlers and Back Ends
Repository Loader Administration
RLClient
Supplemental RLClient Parameters
Repository Loader Manifest
Manifest File Tags and Attributes
Importing Versioned Repository Data
Configuring the VersionedLoaderEventListener
Importing Targeters that Reference rules Files
Configuring TypeMapping Components for the PublishingFileRepository
Repository Loader Example
User Item Type
Item Pathnames
Type Mappings and Content Handlers
TypeMapper
xml2repository Schemas
Running the 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
Property Mappings
Excluding Properties
Link Methods
Creating Composite and Contributing Items
Missing Contributing Items
Configuring the Composite Repository Component
Composite Repository Queries
Composite Repository Caching
Composite Repository Definition File Tag Reference
composite-repository-template
header (Composite Repository)
item-descriptor (Composite Repository)
primary-item-descriptor
contributing-item-descriptor
attribute (Composite Repository)
property (Composite Repository)
primary-item-descriptor-link
link-via-id
link-via-property
Composite Repository Document Type Definition
Sample Composite Repository Definition File
Secured Repositories
Features and Architecture
Creating a Secured Repository
Modify the Underlying Repository
Configure the Secured Repository Adapter Component
Register the Secured Repository Adapter Component
Create the Secured Repository Definition File
Secured Repository Example
Modify the SQL for the Repository Data Store
Modify the XML definition file
Define the Secured Repository Adapter’s Definition File
Configure the Secured Repository Adapter Component
Register the Repositories
ACL Syntax
Standard Access Rights
ACL Examples
Secured Repository Definition File Tag Reference
secured-repository-template
item-descriptor (Secured Repository)
property (Secured Repository)
default-acl
descriptor-acl
owner-property
acl-property
creation-base-acl
creation-owner-acl-template
creation-group-acl-template
Secured Repository Definition File DTD
Performance Considerations
Exceptions Thrown by the Secured Repository
LDAP Repositories
Overview: Setting Up an LDAP Repository
LDAP Directory Primer
Hierarchical Tree Structure
LDAP Data Representation
Hierarchical Entry Types
Directory Schema
LDAP and JNDI
LDAP Sources
LDAP Repository Architecture
LDAP Repository Items and Repository IDs
Item Descriptors and LDAP Object Classes
Item Descriptor Hierarchies and Inheritance
Id and ObjectClasses Properties
Additional Property Tag Attributes
New Item Creation
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
/atg/adapter/ldap/LDAPRepository
/atg/adapter/ldap/InitialContextPool
/atg/adapter/ldap/InitialContextEnvironment
/atg/adapter/ldap/LDAPItemCache
/atg/adapter/ldap/LDAPItemCacheAdapter
/atg/adapter/ldap/LDAPQueryCache
/atg/adapter/ldap/LDAPQueryCacheAdapter
LDAP Password Encryption
LDAP Repository Definition Tag Reference
DOCTYPE (LDAP Repository)
ldap-adapter-template
header (LDAP Repository)
view
item-descriptor (LDAP Repository)
id-property
object-classes-property
object-class
property (LDAP Repository)
option (LDAP Repository)
attribute (LDAP Repository)
child-property
new-items
search-root
Sample LDAP Repository Definition File
Document Type Definition for LDAP Repository Definition Files
Index