Package org.hibernate.dialect

Class OracleSqlAstTranslator<T extends JdbcOperation>

java.lang.Object

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

org.hibernate.dialect.OracleSqlAstTranslator<T>

All Implemented Interfaces:

Appendable, SqlAppender, SqlAstTranslator<T>, SqlAstWalker

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

A SQL AST translator for Oracle.

Nested Class Summary

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

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

Field Summary

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

CLOSE_PARENTHESIS, COMA_SEPARATOR, COMA_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, AbstractSqlAstTranslator.ForUpdateClause forUpdateClause, Boolean followOnLocking)
protected void	emulateFetchOffsetWithWindowFunctions(QueryPart queryPart, Expression offsetExpression, Expression fetchExpression, FetchClauseType fetchClauseType, boolean emulateFetchClause)
protected FetchClauseType	getFetchClauseTypeForRowNumbering(QueryPart queryPart)
protected String	getFromDual()	Some databases require a bit of syntactic noise when there are no tables in the from clause.
protected String	getFromDualForSelectOnly()
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 boolean	renderNamedTableReference(NamedTableReference tableReference, LockMode lockMode)
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)
protected boolean	supportsDuplicateSelectItemsInQueryGroup()
protected boolean	supportsNestedSubqueryCorrelation()
protected boolean	supportsRecursiveCycleClause()	Whether the SQL cycle clause is supported, which can be used for recursive CTEs.
protected boolean	supportsRecursiveSearchClause()	Whether the SQL search clause is supported, which can be used for recursive CTEs.
protected boolean	supportsRowValueConstructorSyntax()	Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax.
protected boolean	supportsRowValueConstructorSyntaxInInList()	If the dialect supports row values, does it offer such support in IN lists as well?
protected boolean	supportsRowValueConstructorSyntaxInInSubQuery()	If the dialect supports row values, does it offer such support in IN subqueries as well?
protected boolean	supportsRowValueConstructorSyntaxInQuantifiedPredicates()	Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax with quantified predicates.
protected boolean	supportsWithClauseInSubquery()	Whether the SQL with clause is supported within a subquery.
void	visitAggregateColumnWriteExpression(AggregateColumnWriteExpression aggregateColumnWriteExpression)
void	visitColumnReference(ColumnReference columnReference)
void	visitFunctionTableReference(FunctionTableReference tableReference)
void	visitOffsetFetchClause(QueryPart queryPart)
protected void	visitOrderBy(List<SortSpecification> sortSpecifications)
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	visitValuesList(List<Values> valuesList)
void	visitValuesTableReference(ValuesTableReference tableReference)

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

