How to load all properties from the primary table with cache-mode="disabled" in a GSARepository (Doc ID 1416422.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle ATG Web Commerce - Version: 2006.3 and later   [Release: 2006 and later ]
Information in this document applies to any platform.

Goal

In situations where caching for GSARepository item descriptor needs to be disabled for data correctness purposes, performance may still be a concern.  This is a common requirement for the InventoryRepository.

When the cache-mode="disabled", this will cause initial loads of the repository items via GSARepository.getItem() or GSARepository.getItems() to only load a few "system" properties (e.g. id, version, and any type property).  Then another query will be required to load the other properties from the primary table when they are requested.

If many items are needed at once, it may be desirable to load many items via GSARepository.getItems(), but if the properties for these items are only loaded when they are requested for individual items, this will negate the performance benefit of this.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms