Class DB2iLegacyDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.community.dialect.DB2LegacyDialect

org.hibernate.community.dialect.DB2iLegacyDialect

All Implemented Interfaces:

org.hibernate.boot.model.FunctionContributor, org.hibernate.boot.model.TypeContributor, org.hibernate.exception.spi.ConversionContext

public class DB2iLegacyDialect
extends DB2LegacyDialect

An SQL dialect for DB2 for iSeries previously known as DB2/400.

Nested Class Summary

Nested classes/interfaces inherited from class org.hibernate.dialect.Dialect

org.hibernate.dialect.Dialect.SizeStrategy, org.hibernate.dialect.Dialect.SizeStrategyImpl

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

CLOSED_QUOTE, FALSE_STRING_VALUES, LEGACY_LOB_MERGE_STRATEGY, LOG_BASE2OF10, NEW_LOCATOR_LOB_MERGE_STRATEGY, QUOTE, STANDARD_MULTI_KEY_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY, TRUE_STRING_VALUES

Constructor Summary

Constructors

Constructor	Description
DB2iLegacyDialect()
DB2iLegacyDialect(org.hibernate.dialect.DatabaseVersion version)
DB2iLegacyDialect(org.hibernate.engine.jdbc.dialect.spi.DialectResolutionInfo info)

Method Summary

Modifier and Type	Method	Description
protected org.hibernate.dialect.lock.spi.LockingSupport	buildLockingSupport()
protected org.hibernate.dialect.unique.UniqueDelegate	createUniqueDelegate()
String	getCreateIndexString(boolean unique)
String	getCreateIndexTail(boolean unique, List<org.hibernate.mapping.Column> columns)
org.hibernate.dialect.DatabaseVersion	getDB2Version()	DB2 LUW Version
org.hibernate.dialect.identity.IdentityColumnSupport	getIdentityColumnSupport()
org.hibernate.dialect.pagination.LimitHandler	getLimitHandler()
String	getQuerySequencesString()
org.hibernate.dialect.sequence.SequenceSupport	getSequenceSupport()	No support for sequences.
org.hibernate.sql.ast.SqlAstTranslatorFactory	getSqlAstTranslatorFactory()
void	initializeFunctionRegistry(org.hibernate.boot.model.FunctionContributions functionContributions)
boolean	supportsDistinctFromPredicate()
boolean	supportsLateral()
boolean	supportsRecursiveCTE()

Methods inherited from class DB2LegacyDialect

appendBinaryLiteral, appendBooleanValueString, appendDatetimeFormat, appendDateTimeLiteral, appendDateTimeLiteral, appendDateTimeLiteral, buildIdentifierHelper, buildSQLExceptionConversionDelegate, canDisableConstraints, castPattern, columnType, contributeTypes, determineDatabaseVersion, doesReadCommittedCauseWritersToBlockReaders, doesRoundTemporalOnOverflow, dropConstraints, extractPattern, generatedAs, getAggregateSupport, getAlterColumnTypeString, getCallableStatementSupport, getCreateUserDefinedTypeExtensionsString, getCurrentTimestampSelectString, getDefaultDecimalPrecision, getDefaultStatementBatchSize, getDisableConstraintStatement, getDmlTargetColumnQualifierSupport, getDropSchemaCommand, getDual, getEnableConstraintStatement, getFallbackSqmInsertStrategy, getFallbackSqmMutationStrategy, getForUpdateSkipLockedString, getForUpdateSkipLockedString, getForUpdateString, getFractionalSecondPrecisionInNanos, getFromDualForSelectOnly, getGlobalTemporaryTableStrategy, getInExpressionCountLimit, getLocalTemporaryTableStrategy, getLockingSupport, getLowercaseFunction, getMaxIdentifierLength, getMaximumSeriesSize, getMaxVarcharLength, getPreferredSqlTypeCodeForArray, getPreferredSqlTypeCodeForBoolean, getReadLockString, getReadLockString, getResultSet, getResultSet, getResultSet, getSelectClauseNullString, getSequenceInformationExtractor, getTableExporter, getTruncateTableStatement, getUniqueDelegate, getViolatedConstraintNameExtractor, getWriteLockString, getWriteLockString, isCurrentTimestampSelectStringCallable, registerColumnTypes, registerDefaultKeywords, registerResultSetOutParameter, registerResultSetOutParameter, requiresCastForConcatenatingNonStrings, rowId, rowIdSqlType, supportsAlterColumnType, supportsCommentOn, supportsCurrentTimestampSelection, supportsExistsInSelect, supportsFromClauseInUpdate, supportsIfExistsBeforeTableName, supportsInsertReturning, supportsInsertReturningRowId, supportsIsTrue, supportsLobValueChangePropagation, supportsNationalizedMethods, supportsNonQueryWithCTE, supportsNullPrecedence, supportsOffsetInSubquery, supportsPartitionBy, supportsPredicateAsExpression, supportsRefCursors, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsRowValueConstructorSyntaxInInSubQuery, supportsRowValueConstructorSyntaxInQuantifiedPredicates, supportsTupleDistinctCounts, supportsValuesList, supportsWindowFunctions, supportsWithClauseInSubquery, timestampaddPattern, timestampdiffPattern, timestampdiffPatternV10, translateExtractField, useConnectionToCreateLob

Methods inherited from class org.hibernate.dialect.Dialect

addPartitionKeyToPrimaryKey, addSqlHintOrComment, addUseIndexQueryHint, appendArrayLiteral, appendCheckConstraintOptions, appendIntervalLiteral, appendIntervalLiteral, appendLiteral, appendLockHint, appendUUIDLiteral, applyLocksToSql, augmentPhysicalTableTypes, augmentRecognizedTableTypes, buildLockingClauseStrategy, buildOptimisticForceIncrementStrategy, buildOptimisticStrategy, buildPessimisticForceIncrementStrategy, buildPessimisticReadStrategy, buildPessimisticWriteStrategy, buildReadStrategy, buildStringToBooleanCast, buildStringToBooleanCastDecode, buildStringToBooleanDecode, canBatchTruncate, canCreateCatalog, canCreateSchema, castType, checkVersion, closeQuote, contribute, contributeFunctions, createOptionalTableUpdateOperation, currentDate, currentLocalTime, currentLocalTimestamp, currentTime, currentTimestamp, currentTimestampWithTimeZone, defaultScrollMode, doesRepeatableReadCauseReadersToBlockWriters, equivalentTypes, escapeComment, forceLobAsLastValue, getAddColumnString, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAlterTableString, getArrayTypeName, getAuxiliaryDatabaseObjectExporter, getBatchLoadSizingStrategy, getBeforeDropStatement, getCascadeConstraintsString, getCaseInsensitiveLike, getCatalogSeparator, getCheckCondition, getCheckCondition, getCheckCondition, getCheckCondition, getCheckCondition, getCheckCondition, getCheckConstraintString, getColumnAliasExtractor, getColumnComment, getCreateCatalogCommand, getCreateEnumTypeCommand, getCreateEnumTypeCommand, getCreateMultisetTableString, getCreateSchemaCommand, getCreateTableString, getCreateTemporaryTableColumnAnnotation, getCreateUserDefinedTypeKindString, getCrossReferenceParentTableFilter, getCurrentSchemaCommand, getDefaultIntervalSecondScale, getDefaultLobLength, getDefaultNonContextualLobCreation, getDefaultOrdinalityColumnName, getDefaultProperties, getDefaultTimestampPrecision, getDefaultUseGetGeneratedKeys, getDisableConstraintsStatement, getDoublePrecision, getDropCatalogCommand, getDropEnumTypeCommand, getDropEnumTypeCommand, getDropForeignKeyString, getDropTableString, getDropUniqueKeyString, getEnableConstraintsStatement, getEnumTypeDeclaration, getEnumTypeDeclaration, getFallbackSchemaManagementTool, getFloatPrecision, getForeignKeyExporter, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctionalDependencyAnalysisSupport, getGroupBySelectItemReferenceStrategy, getHqlTranslator, getIndexExporter, getInformationExtractor, getKeywords, getLobMergeStrategy, getLockingClauseStrategy, getLockingStrategy, getLockingStrategy, getLockRowIdentifier, getMaxAliasLength, getMaxNVarcharCapacity, getMaxNVarcharLength, getMaxVarbinaryCapacity, getMaxVarbinaryLength, getMaxVarcharCapacity, getMinimumSupportedVersion, getMultiKeyLoadSizingStrategy, getNameQualifierSupport, getNationalizationSupport, getNativeIdentifierGeneratorStrategy, getNativeParameterMarkerStrategy, getNativeValueGenerationStrategy, getNoColumnsInsertString, getNullColumnString, getNullColumnString, getNullOrdering, getParameterCountLimit, getPersistentTemporaryTableStrategy, getPessimisticLockStyle, getQueryHintString, getQueryHintString, getReadLockString, getReadLockString, getReadRowLockStrategy, getRowIdColumnString, getSchemaNameResolver, getSelectClauseNullString, getSelectGUIDString, getSequenceExporter, getSizeStrategy, getSqmTranslatorFactory, getSupportedTemporaryTableKind, getTableCleaner, getTableComment, getTableMigrator, getTableTypeString, getTemporaryTableAfterUseAction, getTemporaryTableBeforeUseAction, getTemporaryTableCreateCommand, getTemporaryTableCreateOptions, getTemporaryTableDdlTransactionHandling, getTemporaryTableDropCommand, getTemporaryTableExporter, getTemporaryTableTruncateCommand, getTimeoutInSeconds, getTimeZoneSupport, getTruncateTableStatements, getUniqueKeyExporter, getUserDefinedTypeComment, getUserDefinedTypeExporter, getVersion, getWriteLockString, getWriteLockString, getWriteRowLockStrategy, hasAlterTable, hasDataTypeBeforeGeneratedAs, hasSelfReferentialForeignKeyBug, initDefaultProperties, isEmptyStringTreatedAsNull, isJdbcLogWarningsEnabledByDefault, isLob, openQuote, ordinal, prependComment, qualifyIndexName, quote, quoteCollation, registerKeyword, registerKeywords, requiresColumnListInCreateView, requiresFloatCastingOfIntegerDivision, requiresParensForTupleCounts, requiresParensForTupleDistinctCounts, resolveSqlTypeCode, resolveSqlTypeCode, resolveSqlTypeDescriptor, resolveSqlTypeLength, stripsTrailingSpacesFromChar, supportsArrayConstructor, supportsBatchUpdates, supportsBindAsCallableArgument, supportsBindingNullForSetObject, supportsBindingNullSqlTypeForSetNull, supportsBitType, supportsCascadeDelete, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsConflictClauseForInsertCTE, supportsCrossJoin, supportsDuplicateSelectItemsInQueryGroup, supportsExpectedLobUsagePattern, supportsFetchClause, supportsFilterClause, supportsForUpdate, supportsFractionalTimestampArithmetic, supportsIfExistsAfterAlterTable, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsAfterTypeName, supportsIfExistsBeforeConstraintName, supportsIfExistsBeforeTypeName, supportsInsertReturningGeneratedKeys, supportsIntersect, supportsJdbcConnectionLobCreation, supportsJoinInMutationStatementSubquery, supportsJoinsInDelete, supportsLockTimeouts, supportsMaterializedLobAccess, supportsNamedColumnCheck, supportsNamedParameters, supportsNestedSubqueryCorrelation, supportsNestedWithClause, supportsNoColumnsInsert, supportsNoWait, supportsOrderByInSubquery, supportsOrdinalSelectItemReference, supportsOuterJoinForUpdate, supportsRecursiveCycleClause, supportsRecursiveCycleUsingClause, supportsRecursiveSearchClause, supportsRowConstructor, supportsRowValueConstructorDistinctFromSyntax, supportsRowValueConstructorGtLtSyntax, supportsSimpleQueryGrouping, supportsSkipLocked, supportsStandardArrays, supportsStandardCurrentTimestampFunction, supportsSubqueryInSelect, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTableOptions, supportsTemporalLiteralOffset, supportsTemporaryTablePrimaryKey, supportsTemporaryTables, supportsTruncateWithCast, supportsTupleCounts, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, supportsUnionInSubquery, supportsUpdateReturning, supportsUserDefinedTypes, supportsValuesListForInsert, supportsWait, supportsWithClause, toBooleanValueString, toQuotedIdentifier, toString, transformSelectString, translateDurationField, trimPattern, unquoteGetGeneratedKeys, useArrayForMultiValuedParameters, useCrossReferenceForeignKeys, useFollowOnLocking, useInputStreamToInsertBlob, useMaterializedLobWhenCapacityExceeded

Methods inherited from class Object

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

Constructor Details

DB2iLegacyDialect

public DB2iLegacyDialect(org.hibernate.engine.jdbc.dialect.spi.DialectResolutionInfo info)

DB2iLegacyDialect

public DB2iLegacyDialect()

DB2iLegacyDialect

public DB2iLegacyDialect(org.hibernate.dialect.DatabaseVersion version)

Method Details

buildLockingSupport

protected org.hibernate.dialect.lock.spi.LockingSupport buildLockingSupport()

Overrides:

buildLockingSupport in class DB2LegacyDialect

initializeFunctionRegistry

public void initializeFunctionRegistry(org.hibernate.boot.model.FunctionContributions functionContributions)

Overrides:

initializeFunctionRegistry in class DB2LegacyDialect

getDB2Version

public org.hibernate.dialect.DatabaseVersion getDB2Version()

Description copied from class: DB2LegacyDialect

DB2 LUW Version

Overrides:

getDB2Version in class DB2LegacyDialect

createUniqueDelegate

protected org.hibernate.dialect.unique.UniqueDelegate createUniqueDelegate()

Overrides:

createUniqueDelegate in class DB2LegacyDialect

getCreateIndexString

public String getCreateIndexString(boolean unique)

Overrides:

getCreateIndexString in class org.hibernate.dialect.Dialect

