My Oracle Support Banner

How to Use the New Coherence Query Language (Doc ID 1221116.1)

Last updated on JANUARY 31, 2023

Applies to:

Oracle Coherence - Version 3.6.0 and later
Information in this document applies to any platform.


CohQL is a new light-weight syntax, in the tradition of SQL, that is used to perform cache operations on a Coherence cluster. The language can be used either programmatically or from a command-line tool. It was first introduced in Coherence 3.6.

In this demo we will load a database table into our cache and then query it using the new CohQL syntax both from an API client and the new command line client. We will also briefly look at how it differs from traditional SQL itself.


To view full details, sign in with your My Oracle Support account.

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

In this Document
 Pre Steps
 Populate Cache
 Running Command Line Client
 More Information

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.