<named-query>
<!ELEMENT
<named-query>
(
<rql-query>
|
<sql-query>
)>
Parent:
<item-descriptor>
ATG Repository Guide
.
Documentation Home
Feedback
Highlighting
Prev
Up
Next
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
Date and Timestamp Queries
Property of Property Queries
Logical Operators
Multi-Valued Property Queries
INCLUDES ITEM
IS NULL
COUNT
ALL
Full Text Search Queries
ID-based Queries
ORDER BY
RANGE
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
Compound 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 Example
Item Descriptor Inheritance
Benefits of Item Descriptor Inheritance
Queries and Item Descriptor Inheritance
Item Descriptor Inheritance with the copy-from Attribute
Limitations of SQL Repository Inheritance
Derived Properties
Derivation Syntax
Override Properties
Properties Derived from the Same Item
Complex Derivations
Derivation Methods
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
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
<rql-filter>
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
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
Setting Caching Mode
Disabling Caching
Inherited Caching Modes
Simple Caching
Locked Caching
Prerequisites
ClientLockManager Component
ServerLockManager Component
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
Distributed External Caching
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
Cache Invalidation Service
Enabling the Cache Invalidator
Invoke the Cache Invalidator Manually
Use the Cache Invalidator with Distributed JMS Caching
External SQL Repository Caching
Choosing Repository Items for External Caching
Configuring Repository Items for External Caching
Cache Locality
Cache Modes for External Caching
External Caching and Cache Invalidation
External Caching and Cache Warming
External Cache Naming
External Caching Statistics
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
<!DOCTYTPE>
<gsa-template>
<header>
<item-descriptor>
<property>
<derivation>
<option>
<attribute>
<table>
<expression>
<rql-filter>
<named-query>
<rql-query>
<rql>
<param>
<sql-query>
<sql>
<input-parameter-types>
<returns>
<dependencies>
<transaction>
<rollback-transaction>
<add-item>
<update-item>
<remove-item>
<remove-all-items>
<query-items>
<print-item>
<set-property>
<import-items>
<export-items>
<load-items>
<dump-caches>
<print-ddl>
DTD 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
ContentHandlers
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 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>
DTD for Composite Repository Definition Files
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 a 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>
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
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
DTD for LDAP Repository Definition Files
Index
Search Terms
