Package org.hibernate.community.dialect

Class OracleLegacyDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.community.dialect.OracleLegacyDialect

All Implemented Interfaces:

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

Direct Known Subclasses:

Oracle10gDialect, Oracle8iDialect, Oracle9iDialect

public class OracleLegacyDialect
extends org.hibernate.dialect.Dialect

A SQL dialect for Oracle 8i and above.

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

Modifier and Type	Field	Description
static final String	PREFER_LONG_RAW

Fields inherited from class org.hibernate.dialect.Dialect

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

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
void	appendBinaryLiteral(org.hibernate.sql.ast.spi.SqlAppender appender, byte[] bytes)
void	appendDatetimeFormat(org.hibernate.sql.ast.spi.SqlAppender appender, String format)
void	appendDateTimeLiteral(org.hibernate.sql.ast.spi.SqlAppender appender, TemporalAccessor temporalAccessor, TemporalType precision, TimeZone jdbcTimeZone)
org.hibernate.engine.jdbc.env.spi.IdentifierHelper	buildIdentifierHelper(org.hibernate.engine.jdbc.env.spi.IdentifierHelperBuilder builder, DatabaseMetaData dbMetaData)
org.hibernate.exception.spi.SQLExceptionConversionDelegate	buildSQLExceptionConversionDelegate()
boolean	canCreateSchema()
boolean	canDisableConstraints()
String	castPattern(org.hibernate.query.sqm.CastType from, org.hibernate.query.sqm.CastType to)	Oracle doesn't have any sort of Types.BOOLEAN type or Types.TIME type, and its default behavior for casting dates and timestamps to and from strings is just awful.
protected String	columnType(int sqlTypeCode)
void	contributeTypes(org.hibernate.boot.model.TypeContributions typeContributions, org.hibernate.service.ServiceRegistry serviceRegistry)
String	currentDate()
String	currentLocalTime()
String	currentLocalTimestamp()
String	currentTime()
String	currentTimestamp()
String	currentTimestampWithTimeZone()
static org.hibernate.dialect.Replacer	datetimeFormat(String format, boolean useFm, boolean resetFm)
boolean	dropConstraints()
String	extractPattern(org.hibernate.query.sqm.TemporalUnit unit)	Oracle supports a limited list of temporal fields in the extract() function, but we can emulate some of them by using to_char() with a format string instead of extract().
boolean	forceLobAsLastValue()
String	generatedAs(String generatedAs)
String	getAddColumnString()
org.hibernate.dialect.aggregate.AggregateSupport	getAggregateSupport()
String	getArrayTypeName(String javaElementTypeName, String elementTypeName, Integer maxLength)
org.hibernate.procedure.spi.CallableStatementSupport	getCallableStatementSupport()
String	getCascadeConstraintsString()
String	getCreateUserDefinedTypeKindString()
String	getCurrentSchemaCommand()
String	getCurrentTimestampSelectString()
int	getDefaultStatementBatchSize()
int	getDefaultTimestampPrecision()
boolean	getDefaultUseGetGeneratedKeys()
String	getDisableConstraintStatement(String tableName, String name)
org.hibernate.dialect.DmlTargetColumnQualifierSupport	getDmlTargetColumnQualifierSupport()
String	getEnableConstraintStatement(String tableName, String name)
org.hibernate.query.sqm.mutation.spi.SqmMultiTableInsertStrategy	getFallbackSqmInsertStrategy(org.hibernate.metamodel.mapping.EntityMappingType rootEntityDescriptor, org.hibernate.metamodel.spi.RuntimeModelCreationContext runtimeModelCreationContext)
org.hibernate.query.sqm.mutation.spi.SqmMultiTableMutationStrategy	getFallbackSqmMutationStrategy(org.hibernate.metamodel.mapping.EntityMappingType rootEntityDescriptor, org.hibernate.metamodel.spi.RuntimeModelCreationContext runtimeModelCreationContext)
String	getForUpdateNowaitString()
String	getForUpdateNowaitString(String aliases)
String	getForUpdateSkipLockedString()
String	getForUpdateSkipLockedString(String aliases)
String	getForUpdateString(String aliases)
long	getFractionalSecondPrecisionInNanos()	We minimize multiplicative factors by using seconds (with fractional part) as the "native" precision for duration arithmetic.
org.hibernate.dialect.identity.IdentityColumnSupport	getIdentityColumnSupport()
int	getInExpressionCountLimit()
org.hibernate.dialect.pagination.LimitHandler	getLimitHandler()
int	getMaxAliasLength()
int	getMaxIdentifierLength()
int	getMaxVarbinaryLength()
int	getMaxVarcharLength()
String	getNativeIdentifierGeneratorStrategy()
int	getPreferredSqlTypeCodeForArray()
int	getPreferredSqlTypeCodeForBoolean()
String	getQueryHintString(String sql, String hints)
String	getQuerySequencesString()
String	getReadLockString(int timeout)
String	getReadLockString(String aliases, int timeout)
ResultSet	getResultSet(CallableStatement ps)
ResultSet	getResultSet(CallableStatement statement, int position)
ResultSet	getResultSet(CallableStatement statement, String name)
String	getSelectClauseNullString(int sqlType, org.hibernate.type.spi.TypeConfiguration typeConfiguration)
String	getSelectGUIDString()
org.hibernate.tool.schema.extract.spi.SequenceInformationExtractor	getSequenceInformationExtractor()
org.hibernate.dialect.sequence.SequenceSupport	getSequenceSupport()
org.hibernate.sql.ast.SqlAstTranslatorFactory	getSqlAstTranslatorFactory()
org.hibernate.dialect.temptable.TemporaryTableKind	getSupportedTemporaryTableKind()
String	getTemporaryTableCreateOptions()
org.hibernate.dialect.TimeZoneSupport	getTimeZoneSupport()
org.hibernate.dialect.unique.UniqueDelegate	getUniqueDelegate()
org.hibernate.exception.spi.ViolatedConstraintNameExtractor	getViolatedConstraintNameExtractor()
String	getWriteLockString(int timeout)
String	getWriteLockString(String aliases, int timeout)
org.hibernate.dialect.RowLockStrategy	getWriteRowLockStrategy()
protected void	initDefaultProperties()
void	initializeFunctionRegistry(org.hibernate.boot.model.FunctionContributions functionContributions)
boolean	isCurrentTimestampSelectStringCallable()
boolean	isEmptyStringTreatedAsNull()
protected void	registerColumnTypes(org.hibernate.boot.model.TypeContributions typeContributions, org.hibernate.service.ServiceRegistry serviceRegistry)
int	registerResultSetOutParameter(CallableStatement statement, int col)
int	registerResultSetOutParameter(CallableStatement statement, String name)
org.hibernate.type.descriptor.jdbc.JdbcType	resolveSqlTypeDescriptor(String columnTypeName, int jdbcTypeCode, int precision, int scale, org.hibernate.type.descriptor.jdbc.spi.JdbcTypeRegistry jdbcTypeRegistry)
String	rowId(String rowId)
boolean	supportsBitType()	Oracle has neither BIT nor BOOLEAN.
boolean	supportsCommentOn()
boolean	supportsCurrentTimestampSelection()
boolean	supportsExistsInSelect()
boolean	supportsFetchClause(org.hibernate.query.sqm.FetchClauseType type)
boolean	supportsFromClauseInUpdate()
boolean	supportsInsertReturningGeneratedKeys()
boolean	supportsLateral()
boolean	supportsNamedParameters(DatabaseMetaData databaseMetaData)
boolean	supportsNoWait()
boolean	supportsOffsetInSubquery()
boolean	supportsPartitionBy()
boolean	supportsRecursiveCTE()
boolean	supportsSkipLocked()
boolean	supportsTemporalLiteralOffset()
boolean	supportsTupleDistinctCounts()
boolean	supportsWindowFunctions()
String	timestampaddPattern(org.hibernate.query.sqm.TemporalUnit unit, TemporalType temporalType, org.hibernate.query.sqm.IntervalType intervalType)
String	timestampdiffPattern(org.hibernate.query.sqm.TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)
boolean	useFollowOnLocking(String sql, org.hibernate.query.spi.QueryOptions queryOptions)	For Oracle, the FOR UPDATE clause cannot be applied when using ORDER BY, DISTINCT or views.

Methods inherited from class org.hibernate.dialect.Dialect

addSqlHintOrComment, appendArrayLiteral, appendBooleanValueString, appendDateTimeLiteral, appendDateTimeLiteral, appendIntervalLiteral, appendLiteral, appendLockHint, appendUUIDLiteral, applyLocksToSql, augmentPhysicalTableTypes, augmentRecognizedTableTypes, canBatchTruncate, canCreateCatalog, castType, checkVersion, closeQuote, contribute, contributeFunctions, createOptionalTableUpdateOperation, defaultScrollMode, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, doesRoundTemporalOnOverflow, equivalentTypes, escapeComment, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAlterColumnTypeString, getAlterTableString, getAuxiliaryDatabaseObjectExporter, getBatchLoadSizingStrategy, getCaseInsensitiveLike, getCheckCondition, getCheckCondition, getCheckCondition, getCheckCondition, getCheckCondition, getColumnAliasExtractor, getColumnComment, getCreateCatalogCommand, getCreateEnumTypeCommand, getCreateEnumTypeCommand, getCreateIndexString, getCreateIndexTail, getCreateMultisetTableString, getCreateSchemaCommand, getCreateTableString, getCreateTemporaryTableColumnAnnotation, getCreateUserDefinedTypeExtensionsString, getDefaultDecimalPrecision, getDefaultIntervalSecondScale, getDefaultLobLength, getDefaultNonContextualLobCreation, getDefaultProperties, getDisableConstraintsStatement, getDoublePrecision, getDropCatalogCommand, getDropEnumTypeCommand, getDropEnumTypeCommand, getDropForeignKeyString, getDropSchemaCommand, getDropTableString, getDropUniqueKeyString, getEnableConstraintsStatement, getEnumTypeDeclaration, getEnumTypeDeclaration, getFallbackSchemaManagementTool, getFloatPrecision, getForeignKeyExporter, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctionalDependencyAnalysisSupport, getGroupBySelectItemReferenceStrategy, getHqlTranslator, getIndexExporter, getKeywords, getLobMergeStrategy, getLockingStrategy, getLockRowIdentifier, getLowercaseFunction, getMaxNVarcharCapacity, getMaxNVarcharLength, getMaxVarbinaryCapacity, getMaxVarcharCapacity, getMinimumSupportedVersion, getMultiKeyLoadSizingStrategy, getNameQualifierSupport, getNationalizationSupport, getNativeParameterMarkerStrategy, getNoColumnsInsertString, getNullColumnString, getNullColumnString, getNullOrdering, getParameterCountLimit, getQueryHintString, getReadRowLockStrategy, getRowIdColumnString, getSchemaNameResolver, getSequenceExporter, getSizeStrategy, getSqmTranslatorFactory, getTableCleaner, getTableComment, getTableExporter, getTableMigrator, getTableTypeString, getTemporaryTableAfterUseAction, getTemporaryTableBeforeUseAction, getTemporaryTableCreateCommand, getTemporaryTableDdlTransactionHandling, getTemporaryTableDropCommand, getTemporaryTableExporter, getTemporaryTableTruncateCommand, getTimeoutInSeconds, getTruncateTableStatement, getTruncateTableStatements, getUniqueKeyExporter, getUserDefinedTypeComment, getUserDefinedTypeExporter, getVersion, hasAlterTable, hasDataTypeBeforeGeneratedAs, hasSelfReferentialForeignKeyBug, inlineLiteral, isAnsiNullOn, isJdbcLogWarningsEnabledByDefault, isLob, isLockTimeoutParameterized, openQuote, ordinal, prependComment, qualifyIndexName, quote, quoteCollation, registerDefaultKeywords, registerKeyword, registerKeywords, requiresCastForConcatenatingNonStrings, requiresFloatCastingOfIntegerDivision, requiresParensForTupleCounts, requiresParensForTupleDistinctCounts, resolveSqlTypeCode, resolveSqlTypeCode, resolveSqlTypeLength, rowIdSqlType, supportsAlterColumnType, supportsBatchUpdates, supportsBindAsCallableArgument, supportsCascadeDelete, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsConflictClauseForInsertCTE, supportsDistinctFromPredicate, supportsExpectedLobUsagePattern, supportsFractionalTimestampArithmetic, supportsIfExistsAfterAlterTable, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsAfterTypeName, supportsIfExistsBeforeConstraintName, supportsIfExistsBeforeTableName, supportsIfExistsBeforeTypeName, supportsInsertReturning, supportsInsertReturningRowId, supportsIsTrue, supportsJdbcConnectionLobCreation, supportsLobValueChangePropagation, supportsLockTimeouts, supportsMaterializedLobAccess, supportsNoColumnsInsert, supportsNonQueryWithCTE, supportsNullPrecedence, supportsOrderByInSubquery, supportsOrdinalSelectItemReference, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPredicateAsExpression, supportsRefCursors, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsStandardArrays, supportsStandardCurrentTimestampFunction, supportsSubqueryInSelect, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTemporaryTablePrimaryKey, supportsTemporaryTables, supportsTruncateWithCast, supportsTupleCounts, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, supportsUnionInSubquery, supportsUpdateReturning, supportsValuesList, supportsValuesListForInsert, supportsWait, toBooleanValueString, toQuotedIdentifier, toString, transformSelectString, translateDurationField, translateExtractField, trimPattern, trimPattern, unquoteGetGeneratedKeys, useArrayForMultiValuedParameters, useInputStreamToInsertBlob, useMaterializedLobWhenCapacityExceeded

Methods inherited from class java.lang.Object

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

Field Details

PREFER_LONG_RAW

public static final String PREFER_LONG_RAW

See Also:

• Constant Field Values

Constructor Details

OracleLegacyDialect

public OracleLegacyDialect()

OracleLegacyDialect

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

OracleLegacyDialect

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

Method Details

getPreferredSqlTypeCodeForBoolean

public int getPreferredSqlTypeCodeForBoolean()

Overrides:

getPreferredSqlTypeCodeForBoolean in class org.hibernate.dialect.Dialect

initializeFunctionRegistry

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

Overrides:

initializeFunctionRegistry in class org.hibernate.dialect.Dialect

getMaxVarcharLength

public int getMaxVarcharLength()

Overrides:

getMaxVarcharLength in class org.hibernate.dialect.Dialect

getMaxVarbinaryLength

public int getMaxVarbinaryLength()

Overrides:

getMaxVarbinaryLength in class org.hibernate.dialect.Dialect

getSqlAstTranslatorFactory

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

Overrides:

getSqlAstTranslatorFactory in class org.hibernate.dialect.Dialect

currentDate

public String currentDate()

Overrides:

currentDate in class org.hibernate.dialect.Dialect

currentTime

public String currentTime()

Overrides:

currentTime in class org.hibernate.dialect.Dialect

