How to Query the Coherence*Web session-storage cache in the 12.2.1.x.x versions?
Last updated on NOVEMBER 07, 2017
Applies to:Oracle Coherence - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Customer raised question how to query the coherence*web session caches using the COHQL client in the 12c (12.2.1.x.x) versions when federation is enabled for the coherence*web.
The Coherence federated caching feature replicates cache data asynchronously across multiple geographically dispersed clusters. Coherence*Web can take advantage of federated caching to provide redundancy, off-site backup, and multiple points of access for application users that are in different geographical locations. For details about Federated caching, see Administering Oracle Coherence.
To use federated caching for HTTP session caches:
- Define federation cluster participants and topologies. For detailed instructions, see Administering Oracle Coherence.
- Configure Coherence*Web to use a federated cache scheme. A default session cache configuration file is included in the
coherence-web.jarlibrary and is called
default-federated-session-cache-config.xmlsession cache configuration file. To use the default federated session cache configuration file, use the
coherence-session-cache-federatedcontext parameter with the value set to
- Update or override the
default-federated-session-cache-config.xmlsession cache configuration file and associate the default federated caching scheme (
session-distributed) with a replication topology. For detailed instructions, see Administering Oracle Coherence. For example:
- Is it supported to query by sessionId or obtain sessonId using COHQL?
- Is it possible to get CoherenceWebSessionId using COHQL?
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