Red Hat Summit Red Hat SummitSupportConsoleDevelopersStart a trialContact

4.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.
Expand
Table 4.2. Execution Properties
Constant Identifier String Value Description
ANSI_QUOTED_IDENTIFIERS ansiQuotedIdentifiers See Section 2.8, “Connection Properties for the Driver and Data Source Classes”.
DISABLE_LOCAL_TRANSACTIONS disableLocalTxn See Section 2.8, “Connection Properties for the Driver and Data Source Classes”.
JDBC4COLUMNNAME ANDLABELSEMANTICS useJDBC4ColumnName AndLabelSemantics See Section 2.8, “Connection Properties for the Driver and Data Source Classes”.
NOEXEC See Section 2.8, “Connection Properties for the Driver and Data Source Classes”.  
PROP_FETCH_SIZE fetchSize See Section 2.8, “Connection Properties for the Driver and Data Source Classes”.
PROP_PARTIAL_RESULTS_MODE partialResultsMode See Section 2.8, “Connection Properties for the Driver and Data Source Classes” and Section 4.12, “Partial Results Mode”.
PROP_TXN_AUTO_WRAP autoCommitTxn See Section 2.8, “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 4.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 4.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.8, “Connection Properties for the Driver and Data Source Classes”.
RESULT_SET_CACHE_MODE resultSetCacheMode See Section 2.8, “Connection Properties for the Driver and Data Source Classes”.
SQL_OPTION_SHOWPLAN SHOWPLAN See Section 2.8, “Connection Properties for the Driver and Data Source Classes”.

See Also:

Red Hat logoGithubredditYoutubeTwitter

Learn

Try, buy, & sell

Communities

About Red Hat Documentation

We help Red Hat users innovate and achieve their goals with our products and services with content they can trust. Explore our recent updates.

Making open source more inclusive

Red Hat is committed to replacing problematic language in our code, documentation, and web properties. For more details, see the Red Hat Blog.

About Red Hat

We deliver hardened solutions that make it easier for enterprises to work across platforms and environments, from the core datacenter to the network edge.

Theme

© 2026 Red HatBack to top