currentTimestamp

public String currentTimestamp()

Overrides:

currentTimestamp in class org.hibernate.dialect.Dialect

currentLocalTime

public String currentLocalTime()

Overrides:

currentLocalTime in class org.hibernate.dialect.Dialect

currentLocalTimestamp

public String currentLocalTimestamp()

Overrides:

currentLocalTimestamp in class org.hibernate.dialect.Dialect

currentTimestampWithTimeZone

public String currentTimestampWithTimeZone()

Overrides:

currentTimestampWithTimeZone in class org.hibernate.dialect.Dialect

supportsInsertReturningGeneratedKeys

public boolean supportsInsertReturningGeneratedKeys()

Overrides:

supportsInsertReturningGeneratedKeys in class org.hibernate.dialect.Dialect

castPattern

public String castPattern(org.hibernate.query.sqm.CastType from,
 org.hibernate.query.sqm.CastType to)

Oracle doesn't have any sort of Types.BOOLEAN type or Types.TIME type, and its default behavior for casting dates and timestamps to and from strings is just awful.

Overrides:

castPattern in class org.hibernate.dialect.Dialect

getFractionalSecondPrecisionInNanos

public long getFractionalSecondPrecisionInNanos()

We minimize multiplicative factors by using seconds (with fractional part) as the "native" precision for duration arithmetic.

Overrides:

getFractionalSecondPrecisionInNanos in class org.hibernate.dialect.Dialect

extractPattern

public String extractPattern(org.hibernate.query.sqm.TemporalUnit unit)

Oracle supports a limited list of temporal fields in the extract() function, but we can emulate some of them by using to_char() with a format string instead of extract(). Thus, the additional supported fields are TemporalUnit.DAY_OF_YEAR, TemporalUnit.DAY_OF_MONTH, TemporalUnit.DAY_OF_YEAR, and TemporalUnit.WEEK.

