Course details

Using the Repository

Using the Repository

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

The Oracle Commerce Platform contains a robust repository API. Understanding how to use Java to programmatically manipulate (retrieve, create, update, delete, or query) repository data is a must for any serious application. In this course, you will be able to implement transient (non-persisted) properties, apply rules to override a property's value derivation, and configure versioned repositories and consider their use in support of Commerce Platform functionality. This course is one of a series in the Skillsoft learning path that covers the material for the Oracle Commerce Platform Fundamentals for Developers.

Target Audience
Application developers; data architects; technical architects; and anyone with experience in Java programming, XML parsing and editing, basic JavaServer page and HTML page coding, and a basic understanding of SQL database table structure and data querying


Expected Duration (hours)

Lesson Objectives

Using the Repository

  • start the course
  • describe how the Oracle Commerce Repository API is a set of interfaces that are used for generic data access
  • identify the classes used to view and manipulate repository elements
  • identify the steps in creating, updating, and deleting repository items
  • use Repository Query Language (RQL) to execute queries in a repository
  • describe how a derived property is a transient property that derives its value from another property
  • recognize how properties are derived and how they are defined in configuration files
  • recognize how properties are derived from organizations and how they are defined in configuration files
  • define the steps in setting the value of a derived property
  • list the six different derivation methods used in Oracle Commerce and describe their functionality
  • describe how to use content administration for internally managed content such as products, images, and promotions
  • identify the steps in creating a module used to override the application elements that differ on the CA server
  • list the differences between versioned and unversioned repositories
  • list the steps for configuring versioned repositories
  • list the steps for creating versioned tables
  • list the different utilities used to import and export data
  • describe how hierarchical repositories are used and how they model the original file system
  • describe how each Oracle Commerce server in a cluster maintains its own caches
  • define the two phases performed in repository queries
  • list the six cache modes for repository items
  • identify the differences between preloading caches, cache types, and cache invalidation
  • review the Trunk Show Repository and supporting SQL table definitions and consider what steps would be required to add versioning
  • Course Number:

    Expertise Level