com.vmware.sqlfire
Interface Attribute

public interface Attribute

List of all server connection (JDBC) attributes by the system.

Field Summary

static String	AUTH_PROVIDER Authentication scheme for client connections.
static String	CLIENT_JVM_PROPERTY_PREFIX User should use this prefix for the client attributes traceLevel and traceDirectory when they are sending those attributes as JVM properties.
static String	CLIENT_SECURITY_MECHANISM securityMechanism sets the DRDA mechanism in-use for the client
static String	COLLATION Optional JDBC url attribute (at the database create time only) It can be set to one of the following 2 values 1) UCS_BASIC (This means codepoint based collation.
static String	CONFIG_SCRIPTS The property used to specify the initial SQL scripts to be executed before anything else including initial DDL replay.
static String	CREATE_ATTR The attribute that is used to request a database create.
static String	DBNAME_ATTR The attribute that is used for the database name, from the JDBC notion of jdbc::
static String	DEFAULT_INITIAL_CAPACITY_PROP The VM level property to specify the default initial capacity used for underlying GFE regions on datastores.
static String	DEFAULT_RECOVERY_DELAY_PROP A VM level property to specify the default recovery delay to be used ( PartitionAttributesFactory.setRecoveryDelay(long).
static String	DISABLE_STREAMING A connection level property (i.e. needs to be set on each connection) which when set to true will disable streaming of results on query node.
static String	DNC_PROTOCOL The protocol for Derby Network Client.
static String	DRDA_SECMEC Internal attribute which holds the value of the securityMechanism attribute specified by the client.
static String	DRDA_SECTKN_IN Internal attributes.
static String	DRDA_SECTKN_OUT
static String	DRDAID_ATTR The attribute that is used to set the connection's DRDA ID.
static String	DUMP_TIME_STATS_FREQ Boot connection property used to denote that query time statistics should be dumped using SQLFireQueryTimeStatistics.
static String	ENABLE_STATS Connection property to enable collection of statistics at statement level.
static String	ENABLE_TIMESTATS Connection property to enable collection of time statistics at statement level.
static String	ENABLE_TX_WAIT_MODE A connection level property to use lock waiting mode for transactions instead of the default "fail-fast" conflict mode.
static String	INIT_SCRIPTS The property used to specify the SQL scripts to be executed after VM startup is complete including initial DDL replay.
static String	JCC_PROTOCOL The protocol for the IBM Universal JDBC Driver
static String	LICENSE_SERIAL_NUMBER The serial number specified for licensing.
static String	LOG_FILE The SQLFire log file path property.
static String	PASSWORD_ATTR The attribute that is used to set the user password.
static String	PREFER_NETSERVER_IP_ADDRESS System property to force using IP addresses rather than hostnames for clients.
static String	PROTOCOL The default SQLFire protocol for data store or peer client.
static String	SERVER_AUTH_PROVIDER Authentication scheme configuration for server-to-server communication.
static String	SERVER_GROUPS The property used to specify the server groups.
static String	SHUTDOWN_ATTR The attribute that is used to request a shutdown.
static String	SKIP_LISTENERS A connection level property if set to true, would skip invocation of listeners/writers/DBSynchronizer/AsyncEventListener on server.
static String	SQLF_DBNAME The dummy name used for SQLFire database.
static String	SQLF_ENABLE_TX_WAIT_MODE System property to set ENABLE_TX_WAIT_MODE for all connections.
static String	SQLF_HOST_DATA The SQLFire property used to specify whether this VM should host data or not (i.e. whether data-store or an accessor).
static String	SQLF_PERSIST_DD property name for enabling persistence of data dictionary
static String	SQLF_PREFIX Prefix when setting a boot/connection property as a system property.
static String	SQLJ_NESTED The SQLJ protocol for getting the default connection for server side jdbc.
static String	SQLJ_NESTED_SQLFIRE
static String	STAND_ALONE_LOCATOR Boot property to indicate that this is a stand-alone locator which is really a kind of peer client with a network server running on it to enable processing client locator related DML commands.
static String	SYS_PERSISTENT_DIR The property used to specify the base directory for Sql Fabric persistence of Gateway Queues, Tables, Data Dictionary etc.
static String	TABLE_DEFAULT_PARTITIONED The default DataPolicy for tables is now replicated when no explicit partitioning has been defined.
static String	UPGRADE_ATTR The attribute that is used to allow upgrade.
static String	USERNAME_ALT_ATTR Alternate attribute to set alternative 'UserName' connection attribute.
static String	USERNAME_ATTR The attribute that is used to set the user name.
static String	USING_ODBC_DRIVER System property to denote that the driver is invoked using ODBC API.

Field Detail

PROTOCOL

static final String PROTOCOL

The default SQLFire protocol for data store or peer client.

See Also:

Constant Field Values

SQLF_DBNAME

static final String SQLF_DBNAME

The dummy name used for SQLFire database.

See Also:

Constant Field Values

SQLJ_NESTED

static final String SQLJ_NESTED

The SQLJ protocol for getting the default connection for server side jdbc.

See Also:

Constant Field Values

SQLJ_NESTED_SQLFIRE

static final String SQLJ_NESTED_SQLFIRE

See Also:

Constant Field Values

SHUTDOWN_ATTR

static final String SHUTDOWN_ATTR

The attribute that is used to request a shutdown.

See Also:

Constant Field Values

USERNAME_ATTR

static final String USERNAME_ATTR

The attribute that is used to set the user name.

See Also:

Constant Field Values

USERNAME_ALT_ATTR

static final String USERNAME_ALT_ATTR

Alternate attribute to set alternative 'UserName' connection attribute.

See Also:

Constant Field Values

PASSWORD_ATTR

static final String PASSWORD_ATTR

The attribute that is used to set the user password.

See Also:

Constant Field Values

COLLATION

static final String COLLATION

Optional JDBC url attribute (at the database create time only) It can be set to one of the following 2 values 1) UCS_BASIC (This means codepoint based collation. This will also be the default collation used by Derby if no collation attribute is specified on the JDBC url at the database create time. This collation is what Derby 10.2 and prior have supported) 2)TERRITORY_BASED (the collation will be based on language region specified by the exisiting Derby attribute called territory. If the territory attribute is not specified at the database create time, Derby will use java.util.Locale.getDefault to determine the territory for the newly created database.

See Also:

Constant Field Values

DRDAID_ATTR

static final String DRDAID_ATTR

The attribute that is used to set the connection's DRDA ID.

See Also:

Constant Field Values

DRDA_SECTKN_IN

static final String DRDA_SECTKN_IN

Internal attributes. Mainly used by DRDA and Derby BUILTIN authentication provider in some security mechanism context (SECMEC_USRSSBPWD). DRDA_SECTKN_IN is the random client seed (RDs) DRDA_SECTKN_OUT is the random server seed (RDr)

See Also:

Constant Field Values

DRDA_SECTKN_OUT

static final String DRDA_SECTKN_OUT

See Also:

Constant Field Values

DRDA_SECMEC

static final String DRDA_SECMEC

Internal attribute which holds the value of the securityMechanism attribute specified by the client. Used for passing information about which security mechanism to use from the network server to the embedded driver. Use another name than "securityMechanism" in order to prevent confusion if an attempt is made to establish an embedded connection with securityMechanism specified (see DERBY-3025).

See Also:

Constant Field Values

DISABLE_STREAMING

static final String DISABLE_STREAMING

A connection level property (i.e. needs to be set on each connection) which when set to true will disable streaming of results on query node. This will make the performance slower and require more memory for large query results but with more predictable results in case a server happens to go down while iterating over a ResultSet. When this is not set then an SQLException with state SQLState.SQLF_NODE_SHUTDOWN will be thrown in case a node happens to go down in the middle of ResultSet iteration and application has to retry the query. With this property set, SQLFire will always wait for at least one result from all the nodes and disable chunking of results from nodes, so will always transparently failover in such a scenario.

See Also:

Constant Field Values

SKIP_LISTENERS

static final String SKIP_LISTENERS

A connection level property if set to true, would skip invocation of listeners/writers/DBSynchronizer/AsyncEventListener on server.

See Also:

Constant Field Values

ENABLE_TX_WAIT_MODE

static final String ENABLE_TX_WAIT_MODE

A connection level property to use lock waiting mode for transactions instead of the default "fail-fast" conflict mode. In the lock waiting mode, the transaction commits will get serialized waiting for other ongoing transactions instead of conflicting with them.

See Also:

Constant Field Values

LOG_FILE

static final String LOG_FILE

The SQLFire log file path property. added by GemStone

See Also:

Constant Field Values

CONFIG_SCRIPTS

static final String CONFIG_SCRIPTS

The property used to specify the initial SQL scripts to be executed before anything else including initial DDL replay.

See Also:

Constant Field Values

DEFAULT_INITIAL_CAPACITY_PROP

static final String DEFAULT_INITIAL_CAPACITY_PROP

The VM level property to specify the default initial capacity used for underlying GFE regions on datastores.

See Also:

Constant Field Values

DEFAULT_RECOVERY_DELAY_PROP

static final String DEFAULT_RECOVERY_DELAY_PROP

A VM level property to specify the default recovery delay to be used ( PartitionAttributesFactory.setRecoveryDelay(long). Can be overridden for an individual table using the RECOVERYDELAY clause in CREATE TABLE DDL. If not specified then the default recovery delay is PartitionAttributesFactory.RECOVERY_DELAY_DEFAULT.

See Also:

Constant Field Values

DUMP_TIME_STATS_FREQ

static final String DUMP_TIME_STATS_FREQ

Boot connection property used to denote that query time statistics should be dumped using SQLFireQueryTimeStatistics.

See Also:

Constant Field Values

ENABLE_STATS

static final String ENABLE_STATS

Connection property to enable collection of statistics at statement level.

See Also:

Constant Field Values

ENABLE_TIMESTATS

static final String ENABLE_TIMESTATS

Connection property to enable collection of time statistics at statement level.

See Also:

Constant Field Values

INIT_SCRIPTS

static final String INIT_SCRIPTS

The property used to specify the SQL scripts to be executed after VM startup is complete including initial DDL replay.

See Also:

Constant Field Values

SERVER_GROUPS

static final String SERVER_GROUPS

The property used to specify the server groups.

See Also:

Constant Field Values

SQLF_HOST_DATA

static final String SQLF_HOST_DATA

The SQLFire property used to specify whether this VM should host data or not (i.e. whether data-store or an accessor).

See Also:

Constant Field Values

SQLF_PERSIST_DD

static final String SQLF_PERSIST_DD

property name for enabling persistence of data dictionary

See Also:

Constant Field Values

TABLE_DEFAULT_PARTITIONED

static final String TABLE_DEFAULT_PARTITIONED

The default DataPolicy for tables is now replicated when no explicit partitioning has been defined. The below property can be used to change that default.

See Also:

Constant Field Values

LICENSE_SERIAL_NUMBER

static final String LICENSE_SERIAL_NUMBER

The serial number specified for licensing. If null, then licensing will use "default" evaluation license or attempt to acquire a license from a vFabric installation or vFabric License Server.

See Also:

Constant Field Values

SYS_PERSISTENT_DIR

static final String SYS_PERSISTENT_DIR

The property used to specify the base directory for Sql Fabric persistence of Gateway Queues, Tables, Data Dictionary etc.

See Also:

Constant Field Values

STAND_ALONE_LOCATOR

static final String STAND_ALONE_LOCATOR

Boot property to indicate that this is a stand-alone locator which is really a kind of peer client with a network server running on it to enable processing client locator related DML commands. However, a locator VM does not have any tables or data.

See Also:

Constant Field Values

AUTH_PROVIDER

static final String AUTH_PROVIDER

Authentication scheme for client connections.

See Also:

Constant Field Values

SERVER_AUTH_PROVIDER

static final String SERVER_AUTH_PROVIDER

Authentication scheme configuration for server-to-server communication. Fully qualified java class name can be mentioned implementing CredentialInitializer and UserAuthenticator interfaces

See Also:

Constant Field Values

CLIENT_SECURITY_MECHANISM

static final String CLIENT_SECURITY_MECHANISM

securityMechanism sets the DRDA mechanism in-use for the client

See Also:

Constant Field Values

SQLF_PREFIX

static final String SQLF_PREFIX

Prefix when setting a boot/connection property as a system property.

See Also:

Constant Field Values

DNC_PROTOCOL

static final String DNC_PROTOCOL

The protocol for Derby Network Client.

See Also:

Constant Field Values

CLIENT_JVM_PROPERTY_PREFIX

static final String CLIENT_JVM_PROPERTY_PREFIX

User should use this prefix for the client attributes traceLevel and traceDirectory when they are sending those attributes as JVM properties. These 2 attributes can be sent through jdbc url directly (supported way) or as JVM properties with the following prefix (undocumented way). DERBY-1275

See Also:

Constant Field Values

USING_ODBC_DRIVER

static final String USING_ODBC_DRIVER

System property to denote that the driver is invoked using ODBC API.

See Also:

Constant Field Values

SQLF_ENABLE_TX_WAIT_MODE

static final String SQLF_ENABLE_TX_WAIT_MODE

System property to set ENABLE_TX_WAIT_MODE for all connections.

See Also:

Constant Field Values

PREFER_NETSERVER_IP_ADDRESS

static final String PREFER_NETSERVER_IP_ADDRESS

System property to force using IP addresses rather than hostnames for clients.

See Also:

Constant Field Values

DBNAME_ATTR

static final String DBNAME_ATTR

The attribute that is used for the database name, from the JDBC notion of jdbc::

See Also:

Constant Field Values

CREATE_ATTR

static final String CREATE_ATTR

The attribute that is used to request a database create.

See Also:

Constant Field Values

UPGRADE_ATTR

static final String UPGRADE_ATTR

The attribute that is used to allow upgrade.

See Also:

Constant Field Values

JCC_PROTOCOL

static final String JCC_PROTOCOL

The protocol for the IBM Universal JDBC Driver

See Also:

Constant Field Values