Package org.hibernate.dialect

Class DB2iDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.dialect.DB2Dialect

org.hibernate.dialect.DB2iDialect

All Implemented Interfaces:

ConversionContext

public class DB2iDialect
extends DB2Dialect

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

Dialect.SizeStrategy, Dialect.SizeStrategyImpl

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

CLOSED_QUOTE, LEGACY_LOB_MERGE_STRATEGY, NEW_LOCATOR_LOB_MERGE_STRATEGY, QUOTE, STANDARD_DEFAULT_BATCH_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
protected UniqueDelegate	createUniqueDelegate()
IdentityColumnSupport	getIdentityColumnSupport()	Get the appropriate IdentityColumnSupport
DatabaseVersion	getIVersion()
LimitHandler	getLimitHandler()	Returns a LimitHandler that implements support for Query.setMaxResults(int) and Query.setFirstResult(int) for this dialect.
String	getQuerySequencesString()	Get the select command used retrieve the names of all sequences.
SequenceSupport	getSequenceSupport()	No support for sequences.
SqlAstTranslatorFactory	getSqlAstTranslatorFactory()	Return an SqlAstTranslatorFactory specific for the Dialect.
boolean	supportsLateral()	Does this dialect support the SQL lateral keyword or a proprietary alternative=
boolean	supportsSkipLocked()	Does this dialect/database support SKIP_LOCKED timeout.

Methods inherited from class org.hibernate.dialect.DB2Dialect

appendBinaryLiteral, appendBooleanValueString, appendDatetimeFormat, buildSQLExceptionConversionDelegate, columnType, contributeTypes, doesReadCommittedCauseWritersToBlockReaders, dropConstraints, extractPattern, getCurrentTimestampSelectString, getDefaultDecimalPrecision, getDefaultStatementBatchSize, getDropSchemaCommand, getFallbackSqmInsertStrategy, getFallbackSqmMutationStrategy, getForUpdateSkipLockedString, getForUpdateSkipLockedString, getForUpdateString, getFractionalSecondPrecisionInNanos, getInExpressionCountLimit, getLowercaseFunction, getMaxIdentifierLength, getMaxVarcharLength, getReadLockString, getResultSet, getSelectClauseNullString, getSequenceInformationExtractor, getUniqueDelegate, getWriteLockString, initializeFunctionRegistry, isCurrentTimestampSelectStringCallable, registerDefaultColumnTypes, registerResultSetOutParameter, supportsCommentOn, supportsCurrentTimestampSelection, supportsExistsInSelect, supportsLobValueChangePropagation, supportsLockTimeouts, supportsNonQueryWithCTE, supportsNullPrecedence, supportsOffsetInSubquery, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPartitionBy, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsTupleDistinctCounts, supportsValuesList, supportsWindowFunctions, timestampaddPattern, timestampdiffPattern, translateExtractField

Methods inherited from class org.hibernate.dialect.Dialect

