Configuration for Null Value Filtering in Terracotta Cache

Master Data Management with webMethods OneData : Administering webMethods OneData : Working with In-Memory and Caching in OneData : In-Memory Database : Configuration for Null Value Filtering in Terracotta Cache

For data filtering, OneData uses the indexing functionality in Terracotta. To support indexing of null values in Terracotta, OneData provides substitutes for the null values. The null value substitutes are specified in the onedata.properties file. Terracotta uses these substitutes instead of the null values while indexing.

The properties in onedata.properties file and their default values are listed below.

Important:

The substitute values for null values are used only for indexing purpose and are not expected to be part of the data. If you expect the substitute value in your data, you can customize the value by editing the onedata.properties file located at < Software AG_directory

OneData Property

Specifies the substitute for a null value of data type...

Default Substitute Value

onedata.terracotta. numeric.nullvalue

NumericContiguous
SequenceDatabase
SequenceExternal
SequenceOptional Database
SequencePercentageBoolean

-2147483648

onedata.terracotta. string.nullvalue

CharVarcharFile Type

OD#NULL#OD

onedata.terracotta. date.nullvalue

DateTimestamp

1970-01-01 00:00:00

Note:

You must use the date format YYYY-MM-DDHH24:MM:SS

Contact Support | Community | Feedback