Class DB2iDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.dialect.DB2Dialect

org.hibernate.dialect.DB2iDialect

All Implemented Interfaces:

CheckConstraintSupport, ForeignKeySupport, IdentifierSupport, KeywordSupport, LiteralSupport, AlterTableSupport, ColumnDefinitionSupport, ConstraintControlSupport, IndexDdlSupport, TableCreationSupport, TruncateSupport, CurrentTemporalSupport, TemporalFormatSupport, TemporalOperationSupport, ConversionContext

public class DB2iDialect
extends DB2Dialect

A SQL dialect for DB2 for IBM i version 7.2 and above, previously known as "DB2/400".

Field Summary

Fields

Modifier and Type	Field	Description
static final DatabaseVersion	DB2_LUW_VERSION

Fields inherited from class Dialect

LEGACY_LOB_MERGE_STRATEGY, NEW_LOCATOR_LOB_MERGE_STRATEGY, STANDARD_MULTI_KEY_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY

Fields inherited from interface ConstraintControlSupport

NONE

Fields inherited from interface TruncateSupport

STANDARD

Constructor Summary

Constructors

Constructor	Description
DB2iDialect()
DB2iDialect(DatabaseVersion version)
DB2iDialect(DialectResolutionInfo info)

Method Summary

Modifier and Type	Method	Description
protected LockingSupport	buildLockingSupport()
String	createCommand(IndexDdlRequest request)
MutationOperation	createOptionalTableUpdateOperation(OptionalTableUpdateOperationRequest request)	Creates the JDBC mutation operation for an optional-table update.
String	createTail(IndexDdlRequest request)
DatabaseVersion	getDB2Version()	DB2 LUW Version
GeneratedValuesSupport	getGeneratedValuesSupport()	Supply the stable profile describing immediate retrieval of arbitrary database-generated values for this Dialect.
IdentityColumnSupport	getIdentityColumnSupport()	Supply the stable identity-column DDL, insert syntax, and identity-specific retrieval behavior for this Dialect.
LimitHandler	getLimitHandler()	Supplies execution-time pagination for already-rendered SQL requested by Query.setMaxResults(int) or Query.setFirstResult(int).
protected DatabaseVersion	getMinimumSupportedVersion()	Get the version of the SQL dialect that is the minimum supported by this implementation.
RowIdSupport	getRowIdSupport()	The more "standard" syntax is rid_bit(alias) but here we use alias.rowid.
SequenceInformationExtractor	getSequenceInformationExtractor()	Supply the strategy Hibernate uses to discover existing database sequences and their metadata.
SequenceSupport	getSequenceSupport()	No support for sequences.
SqlAstTranslatorFactory	getSqlAstTranslatorFactory()	Supply the factory for this Dialect's single-use SQL AST translators.
void	initializeFunctionRegistry(FunctionContributions functionContributions)	Contribute the database-specific function descriptors after independent function contributors have run.

Methods inherited from class DB2Dialect

alterColumnType, appendBinaryLiteral, appendBooleanValueString, appendDateTimeLiteral, appendDateTimeLiteral, appendDateTimeLiteral, appendDefinition, appendFormat, buildIdentifierHelper, buildSQLExceptionConversionDelegate, castPattern, causesRollback, columnType, constraintControlMode, contributeDefaultProperties, contributeTypes, createUniqueDelegate, determineDatabaseVersion, determinFullDatabaseVersion, disableConstraintCommands, enableConstraintCommands, extractPattern, fractionalSecondPrecisionInNanos, getAggregateSupport, getCallableStatementSupport, getCteSupport, getCurrentTemporalSupport, getCurrentTimestampSelection, getDirectJavaTimeJdbcSupport, getDmlTargetColumnQualifierSupport, getExpressionCoercionSupport, getGlobalTemporaryTableStrategy, getIfExistsSupport, getJdbcMetadataOverrides, getLockingSupport, getMaxIdentifierLength, getMaximumSeriesSize, getMultiTableMutationSupport, getMutationSyntaxSupport, getNamespaceSupport, getNullOrderingSupport, getParameterLimits, getPredicateSupport, getPreferredSqlTypeCodeForArray, getRefCursorSupportFactory, getRowLevelSecurity, getRowValueSupport, getSchemaCommentSupport, getSchemaDropSupport, getSelectClauseNullString, getSingleRowTableSupport, getSubquerySupport, getTableExporter, getTemporalFormatSupport, getTemporalOperationSupport, getTemporalTableSupport, getTemporalValueSemantics, getTupleCountSupport, getTypeSizingProfile, getUniqueDelegate, getUserDefinedTypeExporter, getValuesListSupport, getViolatedConstraintNameExtractor, getWindowFunctionSupport, parseVersion, registerColumnTypes, registerJsonFunctions, registerXmlFunctions, renderCommands, selectNullString, supportsNationalizedMethods, supportsUserDefinedTypes, timestampaddPattern, timestampdiffPattern, translateExtractField

Methods inherited from class Dialect

addPartitionKeyToPrimaryKey, appendArrayLiteral, augmentPhysicalTableTypes, augmentRecognizedTableTypes, buildLockingClauseStrategy, buildStringToBooleanCast, buildStringToBooleanCastDecode, castType, contributeKeywords, defaultScrollMode, equivalentTypes, getAlterTableSupport, getArraySupport, getArrayTypeName, getBatchLoadSizingStrategy, getCatalogSeparator, getCheckConstraintSupport, getColumnAliasExtractor, getColumnDefinitionSupport, getConstraintControlSupport, getDefaultOrdinalityColumnName, getDefaultProperties, getEntityLockingStrategyFactory, getEnumSupport, getFetchClauseSupport, getForeignKeyExporter, getForeignKeySupport, getFunctionalDependencyAnalysisSupport, getIdentifierSupport, getIndexDdlSupport, getIndexExporter, getInformationExtractor, getKeywords, getKeywordSupport, getLiteralSupport, getLobMergeStrategy, getLobSupport, getLocalTemporaryTableStrategy, getLockingClauseStrategy, getLowercaseFunction, getMultiKeyLoadSizingStrategy, getNameQualifierSupport, getNationalizationSupport, getNativeParameterMarkerStrategy, getNativeValueGenerationStrategy, getObjectNullBindingStrategy, getPersistentTemporaryTableStrategy, getPreferredSqlTypeCodeForBoolean, getQueryHintPlacement, getQueryHintString, getQueryHintString, getSchemaNameResolver, getSequenceExporter, getSetOperationSupport, getSetOperatorSqlString, getSizeStrategy, getStringValueSemantics, getSyntheticTableGroupSupport, getTableCleaner, getTableCreationSupport, getTableMigrator, getTemporaryTableExporter, getTimeZoneSupport, getTruncateSupport, getVersion, isJdbcLogWarningsEnabledByDefault, narrowCastType, resolveSqlTypeCode, resolveSqlTypeCode, resolveSqlTypeDescriptor, resolveSqlTypeLength, supportsCrossJoin, supportsFilterClause, supportsOrdinalSelectItemReference, throttleDdl, toString, trimPattern, truncateMode

Methods inherited from class Object

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

Methods inherited from interface AlterTableSupport

addColumnPrefix, addColumnSuffix, alterTableCommand

Methods inherited from interface CheckConstraintSupport

render, supports

Methods inherited from interface ConstraintControlSupport

disableCommands, enableCommands

Methods inherited from interface CurrentTemporalSupport

currentDate, currentLocalTime, currentLocalTimestamp, currentTime, currentTimestamp, currentTimestampWithTimeZone, isCurrentTimestampStable, usesStandardCurrentTimestampFunction

Methods inherited from interface ForeignKeySupport

renderAddConstraint, renderDropConstraint, requiresSelfReferentialForeignKeyNullification, supportsAlterTableConstraints, supportsOnDeleteAction

Methods inherited from interface IdentifierSupport

closeQuote, getMaxAliasLength, openQuote, quote, quoteCollation, toQuotedIdentifier

Methods inherited from interface IndexDdlSupport

nameQualification

Methods inherited from interface KeywordSupport

acceptsJdbcKeyword

Methods inherited from interface LiteralSupport

appendIntervalLiteral, appendIntervalLiteral, appendLiteral, appendUUIDLiteral, toBooleanValueString

Methods inherited from interface TableCreationSupport

createTableCommand, requiresViewColumnList, tableCreationOptions

Methods inherited from interface TemporalOperationSupport

translateDurationField

Field Details

DB2_LUW_VERSION

public static final DatabaseVersion DB2_LUW_VERSION

Constructor Details

DB2iDialect

public DB2iDialect(DialectResolutionInfo info)

DB2iDialect

public DB2iDialect()

DB2iDialect

public DB2iDialect(DatabaseVersion version)

Method Details

buildLockingSupport

protected LockingSupport buildLockingSupport()

Overrides:

buildLockingSupport in class DB2Dialect

initializeFunctionRegistry

@SPI({IMPLEMENT,SUPPLY})
public void initializeFunctionRegistry(FunctionContributions functionContributions)

Description copied from class: Dialect

Contribute the database-specific function descriptors after independent function contributors have run.

Override this callback to extend or replace the inherited function set. Invoke super first to retain Hibernate's standard and emulated registrations; omitting it deliberately replaces that set. Mutate the supplied boot-scoped function registry only during this callback, and do not retain the contribution context or registry afterward. Implement an independent FunctionContributor instead when the contribution is not owned by a Dialect.

Overrides:

initializeFunctionRegistry in class DB2Dialect

Parameters:

functionContributions - the Hibernate-supplied function contribution target

See Also:

• FunctionContributions
• FunctionContributor
• SqmFunctionRegistry
• SqmFunctionDescriptor
• CommonFunctionFactory

getMinimumSupportedVersion

@SPI({IMPLEMENT,SUPPLY})
protected DatabaseVersion getMinimumSupportedVersion()

Description copied from class: Dialect

Get the version of the SQL dialect that is the minimum supported by this implementation.

This method is called during superclass construction. Implementations must return construction-safe immutable data and must not depend on subclass initialization.

