Package com.blazebit.persistence.impl.dialect

Class DefaultDbmsDialect

java.lang.Object

com.blazebit.persistence.impl.dialect.DefaultDbmsDialect

All Implemented Interfaces:

DbmsDialect

Direct Known Subclasses:

DB2DbmsDialect, H2DbmsDialect, HSQLDbmsDialect, MSSQLDbmsDialect, MySQLDbmsDialect, OracleDbmsDialect, PostgreSQLDbmsDialect

public class DefaultDbmsDialect
extends Object
implements DbmsDialect

Since:

1.2.0

Author:

Christian Beikov, Moritz Becker

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
protected void	appendEmulatedOrderByElementWithNulls(StringBuilder sqlSb, OrderByElement element, String[] aliases)
Map<String,String>	appendExtendedSql(StringBuilder sqlSb, DbmsStatementType statementType, boolean isSubquery, boolean isEmbedded, StringBuilder withClause, String limit, String offset, String[] returningColumns, Map<DbmsModificationState,String> includedModificationStates)
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	appendLimit(StringBuilder sqlSb, boolean isSubquery, String limit, String offset)
protected void	appendOrderBy(StringBuilder sqlSb, List<? extends OrderByElement> orderByElements, String[] aliases)
void	appendOrderByElement(StringBuilder sqlSb, OrderByElement element, String[] aliases)
void	appendSet(StringBuilder sqlSb, SetOperationType setType, boolean isSubquery, List<String> operands, List<? extends OrderByElement> orderByElements, String limit, String offset)
protected String[]	appendSetOperands(StringBuilder sqlSb, SetOperationType setType, String operator, boolean isSubquery, List<String> operands, boolean hasOuterClause)
String	cast(String expression, String sqlType)
DbmsLimitHandler	createLimitHandler()
ResultSet	extractReturningResult(PreparedStatement ps)
Character	getDefaultEscapeCharacter()
DeleteJoinStyle	getDeleteJoinStyle()
String	getDummyTable()
LateralStyle	getLateralStyle()
protected String	getOperator(SetOperationType type)
String	getPhysicalRowId()
int	getPrepareFlags()
String	getSqlType(Class<?> castType)
UpdateJoinStyle	getUpdateJoinStyle()
ValuesStrategy	getValuesStrategy()
protected String	getWindowFunctionDummyOrderBy()
String	getWithClause(boolean recursive)
protected static int	indexOfIgnoreCase(StringBuilder haystack, String needle)
boolean	isNullSmallest()
protected boolean	needsAliasForFromClause()
protected boolean	needsAliasInSetOrderBy()
boolean	needsCastParameters()
boolean	needsReturningSqlTypes()
protected boolean	needsSetOperationWrapper()
boolean	needsUniqueSelectItemNamesAlsoWhenTableColumnAliasing()
PreparedStatement	prepare(PreparedStatement ps, int[] returningSqlTypes)
protected static boolean	regionMatchesIgnoreCase(StringBuilder haystack, int thisStart, String substring, int start, int length)
boolean	requiresNullCast()
boolean	supportsAnsiRowValueConstructor()
boolean	supportsArbitraryLengthMultiset()
boolean	supportsBooleanAggregation()
boolean	supportsComplexJoinOn()
boolean	supportsCountTuple()
boolean	supportsExcept(boolean all)
boolean	supportsFilterClause()
boolean	supportsFullRowValueComparison()
boolean	supportsGroupByExpressionInHavingMatching()
boolean	supportsIntersect(boolean all)
boolean	supportsJoinsInRecursiveCte()
boolean	supportsLimitInQuantifiedPredicateSubquery()
boolean	supportsLimitWithoutOrderBy()
boolean	supportsModificationQueryInWithClause()
boolean	supportsNestedCorrelations()
boolean	supportsNonRecursiveWithClause()
boolean	supportsNullPrecedence()
protected boolean	supportsPartitionInRowNumberOver()
boolean	supportsReturningAllGeneratedKeys()
boolean	supportsReturningColumns()
boolean	supportsReturningGeneratedKeys()
boolean	supportsRowValueConstructor()
boolean	supportsUnion(boolean all)
boolean	supportsWindowFunctions()
boolean	supportsWindowNullPrecedence()
boolean	supportsWithClause()
boolean	supportsWithClauseHead()
boolean	supportsWithClauseInModificationQuery()
boolean	usesExecuteUpdateWhenWithClauseInModificationQuery()

Methods inherited from class java.lang.Object

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

Constructor Details

DefaultDbmsDialect

