Class DB2SqlAstTranslator<T extends JdbcOperation>

java.lang.Object

org.hibernate.dialect.sql.ast.spi.AbstractSqlAstTranslator<T>

org.hibernate.dialect.sql.ast.spi.SqlAstTranslatorWithMerge<T>

org.hibernate.dialect.sql.ast.spi.DB2SqlAstTranslator<T>

All Implemented Interfaces:

Appendable, SqlAstWalker, SqlAstTranslator<T>, SqlAppender

@SPI({USE,IMPLEMENT})
public class DB2SqlAstTranslator<T extends JdbcOperation>
extends SqlAstTranslatorWithMerge<T>

A SQL AST translator for DB2.

Nested Class Summary

Nested classes/interfaces inherited from class AbstractSqlAstTranslator

AbstractSqlAstTranslator.LockStrategy, AbstractSqlAstTranslator.SubQueryRelationalRestrictionEmulationRenderer<X>

Field Summary

Fields inherited from interface SqlAppender

CLOSE_PARENTHESIS, COMMA_SEPARATOR, COMMA_SEPARATOR_CHAR, NO_SEPARATOR, NULL_KEYWORD, OPEN_PARENTHESIS, PARAM_MARKER, WHITESPACE

Constructor Summary

Constructors

Constructor	Description
DB2SqlAstTranslator(SqlAstTranslationRequest<? extends Statement, T> request)

Method Summary