Overrides:

extractPattern in class org.hibernate.dialect.Dialect

timestampaddPattern

public String timestampaddPattern(org.hibernate.query.sqm.TemporalUnit unit,
 TemporalType temporalType,
 org.hibernate.query.sqm.IntervalType intervalType)

Overrides:

timestampaddPattern in class org.hibernate.dialect.Dialect

timestampdiffPattern

public String timestampdiffPattern(org.hibernate.query.sqm.TemporalUnit unit,
 TemporalType fromTemporalType,
 TemporalType toTemporalType)

Overrides:

timestampdiffPattern in class org.hibernate.dialect.Dialect

columnType

protected String columnType(int sqlTypeCode)

Overrides:

columnType in class org.hibernate.dialect.Dialect

registerColumnTypes

protected void registerColumnTypes(org.hibernate.boot.model.TypeContributions typeContributions,
 org.hibernate.service.ServiceRegistry serviceRegistry)

Overrides:

registerColumnTypes in class org.hibernate.dialect.Dialect

getTimeZoneSupport

public org.hibernate.dialect.TimeZoneSupport getTimeZoneSupport()

Overrides:

getTimeZoneSupport in class org.hibernate.dialect.Dialect

initDefaultProperties

protected void initDefaultProperties()

Overrides:

initDefaultProperties in class org.hibernate.dialect.Dialect

getDefaultStatementBatchSize

public int getDefaultStatementBatchSize()

Overrides:

getDefaultStatementBatchSize in class org.hibernate.dialect.Dialect

getDefaultUseGetGeneratedKeys

public boolean getDefaultUseGetGeneratedKeys()

Overrides:

getDefaultUseGetGeneratedKeys in class org.hibernate.dialect.Dialect

resolveSqlTypeDescriptor

public org.hibernate.type.descriptor.jdbc.JdbcType resolveSqlTypeDescriptor(String columnTypeName,
 int jdbcTypeCode,
 int precision,
 int scale,
 org.hibernate.type.descriptor.jdbc.spi.JdbcTypeRegistry jdbcTypeRegistry)

Overrides:

resolveSqlTypeDescriptor in class org.hibernate.dialect.Dialect

supportsBitType

public boolean supportsBitType()

Oracle has neither BIT nor BOOLEAN.

Overrides:

supportsBitType in class org.hibernate.dialect.Dialect

Returns:

false

getArrayTypeName

public String getArrayTypeName(String javaElementTypeName,
 String elementTypeName,
 Integer maxLength)

Overrides:

getArrayTypeName in class org.hibernate.dialect.Dialect

getPreferredSqlTypeCodeForArray

public int getPreferredSqlTypeCodeForArray()

Overrides:

getPreferredSqlTypeCodeForArray in class org.hibernate.dialect.Dialect

contributeTypes

public void contributeTypes(org.hibernate.boot.model.TypeContributions typeContributions,
 org.hibernate.service.ServiceRegistry serviceRegistry)

Overrides:

contributeTypes in class org.hibernate.dialect.Dialect

getAggregateSupport

public org.hibernate.dialect.aggregate.AggregateSupport getAggregateSupport()

Overrides:

getAggregateSupport in class org.hibernate.dialect.Dialect

getNativeIdentifierGeneratorStrategy

public String getNativeIdentifierGeneratorStrategy()

Overrides:

getNativeIdentifierGeneratorStrategy in class org.hibernate.dialect.Dialect

getIdentityColumnSupport

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

Overrides:

getIdentityColumnSupport in class org.hibernate.dialect.Dialect

getLimitHandler

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

Overrides:

getLimitHandler in class org.hibernate.dialect.Dialect

getSelectClauseNullString

public String getSelectClauseNullString(int sqlType,
 org.hibernate.type.spi.TypeConfiguration typeConfiguration)

Overrides:

getSelectClauseNullString in class org.hibernate.dialect.Dialect

getCurrentTimestampSelectString

public String getCurrentTimestampSelectString()

Overrides:

getCurrentTimestampSelectString in class org.hibernate.dialect.Dialect

getAddColumnString

public String getAddColumnString()

Overrides:

getAddColumnString in class org.hibernate.dialect.Dialect

getCascadeConstraintsString

public String getCascadeConstraintsString()