public DefaultDbmsDialect()

DefaultDbmsDialect

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

Method Details

supportsWithClause

public boolean supportsWithClause()

Specified by:

supportsWithClause in interface DbmsDialect

supportsNonRecursiveWithClause

public boolean supportsNonRecursiveWithClause()

Specified by:

supportsNonRecursiveWithClause in interface DbmsDialect

supportsWithClauseHead

public boolean supportsWithClauseHead()

Specified by:

supportsWithClauseHead in interface DbmsDialect

supportsJoinsInRecursiveCte

public boolean supportsJoinsInRecursiveCte()

Specified by:

supportsJoinsInRecursiveCte in interface DbmsDialect

supportsAnsiRowValueConstructor

public boolean supportsAnsiRowValueConstructor()

Specified by:

supportsAnsiRowValueConstructor in interface DbmsDialect

supportsRowValueConstructor

public boolean supportsRowValueConstructor()

Specified by:

supportsRowValueConstructor in interface DbmsDialect

supportsFullRowValueComparison

public boolean supportsFullRowValueComparison()

Specified by:

supportsFullRowValueComparison in interface DbmsDialect

supportsCountTuple

public boolean supportsCountTuple()

Specified by:

supportsCountTuple in interface DbmsDialect

supportsWindowFunctions

public boolean supportsWindowFunctions()

Specified by:

supportsWindowFunctions in interface DbmsDialect

supportsFilterClause

public boolean supportsFilterClause()

Specified by:

supportsFilterClause in interface DbmsDialect

supportsNullPrecedence

public boolean supportsNullPrecedence()

Specified by:

supportsNullPrecedence in interface DbmsDialect

supportsWindowNullPrecedence

public boolean supportsWindowNullPrecedence()

Specified by:

supportsWindowNullPrecedence in interface DbmsDialect

supportsBooleanAggregation

public boolean supportsBooleanAggregation()

Specified by:

supportsBooleanAggregation in interface DbmsDialect

isNullSmallest

public boolean isNullSmallest()

Specified by:

isNullSmallest in interface DbmsDialect

requiresNullCast

public boolean requiresNullCast()

Specified by:

requiresNullCast in interface DbmsDialect

getPhysicalRowId

public String getPhysicalRowId()

Specified by:

getPhysicalRowId in interface DbmsDialect

getLateralStyle

public LateralStyle getLateralStyle()

Specified by:

getLateralStyle in interface DbmsDialect

getDeleteJoinStyle

public DeleteJoinStyle getDeleteJoinStyle()

Specified by:

getDeleteJoinStyle in interface DbmsDialect

getUpdateJoinStyle

public UpdateJoinStyle getUpdateJoinStyle()

Specified by:

getUpdateJoinStyle in interface DbmsDialect

supportsArbitraryLengthMultiset

public boolean supportsArbitraryLengthMultiset()

Specified by:

supportsArbitraryLengthMultiset in interface DbmsDialect

getSqlType

public String getSqlType(Class<?> castType)

Specified by:

getSqlType in interface DbmsDialect

getWithClause

public String getWithClause(boolean recursive)

Specified by:

getWithClause in interface DbmsDialect

appendExtendedSql

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

Specified by:

appendExtendedSql in interface DbmsDialect

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

appendSet

public void appendSet(StringBuilder sqlSb,
 SetOperationType setType,
 boolean isSubquery,
 List<String> operands,
 List<? extends OrderByElement> orderByElements,
 String limit,
 String offset)

Specified by:

appendSet in interface DbmsDialect

createLimitHandler

public DbmsLimitHandler createLimitHandler()

Specified by:

createLimitHandler in interface DbmsDialect

supportsLimitWithoutOrderBy

public boolean supportsLimitWithoutOrderBy()

Specified by:

supportsLimitWithoutOrderBy in interface DbmsDialect

supportsLimitInQuantifiedPredicateSubquery

public boolean supportsLimitInQuantifiedPredicateSubquery()

Specified by:

supportsLimitInQuantifiedPredicateSubquery in interface DbmsDialect

supportsNestedCorrelations

public boolean supportsNestedCorrelations()

Specified by:

supportsNestedCorrelations in interface DbmsDialect

getWindowFunctionDummyOrderBy

protected String getWindowFunctionDummyOrderBy()

needsAliasInSetOrderBy

protected boolean needsAliasInSetOrderBy()

supportsPartitionInRowNumberOver

protected boolean supportsPartitionInRowNumberOver()

needsAliasForFromClause

