Package com.blazebit.persistence.impl.dialect

Class MSSQLDbmsDialect

java.lang.Object

com.blazebit.persistence.impl.dialect.DefaultDbmsDialect

com.blazebit.persistence.impl.dialect.MSSQLDbmsDialect

All Implemented Interfaces:

DbmsDialect

public class MSSQLDbmsDialect
extends DefaultDbmsDialect

Since:

1.2.0

Author:

Christian Beikov, Moritz Becker

Constructor Summary

Constructors

Constructor	Description
MSSQLDbmsDialect()
MSSQLDbmsDialect(Map<Class<?>,String> childSqlTypes)

Method Summary

Modifier and Type	Method	Description
Map<String,String>	appendExtendedSql(StringBuilder sqlSb, DbmsStatementType statementType, boolean isSubquery, boolean isEmbedded, StringBuilder withClause, String limit, String offset, String dmlAffectedTable, String[] returningColumns, Map<DbmsModificationState,String> includedModificationStates)
void	appendOrderByElement(StringBuilder sqlSb, OrderByElement element, String[] aliases)
DbmsLimitHandler	createLimitHandler()
DeleteJoinStyle	getDeleteJoinStyle()
LateralStyle	getLateralStyle()
protected String	getOperator(SetOperationType type)
UpdateJoinStyle	getUpdateJoinStyle()
protected String	getWindowFunctionDummyOrderBy()
String	getWithClause(boolean recursive)
boolean	isNullSmallest()
protected boolean	needsAliasForFromClause()
protected boolean	needsAliasInSetOrderBy()
boolean	supportsArbitraryLengthMultiset()
boolean	supportsFullRowValueComparison()
boolean	supportsLimitWithoutOrderBy()
boolean	supportsNullPrecedence()
protected boolean	supportsPartitionInRowNumberOver()
boolean	supportsReturningColumns()
boolean	supportsRowValueConstructor()

Methods inherited from class com.blazebit.persistence.impl.dialect.DefaultDbmsDialect

appendEmulatedOrderByElementWithNulls, appendExtendedSql, appendLimit, appendOrderBy, appendSet, appendSetOperands, cast, extractReturningResult, getDefaultEscapeCharacter, getDummyTable, getPhysicalRowId, getPrepareFlags, getSqlType, getValuesStrategy, indexOfIgnoreCase, needsCastParameters, needsReturningSqlTypes, needsSetOperationWrapper, needsUniqueSelectItemNamesAlsoWhenTableColumnAliasing, prepare, regionMatchesIgnoreCase, requiresNullCast, supportsAnsiRowValueConstructor, supportsBooleanAggregation, supportsComplexJoinOn, supportsCountTuple, supportsExcept, supportsFilterClause, supportsGroupByExpressionInHavingMatching, supportsIntersect, supportsJoinsInRecursiveCte, supportsLimitInQuantifiedPredicateSubquery, supportsModificationQueryInWithClause, supportsNestedCorrelations, supportsNonRecursiveWithClause, supportsReturningAllGeneratedKeys, supportsReturningGeneratedKeys, supportsUnion, supportsWindowFunctions, supportsWindowNullPrecedence, supportsWithClause, supportsWithClauseHead, supportsWithClauseInModificationQuery, usesExecuteUpdateWhenWithClauseInModificationQuery

Methods inherited from class java.lang.Object

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

Constructor Details

MSSQLDbmsDialect

public MSSQLDbmsDialect()

MSSQLDbmsDialect

public MSSQLDbmsDialect(Map<Class<?>,String> childSqlTypes)

Method Details

getWithClause

public String getWithClause(boolean recursive)

Specified by:

getWithClause in interface DbmsDialect

Overrides:

getWithClause in class DefaultDbmsDialect

getWindowFunctionDummyOrderBy

protected String getWindowFunctionDummyOrderBy()

Overrides:

