CData Virtuality Server の動作の一部は、システムプロパティで設定できます。システムプロパティはdvserver/bin/standalone.conf.props(.bat) ファイルで設定することができ、 形式-Dproperty=valueとなります。

To view the full table, click the expand button in its top right corner


System Property

Description

Default Value

com.datavirtuality.jdbcCursorBufferSizeOfConnections

For usage with the CData Virtuality REST API pagination.

Specifies the maximum number of buffered connections (one connection corresponds to one cursor or requestId)

10

com.datavirtuality.jdbcCursorBufferConnectionLifeTime

For usage with the CData Virtuality REST API pagination.

Specifies the duration a requestId created once will stay valid. After that time requestId  will be expired. Time is measured from the last usage of the requestId and will be reset with each usage.

The actual lifetime may differ depending on buffer usage for pagination queries.

Value is specified in minutes

20

dv.enablemetadatacache

Enables caching of the metadata to the configuration database on adding or refreshing the data source

FALSE

dv.encryptionKeyPath

Defines the path to the key file. The key is used to encrypt/decrypt credentials and other parameters that must be encrypted. Please contact support for more details


dv.maintenance

If set to TRUE, the Server will start in the maintenance mode

FALSE

  • dv.proxy (possible values: NONE, HTTP, SOCKS4, SOCKS5)

  • dv.proxy.host

  • dv.proxy.port

  • dv.proxy.user

  • dv.proxy.pwd

Used by the following:

-

dv.refreshmetadataonstart

If set to FALSE, disables the metadata refresh on bootstrapping for all the data sources having a cached copy of their metadata in the configuration database. Such a copy is created automatically for each data source added or refreshed after the dv.enablemetadatacache property is set to TRUE

TRUE

dv.skipinitmetadataonstartup

If set to TRUE, prevents initialization of modular connectors metadata on server startup

FALSE

dv.webservice.public.url

Used to generate valid links in the OData and REST responses in case the server is configured behind a proxy server, or a load balancer is used. The value of this property is used if not overridden by the dv.webservice.public.url environment variable or by setting the WEBSERVICE_PUBLIC_URL  default option

empty value

org.teiid.compactBufferFiles

If set to TRUE, makes the CData Virtuality Server keep the buffer files more compact (minimizing sparse regions)

FALSE

org.teiid.comparableLobs

If set to TRUE, enables blob and clob column values to be comparable in the CData Virtuality Server. Source type metadata will determine if the comparison can be pushed down

TRUE

org.teiid.subqueryUnnestDefault

Controls whether the optimizer will by default unnest subqueries

FALSE

org.jboss.as.controller.client.timeout-ms

Specifies the timeout for JBoss CLI in milliseconds

20000

org.jboss.as.cli.timeout-ms

Specifies the default CLI timeout for JBoss CLI in milliseconds

20000

org.teiid.maxStringLength

Specifies the default STRING data type length in the CData Virtuality views

Integer.MAX_VALUE

org.teiid.estimatedStringLength

Used for internal cache size calculation

4000

rest.timeout

REST API timeout in milliseconds

600000

snowflake.application.identifier

Specifies a Unique Connection String Identifier for Snowflake data sources

DataVirtuality_DV

dv.webservice.public.url property is available since v3.4

dv.encryptionKeyPath property is available since v4.4

Examples

1. standalone.conf.props.batによるシステムプロパティの設定例 (Windows):

SET "JAVA_OPTS=%JAVA_OPTS% -D<system property>=<system property value>"

2. standalone.conf.props (Linux) を介したシステム・プロパティの設定例:

JAVA_OPTS="$JAVA_OPTS -D<system property>=<system property value>"

3. dv.maintenanceシステム・プロパティをstandalone.conf.props.bat(Windows)を介して設定する例:

SET "JAVA_OPTS=%JAVA_OPTS% -Ddv.maintenance=true"

4. standalone.conf.props (Linux) を介したdv.maintenanceシステム・プロパティの設定例:

JAVA_OPTS="$JAVA_OPTS -Ddv.maintenance=true"