com.atlassian.core.ofbiz.util.database.mssql

Class MSSQLIndexUtil

java.lang.Object

com.atlassian.core.ofbiz.util.database.mssql.MSSQLIndexUtil

public class MSSQLIndexUtil
extends Object

This class encompasses methods to retrieve info about state and limitations of MS SQL indexes

Since:

v8.0

Method Summary

Modifier and Type	Method and Description
static int	getCountFromIndexTableQuery(Connection connection, String sql, String tableName, String indexName)
static int	getDbMajorVersion(Connection conn)
static int	getUnclusteredMaximumKeySizeForMajorVersion(int majorVersion)
static boolean	indexHasIncludedColumns(Connection connection, String tableName, String indexName)
static boolean	isMSSQLAndMajorVersion(Connection connection, int expectedMajorVersion)
static boolean	isMSSQLAndMajorVersion(Connection connection, java.util.function.Predicate<Integer> majorVersionPredicate)
static boolean	isSqlServer(Connection conn)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

getUnclusteredMaximumKeySizeForMajorVersion

public static int getUnclusteredMaximumKeySizeForMajorVersion(int majorVersion)

Parameters:

majorVersion - of MSSQL database

Returns:

maximum number of bytes for index key

isSqlServer

public static boolean isSqlServer(Connection conn)
                           throws SQLException

Throws:

SQLException

getDbMajorVersion

public static int getDbMajorVersion(Connection conn)
                             throws SQLException

Throws:

SQLException

isMSSQLAndMajorVersion

public static boolean isMSSQLAndMajorVersion(Connection connection,
                                             int expectedMajorVersion)
                                      throws SQLException

Throws:

SQLException

isMSSQLAndMajorVersion

public static boolean isMSSQLAndMajorVersion(Connection connection,
                                             java.util.function.Predicate<Integer> majorVersionPredicate)
                                      throws SQLException

Throws:

SQLException

indexHasIncludedColumns

public static boolean indexHasIncludedColumns(Connection connection,
                                              String tableName,
                                              String indexName)
                                       throws SQLException

Throws:

SQLException

getCountFromIndexTableQuery

public static int getCountFromIndexTableQuery(Connection connection,
                                              String sql,
                                              String tableName,
                                              String indexName)
                                       throws SQLException

Throws:

SQLException