addAdditionalWherePredicate, addAppliedParameterBinding, append, append, append, appendBackslashEscapedLikeLiteral, appendSql, appendSql, appendSql, appendSql, appendSql, applyParameter, areAllResultsParameters, areAllResultsParameters, assertRowsOnlyFetchClauseType, castFunction, castNumberToString, cleanup, determineCyclePathColumnName, determineLateralEmulationPredicate, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctionsVisitQueryPart, emulateQuantifiedTupleSubQueryPredicate, emulateQueryPartTableReferenceColumnAliasing, emulateSearchClauseOrderWithRowAndArray, emulateSelectTupleComparison, emulateSortSpecificationNullPrecedence, emulateSubQueryRelationalRestrictionPredicate, emulateTupleComparison, emulateValuesTableReferenceColumnAliasing, getAffectedTableNames, getAppliedParameterBindings, getArrayContainsFunction, getBooleanType, getClauseStack, getCteStatement, getCurrentClauseStack, getCurrentCteStatement, getCurrentDmlStatement, getCurrentQueryPart, getDialect, getDmlTargetTableAlias, getEffectiveLockMode, getEffectiveLockTimeout, getFilterJdbcParameters, getForShare, getForUpdate, getForUpdateWithClause, getIntegerType, getJdbcLockStrategy, getJdbcParameterBindings, getJdbcServices, getLeftHandExpression, getLimit, getLimitParameter, getLockOptions, getMaxRows, getNoWait, getOffsetParameter, getParameterBinders, getParameterBindValue, getParameterRenderingMode, getQueryPartForRowNumbering, getQueryPartStack, getRowsToSkip, getSelectItemReference, getSessionFactory, getSkipLocked, getSortSpecificationsRowNumbering, getSql, getSqlAppender, getStatement, getStringType, getWrapperOptions, hasAggregateFunctions, hasLimit, hasNestedTableGroupsToRender, hasOffset, inlineCteTableGroup, inOverOrWithinGroupClause, interpretExpression, isCorrelated, isInRecursiveQueryPart, isLiteral, isParameter, isRowNumberingCurrentQueryPart, isRowsOnlyFetchClauseType, isStruct, needsCteInlining, needsMaxRows, needsRowsToSkip, prepareLimitOffsetParameters, processNestedTableGroupJoins, processTableGroupJoin, processTableGroupJoins, registerAffectedTable, registerAffectedTable, render, renderAsLiteral, renderBackslashEscapedLikePattern, renderCaseInsensitiveLikeEmulation, renderCasted, renderCombinedLimitClause, renderCombinedLimitClause, renderCommaSeparated, renderCommaSeparatedSelectExpression, renderCommaSeparatedSelectExpression, renderComparisonDistinctOperator, renderComparisonEmulateCase, renderComparisonEmulateDecode, renderComparisonEmulateIntersect, renderComparisonStandard, renderCteColumns, renderCycleClause, renderDerivedTableReference, renderExpressionAsClauseItem, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderFetch, renderFetchExpression, renderFetchPlusOffsetExpression, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderForUpdateClause, renderInsertIntoNoColumns, renderIntoIntoAndTable, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMaterializationHint, renderOffset, renderOffsetExpression, renderOffsetFetchClause, renderOffsetFetchClause, renderOrderBy, renderPrimaryTableReference, renderQueryGroup, renderRecursiveCteVirtualSelections, renderRootTableGroup, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectExpression, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectSimpleComparison, renderSetClause, renderSkipFirstClause, renderSkipFirstClause, rendersTableReferenceAlias, renderStandardCycleClause, renderStandardSearchClause, renderTableGroup, renderTableGroupJoin, renderTableReferenceIdentificationVariable, renderTableReferenceJoins, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderVirtualSelections, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLimitParameter, setOffsetParameter, shouldInlineCte, supportsArrayConstructor, supportsDistinctFromPredicate, supportsFilterClause, supportsIntersect, supportsNestedWithClause, supportsNullPrecedence, supportsQuantifiedPredicates, supportsRecursiveClauseArrayAndRowEmulation, supportsRecursiveCycleUsingClause, supportsRowConstructor, supportsRowValueConstructorDistinctFromSyntax, supportsRowValueConstructorGtLtSyntax, supportsRowValueConstructorSyntaxInSet, supportsSimpleQueryGrouping, supportsWithClause, translate, translateDelete, translateInsert, translateSelect, translateUpdate, useOffsetFetchClause, visitAnsiCaseSearchedExpression, visitAnsiCaseSimpleExpression, visitAny, visitAssignment, visitBetweenPredicate, visitBinaryArithmeticExpression, visitBooleanExpressionPredicate, visitCaseSearchedExpression, visitCaseSearchedExpression, visitCaseSimpleExpression, visitCaseSimpleExpression, visitCastTarget, visitCollation, visitColumnWriteFragment, visitConversion, visitCteContainer, visitCteDefinition, visitCustomTableDelete, visitCustomTableInsert, visitCustomTableUpdate, visitDecodeCaseSearchedExpression, visitDeleteStatement, visitDeleteStatementOnly, visitDistinct, visitDuration, visitDurationUnit, visitEntityTypeLiteral, visitEvery, visitExistsPredicate, visitExtractUnit, visitFilterFragmentPredicate, visitFilterPredicate, visitFormat, visitForUpdateClause, visitFromClause, visitGroupByClause, visitGroupedPredicate, visitHavingClause, visitInListPredicate, visitInsertStatement, visitInsertStatementOnly, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitLikePredicate, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNullnessPredicate, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryLiteral, visitRecursivePath, visitRelationalPredicate, visitReturningColumns, visitReturningColumns, visitSelectClause, visitSelectStatement, visitSelfRenderingExpression, visitSelfRenderingPredicate, visitSortSpecification, visitSortSpecification, visitSqlFragmentPredicate, visitSqlSelectExpression, visitSqlSelectionExpression, visitSqlSelections, visitStandardTableDelete, visitStandardTableInsert, visitStandardTableUpdate, visitStar, visitSummarization, visitTableGroup, visitTableGroupJoin, visitTableReferenceJoin, visitTrimSpecification, visitTuple, visitUnaryOperationExpression, visitUpdateStatement, visitUpdateStatementOnly, visitWhereClause, withParameterRenderingMode, withRowNumbering

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleSqlAstTranslator

public OracleSqlAstTranslator(SessionFactoryImplementor sessionFactory,
                              Statement statement)

Method Detail

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>

supportsWithClauseInSubquery

protected boolean supportsWithClauseInSubquery()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL with clause is supported within a subquery.

Overrides:

supportsWithClauseInSubquery in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsRecursiveSearchClause

protected boolean supportsRecursiveSearchClause()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL search clause is supported, which can be used for recursive CTEs.

Overrides:

supportsRecursiveSearchClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsRecursiveCycleClause

protected boolean supportsRecursiveCycleClause()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL cycle clause is supported, which can be used for recursive CTEs.

Overrides:

supportsRecursiveCycleClause 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,
                                                                         AbstractSqlAstTranslator.ForUpdateClause forUpdateClause,
                                                                         Boolean followOnLocking)

Overrides:

determineLockingStrategy in class AbstractSqlAstTranslator<T extends JdbcOperation>

shouldEmulateLateralWithIntersect

protected boolean shouldEmulateLateralWithIntersect(QueryPart queryPart)

Overrides:

shouldEmulateLateralWithIntersect in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsNestedSubqueryCorrelation

protected boolean supportsNestedSubqueryCorrelation()

Overrides:

supportsNestedSubqueryCorrelation in class AbstractSqlAstTranslator<T extends JdbcOperation>

shouldEmulateFetchClause

protected boolean shouldEmulateFetchClause(QueryPart queryPart)

getFetchClauseTypeForRowNumbering

protected FetchClauseType getFetchClauseTypeForRowNumbering(QueryPart queryPart)

Overrides:

getFetchClauseTypeForRowNumbering in class AbstractSqlAstTranslator<T extends JdbcOperation>

emulateFetchOffsetWithWindowFunctions

protected void emulateFetchOffsetWithWindowFunctions(QueryPart queryPart,
                                                     Expression offsetExpression,
                                                     Expression fetchExpression,
                                                     FetchClauseType fetchClauseType,
                                                     boolean emulateFetchClause)

Overrides:

emulateFetchOffsetWithWindowFunctions in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitOrderBy

protected void visitOrderBy(List<SortSpecification> sortSpecifications)

Overrides:

visitOrderBy in class AbstractSqlAstTranslator<T extends JdbcOperation>

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>

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>

supportsDuplicateSelectItemsInQueryGroup

protected boolean supportsDuplicateSelectItemsInQueryGroup()

Overrides:

supportsDuplicateSelectItemsInQueryGroup in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsRowValueConstructorSyntax

protected boolean supportsRowValueConstructorSyntax()

Description copied from class: AbstractSqlAstTranslator

Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax.

Basically, does it support syntax like "... where (FIRST_NAME, LAST_NAME) = ('Steve', 'Ebersole') ...".

Overrides:

supportsRowValueConstructorSyntax in class AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

True if this SQL dialect is known to support "row value constructor" syntax; false otherwise.

supportsRowValueConstructorSyntaxInInList

protected boolean supportsRowValueConstructorSyntaxInInList()

Description copied from class: AbstractSqlAstTranslator

If the dialect supports row values, does it offer such support in IN lists as well?

For example, "... where (FIRST_NAME, LAST_NAME) IN ( (?, ?), (?, ?) ) ..."

Overrides:

supportsRowValueConstructorSyntaxInInList in class AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

True if this SQL dialect is known to support "row value constructor" syntax in the IN list; false otherwise.

supportsRowValueConstructorSyntaxInQuantifiedPredicates

protected boolean supportsRowValueConstructorSyntaxInQuantifiedPredicates()

Description copied from class: AbstractSqlAstTranslator

Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax with quantified predicates.

Basically, does it support syntax like "... where (FIRST_NAME, LAST_NAME) = ALL (select ...) ...".

Overrides:

supportsRowValueConstructorSyntaxInQuantifiedPredicates in class AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

True if this SQL dialect is known to support "row value constructor" syntax with quantified predicates; false otherwise.

supportsRowValueConstructorSyntaxInInSubQuery

protected boolean supportsRowValueConstructorSyntaxInInSubQuery()

Description copied from class: AbstractSqlAstTranslator

If the dialect supports row values, does it offer such support in IN subqueries as well?

For example, "... where (FIRST_NAME, LAST_NAME) IN ( select ... ) ..."

Overrides:

supportsRowValueConstructorSyntaxInInSubQuery in class AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

True if this SQL dialect is known to support "row value constructor" syntax in the IN subqueries; false otherwise.

getFromDual

protected String getFromDual()

Description copied from class: AbstractSqlAstTranslator

Some databases require a bit of syntactic noise when there are no tables in the from clause.

Overrides:

getFromDual in class AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

the SQL equivalent to Oracle's from dual.

getFromDualForSelectOnly

protected String getFromDualForSelectOnly()

Overrides:

getFromDualForSelectOnly in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderNamedTableReference

protected boolean renderNamedTableReference(NamedTableReference tableReference,
                                            LockMode lockMode)

Overrides:

renderNamedTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitSetAssignment

protected void visitSetAssignment(Assignment assignment)

Overrides:

visitSetAssignment in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitColumnReference

public void visitColumnReference(ColumnReference columnReference)

Specified by:

visitColumnReference in interface SqlAstWalker

Overrides:

visitColumnReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitAggregateColumnWriteExpression

public void visitAggregateColumnWriteExpression(AggregateColumnWriteExpression aggregateColumnWriteExpression)

Specified by:

visitAggregateColumnWriteExpression in interface SqlAstWalker

Overrides:

visitAggregateColumnWriteExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>