Top Description Fields Constructors Methods
org.hibernate.dialect

public Class DialectDelegateWrapper

extends Dialect
Class Inheritance
Annotations
@Incubating
Imports
java.sql.CallableStatement, .DatabaseMetaData, .ResultSet, .SQLException, java.time.Duration, java.time.temporal.TemporalAccessor, java.util.Calendar, .Date, .List, .Map, .Objects, .Properties, .Set, .TimeZone, .UUID, org.hibernate.Incubating, .LockMode, .LockOptions, .ScrollMode, org.hibernate.boot.TempTableDdlTransactionHandling, org.hibernate.boot.model.FunctionContributions, .TypeContributions, org.hibernate.boot.model.relational.AuxiliaryDatabaseObject, .Sequence, org.hibernate.dialect.aggregate.AggregateSupport, org.hibernate.dialect.identity.IdentityColumnSupport, org.hibernate.dialect.lock.LockingStrategy, org.hibernate.dialect.pagination.LimitHandler, org.hibernate.dialect.sequence.SequenceSupport, org.hibernate.dialect.temptable.TemporaryTableExporter, .TemporaryTableKind, org.hibernate.dialect.unique.UniqueDelegate, org.hibernate.engine.jdbc.dialect.spi.DialectResolutionInfo, org.hibernate.engine.jdbc.env.spi.IdentifierHelper, .IdentifierHelperBuilder, .NameQualifierSupport, .SchemaNameResolver, org.hibernate.engine.spi.SessionFactoryImplementor, org.hibernate.exception.spi.SQLExceptionConversionDelegate, .ViolatedConstraintNameExtractor, org.hibernate.loader.ast.spi.MultiKeyLoadSizingStrategy, org.hibernate.mapping.Column, .Constraint, .ForeignKey, .Index, .Table, .UserDefinedType, org.hibernate.metamodel.mapping.EntityMappingType, org.hibernate.metamodel.spi.RuntimeModelCreationContext, org.hibernate.persister.entity.Lockable, org.hibernate.persister.entity.mutation.EntityMutationTarget, org.hibernate.procedure.spi.CallableStatementSupport, org.hibernate.query.hql.HqlTranslator, org.hibernate.query.spi.QueryOptions, org.hibernate.query.sqm.CastType, .FetchClauseType, .IntervalType, .TemporalUnit, .TrimSpec, org.hibernate.query.sqm.mutation.internal.temptable.AfterUseAction, .BeforeUseAction, org.hibernate.query.sqm.mutation.spi.SqmMultiTableInsertStrategy, .SqmMultiTableMutationStrategy, org.hibernate.query.sqm.sql.SqmTranslatorFactory, org.hibernate.service.ServiceRegistry, org.hibernate.service.spi.ServiceRegistryImplementor, org.hibernate.sql.ast.SqlAstTranslatorFactory, org.hibernate.sql.ast.spi.ParameterMarkerStrategy, .SqlAppender, org.hibernate.sql.model.MutationOperation, org.hibernate.sql.model.internal.OptionalTableUpdate, org.hibernate.tool.schema.extract.spi.SequenceInformationExtractor, org.hibernate.tool.schema.internal.TableMigrator, org.hibernate.tool.schema.spi.Cleaner, .Exporter, .SchemaManagementTool, org.hibernate.type.descriptor.WrapperOptions, org.hibernate.type.descriptor.jdbc.JdbcLiteralFormatter, .JdbcType, org.hibernate.type.descriptor.jdbc.spi.JdbcTypeRegistry, org.hibernate.type.spi.TypeConfiguration, jakarta.persistence.TemporalType
A wrapper of Dialect, to allow decorating some selected methods without having to extend the original class. This is used by Hibernate Reactive, possibly useful for others too, best maintained in the Hibernate ORM core repository to ensure alignment with the Dialect contract.

Field Summary

Modifier and TypeField and Description
protected final Dialect
wrapped

Inherited from org.hibernate.dialect.Dialect:
CLOSED_QUOTELEGACY_LOB_MERGE_STRATEGYLOG_BASE2OF10NEW_LOCATOR_LOB_MERGE_STRATEGYQUOTESTANDARD_MULTI_KEY_LOAD_SIZING_STRATEGYSTREAM_XFER_LOB_MERGE_STRATEGY

Constructor Summary

AccessConstructor and Description
public
DialectDelegateWrapper(Dialect wrapped)

Method Summary

Modifier and TypeMethod and Description
public String
addSqlHintOrComment(String sql, QueryOptions queryOptions, boolean commentsEnabled)

Overrides org.hibernate.dialect.Dialect.addSqlHintOrComment.

Modify the SQL, adding hints or comments, if necessary
public void
appendArrayLiteral(SqlAppender appender, Object[] literal, JdbcLiteralFormatter<Object> elementFormatter, WrapperOptions wrapperOptions)

Overrides org.hibernate.dialect.Dialect.appendArrayLiteral.

Append an array literal with the given elements to the given SqlAppender.
public void
appendBinaryLiteral(SqlAppender appender, byte[] bytes)

Overrides org.hibernate.dialect.Dialect.appendBinaryLiteral.

Append a binary literal to the given SqlAppender.
public void
appendBooleanValueString(SqlAppender
The SqlAppender to append the literal expression to
appender, boolean
The boolean value
bool)

Overrides org.hibernate.dialect.Dialect.appendBooleanValueString.

Append the SQL literal expression representing the given boolean value to the given SqlAppender.
public void
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).
public void
appendDateTimeLiteral(SqlAppender appender, TemporalAccessor temporalAccessor, TemporalType precision, TimeZone jdbcTimeZone)

Overrides org.hibernate.dialect.Dialect.appendDateTimeLiteral.

Append a datetime literal representing the given java.time value to the given SqlAppender.
public void
appendDateTimeLiteral(SqlAppender appender, Date date, TemporalType precision, TimeZone jdbcTimeZone)

Overrides org.hibernate.dialect.Dialect.appendDateTimeLiteral.

Append a datetime literal representing the given Date value to the given SqlAppender.
public void
appendDateTimeLiteral(SqlAppender appender, Calendar calendar, TemporalType precision, TimeZone jdbcTimeZone)

Overrides org.hibernate.dialect.Dialect.appendDateTimeLiteral.

Append a datetime literal representing the given Calendar value to the given SqlAppender.
public void
appendIntervalLiteral(SqlAppender appender, Duration literal)

Overrides org.hibernate.dialect.Dialect.appendIntervalLiteral.

Append a literal SQL interval representing the given Java Duration.
public void
appendLiteral(SqlAppender appender, String literal)

Overrides org.hibernate.dialect.Dialect.appendLiteral.

Append a literal string to the given SqlAppender.
public String
appendLockHint(LockOptions
The lock options to apply
lockOptions, String
The name of the table to which to apply the lock hint.
tableName)

Overrides org.hibernate.dialect.Dialect.appendLockHint.

Some dialects support an alternative means to SELECT FOR UPDATE, whereby a "lock hint" is appended to the table name in the from clause.
public void
appendUUIDLiteral(SqlAppender appender, UUID literal)

Overrides org.hibernate.dialect.Dialect.appendUUIDLiteral.

Append a literal SQL uuid representing the given Java UUID.
public String
applyLocksToSql(String
the SQL string to modify
sql, LockOptions
lock options indexed by aliased table names.
aliasedLockOptions, Map<String, String[]>
a map of key columns indexed by aliased table names.
keyColumnNames)

Overrides org.hibernate.dialect.Dialect.applyLocksToSql.

Modifies the given SQL, applying the appropriate updates for the specified lock modes and key columns.
public void
augmentPhysicalTableTypes(List<String> tableTypesList)

Overrides org.hibernate.dialect.Dialect.augmentPhysicalTableTypes.

public void
augmentRecognizedTableTypes(List<String> tableTypesList)

Overrides org.hibernate.dialect.Dialect.augmentRecognizedTableTypes.

public IdentifierHelper
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.
public SQLExceptionConversionDelegate
buildSQLExceptionConversionDelegate()

Overrides org.hibernate.dialect.Dialect.buildSQLExceptionConversionDelegate.

An instance of SQLExceptionConversionDelegate for interpreting dialect-specific error or SQLState codes.
public boolean
canBatchTruncate()

Overrides org.hibernate.dialect.Dialect.canBatchTruncate.

Does the truncate table statement accept multiple tables?
public boolean
canCreateCatalog()

Overrides org.hibernate.dialect.Dialect.canCreateCatalog.

Does this dialect support creating and dropping catalogs?
public boolean
canCreateSchema()

Overrides org.hibernate.dialect.Dialect.canCreateSchema.

Does this dialect support creating and dropping schema?
public boolean
canDisableConstraints()

Overrides org.hibernate.dialect.Dialect.canDisableConstraints.

Is there some way to disable foreign key constraint checking while truncating tables?
public String
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.

Obtain a pattern for the SQL equivalent to a cast() function call.
public String
castType(int
The JDBC type code representing the target type
sqlTypeCode)

Overrides org.hibernate.dialect.Dialect.castType.

The SQL type to use in cast( ...
protected final void
checkVersion()

Overrides org.hibernate.dialect.Dialect.checkVersion.

public char
closeQuote()

Overrides org.hibernate.dialect.Dialect.closeQuote.

The character specific to this dialect used to close a quoted identifier.
public String
columnType(int
a SQL type code
sqlTypeCode)

Overrides org.hibernate.dialect.Dialect.columnType.

The database column type name for a given JDBC type code defined in Types or SqlTypes.
public void
contribute(TypeContributions
The callback for adding contributed types
typeContributions, ServiceRegistry
The service registry
serviceRegistry)

Overrides org.hibernate.dialect.Dialect.contribute.

Implements org.hibernate.boot.model.TypeContributor.contribute.

Contribute types
public void
contributeFunctions(FunctionContributions
The target for the contributions
functionContributions)

Overrides org.hibernate.dialect.Dialect.contributeFunctions.

Implements org.hibernate.boot.model.FunctionContributor.contributeFunctions.

Contribute functions
public void
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.
public MutationOperation
createOptionalTableUpdateOperation(EntityMutationTarget mutationTarget, OptionalTableUpdate optionalTableUpdate, SessionFactoryImplementor factory)

Overrides org.hibernate.dialect.Dialect.createOptionalTableUpdateOperation.

Deprecated as a consequence of SessionFactoryImplementor being deprecated.
Create a MutationOperation for a updating an optional table
public String
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.
public String
currentLocalTime()

Overrides org.hibernate.dialect.Dialect.currentLocalTime.

Translation of the HQL local_time function, which maps to the Java type java.time.LocalTime which is a time with no time zone.
public String
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.
public String
currentTime()

Overrides org.hibernate.dialect.Dialect.currentTime.

Translation of the HQL/JPQL current_time function, which maps to the Java type java.sql.Time which is a time with no time zone.
public String
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.
public String
currentTimestampWithTimeZone()

Overrides org.hibernate.dialect.Dialect.currentTimestampWithTimeZone.

Translation of the HQL offset_datetime function, which maps to the Java type java.time.OffsetDateTime which is a datetime with a time zone.
public ScrollMode
defaultScrollMode()

Overrides org.hibernate.dialect.Dialect.defaultScrollMode.

A default ScrollMode to be used by Query#scroll().
public boolean
doesReadCommittedCauseWritersToBlockReaders()

Overrides org.hibernate.dialect.Dialect.doesReadCommittedCauseWritersToBlockReaders.

For the underlying database, is READ_COMMITTED isolation implemented by forcing readers to wait for write locks to be released?
public boolean
doesRepeatableReadCauseReadersToBlockWriters()

Overrides org.hibernate.dialect.Dialect.doesRepeatableReadCauseReadersToBlockWriters.

For the underlying database, is REPEATABLE_READ isolation implemented by forcing writers to wait for read locks to be released?
public boolean
dropConstraints()

Overrides org.hibernate.dialect.Dialect.dropConstraints.

Do we need to drop constraints before dropping tables in this dialect?
public boolean
equivalentTypes(int
the first column type info
typeCode1, int
the second column type info
typeCode2)

Overrides org.hibernate.dialect.Dialect.equivalentTypes.

Do the given JDBC type codes, as defined in Types represent essentially the same type in this dialect of SQL?
public static String
escapeComment(String comment)

Hides org.hibernate.dialect.Dialect.escapeComment.

Perform necessary character escaping on the text of the comment.
public String
extractPattern(TemporalUnit
the first argument
unit)

Overrides org.hibernate.dialect.Dialect.extractPattern.

Obtain a pattern for the SQL equivalent to an extract() function call.
public static Dialect

Returns:

a Dialect implementation which is not a DialectDelegateWrapper; could be the same as the argument.
extractRealDialect(Dialect
the Dialect to unwrap
dialect)

Extract the wrapped dialect, recursively until a non-wrapped implementation is found; this is useful for all the code needing to know "of which type" the underlying implementation actually is.

public boolean
forceLobAsLastValue()

Overrides org.hibernate.dialect.Dialect.forceLobAsLastValue.

Must LOB values occur last in inserts and updates?
public String
generatedAs(String
a SQL expression used to generate the column value
generatedAs)

Overrides org.hibernate.dialect.Dialect.generatedAs.

The generated as clause, or similar, for generated column declarations in DDL statements.
public String
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.
public String
getAddColumnSuffixString()

Overrides org.hibernate.dialect.Dialect.getAddColumnSuffixString.

The syntax for the suffix used to add a column to a table.
public String
getAddForeignKeyConstraintString(String
The foreign key constraint name
constraintName, String[]
The names of the columns comprising the foreign key
foreignKey, String
The table referenced by the foreign key
referencedTable, String[]
The explicit columns in the referencedTable referenced by this foreign key.
primaryKey, boolean
if false, constraint should be explicit about which column names the constraint refers to
referencesPrimaryKey)

Overrides org.hibernate.dialect.Dialect.getAddForeignKeyConstraintString.

The syntax used to add a foreign key constraint to a table, with the referenced key columns explicitly specified.
public String
getAddForeignKeyConstraintString(String
The foreign key constraint name
constraintName, String
The whole definition of the foreign key as a fragment
foreignKeyDefinition)

Overrides org.hibernate.dialect.Dialect.getAddForeignKeyConstraintString.

The syntax used to add a foreign key constraint to a table, given the definition of the foreign key as a string.
public String
getAddPrimaryKeyConstraintString(String
The name of the PK constraint.
constraintName)

Overrides org.hibernate.dialect.Dialect.getAddPrimaryKeyConstraintString.

The syntax used to add a primary key constraint to a table.
public AggregateSupport
getAggregateSupport()

Overrides org.hibernate.dialect.Dialect.getAggregateSupport.

How does this dialect support aggregate types like SqlTypes#STRUCT.
public String
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.
public String
getAlterTableString(String
The name of the table to alter
tableName)

Overrides org.hibernate.dialect.Dialect.getAlterTableString.

The command used to alter a table with the given name, usually alter table tab_name or alter table tab_name if exists.
public String
getArrayTypeName(String javaElementTypeName, String elementTypeName, Integer maxLength)

Overrides org.hibernate.dialect.Dialect.getArrayTypeName.

The SQL type name for the array type with elements of the given type name.
public Exporter<AuxiliaryDatabaseObject>
getAuxiliaryDatabaseObjectExporter()

Overrides org.hibernate.dialect.Dialect.getAuxiliaryDatabaseObjectExporter.

Get an Exporter for AuxiliaryDatabaseObjects, usually StandardAuxiliaryDatabaseObjectExporter.
public MultiKeyLoadSizingStrategy
getBatchLoadSizingStrategy()

Overrides org.hibernate.dialect.Dialect.getBatchLoadSizingStrategy.

The strategy used to determine the appropriate number of keys to load in a single SQL query with batch-fetch loading.
public CallableStatementSupport
getCallableStatementSupport()

Overrides org.hibernate.dialect.Dialect.getCallableStatementSupport.

The CallableStatementSupport for this database.
public String
getCascadeConstraintsString()

Overrides org.hibernate.dialect.Dialect.getCascadeConstraintsString.

The keyword that specifies that a drop table operation should be cascaded to its constraints, typically " cascade" where the leading space is required, or the empty string if there is no such keyword in this dialect.
public String
getCaseInsensitiveLike()

Overrides org.hibernate.dialect.Dialect.getCaseInsensitiveLike.

The name of the SQL operator that performs case-insensitive LIKE comparisons.
public String
getCheckCondition(String columnName, String[] values)

Overrides org.hibernate.dialect.Dialect.getCheckCondition.

Render a SQL check condition for a column that represents an enumerated value by its string representation.
public String
getCheckCondition(String columnName, long min, long max)

Overrides org.hibernate.dialect.Dialect.getCheckCondition.

Render a SQL check condition for a column that represents an enumerated value.
public ColumnAliasExtractor
getColumnAliasExtractor()

Overrides org.hibernate.dialect.Dialect.getColumnAliasExtractor.

A ColumnAliasExtractor, usually just ResultSetMetaData#getColumnLabel.
public String
getColumnComment(String
The comment to apply
comment)

Overrides org.hibernate.dialect.Dialect.getColumnComment.

Get the comment into a form supported for column definition.
public String[]
getCreateCatalogCommand(String
The name of the catalog to be created.
catalogName)

Overrides org.hibernate.dialect.Dialect.getCreateCatalogCommand.

Get the SQL command used to create the named catalog.
public String
getCreateIndexString(boolean
true if the index is a unique index
unique)

Overrides org.hibernate.dialect.Dialect.getCreateIndexString.

The command used to create an index, usually create index or create unique index.
public String
getCreateIndexTail(boolean unique, List<Column> columns)

Overrides org.hibernate.dialect.Dialect.getCreateIndexTail.

A string to be appended to the end of the create index command, usually to specify that null values are to be considered distinct.
public String
getCreateMultisetTableString()

Overrides org.hibernate.dialect.Dialect.getCreateMultisetTableString.

Slight variation on getCreateTableString.
public String[]
getCreateSchemaCommand(String
The name of the schema to be created.
schemaName)

Overrides org.hibernate.dialect.Dialect.getCreateSchemaCommand.

Get the SQL command used to create the named schema.
public String
getCreateTableString()

Overrides org.hibernate.dialect.Dialect.getCreateTableString.

The command used to create a table, usually create table.
public String
getCreateTemporaryTableColumnAnnotation(int
The SQL type code
sqlTypeCode)

Overrides org.hibernate.dialect.Dialect.getCreateTemporaryTableColumnAnnotation.

Annotation to be appended to the end of each COLUMN clause for temporary tables.
public String
getCreateUserDefinedTypeExtensionsString()

Overrides org.hibernate.dialect.Dialect.getCreateUserDefinedTypeExtensionsString.

An arbitrary extension to append to the end of the UDT create type command.
public String
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.
public String
getCurrentSchemaCommand()

Overrides org.hibernate.dialect.Dialect.getCurrentSchemaCommand.

Get the SQL command used to retrieve the current schema name.
public String
getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSelectString.

The command used to retrieve the current timestamp from the database.
public int
getDefaultDecimalPrecision()

Overrides org.hibernate.dialect.Dialect.getDefaultDecimalPrecision.

This is the default precision for a generated column mapped to a java.math.BigInteger or java.math.BigDecimal.
public long
getDefaultLobLength()

Overrides org.hibernate.dialect.Dialect.getDefaultLobLength.

The default length for a LOB column, if LOB columns have a length in this dialect.
public boolean
getDefaultNonContextualLobCreation()

Overrides org.hibernate.dialect.Dialect.getDefaultNonContextualLobCreation.

The default value to use for the configuration property hibernate.jdbc.lob.non_contextual_creation.
public Properties
getDefaultProperties()

Overrides org.hibernate.dialect.Dialect.getDefaultProperties.

Retrieve a set of default Hibernate properties for this database.
public int
getDefaultStatementBatchSize()

Overrides org.hibernate.dialect.Dialect.getDefaultStatementBatchSize.

The default value to use for the configuration property hibernate.jdbc.batch_size.
public int
getDefaultTimestampPrecision()

Overrides org.hibernate.dialect.Dialect.getDefaultTimestampPrecision.

This is the default precision for a generated column mapped to a Timestamp or java.time.LocalDateTime.
public boolean
getDefaultUseGetGeneratedKeys()

Overrides org.hibernate.dialect.Dialect.getDefaultUseGetGeneratedKeys.

The default value to use for the configuration property hibernate.jdbc.use_get_generated_keys.
public String
getDisableConstraintsStatement()

Overrides org.hibernate.dialect.Dialect.getDisableConstraintsStatement.

A SQL statement that temporarily disables foreign key constraint checking for all tables.
public String
getDisableConstraintStatement(String
the name of the table
tableName, String
the name of the constraint
name)

Overrides org.hibernate.dialect.Dialect.getDisableConstraintStatement.

A SQL statement that temporarily disables checking of the given foreign key constraint.
public int
getDoublePrecision()

Overrides org.hibernate.dialect.Dialect.getDoublePrecision.

This is the default precision for a generated column mapped to a Java Double or double.
public String[]
getDropCatalogCommand(String
The name of the catalog to be dropped.
catalogName)

Overrides org.hibernate.dialect.Dialect.getDropCatalogCommand.

Get the SQL command used to drop the named catalog.
public String
getDropForeignKeyString()

Overrides org.hibernate.dialect.Dialect.getDropForeignKeyString.

The subcommand of the alter table command used to drop a foreign key constraint, usually drop constraint.
public String[]
getDropSchemaCommand(String
The name of the schema to be dropped.
schemaName)

Overrides org.hibernate.dialect.Dialect.getDropSchemaCommand.

Get the SQL command used to drop the named schema.
public String
getDropTableString(String
The name of the table to drop
tableName)

Overrides org.hibernate.dialect.Dialect.getDropTableString.

The command used to drop a table with the given name, usually drop table tab_name.
public String
getDropUniqueKeyString()

Overrides org.hibernate.dialect.Dialect.getDropUniqueKeyString.

The subcommand of the alter table command used to drop a unique key constraint.
public String
getEnableConstraintsStatement()

Overrides org.hibernate.dialect.Dialect.getEnableConstraintsStatement.

A SQL statement that re-enables foreign key constraint checking for all tables.
public String
getEnableConstraintStatement(String
the name of the table
tableName, String
the name of the constraint
name)

Overrides org.hibernate.dialect.Dialect.getEnableConstraintStatement.

A SQL statement that re-enables checking of the given foreign key constraint.
public String
getEnumTypeDeclaration(String name, String[]
the enumerated values of the type
values)

Overrides org.hibernate.dialect.Dialect.getEnumTypeDeclaration.

If this database has a special MySQL-style enum column type, return the type declaration for the given enumeration of values.
public SchemaManagementTool
getFallbackSchemaManagementTool(Map<String, Object> configurationValues, ServiceRegistryImplementor registry)

Overrides org.hibernate.dialect.Dialect.getFallbackSchemaManagementTool.

The SchemaManagementTool to use if none is explicitly specified.
public SqmMultiTableInsertStrategy
getFallbackSqmInsertStrategy(EntityMappingType entityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)

Overrides org.hibernate.dialect.Dialect.getFallbackSqmInsertStrategy.

Deprecated as a consequence of RuntimeModelCreationContext being deprecated.
The SqmMultiTableInsertStrategy to use when not specified by org.hibernate.query.spi.QueryEngineOptions#getCustomSqmMultiTableInsertStrategy.
public SqmMultiTableMutationStrategy
getFallbackSqmMutationStrategy(EntityMappingType entityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)

Overrides org.hibernate.dialect.Dialect.getFallbackSqmMutationStrategy.

Deprecated as a consequence of RuntimeModelCreationContext being deprecated.
The SqmMultiTableMutationStrategy to use when not specified by org.hibernate.query.spi.QueryEngineOptions#getCustomSqmMultiTableMutationStrategy.
public int
getFloatPrecision()

Overrides org.hibernate.dialect.Dialect.getFloatPrecision.

This is the default precision for a generated column mapped to a Java Float or float.
public Exporter<ForeignKey>
getForeignKeyExporter()

Overrides org.hibernate.dialect.Dialect.getForeignKeyExporter.

Get an Exporter for ForeignKeys, usually StandardForeignKeyExporter.
public String
getForUpdateNowaitString()

Overrides org.hibernate.dialect.Dialect.getForUpdateNowaitString.

Retrieves the FOR UPDATE NOWAIT syntax specific to this dialect.
public String
getForUpdateNowaitString(String
The columns to be write locked.
aliases)

Overrides org.hibernate.dialect.Dialect.getForUpdateNowaitString.

Get the FOR UPDATE OF column_list NOWAIT fragment appropriate for this dialect, given the aliases of the columns to be write locked.
public String
getForUpdateSkipLockedString()

Overrides org.hibernate.dialect.Dialect.getForUpdateSkipLockedString.

Retrieves the FOR UPDATE SKIP LOCKED syntax specific to this dialect.
public String
getForUpdateSkipLockedString(String
The columns to be write locked.
aliases)

Overrides org.hibernate.dialect.Dialect.getForUpdateSkipLockedString.

Get the FOR UPDATE OF column_list SKIP LOCKED fragment appropriate for this dialect, given the aliases of the columns to be write locked.
public String
getForUpdateString(LockOptions
contains the lock mode to apply.
lockOptions)

Overrides org.hibernate.dialect.Dialect.getForUpdateString.

Given a set of LockOptions (lock level, timeout), determine the appropriate for update fragment to use to obtain the lock.
public String
getForUpdateString(LockMode
The lock mode to apply.
lockMode)

Overrides org.hibernate.dialect.Dialect.getForUpdateString.

Given a LockMode, determine the appropriate for update fragment to use to obtain the lock.
public String
getForUpdateString()

Overrides org.hibernate.dialect.Dialect.getForUpdateString.

Get the string to append to SELECT statements to acquire pessimistic UPGRADE locks for this dialect.
public String
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.
public String
getForUpdateString(String
The columns to be locked.
aliases, LockOptions
the lock options to apply
lockOptions)

Overrides org.hibernate.dialect.Dialect.getForUpdateString.

Get the FOR UPDATE OF or FOR SHARE OF fragment appropriate for this dialect, given the aliases of the columns to be locked.
public long
getFractionalSecondPrecisionInNanos()

Overrides org.hibernate.dialect.Dialect.getFractionalSecondPrecisionInNanos.

The "native" precision for arithmetic with datetimes and day-to-second durations.
public SelectItemReferenceStrategy
getGroupBySelectItemReferenceStrategy()

Overrides org.hibernate.dialect.Dialect.getGroupBySelectItemReferenceStrategy.

Determine how selected items are referenced in the group by clause.
public HqlTranslator
getHqlTranslator()

Overrides org.hibernate.dialect.Dialect.getHqlTranslator.

Return an HqlTranslator specific to this dialect, or null to use the standard translator.
public IdentityColumnSupport
getIdentityColumnSupport()

Overrides org.hibernate.dialect.Dialect.getIdentityColumnSupport.

Get the appropriate IdentityColumnSupport for this dialect.
public Exporter<Index>
getIndexExporter()

Overrides org.hibernate.dialect.Dialect.getIndexExporter.

Get an Exporter for Indexes, usually StandardIndexExporter.
public int
getInExpressionCountLimit()

Overrides org.hibernate.dialect.Dialect.getInExpressionCountLimit.

Return the limit that the underlying database places on the number of elements in an IN predicate.
public Set<String>
getKeywords()

Overrides org.hibernate.dialect.Dialect.getKeywords.

The keywords of this SQL dialect.
public LimitHandler
getLimitHandler()

Overrides org.hibernate.dialect.Dialect.getLimitHandler.

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

Overrides org.hibernate.dialect.Dialect.getLobMergeStrategy.

Get the LobMergeStrategy to use, NEW_LOCATOR_LOB_MERGE_STRATEGY by default.
public LockingStrategy
getLockingStrategy(Lockable
The persister for the entity to be locked.
lockable, LockMode
The type of lock to be acquired.
lockMode)

Overrides org.hibernate.dialect.Dialect.getLockingStrategy.

Deprecated as a consequence of Lockable being deprecated.
A LockingStrategy which is able to acquire a database-level lock with the specified level.
public RowLockStrategy
getLockRowIdentifier(LockMode lockMode)

Overrides org.hibernate.dialect.Dialect.getLockRowIdentifier.

Obtain a RowLockStrategy for the given LockMode.
public String
getLowercaseFunction()

Overrides org.hibernate.dialect.Dialect.getLowercaseFunction.

The name of the SQL function that transforms a string to lowercase, almost always lower.
public int
getMaxAliasLength()

Overrides org.hibernate.dialect.Dialect.getMaxAliasLength.

What is the maximum length Hibernate can use for generated aliases?
public int
getMaxIdentifierLength()

Overrides org.hibernate.dialect.Dialect.getMaxIdentifierLength.

What is the maximum identifier length supported by this dialect?
public int
getMaxNVarcharCapacity()

Overrides org.hibernate.dialect.Dialect.getMaxNVarcharCapacity.

The longest possible length of a java.sql.Types#NVARCHAR-like column.
public int
getMaxNVarcharLength()

Overrides org.hibernate.dialect.Dialect.getMaxNVarcharLength.

The biggest size value that can be supplied as argument to a java.sql.Types#NVARCHAR-like type.
public int
getMaxVarbinaryCapacity()

Overrides org.hibernate.dialect.Dialect.getMaxVarbinaryCapacity.

The longest possible length of a java.sql.Types#VARBINARY-like column.
public int
getMaxVarbinaryLength()

Overrides org.hibernate.dialect.Dialect.getMaxVarbinaryLength.

The biggest size value that can be supplied as argument to a java.sql.Types#VARBINARY-like type.
public int
getMaxVarcharCapacity()

Overrides org.hibernate.dialect.Dialect.getMaxVarcharCapacity.

The longest possible length of a java.sql.Types#VARCHAR-like column.
public int
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.
public DatabaseVersion
getMinimumSupportedVersion()

Overrides org.hibernate.dialect.Dialect.getMinimumSupportedVersion.

Get the version of the SQL dialect that is the minimum supported by this implementation.
public MultiKeyLoadSizingStrategy
getMultiKeyLoadSizingStrategy()

Overrides org.hibernate.dialect.Dialect.getMultiKeyLoadSizingStrategy.

The strategy used to determine the appropriate number of keys to load in a single SQL query with multi-key loading.
public NameQualifierSupport
getNameQualifierSupport()

Overrides org.hibernate.dialect.Dialect.getNameQualifierSupport.

The support for qualified identifiers.
public NationalizationSupport
getNationalizationSupport()

Overrides org.hibernate.dialect.Dialect.getNationalizationSupport.

Determines whether this database requires the use of explicitly nationalized character (Unicode) data types.
public String
getNativeIdentifierGeneratorStrategy()

Overrides org.hibernate.dialect.Dialect.getNativeIdentifierGeneratorStrategy.

The name identifying the "native" id generation strategy for this dialect.
public ParameterMarkerStrategy
getNativeParameterMarkerStrategy()

Overrides org.hibernate.dialect.Dialect.getNativeParameterMarkerStrategy.

Support for native parameter markers.
public String
getNoColumnsInsertString()

Overrides org.hibernate.dialect.Dialect.getNoColumnsInsertString.

Deprecated since 6.
The fragment used to insert a row without specifying any column values, usually just (), but sometimes default values.
public String
getNullColumnString()

Overrides org.hibernate.dialect.Dialect.getNullColumnString.

The keyword used to specify a nullable column, usually "", but sometimes " null".
public String
getNullColumnString(String columnType)

Overrides org.hibernate.dialect.Dialect.getNullColumnString.

The keyword used to specify a nullable column of the given SQL type.
public NullOrdering
getNullOrdering()

Overrides org.hibernate.dialect.Dialect.getNullOrdering.

Returns the default ordering of null.
public int
getParameterCountLimit()

Overrides org.hibernate.dialect.Dialect.getParameterCountLimit.

Return the limit that the underlying database places on the number of parameters that can be defined for a PreparedStatement.
public int
getPreferredSqlTypeCodeForArray()

Overrides org.hibernate.dialect.Dialect.getPreferredSqlTypeCodeForArray.

The JDBC type code to use for mapping properties of basic Java array or Collection types.
public int
getPreferredSqlTypeCodeForBoolean()

Overrides org.hibernate.dialect.Dialect.getPreferredSqlTypeCodeForBoolean.

The JDBC type code to use for mapping properties of Java type boolean.
public String
getQueryHintString(String
The query to which to apply the hint.
query, List<String>
The hints to apply
hintList)

Overrides org.hibernate.dialect.Dialect.getQueryHintString.

Apply a hint to the given SQL query.
public String
getQueryHintString(String
The query to which to apply the hint.
query, String
The hints to apply
hints)

Overrides org.hibernate.dialect.Dialect.getQueryHintString.

Apply a hint to the given SQL query.
public String
getQuerySequencesString()

Overrides org.hibernate.dialect.Dialect.getQuerySequencesString.

Get the select command used retrieve the names of all sequences.
public String
getReadLockString(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.
public String
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.
public RowLockStrategy
getReadRowLockStrategy()

Overrides org.hibernate.dialect.Dialect.getReadRowLockStrategy.

The row lock strategy to use for read locks.
public ResultSet
getResultSet(CallableStatement
The callable statement.
statement)

Overrides org.hibernate.dialect.Dialect.getResultSet.

Given a callable statement previously processed by registerResultSetOutParameter, extract the ResultSet from the OUT parameter.
public ResultSet
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.
public ResultSet
getResultSet(CallableStatement
The callable statement.
statement, String
The parameter name (for drivers which support named parameters).
name)

Overrides org.hibernate.dialect.Dialect.getResultSet.

Given a callable statement previously processed by registerResultSetOutParameter, extract the ResultSet from the named OUT parameter.
public String
getRowIdColumnString(String rowId)

Overrides org.hibernate.dialect.Dialect.getRowIdColumnString.

If this dialect requires that the rowid column be declared explicitly, return the DDL column definition.
public SchemaNameResolver
getSchemaNameResolver()

Overrides org.hibernate.dialect.Dialect.getSchemaNameResolver.

Get the strategy for determining the schema name from a JDBC Connection, usually DefaultSchemaNameResolver.
public String
getSelectClauseNullString(int
The Types type code.
sqlType, TypeConfiguration
The type configuration
typeConfiguration)

Overrides org.hibernate.dialect.Dialect.getSelectClauseNullString.

Given a JDBC type code, return the expression for a literal null value of that type, to use in a select clause.
public String
getSelectGUIDString()

Overrides org.hibernate.dialect.Dialect.getSelectGUIDString.

Get the command used to select a GUID from the database.
public Exporter<Sequence>
getSequenceExporter()

Overrides org.hibernate.dialect.Dialect.getSequenceExporter.

Get an Exporter for Sequences, usually StandardSequenceExporter.
public SequenceInformationExtractor
getSequenceInformationExtractor()

Overrides org.hibernate.dialect.Dialect.getSequenceInformationExtractor.

A SequenceInformationExtractor which is able to extract org.hibernate.tool.schema.extract.spi.SequenceInformation from the JDBC result set returned when getQuerySequencesString() is executed.
public SequenceSupport
getSequenceSupport()

Overrides org.hibernate.dialect.Dialect.getSequenceSupport.

Get the appropriate SequenceSupport for this dialect.
public Dialect.SizeStrategy
getSizeStrategy()

Overrides org.hibernate.dialect.Dialect.getSizeStrategy.

A custom SizeStrategy for column types.
public SqlAstTranslatorFactory
getSqlAstTranslatorFactory()

Overrides org.hibernate.dialect.Dialect.getSqlAstTranslatorFactory.

Return a SqlAstTranslatorFactory specific to this dialect, or null to use the standard translator.
public SqmTranslatorFactory
getSqmTranslatorFactory()

Overrides org.hibernate.dialect.Dialect.getSqmTranslatorFactory.

Return a SqmTranslatorFactory specific to this dialect, or null to use the standard translator.
public TemporaryTableKind
getSupportedTemporaryTableKind()

Overrides org.hibernate.dialect.Dialect.getSupportedTemporaryTableKind.

The kind of temporary tables that are supported on this database.
public Cleaner
getTableCleaner()

Overrides org.hibernate.dialect.Dialect.getTableCleaner.

Get a schema Cleaner, usually StandardTableCleaner.
public String
getTableComment(String
The comment to apply
comment)

Overrides org.hibernate.dialect.Dialect.getTableComment.

Get the comment into a form supported for table definition.
public Exporter<Table>
getTableExporter()

Overrides org.hibernate.dialect.Dialect.getTableExporter.

Get an Exporter for Tables, usually StandardTableExporter.
public TableMigrator
getTableMigrator()

Overrides org.hibernate.dialect.Dialect.getTableMigrator.

Get a TableMigrator, usually StandardTableMigrator.
public String
getTableTypeString()

Overrides org.hibernate.dialect.Dialect.getTableTypeString.

An arbitrary fragment appended to the end of the create table statement.
public AfterUseAction
getTemporaryTableAfterUseAction()

Overrides org.hibernate.dialect.Dialect.getTemporaryTableAfterUseAction.

The action to take after finishing use of a temporary table.
public BeforeUseAction
getTemporaryTableBeforeUseAction()

Overrides org.hibernate.dialect.Dialect.getTemporaryTableBeforeUseAction.

The action to take before beginning use of a temporary table.
public String
getTemporaryTableCreateCommand()

Overrides org.hibernate.dialect.Dialect.getTemporaryTableCreateCommand.

The command to create a temporary table.
public String
getTemporaryTableCreateOptions()

Overrides org.hibernate.dialect.Dialect.getTemporaryTableCreateOptions.

An arbitrary SQL fragment appended to the end of the statement to create a temporary table, specifying dialect-specific options, or null if there are no options to specify.
public TempTableDdlTransactionHandling
getTemporaryTableDdlTransactionHandling()

Overrides org.hibernate.dialect.Dialect.getTemporaryTableDdlTransactionHandling.

The sort of transaction handling to use when creating or dropping temporary tables.
public String
getTemporaryTableDropCommand()

Overrides org.hibernate.dialect.Dialect.getTemporaryTableDropCommand.

The command to drop a temporary table.
public TemporaryTableExporter
getTemporaryTableExporter()

Overrides org.hibernate.dialect.Dialect.getTemporaryTableExporter.

Get a TemporaryTableExporter, usually StandardTemporaryTableExporter.
public String
getTemporaryTableTruncateCommand()

Overrides org.hibernate.dialect.Dialect.getTemporaryTableTruncateCommand.

The command to truncate a temporary table.
public TimeZoneSupport
getTimeZoneSupport()

Overrides org.hibernate.dialect.Dialect.getTimeZoneSupport.

How the dialect supports time zone types like Types#TIMESTAMP_WITH_TIMEZONE.
public String
getTruncateTableStatement(String
the name of the table
tableName)

Overrides org.hibernate.dialect.Dialect.getTruncateTableStatement.

A SQL statement that truncates the given table.
public String[]
getTruncateTableStatements(String[]
the names of the tables
tableNames)

Overrides org.hibernate.dialect.Dialect.getTruncateTableStatements.

A SQL statement or statements that truncate the given tables.
public UniqueDelegate
getUniqueDelegate()

Overrides org.hibernate.dialect.Dialect.getUniqueDelegate.

Get the UniqueDelegate supported by this dialect
public Exporter<Constraint>
getUniqueKeyExporter()

Overrides org.hibernate.dialect.Dialect.getUniqueKeyExporter.

Get an Exporter for unique key Constraints, usually StandardUniqueKeyExporter.
public String
getUserDefinedTypeComment(String
The comment to apply
comment)

Overrides org.hibernate.dialect.Dialect.getUserDefinedTypeComment.

Get the comment into a form supported for UDT definition.
public Exporter<UserDefinedType>
getUserDefinedTypeExporter()

Overrides org.hibernate.dialect.Dialect.getUserDefinedTypeExporter.

Get an Exporter for UserDefinedTypes, usually StandardUserDefinedTypeExporter.
public DatabaseVersion
getVersion()

Overrides org.hibernate.dialect.Dialect.getVersion.

Get the version of the SQL dialect that is the target of this instance.
public ViolatedConstraintNameExtractor
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.
public Dialect

Returns:

the wrapped Dialect
getWrappedDialect()

Exposed so to allow code needing to know the implementation.

public String
getWriteLockString(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 pessimistic WRITE locks for this dialect.
public String
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.
public RowLockStrategy
getWriteRowLockStrategy()

Overrides org.hibernate.dialect.Dialect.getWriteRowLockStrategy.

The row lock strategy to use for write locks.
public boolean
hasAlterTable()

Overrides org.hibernate.dialect.Dialect.hasAlterTable.

Does this dialect support the ALTER TABLE syntax?
public boolean
hasDataTypeBeforeGeneratedAs()

Overrides org.hibernate.dialect.Dialect.hasDataTypeBeforeGeneratedAs.

Is an explicit column type required for generated as columns?
public boolean
hasSelfReferentialForeignKeyBug()

Overrides org.hibernate.dialect.Dialect.hasSelfReferentialForeignKeyBug.

Does the database/driver have bug in deleting rows that refer to other rows being deleted in the same query?
protected final void
initDefaultProperties()

Overrides org.hibernate.dialect.Dialect.initDefaultProperties.

Set appropriate default values for configuration properties.
public void
initializeFunctionRegistry(FunctionContributions functionContributions)

Overrides org.hibernate.dialect.Dialect.initializeFunctionRegistry.

Initialize the given registry with any dialect-specific functions.
public String
inlineLiteral(String literal)

Overrides org.hibernate.dialect.Dialect.inlineLiteral.

Deprecated for removal since 6.
public boolean
isAnsiNullOn()

Overrides org.hibernate.dialect.Dialect.isAnsiNullOn.

Deprecated since 6.
A setting specific to SybaseASEDialect.
public boolean
isCurrentTimestampSelectStringCallable()

Overrides org.hibernate.dialect.Dialect.isCurrentTimestampSelectStringCallable.

Is the command returned by getCurrentTimestampSelectString treated as callable?
public boolean
isEmptyStringTreatedAsNull()

Overrides org.hibernate.dialect.Dialect.isEmptyStringTreatedAsNull.

Return whether the dialect considers an empty string value to be null.
public boolean
isJdbcLogWarningsEnabledByDefault()

Overrides org.hibernate.dialect.Dialect.isJdbcLogWarningsEnabledByDefault.

Is JDBC statement warning logging enabled by default?
public boolean
isLockTimeoutParameterized()

Overrides org.hibernate.dialect.Dialect.isLockTimeoutParameterized.

Deprecated for removal since 6.
If this dialect supports specifying lock timeouts, are those timeouts rendered into the SQL string as parameters?
public char
openQuote()

Overrides org.hibernate.dialect.Dialect.openQuote.

The character specific to this dialect used to begin a quoted identifier.
public int
ordinal()

Overrides org.hibernate.dialect.Dialect.ordinal.

Overrides default org.hibernate.boot.model.FunctionContributor.ordinal.

Determines order in which the contributions will be applied (lowest ordinal first).
public String
prependComment(String sql, String comment)

Overrides org.hibernate.dialect.Dialect.prependComment.

Prepend a comment to the given SQL fragment.
public boolean
qualifyIndexName()

Overrides org.hibernate.dialect.Dialect.qualifyIndexName.

Do we need to qualify index names with the schema name?
public String
quote(String
The value to be quoted.
name)

Overrides org.hibernate.dialect.Dialect.quote.

Apply dialect-specific quoting if the given name is quoted using backticks.
public void
registerColumnTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)

Overrides org.hibernate.dialect.Dialect.registerColumnTypes.

Register ANSI-standard column types using the length limits defined by getMaxVarcharLength(), getMaxNVarcharLength(), and getMaxVarbinaryLength().
protected final void
registerDefaultKeywords()

Overrides org.hibernate.dialect.Dialect.registerDefaultKeywords.

Register the reserved words of ANSI-standard SQL as keywords.
public void
registerKeyword(String
a reserved word in this SQL dialect
word)

Overrides org.hibernate.dialect.Dialect.registerKeyword.

Register a keyword.
public void
registerKeywords(DialectResolutionInfo info)

Overrides org.hibernate.dialect.Dialect.registerKeywords.

Register the reserved words reported by the JDBC driver as keywords.
public int
registerResultSetOutParameter(CallableStatement
The callable statement.
statement, int
The bind position at which to register the output param.
position)

Overrides org.hibernate.dialect.Dialect.registerResultSetOutParameter.

Registers a parameter capable of returning a ResultSet by position, either an OUT parameter, or a REF_CURSOR parameter as defined in Java 8.
public int
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.
public boolean
requiresCastForConcatenatingNonStrings()

Overrides org.hibernate.dialect.Dialect.requiresCastForConcatenatingNonStrings.

Does this dialect/database require casting of non-string arguments in the concat() function?
public boolean
requiresFloatCastingOfIntegerDivision()

Overrides org.hibernate.dialect.Dialect.requiresFloatCastingOfIntegerDivision.

Does this dialect require that integer divisions be wrapped in cast() calls to tell the db parser the expected type.
public boolean
requiresParensForTupleCounts()

Overrides org.hibernate.dialect.Dialect.requiresParensForTupleCounts.

If supportsTupleCounts() is true, does this dialect require the tuple to be delimited with parentheses?
public boolean
requiresParensForTupleDistinctCounts()

Overrides org.hibernate.dialect.Dialect.requiresParensForTupleDistinctCounts.

If supportsTupleDistinctCounts() is true, does this dialect require the tuple to be delimited with parentheses?
public Integer
resolveSqlTypeCode(String columnTypeName, TypeConfiguration typeConfiguration)

Overrides org.hibernate.dialect.Dialect.resolveSqlTypeCode.

Resolves the SqlTypes type code for the given column type name as reported by the database, or null if it can't be resolved.
public Integer
resolveSqlTypeCode(String typeName, String baseTypeName, TypeConfiguration typeConfiguration)

Overrides org.hibernate.dialect.Dialect.resolveSqlTypeCode.

Resolves the SqlTypes type code for the given column type name as reported by the database and the base type name (i.e. without precision, length and scale), or null if it can't be resolved.
public JdbcType
resolveSqlTypeDescriptor(String
the column type name
columnTypeName, int
the type code
jdbcTypeCode, int
the precision or 0
precision, int
the scale or 0
scale, JdbcTypeRegistry jdbcTypeRegistry)

Overrides org.hibernate.dialect.Dialect.resolveSqlTypeDescriptor.

Assigns an appropriate JdbcType to a column of a JDBC result set based on the column type name, JDBC type code, precision, and scale.
public int
resolveSqlTypeLength(String
the name of the column type
columnTypeName, int
the JDBC type code of the column type
jdbcTypeCode, int
the (numeric) precision or (character) length of the column
precision, int
the scale of a numeric column
scale, int
the display size of the column
displaySize)

Overrides org.hibernate.dialect.Dialect.resolveSqlTypeLength.

Determine the length/precision of a column based on information in the JDBC java.sql.ResultSetMetaData.
public String
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.
public int
rowIdSqlType()

Overrides org.hibernate.dialect.Dialect.rowIdSqlType.

The JDBC type code of the rowid-like pseudo-column which acts as a high-performance row locator.
public boolean
supportsAlterColumnType()

Overrides org.hibernate.dialect.Dialect.supportsAlterColumnType.

Does this dialect support modifying the type of an existing column?
public boolean
supportsBindAsCallableArgument()

Overrides org.hibernate.dialect.Dialect.supportsBindAsCallableArgument.

Does this dialect support using a JDBC bind parameter as an argument to a function or procedure call?
public boolean
supportsBitType()

Overrides org.hibernate.dialect.Dialect.supportsBitType.

Does this dialect have a true SQL BIT type with just two values (0 and 1) or, even better, a proper SQL BOOLEAN type, or does Types#BIT get mapped to a numeric type with more than two values?
public boolean
supportsCascadeDelete()

Overrides org.hibernate.dialect.Dialect.supportsCascadeDelete.

Does this dialect support on delete actions in foreign key definitions?
public boolean
supportsCaseInsensitiveLike()

Overrides org.hibernate.dialect.Dialect.supportsCaseInsensitiveLike.

Does this dialect support case-insensitive LIKE comparisons?
public boolean
supportsCircularCascadeDeleteConstraints()

Overrides org.hibernate.dialect.Dialect.supportsCircularCascadeDeleteConstraints.

Does this dialect support definition of cascade delete constraints which can cause circular chains?
public boolean
supportsColumnCheck()

Overrides org.hibernate.dialect.Dialect.supportsColumnCheck.

Does this dialect support column-level check constraints?
public boolean
supportsCommentOn()

Overrides org.hibernate.dialect.Dialect.supportsCommentOn.

Does this dialect support commenting on tables and columns?
public boolean
supportsCurrentTimestampSelection()

Overrides org.hibernate.dialect.Dialect.supportsCurrentTimestampSelection.

Does this dialect support some way to retrieve the current timestamp value from the database?
public boolean
supportsDistinctFromPredicate()

Overrides org.hibernate.dialect.Dialect.supportsDistinctFromPredicate.

Does this dialect support some kind of distinct from predicate?
public boolean
supportsExistsInSelect()

Overrides org.hibernate.dialect.Dialect.supportsExistsInSelect.

Does the dialect support an exists statement in the select clause?
public boolean
supportsExpectedLobUsagePattern()

Overrides org.hibernate.dialect.Dialect.supportsExpectedLobUsagePattern.

"Expected" LOB usage pattern is such that I can perform an insert via prepared statement with a parameter binding for a LOB value without crazy casting to JDBC driver implementation-specific classes.
public boolean
supportsFetchClause(FetchClauseType
The fetch clause type
type)

Overrides org.hibernate.dialect.Dialect.supportsFetchClause.

Does this dialect support the given FETCH clause type.
public boolean
supportsFractionalTimestampArithmetic()

Overrides org.hibernate.dialect.Dialect.supportsFractionalTimestampArithmetic.

Whether the database supports adding a fractional interval to a timestamp, for example timestamp + 0.5 second.
public boolean
supportsIfExistsAfterAlterTable()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsAfterAlterTable.

For an alter table, can the phrase if exists be applied?
public boolean
supportsIfExistsAfterConstraintName()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsAfterConstraintName.

For dropping a constraint with an alter table, can the phrase if exists be applied after the constraint name?
public boolean
supportsIfExistsAfterTableName()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsAfterTableName.

For dropping a table, can the phrase if exists be applied after the table name?
public boolean
supportsIfExistsAfterTypeName()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsAfterTypeName.

For dropping a type, can the phrase if exists be applied after the type name?
public boolean
supportsIfExistsBeforeConstraintName()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsBeforeConstraintName.

For dropping a constraint with an alter table statement, can the phrase if exists be applied before the constraint name?
public boolean
supportsIfExistsBeforeTableName()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsBeforeTableName.

For dropping a table, can the phrase if exists be applied before the table name?
public boolean
supportsIfExistsBeforeTypeName()

Overrides org.hibernate.dialect.Dialect.supportsIfExistsBeforeTypeName.

For dropping a type, can the phrase if exists be applied before the type name?
public boolean
supportsInsertReturning()

Overrides org.hibernate.dialect.Dialect.supportsInsertReturning.

Does this dialect fully support returning arbitrary generated column values after execution of an insert statement, using native SQL syntax?
public boolean
supportsInsertReturningGeneratedKeys()

Overrides org.hibernate.dialect.Dialect.supportsInsertReturningGeneratedKeys.

Does this dialect fully support returning arbitrary generated column values after execution of an insert statement, using the JDBC method Connection#prepareStatement(String, String[]).
public boolean
supportsJdbcConnectionLobCreation(DatabaseMetaData
JDBC DatabaseMetaData which can be used if LOB creation is supported only starting from a given driver version
databaseMetaData)

Overrides org.hibernate.dialect.Dialect.supportsJdbcConnectionLobCreation.

Check whether the JDBC Connection supports creating LOBs via Connection#createBlob(), Connection#createNClob(), or Connection#createClob().
public boolean
supportsLateral()

Overrides org.hibernate.dialect.Dialect.supportsLateral.

Does this dialect support the SQL lateral keyword or a proprietary alternative?
public boolean
supportsLobValueChangePropagation()

Overrides org.hibernate.dialect.Dialect.supportsLobValueChangePropagation.

Does the dialect support propagating changes to LOB values back to the database?
public boolean
supportsLockTimeouts()

Overrides org.hibernate.dialect.Dialect.supportsLockTimeouts.

Does this dialect support specifying timeouts when requesting locks.
public boolean
supportsMaterializedLobAccess()

Overrides org.hibernate.dialect.Dialect.supportsMaterializedLobAccess.

Check whether the JDBC driver allows setting LOBs via PreparedStatement#setBytes(int, byte[]), PreparedStatement#setNString(int, String), or PreparedStatement#setString(int, String) APIs.
public boolean
supportsNamedParameters(DatabaseMetaData databaseMetaData)

Overrides org.hibernate.dialect.Dialect.supportsNamedParameters.

Override DatabaseMetaData#supportsNamedParameters().
public boolean
supportsNoColumnsInsert()

Overrides org.hibernate.dialect.Dialect.supportsNoColumnsInsert.

Is the INSERT statement is allowed to contain no columns?
public boolean
supportsNonQueryWithCTE()

Overrides org.hibernate.dialect.Dialect.supportsNonQueryWithCTE.

Does this dialect support insert, update, and delete statements with Common Table Expressions (CTEs)?
public boolean
supportsNoWait()

Overrides org.hibernate.dialect.Dialect.supportsNoWait.

Does this dialect support NO_WAIT timeout.
public boolean
supportsNullPrecedence()

Overrides org.hibernate.dialect.Dialect.supportsNullPrecedence.

Does this dialect support nulls first and nulls last?
public boolean
supportsOffsetInSubquery()

Overrides org.hibernate.dialect.Dialect.supportsOffsetInSubquery.

Does this dialect support offset in subqueries?
public boolean
supportsOrderByInSubquery()

Overrides org.hibernate.dialect.Dialect.supportsOrderByInSubquery.

Does this dialect support the order by clause in subqueries?
public boolean
supportsOrdinalSelectItemReference()

Overrides org.hibernate.dialect.Dialect.supportsOrdinalSelectItemReference.

Does this dialect support references to result variables (i.e, select items) by column positions (1-origin) as defined by the select clause?
public boolean
supportsOuterJoinForUpdate()

Overrides org.hibernate.dialect.Dialect.supportsOuterJoinForUpdate.

Does this dialect support FOR UPDATE in conjunction with outer-joined rows?
public boolean
supportsParametersInInsertSelect()

Overrides org.hibernate.dialect.Dialect.supportsParametersInInsertSelect.

Deprecated for removal since 6.
Does this dialect support parameters within the SELECT clause of INSERT ...
public boolean
supportsPartitionBy()

Overrides org.hibernate.dialect.Dialect.supportsPartitionBy.

Does is dialect support partition by?
public boolean
supportsPredicateAsExpression()

Overrides org.hibernate.dialect.Dialect.supportsPredicateAsExpression.

Whether a predicate like a > 0 can appear in an expression context, for example, in a select list item.
public boolean
supportsRecursiveCTE()

Overrides org.hibernate.dialect.Dialect.supportsRecursiveCTE.

Does this dialect/database support recursive CTEs?
public boolean
supportsResultSetPositionQueryMethodsOnForwardOnlyCursor()

Overrides org.hibernate.dialect.Dialect.supportsResultSetPositionQueryMethodsOnForwardOnlyCursor.

Does this dialect support asking the result set its positioning information on forward-only cursors?
public boolean
supportsSkipLocked()

Overrides org.hibernate.dialect.Dialect.supportsSkipLocked.

Does this dialect support SKIP_LOCKED timeout.
public boolean
supportsStandardArrays()

Overrides org.hibernate.dialect.Dialect.supportsStandardArrays.

Does this database have native support for ANSI SQL standard arrays which are expressed in terms of the element type name: integer array.
public boolean
supportsStandardCurrentTimestampFunction()

Overrides org.hibernate.dialect.Dialect.supportsStandardCurrentTimestampFunction.

Does this dialect have an ANSI SQL current_timestamp function?
public boolean
supportsSubqueryInSelect()

Overrides org.hibernate.dialect.Dialect.supportsSubqueryInSelect.

Does this dialect support subqueries in the select clause?
public boolean
supportsSubqueryOnMutatingTable()

Overrides org.hibernate.dialect.Dialect.supportsSubqueryOnMutatingTable.

Does this dialect support referencing the table being mutated in a subquery?
public boolean
supportsSubselectAsInPredicateLHS()

Overrides org.hibernate.dialect.Dialect.supportsSubselectAsInPredicateLHS.

Is a subselect supported as the left-hand side (LHS) of an IN predicates?
public boolean
supportsTableCheck()

Overrides org.hibernate.dialect.Dialect.supportsTableCheck.

Does this dialect support table-level check constraints?
public boolean
supportsTemporalLiteralOffset()

Overrides org.hibernate.dialect.Dialect.supportsTemporalLiteralOffset.

Does this dialect supports timezone offsets in temporal literals.
public boolean
supportsTemporaryTablePrimaryKey()

Overrides org.hibernate.dialect.Dialect.supportsTemporaryTablePrimaryKey.

Does this database support primary keys for temporary tables?
public boolean
supportsTemporaryTables()

Overrides org.hibernate.dialect.Dialect.supportsTemporaryTables.

Does this database have some sort of support for temporary tables?
public boolean
supportsTruncateWithCast()

Overrides org.hibernate.dialect.Dialect.supportsTruncateWithCast.

Does this dialect support truncation of values to a specified length via a cast?
public boolean
supportsTupleCounts()

Overrides org.hibernate.dialect.Dialect.supportsTupleCounts.

Does this dialect support count(a,b)?
public boolean
supportsTupleDistinctCounts()

Overrides org.hibernate.dialect.Dialect.supportsTupleDistinctCounts.

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

Overrides org.hibernate.dialect.Dialect.supportsUnboundedLobLocatorMaterialization.

Is it supported to materialize a LOB locator outside the transaction in which it was created?
public boolean
supportsUnionAll()

Overrides org.hibernate.dialect.Dialect.supportsUnionAll.

Does this dialect support UNION ALL?
public boolean
supportsUnionInSubquery()

Overrides org.hibernate.dialect.Dialect.supportsUnionInSubquery.

Does this dialect support UNION in a subquery.
public boolean
supportsValuesList()

Overrides org.hibernate.dialect.Dialect.supportsValuesList.

Does this dialect support values lists of form VALUES (1), (2), (3)?
public boolean
supportsValuesListForInsert()

Overrides org.hibernate.dialect.Dialect.supportsValuesListForInsert.

Does this dialect support values lists of form VALUES (1), (2), (3) in insert statements?
public boolean
supportsWait()

Overrides org.hibernate.dialect.Dialect.supportsWait.

Does this dialect support WAIT timeout.
public boolean
supportsWindowFunctions()

Overrides org.hibernate.dialect.Dialect.supportsWindowFunctions.

Does this dialect support window functions like row_number() over (..)?
public String
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.
public String
timestampdiffPattern(TemporalUnit
the first argument
unit, TemporalType
true if the first argument is a timestamp, false if a date
fromTemporalType, TemporalType
true if the second argument is
toTemporalType)

Overrides org.hibernate.dialect.Dialect.timestampdiffPattern.

Obtain a pattern for the SQL equivalent to a timestampdiff() function call.
public String
toBooleanValueString(boolean
The boolean value
bool)

Overrides org.hibernate.dialect.Dialect.toBooleanValueString.

The SQL literal expression representing the given boolean value.
public String
toQuotedIdentifier(String
The value to be quoted.
name)

Overrides org.hibernate.dialect.Dialect.toQuotedIdentifier.

Apply dialect-specific quoting.
public String
toString()

Overrides org.hibernate.dialect.Dialect.toString.

Returns a string representation of the object.
public String
transformSelectString(String
The select command
select)

Overrides org.hibernate.dialect.Dialect.transformSelectString.

Meant as a means for end users to affect the select strings being sent to the database and perhaps manipulate them in some fashion.
public String
translateDurationField(TemporalUnit unit)

Overrides org.hibernate.dialect.Dialect.translateDurationField.

Return the name used to identify the given unit of duration as an argument to #timestampadd() or #timestampdiff(), or of this dialect's equivalent functions.
public String
translateExtractField(TemporalUnit unit)

Overrides org.hibernate.dialect.Dialect.translateExtractField.

Return the name used to identify the given field as an argument to the extract() function, or of this dialect's equivalent function.
public String
trimPattern(TrimSpec
leading or trailing
specification, char
the character to trim
character)

Overrides org.hibernate.dialect.Dialect.trimPattern.

Obtain a pattern for the SQL equivalent to a trim() function call.
public String
trimPattern(TrimSpec
leading, trailing or both
specification, boolean
true if the trim character is a whitespace and can be omitted, false if it must be explicit and a ?2 placeholder should be included in the pattern
isWhitespace)

Overrides org.hibernate.dialect.Dialect.trimPattern.

Obtain a pattern for the SQL equivalent to a trim() function call.
public boolean
useFollowOnLocking(String sql, QueryOptions queryOptions)

Overrides org.hibernate.dialect.Dialect.useFollowOnLocking.

Some dialects have trouble applying pessimistic locking depending upon what other query options are specified (paging, ordering, etc).
public boolean
useInputStreamToInsertBlob()

Overrides org.hibernate.dialect.Dialect.useInputStreamToInsertBlob.

Should LOBs (both BLOB and CLOB) be bound using stream operations, that is, using PreparedStatement#setBinaryStream).
public boolean
useMaterializedLobWhenCapacityExceeded()

Overrides org.hibernate.dialect.Dialect.useMaterializedLobWhenCapacityExceeded.

Whether to switch:
Inherited from org.hibernate.dialect.Dialect:
getCheckConditiongetCheckConditiongetCreateEnumTypeCommandgetCreateEnumTypeCommandgetDefaultIntervalSecondScalegetDmlTargetColumnQualifierSupportgetDropEnumTypeCommandgetDropEnumTypeCommandgetEnumTypeDeclarationgetFunctionalDependencyAnalysisSupportgetTimeoutInSecondsisLobquoteCollationsupportsBatchUpdatessupportsIsTruesupportsRefCursorsuseArrayForMultiValuedParameters