System Properties

Some parts of Data Virtuality 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.

system property	description	default
`com.datavirtuality.jdbcCursorBufferSizeOfConnections`	For usage with the Data Virtuality REST API pagination. Specifies the maximum number of buffered connections (one connect corresponds to one cursor or `requestId`).	10
`com.datavirtuality.jdbcCursorBufferConnectionLifeTime`	For usage with the Data 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 of the data source.	false
`dv.maintenance`	If set to true, server will start in 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 SFTP and FTP connector if there is no proxy configured via connector specific connection properties SSHTunnel module if there is no proxy configured via createSSHTunnel respective importSSHTunnel procedures Amazon S3 connector Redshift with upload configured via Amazon S3 Snowflake with upload configured via Amazon S3	no default value
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
`org.teiid.compactBufferFiles`	Set to true to make Data Virtuality Server keep the buffer files more compact (minimizing sparse regions).	false
`org.teiid.comparableLobs`	Set to true to allow blob and clob column values to be comparable in Data Virtuality Server. Source type metadata will determine if the comparison can be pushed down.	false
`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

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

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

CODE

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

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

CODE

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

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

CODE

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

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

CODE

Proxy settings for Amazon S3 and Amazon S3 upload to Redshift and Snowflake available since v2.1.7

dv.enablemetadatacache property available since v2.1.19