addSqlHintOrComment, appendDateTimeLiteral, appendDateTimeLiteral, appendDateTimeLiteral, appendIntervalLiteral, appendLiteral, appendLockHint, applyLocksToSql, augmentRecognizedTableTypes, beforeRegisteringColumnTypes, beforeRegisteringColumnTypes, binaryToDecimalPrecision, buildIdentifierHelper, canCreateCatalog, canCreateSchema, castPattern, closeQuote, currentDate, currentLocalTime, currentLocalTimestamp, currentTime, currentTimestamp, currentTimestampWithTimeZone, defaultScrollMode, doesRepeatableReadCauseReadersToBlockWriters, equivalentTypes, escapeComment, forceLobAsLastValue, getAddColumnString, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAlterTableString, getAuxiliaryDatabaseObjectExporter, getBooleanCheckCondition, getCallableStatementSupport, getCascadeConstraintsString, getCaseInsensitiveLike, getCastTypeName, getColumnAliasExtractor, getColumnComment, getCreateCatalogCommand, getCreateMultisetTableString, getCreateSchemaCommand, getCreateTableString, getCreateTemporaryTableColumnAnnotation, getCurrentSchemaCommand, getDefaultBatchLoadSizingStrategy, getDefaultLobLength, getDefaultNonContextualLobCreation, getDefaultProperties, getDefaultTimestampPrecision, getDefaultUseGetGeneratedKeys, getDefaultUseStreamsForBinary, getDoublePrecision, getDropCatalogCommand, getDropForeignKeyString, getDropTableString, getEnumCheckCondition, getFloatPrecision, getForeignKeyExporter, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getGroupBySelectItemReferenceStrategy, getHibernateTypeName, getHibernateTypeName, getHqlTranslator, getIndexExporter, getKeywords, getLobMergeStrategy, getLockingStrategy, getLockRowIdentifier, getMaxAliasLength, getMaxNVarcharLength, getMaxVarbinaryLength, getNameQualifierSupport, getNationalizationSupport, getNativeIdentifierGeneratorStrategy, getNoColumnsInsertString, getNullColumnString, getNullColumnString, getNullOrdering, getPreferredSqlTypeCodeForBoolean, getQueryHintString, getQueryHintString, getRawTypeName, getRawTypeName, getReadLockString, getReadRowLockStrategy, getResultSet, getResultSet, getSchemaNameResolver, getSelectGUIDString, getSequenceExporter, getSizeStrategy, getSqmTranslatorFactory, getSupportedJdbcTypeCodes, getSupportedTemporaryTableKind, getTableComment, getTableExporter, getTableTypeString, getTemporaryTableAfterUseAction, getTemporaryTableBeforeUseAction, getTemporaryTableCreateCommand, getTemporaryTableCreateOptions, getTemporaryTableDdlTransactionHandling, getTemporaryTableDropCommand, getTemporaryTableExporter, getTemporaryTableTruncateCommand, getTimeZoneSupport, getTypeName, getTypeName, getTypeName, getTypeName, getUniqueKeyExporter, getVersion, getViolatedConstraintNameExtractor, getWriteLockString, getWriteRowLockStrategy, hasAlterTable, hasSelfReferentialForeignKeyBug, initDefaultProperties, inlineLiteral, isAnsiNullOn, isEmptyStringTreatedAsNull, isJdbcLogWarningsEnabledByDefault, isLockTimeoutParameterized, isTypeNameRegistered, openQuote, prependComment, qualifyIndexName, quote, registerColumnType, registerColumnType, registerDefaultColumnTypes, registerDefaultKeywords, registerHibernateType, registerHibernateType, registerHibernateTypes, registerKeyword, registerKeywords, registerResultSetOutParameter, requiresFloatCastingOfIntegerDivision, requiresParensForTupleCounts, requiresParensForTupleDistinctCounts, resolveSqlTypeDescriptor, resolveSqlTypeLength, supportsBindAsCallableArgument, supportsBitType, supportsCascadeDelete, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsExpectedLobUsagePattern, supportsFetchClause, supportsFractionalTimestampArithmetic, supportsIfExistsAfterAlterTable, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsBeforeConstraintName, supportsIfExistsBeforeTableName, supportsJdbcConnectionLobCreation, supportsNamedParameters, supportsNoColumnsInsert, supportsNoWait, supportsOrderByInSubquery, supportsOrdinalSelectItemReference, supportsSubqueryInSelect, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTemporalLiteralOffset, supportsTemporaryTablePrimaryKey, supportsTemporaryTables, supportsTruncateWithCast, supportsTupleCounts, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, supportsUnionInSubquery, supportsValuesListForInsert, supportsWait, toBooleanValueString, toString, transformSelectString, translateDurationField, trimPattern, useFollowOnLocking, useInputStreamToInsertBlob

Methods inherited from class java.lang.Object

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

Constructor Detail

DB2iDialect

public DB2iDialect(DialectResolutionInfo info)

DB2iDialect

public DB2iDialect()

DB2iDialect

public DB2iDialect(DatabaseVersion version)

Method Detail

getIVersion

public DatabaseVersion getIVersion()

createUniqueDelegate

protected UniqueDelegate createUniqueDelegate()

Overrides:

createUniqueDelegate in class DB2Dialect

getSequenceSupport

public SequenceSupport getSequenceSupport()

No support for sequences.

Overrides:

getSequenceSupport in class DB2Dialect

getQuerySequencesString

public String getQuerySequencesString()

Description copied from class: Dialect

Get the select command used retrieve the names of all sequences.

Overrides:

getQuerySequencesString in class DB2Dialect

Returns:

The select command; or null if sequences are not supported.

getLimitHandler

public LimitHandler getLimitHandler()

Description copied from class: Dialect

Returns a LimitHandler that implements support for Query.setMaxResults(int) and Query.setFirstResult(int) for this dialect.

Overrides:

getLimitHandler in class DB2Dialect

getIdentityColumnSupport

public IdentityColumnSupport getIdentityColumnSupport()

Description copied from class: Dialect

Get the appropriate IdentityColumnSupport

Overrides:

getIdentityColumnSupport in class DB2Dialect

Returns:

the IdentityColumnSupport

supportsSkipLocked

public boolean supportsSkipLocked()

Description copied from class: Dialect

Does this dialect/database support SKIP_LOCKED timeout.

Overrides:

supportsSkipLocked in class DB2Dialect

Returns:

true if SKIP_LOCKED is supported

supportsLateral

public boolean supportsLateral()

Description copied from class: Dialect

Does this dialect support the SQL lateral keyword or a proprietary alternative=

Overrides:

supportsLateral in class DB2Dialect

Returns:

true if the underlying database supports lateral, false otherwise. The default is false.

getSqlAstTranslatorFactory

public SqlAstTranslatorFactory getSqlAstTranslatorFactory()

Description copied from class: Dialect

Return an SqlAstTranslatorFactory specific for the Dialect. Return null to use Hibernate's standard translator.

Overrides:

getSqlAstTranslatorFactory in class DB2Dialect

See Also:

StandardSqlAstTranslatorFactory, JdbcEnvironment.getSqlAstTranslatorFactory()