protected boolean needsAliasForFromClause()

needsSetOperationWrapper

protected boolean needsSetOperationWrapper()

appendSetOperands

protected String[] appendSetOperands(StringBuilder sqlSb,
 SetOperationType setType,
 String operator,
 boolean isSubquery,
 List<String> operands,
 boolean hasOuterClause)

appendOrderBy

protected void appendOrderBy(StringBuilder sqlSb,
 List<? extends OrderByElement> orderByElements,
 String[] aliases)

appendOrderByElement

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

Specified by:

appendOrderByElement in interface DbmsDialect

appendEmulatedOrderByElementWithNulls

protected void appendEmulatedOrderByElementWithNulls(StringBuilder sqlSb,
 OrderByElement element,
 String[] aliases)

getOperator

protected String getOperator(SetOperationType type)

supportsUnion

public boolean supportsUnion(boolean all)

Specified by:

supportsUnion in interface DbmsDialect

supportsIntersect

public boolean supportsIntersect(boolean all)

Specified by:

supportsIntersect in interface DbmsDialect

supportsExcept

public boolean supportsExcept(boolean all)

Specified by:

supportsExcept in interface DbmsDialect

supportsWithClauseInModificationQuery

public boolean supportsWithClauseInModificationQuery()

Specified by:

supportsWithClauseInModificationQuery in interface DbmsDialect

supportsModificationQueryInWithClause

public boolean supportsModificationQueryInWithClause()

Specified by:

supportsModificationQueryInWithClause in interface DbmsDialect

usesExecuteUpdateWhenWithClauseInModificationQuery

public boolean usesExecuteUpdateWhenWithClauseInModificationQuery()

Specified by:

usesExecuteUpdateWhenWithClauseInModificationQuery in interface DbmsDialect

supportsReturningGeneratedKeys

public boolean supportsReturningGeneratedKeys()

Specified by:

supportsReturningGeneratedKeys in interface DbmsDialect

supportsReturningAllGeneratedKeys

public boolean supportsReturningAllGeneratedKeys()

Specified by:

supportsReturningAllGeneratedKeys in interface DbmsDialect

supportsReturningColumns

public boolean supportsReturningColumns()

Specified by:

supportsReturningColumns in interface DbmsDialect

supportsGroupByExpressionInHavingMatching

public boolean supportsGroupByExpressionInHavingMatching()

Specified by:

supportsGroupByExpressionInHavingMatching in interface DbmsDialect

supportsComplexJoinOn

public boolean supportsComplexJoinOn()

Specified by:

supportsComplexJoinOn in interface DbmsDialect

getValuesStrategy

public ValuesStrategy getValuesStrategy()

Specified by:

getValuesStrategy in interface DbmsDialect

needsUniqueSelectItemNamesAlsoWhenTableColumnAliasing

public boolean needsUniqueSelectItemNamesAlsoWhenTableColumnAliasing()

Specified by:

needsUniqueSelectItemNamesAlsoWhenTableColumnAliasing in interface DbmsDialect

needsCastParameters

public boolean needsCastParameters()

Specified by:

needsCastParameters in interface DbmsDialect

getDummyTable

public String getDummyTable()

Specified by:

getDummyTable in interface DbmsDialect

cast

public String cast(String expression,
 String sqlType)

Specified by:

cast in interface DbmsDialect

getDefaultEscapeCharacter

public Character getDefaultEscapeCharacter()

Specified by:

getDefaultEscapeCharacter in interface DbmsDialect

needsReturningSqlTypes

public boolean needsReturningSqlTypes()

Specified by:

needsReturningSqlTypes in interface DbmsDialect

getPrepareFlags

public int getPrepareFlags()

Specified by:

getPrepareFlags in interface DbmsDialect

prepare

public PreparedStatement prepare(PreparedStatement ps,
 int[] returningSqlTypes)
                          throws SQLException

Specified by:

prepare in interface DbmsDialect

Throws:

SQLException

extractReturningResult

public ResultSet extractReturningResult(PreparedStatement ps)
                                 throws SQLException

Specified by:

extractReturningResult in interface DbmsDialect

Throws:

SQLException

appendLimit

public void appendLimit(StringBuilder sqlSb,
 boolean isSubquery,
 String limit,
 String offset)

indexOfIgnoreCase

protected static int indexOfIgnoreCase(StringBuilder haystack,
 String needle)

regionMatchesIgnoreCase

protected static boolean regionMatchesIgnoreCase(StringBuilder haystack,
 int thisStart,
 String substring,
 int start,
 int length)