ApplicationName

string

Name of the client application; allows the administrator to identify the connections

FetchSize

int

Size of the resultset. Default: 500. ⇐0 indicates that the default should be used

partialResultsMode

boolean

Enable/disable partial results mode. Default: FALSE

autoCommitTxn

string

Only applies when autoCommit is set to TRUE. This determines how an executed command must be transactionally wrapped inside the CData Virtuality engine to maintain the data integrity.

Possible values:

• ON: always wrap the command in a distributed transaction

• OFF: never wrap the command in a distributed transaction

• DETECT (default): if the executed command spans more than one source, it automatically uses distributed transaction

disableLocalTxn

boolean

If TRUE, the autoCommit setting, commit, and rollback will be ignored for local transactions. Default: FALSE

user

string

User name

Password

string

User password

ansiQuotedIdentifiers

boolean

Sets the parsing behaviour for double-quoted entries in SQL. If set to TRUE, parses doubled quoted entries as identifiers. If set to FALSE, then double-quoted values that are valid string literals will be parsed as string literals. Default: TRUE

version

integer

Version number of the VDB

resultSetCacheMode

boolean

ResultSet caching is turned on/off. Default: FALSE

autoFailover

boolean

If TRUE, will automatically select a new server instance after a communication exception. Default: FALSE. This is typically not needed when connections are managed, as the connection can be purged from the pool. If TRUE in embedded mode, connections will reconnect to a newer VDB of the same name/version

SHOWPLAN

string

(typically not set as a connection property)

Possible values:

• ON: returns the query plan along with the results

• DEBUG: additionally prints the query planner debug information in the log and returns it with the results. Both the plan and the log are available through JDBC API extensions

• OFF (default)

NoExec

string

(typically not set as a connection property)

Possible values:

• ON: prevents query execution, but parsing and planning will still occur

• OFF (default)

QueryTimeout

integer

Default query timeout in seconds. Must be >= 0. 0 indicates no timeout. Can be overridden by Statement.setQueryTimeout. Default: 0

useJDBC4ColumnNameAndLabelSemantics

boolean

A change was made in JDBC4 to return unaliased column names as the ResultSetMetadata column name. Before this, if a column alias was used, it was returned as the column name. Setting this property to FALSE will enable backwards compatibility with JDBC3 and earlier. Default: TRUE

jaasName

string

JAAS configuration name. Only applies when configuring a GSS authentication. Default: DVClient

kerberosServicePrincipleName

string

Kerberos principal name. Only applies when configuring a GSS authentication. Default: DVServer/hostname

encryptRequest

boolean

Only applies to non-SSL socket connections. When set to TRUE, the request message and any associate payload will be encrypted using the connection encryptor. Default: FALSE

disableResultSetFetchSize

boolean

In some situations, tooling may choose undesirable fetch sizes for processing results. To disable honouring ResultSet.setFetchSize, set to TRUE. Default: FALSE

loginTimeout

integer

Login timeout in seconds. Must be >= 0. 0 indicates no specific timeout, but other timeouts may apply. An exception will be thrown if a connection cannot be created in approximately the timeout value. A default of 0 does not mean that the login will wait indefinitely. Typically if an active VDB cannot be found, the login will fail at that time. Local connections that specify a VDB version, however, can wait by default for up to the time specified in the  org.teiid.clientVdbLoadTimeoutMillis[org.teiid.clientVdbLoadTimeoutMillis property

reportAsViews

boolean

If TRUE, the CData Virtuality Server will report views as a VIEW table type. If FALSE, views will be reported as a TABLE. Default: TRUE

removeQuotesFromCatalog 

boolean

When set to TRUE, double quotes around the catalog name are removed to load the correct metadata

useDvRoles 

boolean

When set to TRUE, CData Virtuality roles are used to get permission for SSO users