Overrides:

getCascadeConstraintsString in class org.hibernate.dialect.Dialect

dropConstraints

public boolean dropConstraints()

Overrides:

dropConstraints in class org.hibernate.dialect.Dialect

getSequenceSupport

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

Overrides:

getSequenceSupport in class org.hibernate.dialect.Dialect

getQuerySequencesString

public String getQuerySequencesString()

Overrides:

getQuerySequencesString in class org.hibernate.dialect.Dialect

getSequenceInformationExtractor

public org.hibernate.tool.schema.extract.spi.SequenceInformationExtractor getSequenceInformationExtractor()

Overrides:

getSequenceInformationExtractor in class org.hibernate.dialect.Dialect

getSelectGUIDString

public String getSelectGUIDString()

Overrides:

getSelectGUIDString in class org.hibernate.dialect.Dialect

getViolatedConstraintNameExtractor

public org.hibernate.exception.spi.ViolatedConstraintNameExtractor getViolatedConstraintNameExtractor()

Specified by:

getViolatedConstraintNameExtractor in interface org.hibernate.exception.spi.ConversionContext

Overrides:

getViolatedConstraintNameExtractor in class org.hibernate.dialect.Dialect

buildSQLExceptionConversionDelegate

public org.hibernate.exception.spi.SQLExceptionConversionDelegate buildSQLExceptionConversionDelegate()

Overrides:

buildSQLExceptionConversionDelegate in class org.hibernate.dialect.Dialect

registerResultSetOutParameter

public int registerResultSetOutParameter(CallableStatement statement,
 int col)
                                  throws SQLException

Overrides:

registerResultSetOutParameter in class org.hibernate.dialect.Dialect

Throws:

SQLException

getResultSet

public ResultSet getResultSet(CallableStatement ps)
                       throws SQLException

Overrides:

getResultSet in class org.hibernate.dialect.Dialect

Throws:

SQLException

supportsCommentOn

public boolean supportsCommentOn()

Overrides:

supportsCommentOn in class org.hibernate.dialect.Dialect

supportsCurrentTimestampSelection

public boolean supportsCurrentTimestampSelection()

Overrides:

supportsCurrentTimestampSelection in class org.hibernate.dialect.Dialect

isCurrentTimestampSelectStringCallable

public boolean isCurrentTimestampSelectStringCallable()

Overrides:

isCurrentTimestampSelectStringCallable in class org.hibernate.dialect.Dialect

supportsExistsInSelect

public boolean supportsExistsInSelect()

Overrides:

supportsExistsInSelect in class org.hibernate.dialect.Dialect

getInExpressionCountLimit

public int getInExpressionCountLimit()

Overrides:

getInExpressionCountLimit in class org.hibernate.dialect.Dialect

forceLobAsLastValue

public boolean forceLobAsLastValue()

Overrides:

forceLobAsLastValue in class org.hibernate.dialect.Dialect

isEmptyStringTreatedAsNull

public boolean isEmptyStringTreatedAsNull()

Overrides:

isEmptyStringTreatedAsNull in class org.hibernate.dialect.Dialect

getFallbackSqmMutationStrategy

public org.hibernate.query.sqm.mutation.spi.SqmMultiTableMutationStrategy getFallbackSqmMutationStrategy(org.hibernate.metamodel.mapping.EntityMappingType rootEntityDescriptor,
 org.hibernate.metamodel.spi.RuntimeModelCreationContext runtimeModelCreationContext)

Overrides:

getFallbackSqmMutationStrategy in class org.hibernate.dialect.Dialect

getFallbackSqmInsertStrategy

public org.hibernate.query.sqm.mutation.spi.SqmMultiTableInsertStrategy getFallbackSqmInsertStrategy(org.hibernate.metamodel.mapping.EntityMappingType rootEntityDescriptor,
 org.hibernate.metamodel.spi.RuntimeModelCreationContext runtimeModelCreationContext)

Overrides:

getFallbackSqmInsertStrategy in class org.hibernate.dialect.Dialect

getSupportedTemporaryTableKind

public org.hibernate.dialect.temptable.TemporaryTableKind getSupportedTemporaryTableKind()

Overrides:

getSupportedTemporaryTableKind in class org.hibernate.dialect.Dialect

getTemporaryTableCreateOptions

public String getTemporaryTableCreateOptions()

Overrides:

getTemporaryTableCreateOptions in class org.hibernate.dialect.Dialect

useFollowOnLocking

public boolean useFollowOnLocking(String sql,
 org.hibernate.query.spi.QueryOptions queryOptions)

For Oracle, the FOR UPDATE clause cannot be applied when using ORDER BY, DISTINCT or views.

Overrides:

useFollowOnLocking in class org.hibernate.dialect.Dialect

See Also:

• Oracle FOR UPDATE restrictions

getQueryHintString

public String getQueryHintString(String sql,
 String hints)

Overrides:

getQueryHintString in class org.hibernate.dialect.Dialect

getMaxAliasLength

public int getMaxAliasLength()

Overrides:

getMaxAliasLength in class org.hibernate.dialect.Dialect

getMaxIdentifierLength

public int getMaxIdentifierLength()

Overrides:

getMaxIdentifierLength in class org.hibernate.dialect.Dialect

getDefaultTimestampPrecision

public int getDefaultTimestampPrecision()

Overrides:

getDefaultTimestampPrecision in class org.hibernate.dialect.Dialect

getCallableStatementSupport

public org.hibernate.procedure.spi.CallableStatementSupport getCallableStatementSupport()

Overrides:

getCallableStatementSupport in class org.hibernate.dialect.Dialect

canCreateSchema

public boolean canCreateSchema()

Overrides:

canCreateSchema in class org.hibernate.dialect.Dialect

getCurrentSchemaCommand

public String getCurrentSchemaCommand()

Overrides:

getCurrentSchemaCommand in class org.hibernate.dialect.Dialect

supportsPartitionBy

public boolean supportsPartitionBy()

Overrides:

supportsPartitionBy in class org.hibernate.dialect.Dialect

supportsTupleDistinctCounts

public boolean supportsTupleDistinctCounts()

Overrides:

supportsTupleDistinctCounts in class org.hibernate.dialect.Dialect

supportsOffsetInSubquery

public boolean supportsOffsetInSubquery()

Overrides:

supportsOffsetInSubquery in class org.hibernate.dialect.Dialect

supportsFetchClause

public boolean supportsFetchClause(org.hibernate.query.sqm.FetchClauseType type)

Overrides:

supportsFetchClause in class org.hibernate.dialect.Dialect

supportsWindowFunctions

public boolean supportsWindowFunctions()

Overrides:

supportsWindowFunctions in class org.hibernate.dialect.Dialect

supportsRecursiveCTE

public boolean supportsRecursiveCTE()

Overrides:

supportsRecursiveCTE in class org.hibernate.dialect.Dialect

supportsLateral

public boolean supportsLateral()

Overrides:

supportsLateral in class org.hibernate.dialect.Dialect

supportsNoWait

public boolean supportsNoWait()

Overrides:

supportsNoWait in class org.hibernate.dialect.Dialect

supportsSkipLocked

public boolean supportsSkipLocked()

Overrides:

supportsSkipLocked in class org.hibernate.dialect.Dialect

getWriteRowLockStrategy

public org.hibernate.dialect.RowLockStrategy getWriteRowLockStrategy()

Overrides:

getWriteRowLockStrategy in class org.hibernate.dialect.Dialect

getForUpdateNowaitString

public String getForUpdateNowaitString()

Overrides:

getForUpdateNowaitString in class org.hibernate.dialect.Dialect

getForUpdateString

public String getForUpdateString(String aliases)

Overrides:

getForUpdateString in class org.hibernate.dialect.Dialect

getForUpdateNowaitString

public String getForUpdateNowaitString(String aliases)

Overrides:

getForUpdateNowaitString in class org.hibernate.dialect.Dialect

getForUpdateSkipLockedString

public String getForUpdateSkipLockedString()

Overrides:

getForUpdateSkipLockedString in class org.hibernate.dialect.Dialect

getForUpdateSkipLockedString

public String getForUpdateSkipLockedString(String aliases)

Overrides:

getForUpdateSkipLockedString in class org.hibernate.dialect.Dialect

getWriteLockString

public String getWriteLockString(int timeout)

Overrides:

getWriteLockString in class org.hibernate.dialect.Dialect

getWriteLockString

public String getWriteLockString(String aliases,
 int timeout)

Overrides:

getWriteLockString in class org.hibernate.dialect.Dialect

getReadLockString

public String getReadLockString(int timeout)

Overrides:

getReadLockString in class org.hibernate.dialect.Dialect

getReadLockString

public String getReadLockString(String aliases,
 int timeout)

Overrides:

getReadLockString in class org.hibernate.dialect.Dialect

supportsTemporalLiteralOffset

public boolean supportsTemporalLiteralOffset()

Overrides:

supportsTemporalLiteralOffset in class org.hibernate.dialect.Dialect

appendDateTimeLiteral

public void appendDateTimeLiteral(org.hibernate.sql.ast.spi.SqlAppender appender,
 TemporalAccessor temporalAccessor,
 TemporalType precision,
 TimeZone jdbcTimeZone)

Overrides:

appendDateTimeLiteral in class org.hibernate.dialect.Dialect

appendDatetimeFormat

public void appendDatetimeFormat(org.hibernate.sql.ast.spi.SqlAppender appender,
 String format)

Overrides:

appendDatetimeFormat in class org.hibernate.dialect.Dialect

datetimeFormat

public static org.hibernate.dialect.Replacer datetimeFormat(String format,
 boolean useFm,
 boolean resetFm)

appendBinaryLiteral

public void appendBinaryLiteral(org.hibernate.sql.ast.spi.SqlAppender appender,
 byte[] bytes)

Overrides:

appendBinaryLiteral in class org.hibernate.dialect.Dialect

getResultSet

public ResultSet getResultSet(CallableStatement statement,
 int position)
                       throws SQLException

Overrides:

getResultSet in class org.hibernate.dialect.Dialect

Throws:

SQLException

registerResultSetOutParameter

public int registerResultSetOutParameter(CallableStatement statement,
 String name)
                                  throws SQLException

Overrides:

registerResultSetOutParameter in class org.hibernate.dialect.Dialect

Throws:

SQLException

supportsNamedParameters

public boolean supportsNamedParameters(DatabaseMetaData databaseMetaData)

Overrides:

supportsNamedParameters in class org.hibernate.dialect.Dialect

getResultSet

public ResultSet getResultSet(CallableStatement statement,
 String name)
                       throws SQLException

Overrides:

getResultSet in class org.hibernate.dialect.Dialect

Throws:

SQLException

generatedAs

public String generatedAs(String generatedAs)

Overrides:

generatedAs in class org.hibernate.dialect.Dialect

buildIdentifierHelper

public org.hibernate.engine.jdbc.env.spi.IdentifierHelper buildIdentifierHelper(org.hibernate.engine.jdbc.env.spi.IdentifierHelperBuilder builder,
 DatabaseMetaData dbMetaData)
                                                                         throws SQLException

Overrides:

buildIdentifierHelper in class org.hibernate.dialect.Dialect

Throws:

SQLException

canDisableConstraints

public boolean canDisableConstraints()

Overrides:

canDisableConstraints in class org.hibernate.dialect.Dialect

getDisableConstraintStatement

public String getDisableConstraintStatement(String tableName,
 String name)

Overrides:

getDisableConstraintStatement in class org.hibernate.dialect.Dialect

getEnableConstraintStatement

public String getEnableConstraintStatement(String tableName,
 String name)

Overrides:

getEnableConstraintStatement in class org.hibernate.dialect.Dialect

getUniqueDelegate

public org.hibernate.dialect.unique.UniqueDelegate getUniqueDelegate()

Overrides:

getUniqueDelegate in class org.hibernate.dialect.Dialect

getCreateUserDefinedTypeKindString

public String getCreateUserDefinedTypeKindString()

Overrides:

getCreateUserDefinedTypeKindString in class org.hibernate.dialect.Dialect

rowId

public String rowId(String rowId)

Overrides:

rowId in class org.hibernate.dialect.Dialect

getDmlTargetColumnQualifierSupport

public org.hibernate.dialect.DmlTargetColumnQualifierSupport getDmlTargetColumnQualifierSupport()

Overrides:

getDmlTargetColumnQualifierSupport in class org.hibernate.dialect.Dialect

supportsFromClauseInUpdate

public boolean supportsFromClauseInUpdate()

Overrides:

supportsFromClauseInUpdate in class org.hibernate.dialect.Dialect