Package org.hibernate.dialect.sql.ast

Class OracleSqlAstTranslator<T extends JdbcOperation>

java.lang.Object

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

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

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

All Implemented Interfaces:

Appendable, SqlAppender, SqlAstTranslator<T>, SqlAstWalker

public class OracleSqlAstTranslator<T extends JdbcOperation>
extends SqlAstTranslatorWithUpsert<T>

A SQL AST translator for Oracle.

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
OracleSqlAstTranslator(SessionFactoryImplementor sessionFactory, Statement statement)

Method Summary

Modifier and Type	Method	Description
protected AbstractSqlAstTranslator.LockStrategy	determineLockingStrategy(QuerySpec querySpec, Locking.FollowOn followOnStrategy)
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	renderDerivedTableReference(DerivedTableReference tableReference)
protected void	renderDerivedTableReferenceIdentificationVariable(DerivedTableReference tableReference)
protected void	renderDmlTargetTableExpression(NamedTableReference tableReference)
protected void	renderMergeSource(OptionalTableUpdate optionalTableUpdate)
protected void	renderMergeSourceAlias()
protected void	renderMergeTargetAlias()
protected void	renderMergeUpdateClause(List<Assignment> assignments, Predicate wherePredicate)
void	renderNamedSetReturningFunction(String functionName, List<? extends SqlAstNode> sqlAstArguments, AnonymousTupleTableGroupProducer tupleType, String tableIdentifierVariable, SqlAstNodeRenderingMode argumentRenderingMode)	Renders a named set returning function.
protected void	renderNull(Literal literal)
protected void	renderPartitionItem(Expression expression)
protected void	renderRowNumber(SelectClause selectClause, QueryPart queryPart)
protected void	renderSelectTupleComparison(List<SqlSelection> lhsExpressions, SqlTuple tuple, ComparisonOperator operator)
protected boolean	shouldEmulateFetchClause(QueryPart queryPart)
protected boolean	shouldEmulateLateralWithIntersect(QueryPart queryPart)
void	visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)
protected void	visitConflictClause(ConflictClause conflictClause)
void	visitFunctionTableReference(FunctionTableReference tableReference)
void	visitInArrayPredicate(InArrayPredicate inArrayPredicate)
protected void	visitInsertStatementOnly(InsertSelectStatement statement)
void	visitOffsetFetchClause(QueryPart queryPart)
void	visitOver(Over<?> over)
void	visitQueryGroup(QueryGroup queryGroup)
void	visitQueryPartTableReference(QueryPartTableReference tableReference)
void	visitQuerySpec(QuerySpec querySpec)
protected void	visitSetAssignment(Assignment assignment)
void	visitSqlSelection(SqlSelection sqlSelection)
protected void	visitUpdateStatementOnly(UpdateStatement statement)
protected void	visitValuesList(List<Values> valuesList)
void	visitValuesTableReference(ValuesTableReference tableReference)

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

createMergeOperation, renderMergeInsert, renderMergeInto, renderMergeOn, renderMergeUpdate, renderMergeUsing, renderUpsertStatement, wrapMergeSourceExpression

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, determineWhereClauseRestrictionWithJoinEmulation, determineWhereClauseRestrictionWithJoinEmulation, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctionsVisitQueryPart, 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, renderComparisonStandard, renderCteColumns, renderCycleClause, renderDeleteClause, renderDmlTargetTableGroup, renderExpressionAsClauseItem, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderFetch, renderFetchExpression, renderFetchPlusOffsetExpression, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderFromClauseAfterUpdateSet, renderFromClauseExcludingDmlTargetReference, renderFromClauseJoiningDmlTargetReference, renderFromClauseSpaces, renderInsertIntoNoColumns, renderInterval, renderIntervalLiteral, renderIntoIntoAndTable, renderJoinedTableGroup, renderLikePredicate, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMaterializationHint, renderNamedTableReference, renderOffset, renderOffsetExpression, renderOffsetFetchClause, renderOffsetFetchClause, renderOrderBy, renderParameterAsParameter, renderPrimaryTableReference, renderQueryGroup, renderRecursiveCteVirtualSelections, renderRootTableGroup, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectExpression, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectSimpleComparison, renderSetClause, renderSimpleNamedFunction, renderSkipFirstClause, renderSkipFirstClause, renderSortExpression, renderStandardCycleClause, renderStandardSearchClause, renderStringContainsExactlyPredicate, renderTableGroupJoin, renderTableReferenceIdentificationVariable, renderTableReferenceJoins, renderTableReferenceJoins, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderUpdateClause, renderVirtualSelections, renderWrappedParameter, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLimitParameter, setLockingTarget, setOffsetParameter, shouldInlineCte, simpleColumnWriteFragmentRendering, supportsRecursiveClauseArrayAndRowEmulation, translate, translateDelete, translateInsert, translateSelect, translateUpdate, useOffsetFetchClause, visitAggregateColumnWriteExpression, visitAnsiCaseSearchedExpression, visitAnsiCaseSimpleExpression, visitAny, visitArithmeticOperand, visitAssignment, visitBetweenPredicate, visitBooleanExpressionPredicate, visitCaseSearchedExpression, visitCaseSearchedExpression, visitCaseSimpleExpression, visitCaseSimpleExpression, visitCastTarget, visitCollation, visitColumnReference, visitColumnWriteFragment, visitConversion, visitCteContainer, visitCteDefinition, visitCteObject, visitCustomTableDelete, visitCustomTableInsert, visitCustomTableUpdate, visitDecodeCaseSearchedExpression, visitDeleteStatement, visitDeleteStatementOnly, visitDistinct, visitDuration, visitDurationUnit, visitEmbeddableTypeLiteral, visitEntityTypeLiteral, visitEvery, visitExistsPredicate, visitExtractUnit, visitFilterFragmentPredicate, visitFilterPredicate, visitFormat, visitForUpdateClause, visitFromClause, visitGroupByClause, visitGroupedPredicate, visitHavingClause, visitInListPredicate, visitInsertSource, visitInsertStatement, visitInsertStatementEmulateMerge, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitLikePredicate, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNestedColumnReference, visitNullnessPredicate, visitOnDuplicateKeyConflictClause, visitOnDuplicateKeyConflictClauseWithDoNothing, visitOptionalTableUpdate, visitOrderBy, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryClauses, visitQueryLiteral, visitRecursivePath, visitRelationalPredicate, visitReturningColumns, visitReturningColumns, visitSelectClause, visitSelectStatement, visitSelfRenderingExpression, visitSelfRenderingPredicate, visitSetAssignmentEmulateJoin, visitSortSpecification, visitSortSpecification, visitSqlFragmentPredicate, visitSqlSelectExpression, visitSqlSelectionExpression, visitSqlSelections, visitStandardConflictClause, visitStandardTableDelete, visitStandardTableInsert, visitStandardTableUpdate, visitStar, visitSummarization, visitTableGroup, visitTableGroupJoin, visitTableReferenceJoin, visitThruthnessPredicate, visitTrimSpecification, visitTuple, visitUnaryOperationExpression, visitUnparsedNumericLiteral, visitUpdateStatement, visitUpdateStatementEmulateInlineView, visitUpdateStatementEmulateMerge, visitUpdateStatementEmulateTupleSet, visitValuesListEmulateSelectUnion, visitValuesListStandard, visitWhereClause, withParameterRenderingMode, withRowNumbering

Methods inherited from class java.lang.Object

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

Constructor Details

OracleSqlAstTranslator

public OracleSqlAstTranslator(SessionFactoryImplementor sessionFactory,
 Statement statement)

Method Details

visitInsertStatementOnly

protected void visitInsertStatementOnly(InsertSelectStatement statement)

Overrides:

visitInsertStatementOnly in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitUpdateStatementOnly

protected void visitUpdateStatementOnly(UpdateStatement statement)

Overrides:

visitUpdateStatementOnly in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderMergeUpdateClause

protected void renderMergeUpdateClause(List<Assignment> assignments,
 Predicate wherePredicate)

Overrides:

renderMergeUpdateClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDmlTargetTableExpression

protected void renderDmlTargetTableExpression(NamedTableReference tableReference)

Overrides:

renderDmlTargetTableExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitConflictClause

protected void visitConflictClause(ConflictClause conflictClause)

Overrides:

visitConflictClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

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>

visitInArrayPredicate

public void visitInArrayPredicate(InArrayPredicate inArrayPredicate)

Specified by:

visitInArrayPredicate in interface SqlAstWalker

Overrides:

visitInArrayPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitSqlSelection

public void visitSqlSelection(SqlSelection sqlSelection)

Specified by:

visitSqlSelection in interface SqlAstWalker

Overrides:

visitSqlSelection in class AbstractSqlAstTranslator<T extends JdbcOperation>

determineLockingStrategy

protected AbstractSqlAstTranslator.LockStrategy determineLockingStrategy(QuerySpec querySpec,
 Locking.FollowOn followOnStrategy)

Overrides:

determineLockingStrategy in class AbstractSqlAstTranslator<T extends JdbcOperation>

shouldEmulateLateralWithIntersect

protected boolean shouldEmulateLateralWithIntersect(QueryPart queryPart)

Overrides:

shouldEmulateLateralWithIntersect in class AbstractSqlAstTranslator<T extends JdbcOperation>

shouldEmulateFetchClause

protected boolean shouldEmulateFetchClause(QueryPart queryPart)

visitValuesList

protected void visitValuesList(List<Values> valuesList)

Overrides:

visitValuesList in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitValuesTableReference

public void visitValuesTableReference(ValuesTableReference tableReference)

Specified by:

visitValuesTableReference in interface SqlAstWalker

Overrides:

visitValuesTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitQueryPartTableReference

public void visitQueryPartTableReference(QueryPartTableReference tableReference)

Specified by:

visitQueryPartTableReference in interface SqlAstWalker

Overrides:

visitQueryPartTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitFunctionTableReference

public void visitFunctionTableReference(FunctionTableReference tableReference)

Specified by:

visitFunctionTableReference in interface SqlAstWalker

Overrides:

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

renderDerivedTableReference

protected void renderDerivedTableReference(DerivedTableReference tableReference)

Overrides:

renderDerivedTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDerivedTableReferenceIdentificationVariable

protected void renderDerivedTableReferenceIdentificationVariable(DerivedTableReference tableReference)

Overrides:

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

renderRowNumber

protected void renderRowNumber(SelectClause selectClause,
 QueryPart queryPart)

Overrides:

renderRowNumber in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitOver

public void visitOver(Over<?> over)

Specified by:

visitOver in interface SqlAstWalker

Overrides:

visitOver in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderComparison

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

Overrides:

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

renderPartitionItem

protected void renderPartitionItem(Expression expression)

Overrides:

renderPartitionItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitBinaryArithmeticExpression

public void visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)

Specified by:

visitBinaryArithmeticExpression in interface SqlAstWalker

Overrides:

visitBinaryArithmeticExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderNull

protected void renderNull(Literal literal)

Overrides:

renderNull in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitSetAssignment

protected void visitSetAssignment(Assignment assignment)

Overrides:

visitSetAssignment in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderMergeTargetAlias

protected void renderMergeTargetAlias()

Overrides:

renderMergeTargetAlias in class SqlAstTranslatorWithUpsert<T extends JdbcOperation>

renderMergeSourceAlias

protected void renderMergeSourceAlias()

Overrides:

renderMergeSourceAlias in class SqlAstTranslatorWithUpsert<T extends JdbcOperation>

renderMergeSource

protected void renderMergeSource(OptionalTableUpdate optionalTableUpdate)

Overrides:

renderMergeSource in class SqlAstTranslatorWithUpsert<T extends JdbcOperation>