Package org.hibernate.dialect

Class DB2zDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.dialect.DB2Dialect

org.hibernate.dialect.DB2zDialect

All Implemented Interfaces:

ConversionContext

public class DB2zDialect
extends DB2Dialect

An SQL dialect for DB2 for z/OS, previously known as known as Db2 UDB for z/OS and Db2 UDB for z/OS and OS/390.

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
DB2zDialect()
DB2zDialect(DatabaseVersion version)
DB2zDialect(DialectResolutionInfo info)

Method Summary

Modifier and Type	Method	Description
protected String	columnType(int jdbcTypeCode)	The column type name for a given JDBC type code defined in Types or SqlTypes.
DatabaseVersion	getDB2Version()	DB2 LUW Version
IdentityColumnSupport	getIdentityColumnSupport()	Get the appropriate IdentityColumnSupport
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()
SqlAstTranslatorFactory	getSqlAstTranslatorFactory()	Return an SqlAstTranslatorFactory specific for the Dialect.
TimeZoneSupport	getTimeZoneSupport()	How the Dialect supports time zone types like Types.TIMESTAMP_WITH_TIMEZONE.
boolean	supportsLateral()	Does this dialect support the SQL lateral keyword or a proprietary alternative?
boolean	supportsSkipLocked()	Does this dialect/database support SKIP_LOCKED timeout.
String	timestampaddPattern(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType)	Obtain a pattern for the SQL equivalent to a timestampadd() function call.

Methods inherited from class org.hibernate.dialect.DB2Dialect

appendBinaryLiteral, appendBooleanValueString, appendDatetimeFormat, buildIdentifierHelper, buildSQLExceptionConversionDelegate, contributeTypes, createUniqueDelegate, doesReadCommittedCauseWritersToBlockReaders, dropConstraints, extractPattern, generatedAs, 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, timestampdiffPattern, translateExtractField

Methods inherited from class org.hibernate.dialect.Dialect

addSqlHintOrComment, appendDateTimeLiteral, appendDateTimeLiteral, appendDateTimeLiteral, appendIntervalLiteral, appendLiteral, appendLockHint, applyLocksToSql, augmentPhysicalTableTypes, augmentRecognizedTableTypes, beforeRegisteringColumnTypes, beforeRegisteringColumnTypes, binaryToDecimalPrecision, 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, 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, getTypeName, getTypeName, getTypeName, getTypeName, getUniqueKeyExporter, getVersion, getViolatedConstraintNameExtractor, getWriteLockString, getWriteRowLockStrategy, hasAlterTable, hasDataTypeBeforeGeneratedAs, 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

DB2zDialect

public DB2zDialect(DialectResolutionInfo info)

DB2zDialect

public DB2zDialect()

DB2zDialect

public DB2zDialect(DatabaseVersion version)

Method Detail

columnType

protected String columnType(int jdbcTypeCode)

Description copied from class: Dialect

The column type name for a given JDBC type code defined in Types or SqlTypes. This default implementation returns the ANSI-standard type name.

This method may be overridden by concrete Dialects as an alternative to calling Dialect.registerColumnType(int,String).

Overrides:

columnType in class DB2Dialect

Parameters:

jdbcTypeCode - a JDBC type code

Returns:

a column type name, with $l, $p, $s placeholders for length, precision, scale

See Also:

SqlTypes, Dialect.getSupportedJdbcTypeCodes()

getDB2Version

public DatabaseVersion getDB2Version()

Description copied from class: DB2Dialect

DB2 LUW Version

Overrides:

getDB2Version in class DB2Dialect

getTimeZoneSupport

public TimeZoneSupport getTimeZoneSupport()

Description copied from class: Dialect

How the Dialect supports time zone types like Types.TIMESTAMP_WITH_TIMEZONE.

Overrides:

getTimeZoneSupport in class Dialect

getSequenceSupport

public SequenceSupport getSequenceSupport()

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.

timestampaddPattern

public String timestampaddPattern(TemporalUnit unit,
                                  TemporalType temporalType,
                                  IntervalType intervalType)

Description copied from class: Dialect

Obtain a pattern for the SQL equivalent to a timestampadd() function call. The resulting pattern must contain ?1, ?2, and ?3 placeholders for the arguments.

Overrides:

timestampaddPattern in class DB2Dialect

Parameters:

unit - The unit to add to the temporal

temporalType - The type of the temporal

intervalType - The type of interval to add or null if it's not a native interval

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()