getWindowFunctionDummyOrderBy in class DefaultDbmsDialect

supportsReturningColumns

public boolean supportsReturningColumns()

Specified by:

supportsReturningColumns in interface DbmsDialect

Overrides:

supportsReturningColumns in class DefaultDbmsDialect

isNullSmallest

public boolean isNullSmallest()

Specified by:

isNullSmallest in interface DbmsDialect

Overrides:

isNullSmallest in class DefaultDbmsDialect

getLateralStyle

public LateralStyle getLateralStyle()

Specified by:

getLateralStyle in interface DbmsDialect

Overrides:

getLateralStyle in class DefaultDbmsDialect

getDeleteJoinStyle

public DeleteJoinStyle getDeleteJoinStyle()

Specified by:

getDeleteJoinStyle in interface DbmsDialect

Overrides:

getDeleteJoinStyle in class DefaultDbmsDialect

getUpdateJoinStyle

public UpdateJoinStyle getUpdateJoinStyle()

Specified by:

getUpdateJoinStyle in interface DbmsDialect

Overrides:

getUpdateJoinStyle in class DefaultDbmsDialect

supportsArbitraryLengthMultiset

public boolean supportsArbitraryLengthMultiset()

Specified by:

supportsArbitraryLengthMultiset in interface DbmsDialect

Overrides:

supportsArbitraryLengthMultiset in class DefaultDbmsDialect

getOperator

protected String getOperator(SetOperationType type)

Overrides:

getOperator in class DefaultDbmsDialect

supportsPartitionInRowNumberOver

protected boolean supportsPartitionInRowNumberOver()

Overrides:

supportsPartitionInRowNumberOver in class DefaultDbmsDialect

supportsRowValueConstructor

public boolean supportsRowValueConstructor()

Specified by:

supportsRowValueConstructor in interface DbmsDialect

Overrides:

supportsRowValueConstructor in class DefaultDbmsDialect

supportsFullRowValueComparison

public boolean supportsFullRowValueComparison()

Specified by:

supportsFullRowValueComparison in interface DbmsDialect

Overrides:

supportsFullRowValueComparison in class DefaultDbmsDialect

supportsNullPrecedence

public boolean supportsNullPrecedence()

Specified by:

supportsNullPrecedence in interface DbmsDialect

Overrides:

supportsNullPrecedence in class DefaultDbmsDialect

appendExtendedSql

public Map<String,String> appendExtendedSql(StringBuilder sqlSb,
 DbmsStatementType statementType,
 boolean isSubquery,
 boolean isEmbedded,
 StringBuilder withClause,
 String limit,
 String offset,
 String dmlAffectedTable,
 String[] returningColumns,
 Map<DbmsModificationState,String> includedModificationStates)

Specified by:

appendExtendedSql in interface DbmsDialect

Overrides:

appendExtendedSql in class DefaultDbmsDialect

needsAliasForFromClause

protected boolean needsAliasForFromClause()

Overrides:

needsAliasForFromClause in class DefaultDbmsDialect

needsAliasInSetOrderBy

protected boolean needsAliasInSetOrderBy()

Overrides:

needsAliasInSetOrderBy in class DefaultDbmsDialect

appendOrderByElement

public void appendOrderByElement(StringBuilder sqlSb,
 OrderByElement element,
 String[] aliases)

Specified by:

appendOrderByElement in interface DbmsDialect

Overrides:

appendOrderByElement in class DefaultDbmsDialect

createLimitHandler

public DbmsLimitHandler createLimitHandler()

Specified by:

createLimitHandler in interface DbmsDialect

Overrides:

createLimitHandler in class DefaultDbmsDialect

supportsLimitWithoutOrderBy

public boolean supportsLimitWithoutOrderBy()

Specified by:

supportsLimitWithoutOrderBy in interface DbmsDialect

Overrides:

supportsLimitWithoutOrderBy in class DefaultDbmsDialect