public Class OracleDialect

appendDatetimeFormat(SqlAppender appender, String format)

Overrides org.hibernate.dialect.Dialect.appendDatetimeFormat.

Translate the given datetime format string from the pattern language defined by Java's java.time.format.DateTimeFormatter to whatever pattern language is understood by the native datetime formatting function for this database (often the to_char() function).

buildIdentifierHelper(IdentifierHelperBuilder

A partially-configured IdentifierHelperBuilder.

builder, DatabaseMetaData

Access to the metadata returned from the driver if needed and if available

Warning

it may be null.

dbMetaData)

Overrides org.hibernate.dialect.Dialect.buildIdentifierHelper.

The IdentifierHelper indicated by this dialect for handling identifier conversions.

canCreateSchema()

Overrides org.hibernate.dialect.Dialect.canCreateSchema.

Does this dialect support creating and dropping schema?

castPattern(CastType

a CastType indicating the type of the value argument

from, CastType

a CastType indicating the type the value argument is cast to

to)

Overrides org.hibernate.dialect.Dialect.castPattern.

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.

contributeTypes(TypeContributions

Callback to contribute the types

typeContributions, ServiceRegistry

The service registry

serviceRegistry)

Overrides org.hibernate.dialect.Dialect.contributeTypes.

A callback which allows the Dialect to contribute types.

currentDate()

Overrides org.hibernate.dialect.Dialect.currentDate.

Translation of the HQL/JPQL current_date function, which maps to the Java type java.sql.Date, and of the HQL local_date function which maps to the Java type java.time.LocalDate.

currentLocalTimestamp()

Overrides org.hibernate.dialect.Dialect.currentLocalTimestamp.

Translation of the HQL local_datetime function, which maps to the Java type java.time.LocalDateTime which is a datetime with no time zone.

currentTimestamp()

Overrides org.hibernate.dialect.Dialect.currentTimestamp.

Translation of the HQL/JPQL current_timestamp function, which maps to the Java type java.sql.Timestamp which is a datetime with no time zone.

forceLobAsLastValue()

Overrides org.hibernate.dialect.Dialect.forceLobAsLastValue.

Must LOB values occur last in inserts and updates?

getAddColumnString()

Overrides org.hibernate.dialect.Dialect.getAddColumnString.

The subcommand of the alter table command used to add a column to a table, usually add column or add.

getAlterColumnTypeString(String

the name of the column

columnName, String

the new type of the column

columnType, String

the full column definition

columnDefinition)

Overrides org.hibernate.dialect.Dialect.getAlterColumnTypeString.

The fragment of an alter table command which modifies a column type, or null if column types cannot be modified.

getCallableStatementSupport()

Overrides org.hibernate.dialect.Dialect.getCallableStatementSupport.

The CallableStatementSupport for this database.

getCreateUserDefinedTypeKindString()

Overrides org.hibernate.dialect.Dialect.getCreateUserDefinedTypeKindString.

The kind of user-defined type to create, or the empty string if this does not need to be specified.

getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSelectString.

The command used to retrieve the current timestamp from the database.

getDefaultUseGetGeneratedKeys()

Overrides org.hibernate.dialect.Dialect.getDefaultUseGetGeneratedKeys.

The default value to use for the configuration property hibernate.jdbc.use_get_generated_keys.

getDmlTargetColumnQualifierSupport()

Overrides org.hibernate.dialect.Dialect.getDmlTargetColumnQualifierSupport.

Get the minimum DmlTargetColumnQualifierSupport required by this dialect.

getFallbackSqmInsertStrategy(EntityMappingType rootEntityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)

Overrides org.hibernate.dialect.Dialect.getFallbackSqmInsertStrategy.

The SqmMultiTableInsertStrategy to use when not specified by org.hibernate.query.spi.QueryEngineOptions#getCustomSqmMultiTableInsertStrategy.

getForUpdateNowaitString()

Overrides org.hibernate.dialect.Dialect.getForUpdateNowaitString.

Retrieves the FOR UPDATE NOWAIT syntax specific to this dialect.

getForUpdateSkipLockedString()

Overrides org.hibernate.dialect.Dialect.getForUpdateSkipLockedString.

Retrieves the FOR UPDATE SKIP LOCKED syntax specific to this dialect.

getForUpdateString(String

The columns to be write locked.

aliases)

Overrides org.hibernate.dialect.Dialect.getForUpdateString.

Get the FOR UPDATE OF column_list fragment appropriate for this dialect, given the aliases of the columns to be write locked.

getIdentityColumnSupport()

Overrides org.hibernate.dialect.Dialect.getIdentityColumnSupport.

Get the appropriate IdentityColumnSupport for this dialect.

getLimitHandler()

Overrides org.hibernate.dialect.Dialect.getLimitHandler.

Obtain a LimitHandler that implements pagination support for Query#setMaxResults(int) and Query#setFirstResult(int).

getMaxIdentifierLength()

Overrides org.hibernate.dialect.Dialect.getMaxIdentifierLength.

What is the maximum identifier length supported by this dialect?

getMaxVarcharLength()

Overrides org.hibernate.dialect.Dialect.getMaxVarcharLength.

The biggest size value that can be supplied as argument to a java.sql.Types#VARCHAR-like type.

getNativeIdentifierGeneratorStrategy()

Overrides org.hibernate.dialect.Dialect.getNativeIdentifierGeneratorStrategy.

The name identifying the "native" id generation strategy for this dialect.

getPreferredSqlTypeCodeForBoolean()

Overrides org.hibernate.dialect.Dialect.getPreferredSqlTypeCodeForBoolean.

The JDBC type code to use for mapping properties of Java type boolean.

getQuerySequencesString()

Overrides org.hibernate.dialect.Dialect.getQuerySequencesString.

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

getReadLockString(String

The columns to be read locked.

aliases, int

in milliseconds, -1 for indefinite wait and 0 for no wait.

timeout)

Overrides org.hibernate.dialect.Dialect.getReadLockString.

Get the string to append to SELECT statements to acquire READ locks for this dialect, given the aliases of the columns to be read locked.

getResultSet(CallableStatement

The callable statement.

statement, int

The bind position at which to register the output param.

position)

Overrides org.hibernate.dialect.Dialect.getResultSet.

Given a callable statement previously processed by registerResultSetOutParameter, extract the ResultSet from the positional OUT parameter.

getSelectGUIDString()

Overrides org.hibernate.dialect.Dialect.getSelectGUIDString.

Get the command used to select a GUID from the database.

getSequenceSupport()

Overrides org.hibernate.dialect.Dialect.getSequenceSupport.

Get the appropriate SequenceSupport for this dialect.

getSupportedTemporaryTableKind()

Overrides org.hibernate.dialect.Dialect.getSupportedTemporaryTableKind.

The kind of temporary tables that are supported on this database.

getTimeZoneSupport()

Overrides org.hibernate.dialect.Dialect.getTimeZoneSupport.

How the dialect supports time zone types like Types#TIMESTAMP_WITH_TIMEZONE.

getViolatedConstraintNameExtractor()

Overrides org.hibernate.dialect.Dialect.getViolatedConstraintNameExtractor.

Implements org.hibernate.exception.spi.ConversionContext.getViolatedConstraintNameExtractor.

A ViolatedConstraintNameExtractor for extracting the name of a violated constraint from a SQLException.

getWriteLockString(String

The columns to be read locked.

aliases, int

in milliseconds, -1 for indefinite wait and 0 for no wait.

timeout)

Overrides org.hibernate.dialect.Dialect.getWriteLockString.

Get the string to append to SELECT statements to acquire WRITE locks for this dialect, given the aliases of the columns to be write locked.

isCurrentTimestampSelectStringCallable()

Overrides org.hibernate.dialect.Dialect.isCurrentTimestampSelectStringCallable.

Is the command returned by getCurrentTimestampSelectString treated as callable?

registerResultSetOutParameter(CallableStatement

The callable statement.

statement, String

The parameter name (for drivers which support named parameters).

name)

Overrides org.hibernate.dialect.Dialect.registerResultSetOutParameter.

Registers a parameter capable of returning a ResultSet by name, either an OUT parameter, or a REF_CURSOR parameter as defined in Java 8.

rowId(String

the name specified by org.hibernate.annotations.RowId#value(), which is ignored if getRowIdColumnString is not overridden

rowId)

Overrides org.hibernate.dialect.Dialect.rowId.

The name of a rowid-like pseudo-column which acts as a high-performance row locator, or null if this dialect has no such pseudo-column.

supportsAlterColumnType()

Overrides org.hibernate.dialect.Dialect.supportsAlterColumnType.

Does this dialect support modifying the type of an existing column?

supportsCommentOn()

Overrides org.hibernate.dialect.Dialect.supportsCommentOn.

Does this dialect support commenting on tables and columns?

supportsExistsInSelect()

Overrides org.hibernate.dialect.Dialect.supportsExistsInSelect.

Does the dialect support an exists statement in the select clause?

supportsIfExistsAfterAlterTable()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsAfterAlterTable.

For an alter table, can the phrase if exists be applied?

supportsIfExistsBeforeTypeName()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsBeforeTypeName.

For dropping a type, can the phrase if exists be applied before the type name?

supportsLateral()

Overrides org.hibernate.dialect.Dialect.supportsLateral.

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

supportsNoWait()

Overrides org.hibernate.dialect.Dialect.supportsNoWait.

Does this dialect support NO_WAIT timeout.

supportsPartitionBy()

Overrides org.hibernate.dialect.Dialect.supportsPartitionBy.

Does is dialect support partition by?

supportsSkipLocked()

Overrides org.hibernate.dialect.Dialect.supportsSkipLocked.

Does this dialect support SKIP_LOCKED timeout.

supportsTupleDistinctCounts()

Overrides org.hibernate.dialect.Dialect.supportsTupleDistinctCounts.

Does this dialect support count(distinct a,b)?

timestampaddPattern(TemporalUnit

The unit to add to the temporal

unit, TemporalType

The type of the temporal

temporalType, IntervalType

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

intervalType)

Overrides org.hibernate.dialect.Dialect.timestampaddPattern.

Obtain a pattern for the SQL equivalent to a timestampadd() function call.

useFollowOnLocking(String sql, QueryOptions queryOptions)

Overrides org.hibernate.dialect.Dialect.useFollowOnLocking.

The FOR UPDATE clause cannot be applied when using ORDER BY, DISTINCT or views.