Skip to main content
Skip table of contents

System Properties

Some parts of CData Virtuality Server behaviour can be configured via system properties. System properties may be set in the dvserver/bin/standalone.conf.props(.bat) file and have the format -Dproperty=value.

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


System PropertyDescriptionDefault 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 sourceFALSE
dv.encryptionKeyPathDefines 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 TRUETRUE

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 optionempty 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 milliseconds20000

org.teiid.maxStringLength

Specifies the default STRING data type length in the CData Virtuality viewsInteger.MAX_VALUE

org.teiid.estimatedStringLength

Used for internal cache size calculation4000

rest.timeout

REST API timeout in milliseconds600000

snowflake.application.identifier

Specifies a Unique Connection String Identifier for Snowflake data sourcesDataVirtuality_DV

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

dv.encryptionKeyPath property is available since v4.4

Examples

1. Example for setting system property via standalone.conf.props.bat (Windows):

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

2. Example for setting system property via standalone.conf.props (Linux):

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

3. Example for setting the dv.maintenance system property via standalone.conf.props.bat (Windows):

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

4. Example for setting the dv.maintenance system property via standalone.conf.props (Linux):

SQL
JAVA_OPTS="$JAVA_OPTS -Ddv.maintenance=true"
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.