1   package com.trendmicro.grid.acl.mssql;
2   
3   /**
4    * Defines all system properties that are used by the MSSQL binding.
5    *
6    * @author Juergen_Kellerer, 2012-02-20
7    */
8   public interface MSSQLSystemProperties {
9   
10  	/**
11  	 * Is a property defining the hostname or IP-address of the MSSQL server that hosts the GRID CoreDB. The default configuration
12  	 * that is created by the MSSQL extension will only enable MSSQL support if this system property was specified.
13  	 * <br/>
14  	 * <b>Note:</b> Setting the port number with the hostname or IP-address is not allowed.
15  	 */
16  	String PROPERTY_HOST = "mssqlserver";
17  
18  	/**
19  	 * Is a property defining the hostname or IP-address of the MSSQL server that hosts a <b>hot standby mirror</b> of the
20  	 * GRID CoreDB. Use this parameter in high availability setups.
21  	 * <br/>
22  	 * <b>Note:</b> Setting the port number with the hostname or IP-address is not allowed.
23  	 *
24  	 * @since 1.2.2
25  	 */
26  	String PROPERTY_FAILOVER_HOST = "mssqlserverFailover";
27  
28  	/**
29  	 * Is a boolean property that toggles whether the SQLServer driver is used with the classic Driver interface wrapped in an
30  	 * XA.emulating datasource instead of using the driver's real XA interface which provides true distributed transactions at the
31  	 * cost of additional database configuration inside the SQLServer.
32  	 *
33  	 * @since 1.2.2
34  	 */
35  	String PROPERTY_NO_XA = "mssql.no.xa";
36  
37  	/**
38  	 * When set to true, uses prepared parametrized queries with FT searches instead of building adhoc search
39  	 * queries with values being included as text.
40  	 * Note: In general this should offer better performance, however SQLServer 2008 crashes when this is enabled.
41  	 */
42  	String PROPERTY_MOSUL_USE_PARAMETRIZED_TAG_QUERIES = "gacl.mssql.use.parametrized.tag.queries";
43  
44  	/**
45  	 * Tuning property to enable fulltext search in MSSQL instead of using full table scan for tag queries.
46  	 * <br/>
47  	 * Fulltext search has the disadvantage that date limitation is not honored in the index, thus a table scan
48  	 * with a data range limitation can be faster.
49  	 * <p/>
50  	 * Starting from version 1.2.3, FT searches are no longer enabled by default. Use this option to bring back the
51  	 * behaviour of previous versions.
52  	 *
53  	 * @since 1.2.3
54  	 */
55  	String PROPERTY_MSSQL_USE_FTSEARCH_TAG_QUERIES = "mssql.use.ftsearch.tag.queries";
56  
57  	/**
58  	 * Tuning property to force enabling this tag query provider even when fulltext search is not enabled.
59  	 *
60  	 * @since 1.2.3
61  	 */
62  	String PROPERTY_MSSQL_USE_TAG_QUERY_PROVIDER_ALWAYS = "mssql.use.tag.query.provider.always";
63  
64      /**
65       * Is a boolean property that toggles whether the SQLServer driver is used with Always On feature
66       *
67       * @since 1.2.2
68       */
69      String PROPERTY_USE_AO = "mssql.use.ao";
70  
71      /**
72       * Is a boolean property that toggles whether the SQLServer driver is used with readonly Always On feature
73       *
74       * @since 1.2.2
75       */
76      String PROPERTY_AO_READONLY = "readonly";
77  }