com.metamatrix.jdbc.api
Interface ExecutionProperties


public interface ExecutionProperties

MetaMatrix-specific execution properties. These execution properties can be set via the Statement.setExecutionProperty(String, String) method. They affect the subsequent execution of all commands on that Statement instance.


Field Summary
static java.lang.String ALLOW_DBL_QUOTED_VARIABLE
          By default treat the double quoted strings as variables in a ODBC connection.
static java.lang.String AUTO_WRAP_OFF
          Transaction auto wrap constant - never wrap a command execution in a transaction and allow multi-source updates to occur outside of a transaction.
static java.lang.String AUTO_WRAP_ON
          Transaction auto wrap constant - always wrap every non-transactional command execution in a transaction.
static java.lang.String AUTO_WRAP_OPTIMISTIC
          Transaction auto wrap constant
static java.lang.String AUTO_WRAP_PESSIMISTIC
          Transaction auto wrap constant - pessimistic mode assumes that any command execution might require a transaction to be wrapped around it.
static java.lang.String DISABLE_LOCAL_TRANSACTIONS
          If true, will ignore autocommit for local transactions.
static java.lang.String PLAN_NOT_ALLOWED
           
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_SQL_OPTIONS
          Additional options/hints for executing the command
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
          Passed as an option to PROP_SQL_OPTIONS
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

AUTO_WRAP_OFF

static final java.lang.String AUTO_WRAP_OFF
Transaction auto wrap constant - never wrap a command execution in a transaction and allow multi-source updates to occur outside of a transaction.

See Also:
Constant Field Values

AUTO_WRAP_ON

static final java.lang.String AUTO_WRAP_ON
Transaction auto wrap constant - always wrap every non-transactional command execution in a transaction.

See Also:
Constant Field Values

AUTO_WRAP_PESSIMISTIC

static final java.lang.String AUTO_WRAP_PESSIMISTIC
Transaction auto wrap constant - pessimistic mode assumes that any command execution might require a transaction to be wrapped around it. To determine this an extra server call is made to check whether the command requires a transaction and a transaction will be automatically started. This is most accurate and safe, but has a performance impact.

See Also:
Constant Field Values

AUTO_WRAP_OPTIMISTIC

static final java.lang.String AUTO_WRAP_OPTIMISTIC
Transaction auto wrap constant

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

ALLOW_DBL_QUOTED_VARIABLE

static final java.lang.String ALLOW_DBL_QUOTED_VARIABLE
By default treat the double quoted strings as variables in a ODBC connection. This is to allow the metadata tools based on ODBC to work seemlessly.

Since:
4.3
See Also:
Constant Field Values

PROP_SQL_OPTIONS

static final java.lang.String PROP_SQL_OPTIONS
Additional options/hints for executing the command

Since:
4.3
See Also:
Constant Field Values

SQL_OPTION_SHOWPLAN

static final java.lang.String SQL_OPTION_SHOWPLAN
Passed as an option to PROP_SQL_OPTIONS

See Also:
Constant Field Values

PLAN_NOT_ALLOWED

static final java.lang.String PLAN_NOT_ALLOWED
See Also:
Constant Field Values


Copyright © 2009. All Rights Reserved.