Chapter 11. Execution Properties

Execution properties may be set on a per statement basis through the Data VirtualizationStatement interface or on the connection via the SET Statement. For convenience, the property keys are defined by constants on the org.teiid.jdbc.ExecutionProperties interface.

Table 11.1. Execution Properties

Property Name/String ConstantDescription

PROP_TXN_AUTO_WRAP / autoCommitTxn

Same as the connection property.

PROP_PARTIAL_RESULTS_MODE / partialResultsMode

See the Partial Results Mode

RESULT_SET_CACHE_MODE / resultSetCacheMode

Same as the connection property.

SQL_OPTION_SHOWPLAN / SHOWPLAN

Same as the connection property.

NOEXEC / NOEXEC

Same as the connection property.

JDBC4COLUMNNAMEANDLABELSEMANTICS / useJDBC4ColumnNameAndLabelSemantics

Same as the connection property.