Modifier and Type	Method	Description
protected void	emulateFetchOffsetWithWindowFunctionsVisitQueryPart(QueryPart queryPart)
DatabaseVersion	getDB2Version()
protected DerivedTableRenderingSupport	getDerivedTableRenderingSupport()	Supplies the strategy which selects derived-table rendering plans.
protected InsertConflictRenderingSupport	getInsertConflictRenderingSupport()	Supplies the strategy which selects insert-conflict rendering plans.
protected PaginationRenderingSupport	getPaginationRenderingSupport()	Supplies the strategy which selects SQL AST pagination plans.
protected QueryMutationRenderingSupport	getQueryMutationRenderingSupport()	Supplies the strategy which selects query update and delete rendering plans.
protected ReturningRenderingSupport	getReturningRenderingSupport()	Supplies the strategy which selects how mutations return generated column values.
protected SetReturningFunctionRenderingSupport	getSetReturningFunctionRenderingSupport()	Supplies the strategy which selects named set-returning-function plans.
protected TableJoinRenderingSupport	getTableJoinRenderingSupport()	Supplies the strategy which selects table-join rendering plans.
protected void	renderComparison(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderComparisonStandard(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderDmlTargetTableExpression(NamedTableReference tableReference)
protected void	renderExpressionAsClauseItem(Expression expression)
protected void	renderFetchExpression(Expression fetchExpression)
protected void	renderFromClauseAfterUpdateSet(UpdateStatement statement)
protected void	renderOffsetExpression(Expression offsetExpression)
protected void	renderSelectExpression(Expression expression)
protected void	renderSelectStatement(SelectStatement statement)	Render the SQL for a select statement after the base has established its statement-stack and parameter-rendering-mode invariants.
protected void	renderSelectTupleComparison(List<SqlSelection> lhsExpressions, SqlTuple tuple, ComparisonOperator operator)
protected boolean	supportsParameterOffsetFetchExpression()
protected void	visitAnsiCaseSearchedExpression(CaseSearchedExpression caseSearchedExpression, Consumer<Expression> resultRenderer)
protected void	visitAnsiCaseSimpleExpression(CaseSimpleExpression caseSimpleExpression, Consumer<Expression> resultRenderer)
protected void	visitArithmeticOperand(Expression expression)
void	visitBooleanExpressionPredicate(BooleanExpressionPredicate booleanExpressionPredicate)

Methods inherited from class SqlAstTranslatorWithMerge

createMergeOperation, expectation, renderMergeDelete, renderMergeInsert, renderMergeInto, renderMergeOn, renderMergeSourceAlias, renderMergeStatement, renderMergeTargetAlias, renderMergeUpdate, renderMergeUsing, renderMergeUsingQuery, renderMergeUsingQuerySelection

Methods inherited from class AbstractSqlAstTranslator

addAdditionalWherePredicate, addAffectedTableName, addParameterBinder, addParameterBinder, afterQueryGroup, append, append, append, appendBackslashEscapedLikeLiteral, appendDoubleQuoteEscapedString, appendSingleQuoteEscapedString, appendSql, appendSql, appendSql, appendSql, appendSql, appendSql, appendSql, applySqlComment, areAllResultsParameters, areAllResultsParameters, assertRowsOnlyFetchClauseType, beforeQueryGroup, castFunction, castNumberToString, determineColumnReferenceQualifier, determineCyclePathColumnName, determineLateralEmulationPredicate, determineLockingStrategy, determinePaginationRenderingPlan, determineUniqueConstraintNameThatMayFail, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctions, emulateQuantifiedTupleSubQueryPredicate, emulateSearchClauseOrderWithRowAndArray, emulateSelectTupleComparison, emulateSortSpecificationNullPrecedence, emulateSubQueryRelationalRestrictionPredicate, emulateTupleComparison, getAffectedTableNames, getArrayContainsFunction, getBooleanType, getClauseStack, getCteParameterRenderingMode, getCteStatement, getCurrentClauseStack, getCurrentDmlStatement, getCurrentQueryPart, getDialect, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockTimeout, getFetchClauseTypeForRowNumbering, getGroupBySelectItemReferenceStrategy, getIntegerType, getJdbcParameterBindings, getJdbcServices, getLeftHandExpression, getLimit, getLimitParameter, getLiteralValue, getLockingClauseStrategy, getLockOptions, getOffsetParameter, getParameterBinders, getParameterBindValue, getParameterRenderingMode, getQueryPartForRowNumbering, getQueryPartStack, getSelectItemReference, getSelectOnlyFromClause, getSessionFactory, getSingleRowTableExpression, getSortSpecificationsRowNumbering, getSql, getSqlAst, getSqlBuffer, getStatement, getStatementStack, getStringType, getTranslationRequest, getVersionSeedMapping, getWrapperOptions, hasAggregateFunctions, hasFrom, hasLimit, hasLimit, hasNestedOrTargetTableCorrelation, hasNonTrivialFromClause, hasOffset, hasTargetTableCorrelation, hasWhere, inOverOrWithinGroupClause, interpretExpression, isInRecursiveQueryPart, isInSubquery, isIntegerDivisionEmulationRequired, isLiteral, isLob, isParameter, isParameterInterpretation, isRenderingCorrelatedDerivedTable, isRenderingDerivedTable, isRenderingLateralDerivedTable, isRowNumberingCurrentQueryPart, isRowsOnlyFetchClauseType, isStruct, needsCteInlining, needsLocking, preferUnionQueryForTupleInListPredicate, registerAffectedTable, registerAffectedTable, render, renderAsLiteral, renderAssignmentColumn, renderBackslashEscapedLikePattern, renderCaseInsensitiveLikeEmulation, renderCasted, renderColumnWrite, renderCombinedLimitClause, renderCombinedLimitClause, renderCommaSeparated, renderCommaSeparatedSelectExpression, renderCommaSeparatedSelectExpression, renderComparisonDistinctOperator, renderComparisonEmulateCase, renderComparisonEmulateDecode, renderComparisonEmulateDecode, renderComparisonEmulateIntersect, renderCteSelectHint, renderCycleClause, renderCycleUsingClause, renderDeleteClause, renderDeleteStatementDirect, renderDeleteStatementWithJoinEmulation, renderDerivedTableReferenceIdentificationVariable, renderEmptyOrderBy, renderEscapeCharacter, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderExpressionsAsValuesSubquery, renderFetch, renderFetchFirstRow, renderFetchPlusOffsetExpression, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderFromClauseExcludingDmlTargetReference, renderFromClauseJoiningDmlTargetReference, renderFromClauseSpaces, renderInsertInto, renderInsertIntoNoColumns, renderInsertStatementAsMerge, renderInterval, renderIntervalLiteral, renderIntoIntoAndTable, renderLegacyReturningInsert, renderLikePattern, renderLikePredicate, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMaterializationHint, renderMergeUpdateClause, renderNamedSetReturningFunction, renderNull, renderOffset, renderOffsetFetchClause, renderOffsetFetchClause, renderOnDuplicateKeyConflictClause, renderOrderByClause, renderParameterAsParameter, renderPartitionItem, renderPrimaryTableReferencePrefix, renderQuantifiedEmulationSubQuery, renderQueryGroupWithoutOrderByAndOffsetFetch, renderQueryPartTableReferenceWithSelectListAliases, renderRecursiveCteVirtualSelections, renderRelationalEmulationSubQuery, renderRowNumber, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectClause, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectItems, renderSelectSimpleComparison, renderSetAssignment, renderSetAssignmentEmulateJoin, renderSetClause, renderSkipFirstClause, renderSkipFirstClause, renderSortExpression, renderStandardConflictClause, renderStandardCycleClause, renderStandardSearchClause, renderStandardTableInsert, renderStandardTableUpdate, renderStatementPrefix, renderStringContainsExactlyPredicate, renderTableReferenceAlias, renderTableReferenceIdentificationVariable, renderTenantRestriction, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderUpdateClause, renderUpdateStatementAsInlineView, renderUpdateStatementAsMerge, renderUpdateStatementAsScalarSubquery, renderUpdateStatementAsTupleSet, renderUpdateStatementDirect, renderValuesListAsSelectUnion, renderValuesListStandard, renderValuesTableReferenceWithSelectListAliases, renderVirtualSelections, renderWrappedParameter, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLockingTarget, shouldEmulateLateralWithIntersect, shouldInlineCte, simpleColumnWriteFragmentRendering, translate, useOffsetFetchClause, visitAggregateColumnWriteExpression, visitAny, visitAssignment, visitBetweenPredicate, visitBinaryArithmeticExpression, visitCaseSearchedExpression, visitCaseSearchedExpression, visitCaseSimpleExpression, visitCaseSimpleExpression, visitCastTarget, visitCollation, visitColumnReference, visitColumnWriteFragment, visitConversion, visitCteContainer, visitCustomTableDelete, visitCustomTableInsert, visitCustomTableUpdate, visitDecodeCaseSearchedExpression, visitDeleteClause, visitDeleteStatement, visitDeleteStatementOnly, visitDistinct, visitDuration, visitDurationUnit, visitEmbeddableTypeLiteral, visitEntityTypeLiteral, visitEvery, visitExistsPredicate, visitExtractUnit, visitFilterFragmentPredicate, visitFilterPredicate, visitFormat, visitForUpdateClause, visitFromClause, visitFunctionTableReference, visitGroupByClause, visitGroupedPredicate, visitHavingClause, visitInArrayPredicate, visitInListPredicate, visitInsertStatement, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitLikePredicate, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNestedColumnReference, visitNullnessPredicate, visitOffsetFetchClause, visitOptionalTableUpdate, visitOrderBy, visitOver, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryClauses, visitQueryGroup, visitQueryLiteral, visitQueryPartTableReference, visitQuerySpec, visitRecursivePath, visitRelationalPredicate, visitSelectClause, visitSelectStatement, visitSelfRenderingExpression, visitSelfRenderingPredicate, visitSetAssignment, visitSortSpecification, visitSortSpecification, visitSqlFragmentPredicate, visitSqlSelectExpression, visitSqlSelection, visitSqlSelectionExpression, visitStandardTableDelete, visitStandardTableInsert, visitStandardTableUpdate, visitStar, visitSummarization, visitTableGroup, visitTableGroupJoin, visitTableReferenceJoin, visitThruthnessPredicate, visitTrimSpecification, visitTuple, visitUnaryOperationExpression, visitUnparsedNumericLiteral, visitUpdateClause, visitUpdateStatement, visitUpdateStatementOnly, visitValuesList, visitValuesTableReference, visitWhereClause, withoutLateralDerivedTableContext, withParameterRenderingMode, withRowNumbering

Methods inherited from class Object

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

Constructor Details

DB2SqlAstTranslator

@SPI(IMPLEMENT)
public DB2SqlAstTranslator(SqlAstTranslationRequest<? extends Statement, T> request)

Method Details

getTableJoinRenderingSupport

protected TableJoinRenderingSupport getTableJoinRenderingSupport()

Description copied from class: AbstractSqlAstTranslator

Supplies the strategy which selects table-join rendering plans.

Override this hook for contextual alternatives such as comma joins or apply syntax. The translator remains responsible for predicates and traversal. The support must not be null and must not retain a supplied request.

Overrides:

getTableJoinRenderingSupport in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderExpressionAsClauseItem

protected void renderExpressionAsClauseItem(Expression expression)

Overrides:

renderExpressionAsClauseItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitArithmeticOperand

protected void visitArithmeticOperand(Expression expression)

Overrides:

visitArithmeticOperand in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitBooleanExpressionPredicate

public void visitBooleanExpressionPredicate(BooleanExpressionPredicate booleanExpressionPredicate)

Specified by:

visitBooleanExpressionPredicate in interface SqlAstWalker

Overrides:

visitBooleanExpressionPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitAnsiCaseSearchedExpression

protected void visitAnsiCaseSearchedExpression(CaseSearchedExpression caseSearchedExpression,
 Consumer<Expression> resultRenderer)

Overrides:

visitAnsiCaseSearchedExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitAnsiCaseSimpleExpression

protected void visitAnsiCaseSimpleExpression(CaseSimpleExpression caseSimpleExpression,
 Consumer<Expression> resultRenderer)

Overrides:

visitAnsiCaseSimpleExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

getPaginationRenderingSupport

protected PaginationRenderingSupport getPaginationRenderingSupport()

Description copied from class: AbstractSqlAstTranslator

Supplies the strategy which selects SQL AST pagination plans.

This hook controls pagination represented in the SQL AST. It is distinct from LimitHandler, which rewrites already-rendered SQL for execution-time query limits. The returned support must be non-null and must not retain supplied requests.

Overrides:

getPaginationRenderingSupport in class AbstractSqlAstTranslator<T extends JdbcOperation>

getDerivedTableRenderingSupport

protected DerivedTableRenderingSupport getDerivedTableRenderingSupport()

Description copied from class: AbstractSqlAstTranslator

Supplies the strategy which selects derived-table rendering plans.

Override this hook to customize query-part, values-table, or function-table syntax without overriding their traversal callbacks. The returned support must be non-null and must not retain supplied requests or translator state.

Overrides:

getDerivedTableRenderingSupport in class AbstractSqlAstTranslator<T extends JdbcOperation>

getSetReturningFunctionRenderingSupport

protected SetReturningFunctionRenderingSupport getSetReturningFunctionRenderingSupport()

Description copied from class: AbstractSqlAstTranslator

Supplies the strategy which selects named set-returning-function plans.

Override this hook to select native invocation, wrapping, or ordinality emulation while leaving argument traversal and SQL emission to the translator. The support must not be null and must not retain a supplied request.

Overrides:

getSetReturningFunctionRenderingSupport in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderSelectStatement

protected void renderSelectStatement(SelectStatement statement)

Description copied from class: AbstractSqlAstTranslator

Render the SQL for a select statement after the base has established its statement-stack and parameter-rendering-mode invariants. Overrides may decorate or replace the standard rendering and may delegate to super to retain it.

Overrides:

renderSelectStatement in class AbstractSqlAstTranslator<T extends JdbcOperation>

emulateFetchOffsetWithWindowFunctionsVisitQueryPart

protected void emulateFetchOffsetWithWindowFunctionsVisitQueryPart(QueryPart queryPart)

Overrides:

emulateFetchOffsetWithWindowFunctionsVisitQueryPart in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderOffsetExpression

protected void renderOffsetExpression(Expression offsetExpression)

Overrides:

renderOffsetExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderFetchExpression

protected void renderFetchExpression(Expression fetchExpression)

Overrides:

renderFetchExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

getQueryMutationRenderingSupport

protected QueryMutationRenderingSupport getQueryMutationRenderingSupport()

Description copied from class: AbstractSqlAstTranslator

Supplies the strategy which selects query update and delete rendering plans.

Override this hook to compose database-specific plan selection without taking ownership of statement traversal. The returned support must be non-null and must not retain supplied requests or translator state.

Overrides:

getQueryMutationRenderingSupport in class AbstractSqlAstTranslator<T extends JdbcOperation>

getReturningRenderingSupport

protected ReturningRenderingSupport getReturningRenderingSupport()

Description copied from class: AbstractSqlAstTranslator

Supplies the strategy which selects how mutations return generated column values.

Override this hook to select a trailing clause or data-change-table plan; leave column traversal and SQL emission to the translator. The returned support must be non-null and must not retain supplied requests.

Overrides:

getReturningRenderingSupport in class AbstractSqlAstTranslator<T extends JdbcOperation>

getInsertConflictRenderingSupport

protected InsertConflictRenderingSupport getInsertConflictRenderingSupport()

Description copied from class: AbstractSqlAstTranslator

Supplies the strategy which selects insert-conflict rendering plans.

Override this hook when the database's native or emulated conflict syntax differs from StandardInsertConflictRenderingSupport.CONSTRAINT_VIOLATION. The returned support must be non-null and must not retain supplied requests or translator state.

Overrides:

getInsertConflictRenderingSupport in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDmlTargetTableExpression

protected void renderDmlTargetTableExpression(NamedTableReference tableReference)

Overrides:

renderDmlTargetTableExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderFromClauseAfterUpdateSet

protected void renderFromClauseAfterUpdateSet(UpdateStatement statement)

Overrides:

renderFromClauseAfterUpdateSet in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderComparison

protected void renderComparison(Expression lhs,
 ComparisonOperator operator,
 Expression rhs)

Overrides:

renderComparison in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderComparisonStandard

protected void renderComparisonStandard(Expression lhs,
 ComparisonOperator operator,
 Expression rhs)

Overrides:

renderComparisonStandard in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderSelectExpression

protected void renderSelectExpression(Expression expression)

Overrides:

renderSelectExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderSelectTupleComparison

protected void renderSelectTupleComparison(List<SqlSelection> lhsExpressions,
 SqlTuple tuple,
 ComparisonOperator operator)

Overrides:

renderSelectTupleComparison in class AbstractSqlAstTranslator<T extends JdbcOperation>

getDB2Version

public DatabaseVersion getDB2Version()

supportsParameterOffsetFetchExpression

protected boolean supportsParameterOffsetFetchExpression()