1. ECE Implementing Charging
  2. ECE Utilities
  3. Charging Utilities

26 Charging Utilities

You learn about syntax and parameters used by the Oracle Communications Elastic Charging Engine (ECE) charging utilities.

Topics in this document:

query

Use the query utility to launch the Oracle Coherence query client and run queries against the ECE Coherence cache. You can use the utility to write scripts that interact with the ECE domain objects, creating CohQL queries. The utility supports all ECE caches and objects. For more information, see "Using the query Utility to Test ECE".

You can run this utility in interactive mode or non-interactive mode.

Location

ECE_home/bin

Syntax: Interactive Mode

./query.sh
Coherence Command Line Tool
CohQl>

Syntax: Non-Interactive Mode

./query.sh [-t] [-c] [-s] [-e] [-l "statement"] [-f filename] [-h]
           [-P "CohQLquery"]

Parameters: Non-Interactive Mode

-t

Enables trace mode for printing debugging information.

-c

Specifies to exit the utility after processing all command-line arguments.

Note:

Do not use this argument when redirecting from standard input, because the utility exits as soon as the command-line arguments have been processed and the redirected input will never be read.

-s

Runs the utility in silent mode. This allows the utility to be used in pipes or filters by redirecting to standard input and standard output.

-e

Runs the utility in extended language mode. This mode allows object literals in update and insert commands.

-l "statement"

Runs the specified CohQL statement. Enclose your CohQL statements in single or double quotes.

For more information about CohQL statements, see "Using Coherence Query Language" in Oracle Fusion Middleware Developing Applications with Oracle Coherence.

-f filename

Processes the CohQL statements in the specified file. The statements in the file must be separated by a semicolon (;). The file is an operating system-dependent path and must be enclosed in single or double quotes.

-P "CohQLquery"

Runs the specified CohQL SELECT query against the database. You can run the select Count() and select Value() queries. If you include a WHERE clause, it supports the condition Customer_id = 'value'. For example: 

./query.sh -P "select value() from Customer where Customer_id = 'Cust#6500000242'"

For more information about CohQL queries, see "Using Coherence Query Language" in Oracle Fusion Middleware Developing Applications with Oracle Coherence.

-h

Displays the syntax for this utility.

Results

Look in the ECE_home/logs/query_out.log file for errors.

Note:

Oracle recommends that you not query the cache for the entire list of customer information. Filtered/ selected query is recommended because the complete customer list would cause ECE to crash.