Purpose

Controls how the driver instructs the Oracle Service Cloud Web service to resolve queries. Oracle Service Cloud can satisfy queries against the production or the reporting database that backs the service. This property instructs the driver to indicate against which database the queries should be resolved.

Valid Values

none | report | operational

Behavior

If set to none, the driver sends the base ROQL command directly. This results in the default database behavior.

If set to report, the driver prepends a "USE REPORT; " statement to the base ROQL command. This results in the reporting database being used for subsequent queries. The report database is a copy of the operational database. The report database is only up to date once the data from the site has propagated to it. When your queries do not depend on using live data, you should set the OracleServiceCloudDatabase property to report to reduce the load a system is under.

If set to operational, the driver prepends a "USE OPERATIONAL; " statement to the base ROQL command. This results in the production database being used for subsequent queries. The operational database contains live, up-to-date data. When your queries require live data, you should set the OracleServiceCloudDatabase property to operational. However, there is an increased likelihood that queries made to the operational database may fail.

Notes

Depending on the load a system is under, some queries made to the Web service can fail, independent of the driver. Queries made to the report database are generally less likely to fail than queries made to the operational database.

Default

report

Data Type

String

See also

Using Connection Properties