The SQL repository implements several different modes of caching. Which mode you choose depends on the nature of your application. You can set the default caching mode on each item descriptor in a repository. Each property’s definition can override the cache mode of its item-descriptor. The caching modes implemented in the SQL repository are:
No Caching (disabled)
Simple Caching (caching is handled separately in each VM, with no invalidation events to synchronize updates from different server instances)
Locked Caching (read and write locks are used to synchronize the caches)
Distributed Caching via TCP (caching with cache invalidation events; events are communicated using TCP)
Distributed Caching via JMS (caching with cache invalidation events; events are communicated using JMS)
By default, the SQL repository uses simple caching. To enable a different cache mode for an item descriptor, set the cache-mode attribute in the <item-descriptor> tag of the repository definition file:
<item-descriptor name="role" cache-mode="distributed">