Execution Properties

Execution properties may be set on a per statement basis through the Teiid Spring BootStatement 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 1. Execution Properties
Property Name/String Constant Description

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.

results matching ""

    No results matching ""