com.trendmicro.grid.acl.mssql
Interface MSSQLSystemProperties

All Known Implementing Classes:

MSSQLConfigurator

public interface MSSQLSystemProperties

Defines all system properties that are used by the MSSQL binding.

Author:

Juergen_Kellerer, 2012-02-20

Field Summary

static String	PROPERTY_AO_READONLY Is a boolean property that toggles whether the SQLServer driver is used with readonly Always On feature
static String	PROPERTY_FAILOVER_HOST Is a property defining the hostname or IP-address of the MSSQL server that hosts a hot standby mirror of the GRID CoreDB.
static String	PROPERTY_HOST Is a property defining the hostname or IP-address of the MSSQL server that hosts the GRID CoreDB.
static String	PROPERTY_MOSUL_USE_PARAMETRIZED_TAG_QUERIES When set to true, uses prepared parametrized queries with FT searches instead of building adhoc search queries with values being included as text.
static String	PROPERTY_MSSQL_USE_FTSEARCH_TAG_QUERIES Tuning property to enable fulltext search in MSSQL instead of using full table scan for tag queries.
static String	PROPERTY_MSSQL_USE_TAG_QUERY_PROVIDER_ALWAYS Tuning property to force enabling this tag query provider even when fulltext search is not enabled.
static String	PROPERTY_NO_XA Is a boolean property that toggles whether the SQLServer driver is used with the classic Driver interface wrapped in an XA.emulating datasource instead of using the driver's real XA interface which provides true distributed transactions at the cost of additional database configuration inside the SQLServer.
static String	PROPERTY_USE_AO Is a boolean property that toggles whether the SQLServer driver is used with Always On feature

Field Detail

PROPERTY_HOST

static final String PROPERTY_HOST

Is a property defining the hostname or IP-address of the MSSQL server that hosts the GRID CoreDB. The default configuration that is created by the MSSQL extension will only enable MSSQL support if this system property was specified.
Note: Setting the port number with the hostname or IP-address is not allowed.

See Also:

Constant Field Values

PROPERTY_FAILOVER_HOST

static final String PROPERTY_FAILOVER_HOST

Is a property defining the hostname or IP-address of the MSSQL server that hosts a hot standby mirror of the GRID CoreDB. Use this parameter in high availability setups.
Note: Setting the port number with the hostname or IP-address is not allowed.

Since:

1.2.2

See Also:

Constant Field Values

PROPERTY_NO_XA

static final String PROPERTY_NO_XA

Is a boolean property that toggles whether the SQLServer driver is used with the classic Driver interface wrapped in an XA.emulating datasource instead of using the driver's real XA interface which provides true distributed transactions at the cost of additional database configuration inside the SQLServer.

Since:

1.2.2

See Also:

Constant Field Values

PROPERTY_MOSUL_USE_PARAMETRIZED_TAG_QUERIES

static final String PROPERTY_MOSUL_USE_PARAMETRIZED_TAG_QUERIES

When set to true, uses prepared parametrized queries with FT searches instead of building adhoc search queries with values being included as text. Note: In general this should offer better performance, however SQLServer 2008 crashes when this is enabled.

See Also:

Constant Field Values

PROPERTY_MSSQL_USE_FTSEARCH_TAG_QUERIES

static final String PROPERTY_MSSQL_USE_FTSEARCH_TAG_QUERIES

Tuning property to enable fulltext search in MSSQL instead of using full table scan for tag queries.
Fulltext search has the disadvantage that date limitation is not honored in the index, thus a table scan with a data range limitation can be faster.

Starting from version 1.2.3, FT searches are no longer enabled by default. Use this option to bring back the behaviour of previous versions.

Since:

1.2.3

See Also:

Constant Field Values

PROPERTY_MSSQL_USE_TAG_QUERY_PROVIDER_ALWAYS

static final String PROPERTY_MSSQL_USE_TAG_QUERY_PROVIDER_ALWAYS

Tuning property to force enabling this tag query provider even when fulltext search is not enabled.

Since:

1.2.3

See Also:

Constant Field Values

PROPERTY_USE_AO

static final String PROPERTY_USE_AO

Is a boolean property that toggles whether the SQLServer driver is used with Always On feature

Since:

1.2.2

See Also:

Constant Field Values

PROPERTY_AO_READONLY

static final String PROPERTY_AO_READONLY

Is a boolean property that toggles whether the SQLServer driver is used with readonly Always On feature

Since:

1.2.2

See Also:

Constant Field Values