getCreateIndexTail

public String getCreateIndexTail(boolean unique,
 List<org.hibernate.mapping.Column> columns)

Overrides:

getCreateIndexTail in class DB2LegacyDialect

supportsDistinctFromPredicate

public boolean supportsDistinctFromPredicate()

Overrides:

supportsDistinctFromPredicate in class DB2LegacyDialect

getSequenceSupport

public org.hibernate.dialect.sequence.SequenceSupport getSequenceSupport()

No support for sequences.

Overrides:

getSequenceSupport in class DB2LegacyDialect

getQuerySequencesString

public String getQuerySequencesString()

Overrides:

getQuerySequencesString in class DB2LegacyDialect

getLimitHandler

public org.hibernate.dialect.pagination.LimitHandler getLimitHandler()

Overrides:

getLimitHandler in class DB2LegacyDialect

getIdentityColumnSupport

public org.hibernate.dialect.identity.IdentityColumnSupport getIdentityColumnSupport()

Overrides:

getIdentityColumnSupport in class DB2LegacyDialect

supportsLateral

public boolean supportsLateral()

Overrides:

supportsLateral in class DB2LegacyDialect

supportsRecursiveCTE

public boolean supportsRecursiveCTE()

Overrides:

supportsRecursiveCTE in class DB2LegacyDialect

getSqlAstTranslatorFactory

public org.hibernate.sql.ast.SqlAstTranslatorFactory getSqlAstTranslatorFactory()

Overrides:

getSqlAstTranslatorFactory in class DB2LegacyDialect