Overrides:

getMinimumSupportedVersion in class DB2Dialect

getDB2Version

public DatabaseVersion getDB2Version()

Description copied from class: DB2Dialect

DB2 LUW Version

Overrides:

getDB2Version in class DB2Dialect

createCommand

@SPI({USE,IMPLEMENT})
public String createCommand(IndexDdlRequest request)

createTail

@SPI({USE,IMPLEMENT})
public String createTail(IndexDdlRequest request)

Specified by:

createTail in interface IndexDdlSupport

Overrides:

createTail in class DB2Dialect

getGeneratedValuesSupport

public GeneratedValuesSupport getGeneratedValuesSupport()

Description copied from class: Dialect

Supply the stable profile describing immediate retrieval of arbitrary database-generated values for this Dialect.

Override this method to declare native insert or update returning, row-id returning, or JDBC generated-key support for arbitrary generated columns. Identity-only retrieval belongs to Dialect.getIdentityColumnSupport(), and an ordinary select after mutation is a Hibernate fallback rather than a capability of this profile. Refine a family profile by copying the value returned by the superclass and changing only the differing capabilities.

Overrides:

getGeneratedValuesSupport in class DB2Dialect

Returns:

true because we can use select ... from new table (insert .... )

getSequenceSupport

@SPI({IMPLEMENT,SUPPLY})
public SequenceSupport getSequenceSupport()

No support for sequences.

Overrides:

getSequenceSupport in class DB2Dialect

Returns:

the non-null sequence-support strategy

See Also:

• SequenceSupport

getSequenceInformationExtractor

public SequenceInformationExtractor getSequenceInformationExtractor()

Description copied from class: Dialect

Supply the strategy Hibernate uses to discover existing database sequences and their metadata.

Return SequenceInformationExtractors.none() when the database version does not expose sequence metadata. Configure ordinary single-query extraction with SequenceInformationExtractors.builder(String), and implement SequenceInformationExtractor directly only for a genuinely multi-stage algorithm.

Overrides:

getSequenceInformationExtractor in class DB2Dialect

See Also:

• SequenceInformationExtractor
• SequenceInformationExtractors

getLimitHandler

public LimitHandler getLimitHandler()

Description copied from class: Dialect

Supplies execution-time pagination for already-rendered SQL requested by Query.setMaxResults(int) or Query.setFirstResult(int).

This is distinct from SQL AST PaginationRenderingSupport, which handles offset and fetch clauses represented in the semantic tree. A custom Dialect should normally return a stock LimitHandler or extend a supported handler family. The returned handler may be reused concurrently and must not retain per-query state.

Overrides:

getLimitHandler in class DB2Dialect

Returns:

a non-null handler

getIdentityColumnSupport

public IdentityColumnSupport getIdentityColumnSupport()

Description copied from class: Dialect

Supply the stable identity-column DDL, insert syntax, and identity-specific retrieval behavior for this Dialect.

Override this method to supply a provider implementation of IdentityColumnSupport. Prefer extending IdentityColumnSupportBase and return the same immutable or otherwise stable support instance on every invocation. Do not construct Hibernate mutation delegates in this supply point.

Overrides:

getIdentityColumnSupport in class DB2Dialect

createOptionalTableUpdateOperation

@SPI({USE,IMPLEMENT,SUPPLY})
public MutationOperation createOptionalTableUpdateOperation(OptionalTableUpdateOperationRequest request)

Description copied from class: Dialect

Creates the JDBC mutation operation for an optional-table update.

Override this factory when the database needs an operation other than the standard update-then-insert behavior. The request contains the semantic update and bootstrap services; implementations must return an operation for the same OptionalTableUpdateOperationRequest.mutationTarget() and must not retain the request.

Overrides:

createOptionalTableUpdateOperation in class DB2Dialect

Returns:

a non-null operation for the supplied optional-table update

See Also:

• OptionalTableUpdateOperationRequest
• MutationOperation

getSqlAstTranslatorFactory

@SPI({IMPLEMENT,SUPPLY})
public SqlAstTranslatorFactory getSqlAstTranslatorFactory()

Description copied from class: Dialect

Supply the factory for this Dialect's single-use SQL AST translators.

Return null to use StandardSqlAstTranslatorFactory. A custom Dialect should normally return a reusable factory derived from that class and create translators derived from AbstractSqlAstTranslator or an appropriate supported family base. The factory must not retain translation requests, and every translator it returns is used for one translation.

Overrides:

getSqlAstTranslatorFactory in class DB2Dialect

See Also:

• SqlAstTranslatorFactory
• JdbcEnvironment.getSqlAstTranslatorFactory()

getRowIdSupport

@SPI({IMPLEMENT,SUPPLY})
public RowIdSupport getRowIdSupport()

Description copied from class: DB2Dialect

The more "standard" syntax is rid_bit(alias) but here we use alias.rowid.

There is also an alternative rid() of type bigint, but it cannot be used with partitioning.

Overrides:

getRowIdSupport in class DB2Dialect

Returns:

the stable non-null row-id strategy

See Also:

• RowIdSupport