Package org.hibernate.dialect.sql.ast

Class DB2SqlAstTranslator<T extends JdbcOperation>

java.lang.Object

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

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

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

All Implemented Interfaces:

Appendable, SqlAppender, SqlAstTranslator<T>, SqlAstWalker

Direct Known Subclasses:

DB2iSqlAstTranslator, DB2zSqlAstTranslator

public class DB2SqlAstTranslator<T extends JdbcOperation>
extends SqlAstTranslatorWithMerge<T>

A SQL AST translator for DB2.

Nested Class Summary

Nested classes/interfaces inherited from class org.hibernate.sql.ast.spi.AbstractSqlAstTranslator

AbstractSqlAstTranslator.LockStrategy, AbstractSqlAstTranslator.SubQueryRelationalRestrictionEmulationRenderer<X extends Expression>

Field Summary

Fields inherited from interface org.hibernate.sql.ast.spi.SqlAppender

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

Constructor Summary

Constructors

Constructor	Description
DB2SqlAstTranslator(SessionFactoryImplementor sessionFactory, Statement statement)

Method Summary

Modifier and Type	Method	Description
protected void	emulateFetchOffsetWithWindowFunctionsVisitQueryPart(QueryPart queryPart)
DatabaseVersion	getDB2Version()
protected String	getNewTableChangeModifier()
protected boolean	needsRecursiveKeywordInWithClause()	Whether the SQL with clause requires the "recursive" keyword for recursive CTEs.
protected void	renderComparison(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderComparisonStandard(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderDerivedTableReference(DerivedTableReference tableReference)
protected void	renderDmlTargetTableExpression(NamedTableReference tableReference)
protected void	renderExpressionAsClauseItem(Expression expression)
protected void	renderFetchExpression(Expression fetchExpression)
protected void	renderFromClauseAfterUpdateSet(UpdateStatement statement)
void	renderNamedSetReturningFunction(String functionName, List<? extends SqlAstNode> sqlAstArguments, AnonymousTupleTableGroupProducer tupleType, String tableIdentifierVariable, SqlAstNodeRenderingMode argumentRenderingMode)	Renders a named set returning function.
protected void	renderOffsetExpression(Expression offsetExpression)
protected boolean	renderReturningClause(MutationStatement statement)
protected void	renderSelectExpression(Expression expression)
protected void	renderSelectTupleComparison(List<SqlSelection> lhsExpressions, SqlTuple tuple, ComparisonOperator operator)
protected void	renderTableGroupJoin(TableGroupJoin tableGroupJoin, List<TableGroupJoin> tableGroupJoinCollector)
protected void	renderTableReferenceJoins(TableGroup tableGroup, LockMode lockMode, int swappedJoinIndex, boolean forceLeftJoin)
protected boolean	shouldEmulateFetchClause(QueryPart queryPart)
protected boolean	supportsFromClauseInUpdate()
protected boolean	supportsOffsetClause()
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)
protected void	visitConflictClause(ConflictClause conflictClause)
protected void	visitDeleteStatementOnly(DeleteStatement statement)
protected void	visitInsertStatementOnly(InsertSelectStatement statement)
void	visitOffsetFetchClause(QueryPart queryPart)
void	visitQueryGroup(QueryGroup queryGroup)
void	visitQueryPartTableReference(QueryPartTableReference tableReference)
void	visitQuerySpec(QuerySpec querySpec)
protected void	visitReturningColumns(List<ColumnReference> returningColumns)
void	visitSelectStatement(SelectStatement statement)
void	visitStandardTableInsert(TableInsertStandard tableInsert)
void	visitStandardTableUpdate(TableUpdateStandard tableUpdate)
protected void	visitUpdateStatementOnly(UpdateStatement statement)

Methods inherited from class org.hibernate.sql.ast.spi.SqlAstTranslatorWithMerge

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

Methods inherited from class org.hibernate.sql.ast.spi.AbstractSqlAstTranslator

addAdditionalWherePredicate, addAffectedTableName, addAppliedParameterBinding, addParameterBinder, addParameterBinder, afterQueryGroup, append, append, append, appendAssignmentColumn, appendBackslashEscapedLikeLiteral, appendDoubleQuoteEscapedString, appendSingleQuoteEscapedString, appendSql, appendSql, appendSql, appendSql, appendSql, areAllResultsParameters, areAllResultsParameters, assertRowsOnlyFetchClauseType, beforeQueryGroup, castFunction, castNumberToString, cleanup, createRowMatchingPredicate, determineColumnReferenceQualifier, determineCyclePathColumnName, determineLateralEmulationPredicate, determineLockingStrategy, determineWhereClauseRestrictionWithJoinEmulation, determineWhereClauseRestrictionWithJoinEmulation, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctions, emulateQuantifiedTupleSubQueryPredicate, emulateQueryPartTableReferenceColumnAliasing, emulateSearchClauseOrderWithRowAndArray, emulateSelectTupleComparison, emulateSortSpecificationNullPrecedence, emulateSubQueryRelationalRestrictionPredicate, emulateTupleComparison, emulateValuesTableReferenceColumnAliasing, getAffectedTableNames, getAppliedParameterBindings, getArrayContainsFunction, getBooleanType, getCastTypeName, getClauseStack, getCteStatement, getCurrentClauseStack, getCurrentCteStatement, getCurrentDmlStatement, getCurrentQueryPart, getDialect, getDual, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockTimeout, getFetchClauseTypeForRowNumbering, getFromDualForSelectOnly, getIntegerType, getJdbcLockStrategy, getJdbcParameterBindings, getJdbcServices, getLeftHandExpression, getLimit, getLimitParameter, getLiteralValue, getLockingClauseStrategy, getLockOptions, getMaxRows, getOffsetParameter, getParameterBinders, getParameterBindValue, getParameterRenderingMode, getQueryPartForRowNumbering, getQueryPartStack, getRowsToSkip, getSelectItemReference, getSessionFactory, getSortSpecificationsRowNumbering, getSql, getSqlAppender, getSqlAst, getSqlBuffer, getSqlTypeName, getStatement, getStatementStack, getStringType, getUniqueConstraintNameThatMayFail, getWrapperOptions, hasAggregateFunctions, hasFrom, hasLimit, hasLimit, hasNestedTableGroupsToRender, hasNonTrivialFromClause, hasOffset, hasWhere, inlineCteTableGroup, inOverOrWithinGroupClause, interpretExpression, isCorrelated, isInRecursiveQueryPart, isInSubquery, isIntegerDivisionEmulationRequired, isLiteral, isParameter, isRowNumberingCurrentQueryPart, isRowsOnlyFetchClauseType, isStruct, needsCteInlining, needsLocking, needsMaxRows, needsParenthesesAroundQueryGroup, needsRowsToSkip, prepareLimitOffsetParameters, prependSql, processNestedTableGroupJoins, processTableGroupJoin, processTableGroupJoins, registerAffectedTable, registerAffectedTable, render, renderAsLiteral, renderBackslashEscapedLikePattern, renderCaseInsensitiveLikeEmulation, renderCasted, renderCombinedLimitClause, renderCombinedLimitClause, renderCommaSeparated, renderCommaSeparatedSelectExpression, renderCommaSeparatedSelectExpression, renderComparisonDistinctOperator, renderComparisonEmulateCase, renderComparisonEmulateDecode, renderComparisonEmulateDecode, renderComparisonEmulateIntersect, renderCteColumns, renderCycleClause, renderDeleteClause, renderDerivedTableReferenceIdentificationVariable, renderDmlTargetTableGroup, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderFetch, renderFetchPlusOffsetExpression, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderFromClauseExcludingDmlTargetReference, renderFromClauseJoiningDmlTargetReference, renderFromClauseSpaces, renderInsertIntoNoColumns, renderInterval, renderIntervalLiteral, renderIntoIntoAndTable, renderJoinedTableGroup, renderLikePredicate, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMaterializationHint, renderMergeUpdateClause, renderNamedTableReference, renderNull, renderOffset, renderOffsetFetchClause, renderOffsetFetchClause, renderOrderBy, renderParameterAsParameter, renderPartitionItem, renderPrimaryTableReference, renderQueryGroup, renderRecursiveCteVirtualSelections, renderRootTableGroup, renderRowNumber, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectSimpleComparison, renderSetClause, renderSimpleNamedFunction, renderSkipFirstClause, renderSkipFirstClause, renderSortExpression, renderStandardCycleClause, renderStandardSearchClause, renderStringContainsExactlyPredicate, renderTableReferenceIdentificationVariable, renderTableReferenceJoins, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderUpdateClause, renderVirtualSelections, renderWrappedParameter, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLimitParameter, setLockingTarget, setOffsetParameter, shouldEmulateLateralWithIntersect, shouldInlineCte, simpleColumnWriteFragmentRendering, supportsRecursiveClauseArrayAndRowEmulation, translate, translateDelete, translateInsert, translateSelect, translateUpdate, useOffsetFetchClause, visitAggregateColumnWriteExpression, visitAny, visitAssignment, visitBetweenPredicate, visitBinaryArithmeticExpression, visitCaseSearchedExpression, visitCaseSearchedExpression, visitCaseSimpleExpression, visitCaseSimpleExpression, visitCastTarget, visitCollation, visitColumnReference, visitColumnWriteFragment, visitConversion, visitCteContainer, visitCteDefinition, visitCteObject, visitCustomTableDelete, visitCustomTableInsert, visitCustomTableUpdate, visitDecodeCaseSearchedExpression, visitDeleteStatement, visitDistinct, visitDuration, visitDurationUnit, visitEmbeddableTypeLiteral, visitEntityTypeLiteral, visitEvery, visitExistsPredicate, visitExtractUnit, visitFilterFragmentPredicate, visitFilterPredicate, visitFormat, visitForUpdateClause, visitFromClause, visitFunctionTableReference, visitGroupByClause, visitGroupedPredicate, visitHavingClause, visitInArrayPredicate, visitInListPredicate, visitInsertSource, visitInsertStatement, visitInsertStatementEmulateMerge, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitLikePredicate, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNestedColumnReference, visitNullnessPredicate, visitOnDuplicateKeyConflictClause, visitOnDuplicateKeyConflictClauseWithDoNothing, visitOptionalTableUpdate, visitOrderBy, visitOver, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryClauses, visitQueryLiteral, visitRecursivePath, visitRelationalPredicate, visitReturningColumns, visitSelectClause, visitSelfRenderingExpression, visitSelfRenderingPredicate, visitSetAssignment, visitSetAssignmentEmulateJoin, visitSortSpecification, visitSortSpecification, visitSqlFragmentPredicate, visitSqlSelectExpression, visitSqlSelection, visitSqlSelectionExpression, visitSqlSelections, visitStandardConflictClause, visitStandardTableDelete, visitStar, visitSummarization, visitTableGroup, visitTableGroupJoin, visitTableReferenceJoin, visitThruthnessPredicate, visitTrimSpecification, visitTuple, visitUnaryOperationExpression, visitUnparsedNumericLiteral, visitUpdateStatement, visitUpdateStatementEmulateInlineView, visitUpdateStatementEmulateMerge, visitUpdateStatementEmulateTupleSet, visitValuesList, visitValuesListEmulateSelectUnion, visitValuesListStandard, visitValuesTableReference, visitWhereClause, withParameterRenderingMode, withRowNumbering

Methods inherited from class java.lang.Object

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

Constructor Details

DB2SqlAstTranslator

public DB2SqlAstTranslator(SessionFactoryImplementor sessionFactory,
 Statement statement)

Method Details

needsRecursiveKeywordInWithClause

protected boolean needsRecursiveKeywordInWithClause()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL with clause requires the "recursive" keyword for recursive CTEs.

Overrides:

needsRecursiveKeywordInWithClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderTableReferenceJoins

protected void renderTableReferenceJoins(TableGroup tableGroup,
 LockMode lockMode,
 int swappedJoinIndex,
 boolean forceLeftJoin)

Overrides:

renderTableReferenceJoins in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderTableGroupJoin

protected void renderTableGroupJoin(TableGroupJoin tableGroupJoin,
 List<TableGroupJoin> tableGroupJoinCollector)

Overrides:

renderTableGroupJoin 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>

shouldEmulateFetchClause

protected boolean shouldEmulateFetchClause(QueryPart queryPart)

supportsOffsetClause

protected boolean supportsOffsetClause()

visitQueryPartTableReference

public void visitQueryPartTableReference(QueryPartTableReference tableReference)

Specified by:

visitQueryPartTableReference in interface SqlAstWalker

Overrides:

visitQueryPartTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDerivedTableReference

protected void renderDerivedTableReference(DerivedTableReference tableReference)

Overrides:

renderDerivedTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderNamedSetReturningFunction

public void renderNamedSetReturningFunction(String functionName,
 List<? extends SqlAstNode> sqlAstArguments,
 AnonymousTupleTableGroupProducer tupleType,
 String tableIdentifierVariable,
 SqlAstNodeRenderingMode argumentRenderingMode)

Description copied from interface: SqlAstTranslator

Renders a named set returning function.

Specified by:

renderNamedSetReturningFunction in interface SqlAstTranslator<T extends JdbcOperation>

Overrides:

renderNamedSetReturningFunction in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitSelectStatement

public void visitSelectStatement(SelectStatement statement)

Specified by:

visitSelectStatement in interface SqlAstWalker

Overrides:

visitSelectStatement in class AbstractSqlAstTranslator<T extends JdbcOperation>

emulateFetchOffsetWithWindowFunctionsVisitQueryPart

protected void emulateFetchOffsetWithWindowFunctionsVisitQueryPart(QueryPart queryPart)

Overrides:

emulateFetchOffsetWithWindowFunctionsVisitQueryPart in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitQueryGroup

public void visitQueryGroup(QueryGroup queryGroup)

Specified by:

visitQueryGroup in interface SqlAstWalker

Overrides:

visitQueryGroup in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitQuerySpec

public void visitQuerySpec(QuerySpec querySpec)

Specified by:

visitQuerySpec in interface SqlAstWalker

Overrides:

visitQuerySpec in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitOffsetFetchClause

public void visitOffsetFetchClause(QueryPart queryPart)

Specified by:

visitOffsetFetchClause in interface SqlAstWalker

Overrides:

visitOffsetFetchClause 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>

visitDeleteStatementOnly

protected void visitDeleteStatementOnly(DeleteStatement statement)

Overrides:

visitDeleteStatementOnly in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitUpdateStatementOnly

protected void visitUpdateStatementOnly(UpdateStatement statement)

Overrides:

visitUpdateStatementOnly in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsFromClauseInUpdate

protected boolean supportsFromClauseInUpdate()

visitInsertStatementOnly

protected void visitInsertStatementOnly(InsertSelectStatement statement)

Overrides:

visitInsertStatementOnly in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitConflictClause

protected void visitConflictClause(ConflictClause conflictClause)

Overrides:

visitConflictClause 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>

renderReturningClause

protected boolean renderReturningClause(MutationStatement statement)

getNewTableChangeModifier

protected String getNewTableChangeModifier()

visitStandardTableInsert

public void visitStandardTableInsert(TableInsertStandard tableInsert)

Specified by:

visitStandardTableInsert in interface SqlAstWalker

Overrides:

visitStandardTableInsert in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitStandardTableUpdate

public void visitStandardTableUpdate(TableUpdateStandard tableUpdate)

Specified by:

visitStandardTableUpdate in interface SqlAstWalker

Overrides:

visitStandardTableUpdate 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>

visitReturningColumns

protected void visitReturningColumns(List<ColumnReference> returningColumns)

Overrides:

visitReturningColumns in class AbstractSqlAstTranslator<T extends JdbcOperation>

getDB2Version

public DatabaseVersion getDB2Version()

supportsParameterOffsetFetchExpression

protected boolean supportsParameterOffsetFetchExpression()