org.teiid.jdbc
Interface ExecutionProperties

public interface ExecutionProperties

These execution properties can be set via the TeiidStatement.setExecutionProperty(String, String) method. They affect the subsequent execution of all commands on that Statement instance. They can also be set using a SET statement via JDBC and take effect for the duration of the session.

Field Summary

static java.lang.String	ANSI_QUOTED_IDENTIFIERS Overrides the handling of double quoted identifiers to allow them to be strings.
static java.lang.String	DISABLE_LOCAL_TRANSACTIONS If true, will ignore autocommit for local transactions.
static java.lang.String	NEWINSTANCE
static java.lang.String	NOEXEC Can be one of ON|OFF
static java.lang.String	PROP_FETCH_SIZE Default fetch size to use on Statements if the fetch size is not explicitly set.
static java.lang.String	PROP_PARTIAL_RESULTS_MODE Execution property name for partial results mode
static java.lang.String	PROP_TXN_AUTO_WRAP Execution property name for transaction auto wrap mode
static java.lang.String	PROP_XML_FORMAT Execution property name for XML format
static java.lang.String	PROP_XML_VALIDATION Execution property name for XML validation
static java.lang.String	RESULT_SET_CACHE_MODE Whether to use result set cache if it is available
static java.lang.String	SQL_OPTION_SHOWPLAN Can be one of ON|OFF|DEBUG
static java.lang.String	TXN_WRAP_DETECT Transaction auto wrap constant - checks if a command requires a transaction and will be automatically wrap it.
static java.lang.String	TXN_WRAP_OFF Transaction auto wrap constant - never wrap a command execution in a transaction
static java.lang.String	TXN_WRAP_ON Transaction auto wrap constant - always wrap commands in a transaction.
static java.lang.String	XML_COMPACT_FORMAT XML results format: XML results displayed in compact form
static java.lang.String	XML_TREE_FORMAT XML results format: XML results displayed as a formatted tree

Field Detail

PROP_XML_FORMAT

static final java.lang.String PROP_XML_FORMAT

Execution property name for XML format

See Also:

Constant Field Values

PROP_XML_VALIDATION

static final java.lang.String PROP_XML_VALIDATION

Execution property name for XML validation

See Also:

Constant Field Values

PROP_TXN_AUTO_WRAP

static final java.lang.String PROP_TXN_AUTO_WRAP

Execution property name for transaction auto wrap mode

See Also:

Constant Field Values

PROP_PARTIAL_RESULTS_MODE

static final java.lang.String PROP_PARTIAL_RESULTS_MODE

Execution property name for partial results mode

See Also:

Constant Field Values

XML_TREE_FORMAT

static final java.lang.String XML_TREE_FORMAT

XML results format: XML results displayed as a formatted tree

See Also:

Constant Field Values

XML_COMPACT_FORMAT

static final java.lang.String XML_COMPACT_FORMAT

XML results format: XML results displayed in compact form

See Also:

Constant Field Values

TXN_WRAP_OFF

static final java.lang.String TXN_WRAP_OFF

Transaction auto wrap constant - never wrap a command execution in a transaction

See Also:

Constant Field Values

TXN_WRAP_ON

static final java.lang.String TXN_WRAP_ON

Transaction auto wrap constant - always wrap commands in a transaction.

See Also:

Constant Field Values

TXN_WRAP_DETECT

static final java.lang.String TXN_WRAP_DETECT

Transaction auto wrap constant - checks if a command requires a transaction and will be automatically wrap it.

See Also:

Constant Field Values

RESULT_SET_CACHE_MODE

static final java.lang.String RESULT_SET_CACHE_MODE

Whether to use result set cache if it is available

Since:

4.2

See Also:

Constant Field Values

PROP_FETCH_SIZE

static final java.lang.String PROP_FETCH_SIZE

Default fetch size to use on Statements if the fetch size is not explicitly set. The default is 500.

Since:

4.2

See Also:

Constant Field Values

DISABLE_LOCAL_TRANSACTIONS

static final java.lang.String DISABLE_LOCAL_TRANSACTIONS

If true, will ignore autocommit for local transactions.

Since:

5.5.2

See Also:

Constant Field Values

ANSI_QUOTED_IDENTIFIERS

static final java.lang.String ANSI_QUOTED_IDENTIFIERS

Overrides the handling of double quoted identifiers to allow them to be strings.

Since:

4.3

See Also:

Constant Field Values

SQL_OPTION_SHOWPLAN

static final java.lang.String SQL_OPTION_SHOWPLAN

Can be one of ON|OFF|DEBUG

See Also:

Constant Field Values

NOEXEC

static final java.lang.String NOEXEC

Can be one of ON|OFF

See Also:

Constant Field Values

NEWINSTANCE

static final java.lang.String NEWINSTANCE

See Also:

Constant Field Values