Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

5.5. Execution Properties

The following table provides a list of execution properties as defined in org.teiid.jdbc.ExecutionProperties. These can be modified using the SET statement.

Table 5.2. Execution Properties

Constant Identifier String Value Description
ANSI_QUOTED_IDENTIFIERS ansiQuotedIdentifiers See Section 2.10, “Connection Properties for the Driver and Data Source Classes”.
DISABLE_LOCAL_TRANSACTIONS disableLocalTxn See Section 2.10, “Connection Properties for the Driver and Data Source Classes”.
JDBC4COLUMNNAME ANDLABELSEMANTICS useJDBC4ColumnName AndLabelSemantics See Section 2.10, “Connection Properties for the Driver and Data Source Classes”.
NOEXEC See Section 2.10, “Connection Properties for the Driver and Data Source Classes”.  
PROP_FETCH_SIZE fetchSize See Section 2.10, “Connection Properties for the Driver and Data Source Classes”.
PROP_PARTIAL_RESULTS_MODE partialResultsMode See Section 2.10, “Connection Properties for the Driver and Data Source Classes” and Section 5.12, “Partial Results Mode”.
PROP_TXN_AUTO_WRAP autoCommitTxn See Section 2.10, “Connection Properties for the Driver and Data Source Classes”.
PROP_XML_FORMAT XMLFormat
Determines the formatting of XML documents returned by XML document models. Can be one of XML_COMPACT_FORMAT or XML_TREE_FORMAT. See Section 5.7, “XML Document Formatting” for more information.
PROP_XML_VALIDATION XMLValidation
Determines whether XML documents returned by XML document models will be validated against their schema after processing. See Section 5.8, “XML Schema Validation” and topics on "XML SELECT" in the JBoss Data Virtualization Development Guide: Reference Material for more information.
QUERYTIMEOUT QUERYTIMEOUT See Section 2.10, “Connection Properties for the Driver and Data Source Classes”.
RESULT_SET_CACHE_MODE resultSetCacheMode See Section 2.10, “Connection Properties for the Driver and Data Source Classes”.
SQL_OPTION_SHOWPLAN SHOWPLAN See Section 2.10, “Connection Properties for the Driver and Data Source Classes”.

See Also: