Package org.hibernate.dialect

Class DerbySqlAstTranslator<T extends JdbcOperation>

java.lang.Object

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

org.hibernate.dialect.DerbySqlAstTranslator<T>

All Implemented Interfaces:

Appendable, SqlAppender, SqlAstTranslator<T>, SqlAstWalker

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

A SQL AST translator for Derby.

Author:

Christian Beikov

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, COMMA_SEPARATOR, COMMA_SEPARATOR_CHAR, NO_SEPARATOR, NULL_KEYWORD, OPEN_PARENTHESIS, PARAM_MARKER, WHITESPACE

Constructor Summary

Constructors

Constructor	Description
DerbySqlAstTranslator(SessionFactoryImplementor sessionFactory, Statement statement)

Method Summary

Modifier and Type	Method	Description
protected String	getForShare(int timeoutMillis)
protected String	getForUpdateWithClause()
protected boolean	needsMaxRows()
protected boolean	needsRowsToSkip()
protected void	renderComparison(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderDmlTargetTableExpression(NamedTableReference tableReference)
protected void	renderExpressionAsClauseItem(Expression expression)
protected void	renderFetchExpression(Expression fetchExpression)
protected void	renderOffsetExpression(Expression offsetExpression)
protected void	renderPartitionItem(Expression expression)
protected void	renderSelectExpression(Expression expression)
protected void	renderSelectTupleComparison(List<SqlSelection> lhsExpressions, SqlTuple tuple, ComparisonOperator operator)
protected boolean	supportsJoinInMutationStatementSubquery()	If the dialect supports using joins in mutation statement subquery that could also use columns from the mutation target table
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	supportsRowValueConstructorSyntaxInQuantifiedPredicates()	Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax with quantified predicates.
protected boolean	supportsWithClause()	Whether the SQL with clause is supported.
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	visitDeleteStatementOnly(DeleteStatement statement)
void	visitInListPredicate(InListPredicate inListPredicate)
void	visitOffsetFetchClause(QueryPart queryPart)
protected void	visitSetAssignment(Assignment assignment)
protected void	visitUpdateStatementOnly(UpdateStatement statement)

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, createRowMatchingPredicate, determineColumnReferenceQualifier, determineCyclePathColumnName, determineLateralEmulationPredicate, determineLockingStrategy, determineWhereClauseRestrictionWithJoinEmulation, determineWhereClauseRestrictionWithJoinEmulation, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctionsVisitQueryPart, emulateQuantifiedTupleSubQueryPredicate, emulateQueryPartTableReferenceColumnAliasing, emulateSearchClauseOrderWithRowAndArray, emulateSelectTupleComparison, emulateSortSpecificationNullPrecedence, emulateSubQueryRelationalRestrictionPredicate, emulateTupleComparison, emulateValuesTableReferenceColumnAliasing, getAffectedTableNames, getAppliedParameterBindings, getArrayContainsFunction, getBooleanType, getCastTypeName, getCastTypeName, getClauseStack, getCteStatement, getCurrentClauseStack, getCurrentCteStatement, getCurrentDmlStatement, getCurrentQueryPart, getDialect, getDual, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockTimeout, getFetchClauseTypeForRowNumbering, getForUpdate, getFromDual, getFromDualForSelectOnly, getIntegerType, getJdbcLockStrategy, getJdbcParameterBindings, getJdbcServices, getLeftHandExpression, getLimit, getLimitParameter, getLockOptions, getMaxRows, getNoWait, getOffsetParameter, getParameterBinders, getParameterBindValue, getParameterRenderingMode, getQueryPartForRowNumbering, getQueryPartStack, getRowsToSkip, getSelectItemReference, getSessionFactory, getSkipLocked, getSortSpecificationsRowNumbering, getSql, getSqlAppender, getSqlBuffer, getSqlTypeName, getSqlTypeName, getStatement, getStatementStack, getStringType, getUniqueConstraintNameThatMayFail, getWrapperOptions, hasAggregateFunctions, hasLimit, hasLimit, hasNestedTableGroupsToRender, hasNonTrivialFromClause, hasOffset, inlineCteTableGroup, inOverOrWithinGroupClause, interpretExpression, isCorrelated, isInRecursiveQueryPart, isInSubquery, isIntegerDivisionEmulationRequired, isLiteral, isParameter, isRowNumberingCurrentQueryPart, isRowsOnlyFetchClauseType, isStruct, needsCteInlining, needsLocking, needsRecursiveKeywordInWithClause, prepareLimitOffsetParameters, processNestedTableGroupJoins, processTableGroupJoin, processTableGroupJoins, registerAffectedTable, registerAffectedTable, render, renderAsLiteral, renderBackslashEscapedLikePattern, renderCaseInsensitiveLikeEmulation, renderCasted, renderCombinedLimitClause, renderCombinedLimitClause, renderCommaSeparated, renderCommaSeparatedSelectExpression, renderCommaSeparatedSelectExpression, renderComparisonDistinctOperator, renderComparisonEmulateCase, renderComparisonEmulateDecode, renderComparisonEmulateDecode, renderComparisonEmulateIntersect, renderComparisonStandard, renderCteColumns, renderCycleClause, renderDeleteClause, renderDerivedTableReference, renderDmlTargetTableGroup, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderFetch, renderFetchPlusOffsetExpression, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderForUpdateClause, renderFromClauseAfterUpdateSet, renderFromClauseExcludingDmlTargetReference, renderFromClauseJoiningDmlTargetReference, renderFromClauseSpaces, renderInsertIntoNoColumns, renderIntoIntoAndTable, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMaterializationHint, renderMergeUpdateClause, renderNamedTableReference, renderNull, renderOffset, renderOffsetFetchClause, renderOffsetFetchClause, renderOrderBy, renderParameterAsParameter, renderParameterAsParameter, renderPrimaryTableReference, renderQueryGroup, renderRecursiveCteVirtualSelections, renderRootTableGroup, renderRowNumber, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectSimpleComparison, renderSetClause, renderSkipFirstClause, renderSkipFirstClause, renderSortExpression, renderStandardCycleClause, renderStandardSearchClause, renderStringContainsExactlyPredicate, renderTableGroup, renderTableGroupJoin, renderTableReferenceIdentificationVariable, renderTableReferenceJoins, renderTableReferenceJoins, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderUpdateClause, renderVirtualSelections, renderWrappedParameter, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLimitParameter, setOffsetParameter, shouldEmulateLateralWithIntersect, shouldInlineCte, simpleColumnWriteFragmentRendering, supportsArrayConstructor, supportsDistinctFromPredicate, supportsDuplicateSelectItemsInQueryGroup, supportsFilterClause, supportsIntersect, supportsJoinsInDelete, supportsNestedSubqueryCorrelation, supportsNestedWithClause, supportsNullPrecedence, supportsQuantifiedPredicates, supportsRecursiveClauseArrayAndRowEmulation, supportsRecursiveCycleClause, supportsRecursiveCycleUsingClause, supportsRecursiveSearchClause, supportsRowConstructor, supportsRowValueConstructorDistinctFromSyntax, supportsRowValueConstructorGtLtSyntax, supportsRowValueConstructorSyntaxInInSubQuery, supportsRowValueConstructorSyntaxInSet, supportsSimpleQueryGrouping, supportsWithClauseInSubquery, translate, translateDelete, translateInsert, translateSelect, translateUpdate, useOffsetFetchClause, visitAggregateColumnWriteExpression, visitAny, visitAssignment, visitBetweenPredicate, visitBinaryArithmeticExpression, visitCaseSearchedExpression, visitCaseSearchedExpression, visitCaseSimpleExpression, visitCaseSimpleExpression, visitCastTarget, visitCollation, visitColumnReference, visitColumnWriteFragment, visitConflictClause, 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, visitInsertSource, visitInsertStatement, visitInsertStatementEmulateMerge, visitInsertStatementOnly, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitLikePredicate, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNestedColumnReference, visitNullnessPredicate, visitOnDuplicateKeyConflictClause, visitOptionalTableUpdate, visitOrderBy, visitOver, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryGroup, visitQueryLiteral, visitQueryPartTableReference, visitQuerySpec, visitRecursivePath, visitRelationalPredicate, visitReturningColumns, visitReturningColumns, visitSelectClause, visitSelectStatement, visitSelfRenderingExpression, visitSelfRenderingPredicate, visitSetAssignmentEmulateJoin, visitSortSpecification, visitSortSpecification, visitSqlFragmentPredicate, visitSqlSelectExpression, visitSqlSelection, visitSqlSelectionExpression, visitSqlSelections, visitStandardConflictClause, visitStandardTableDelete, visitStandardTableInsert, visitStandardTableUpdate, 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

DerbySqlAstTranslator

public DerbySqlAstTranslator(SessionFactoryImplementor sessionFactory,
 Statement statement)

Method Details

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>

visitSetAssignment

protected void visitSetAssignment(Assignment assignment)

Overrides:

visitSetAssignment in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDmlTargetTableExpression

protected void renderDmlTargetTableExpression(NamedTableReference tableReference)

Overrides:

renderDmlTargetTableExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsWithClause

protected boolean supportsWithClause()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL with clause is supported.

Overrides:

supportsWithClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderExpressionAsClauseItem

protected void renderExpressionAsClauseItem(Expression expression)

Overrides:

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

getForShare

protected String getForShare(int timeoutMillis)

Overrides:

getForShare in class AbstractSqlAstTranslator<T extends JdbcOperation>

getForUpdateWithClause

protected String getForUpdateWithClause()

Overrides:

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

renderFetchExpression

protected void renderFetchExpression(Expression fetchExpression)

Overrides:

renderFetchExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderOffsetExpression

protected void renderOffsetExpression(Expression offsetExpression)

Overrides:

renderOffsetExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderComparison

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

Overrides:

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

renderPartitionItem

protected void renderPartitionItem(Expression expression)

Overrides:

renderPartitionItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitInListPredicate

public void visitInListPredicate(InListPredicate inListPredicate)

Specified by:

visitInListPredicate in interface SqlAstWalker

Overrides:

visitInListPredicate 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.

needsRowsToSkip

protected boolean needsRowsToSkip()

Overrides:

needsRowsToSkip in class AbstractSqlAstTranslator<T extends JdbcOperation>

needsMaxRows

protected boolean needsMaxRows()

Overrides:

needsMaxRows in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsJoinInMutationStatementSubquery

protected boolean supportsJoinInMutationStatementSubquery()

Description copied from class: AbstractSqlAstTranslator

If the dialect supports using joins in mutation statement subquery that could also use columns from the mutation target table

Overrides:

supportsJoinInMutationStatementSubquery in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitArithmeticOperand

protected void visitArithmeticOperand(Expression expression)

Overrides:

visitArithmeticOperand in class AbstractSqlAstTranslator<T extends JdbcOperation>