Top Description Fields Constructors Methods
org.hibernate.dialect

public Class MySQLDialect

extends Dialect
Class Inheritance
Known Direct Subclasses
org.hibernate.dialect.TiDBDialect, org.hibernate.dialect.MariaDBDialect, org.hibernate.dialect.MySQL8Dialect
Imports
java.sql.CallableStatement, .DatabaseMetaData, .ResultSet, .SQLException, .Types, java.time.ZonedDateTime, java.time.temporal.TemporalAccessor, java.util.Calendar, .Date, .TimeZone, org.hibernate.LockOptions, .PessimisticLockException, org.hibernate.boot.model.FunctionContributions, .TypeContributions, org.hibernate.cfg.Environment, org.hibernate.dialect.function.CommonFunctionFactory, org.hibernate.dialect.hint.IndexQueryHintHandler, org.hibernate.dialect.identity.IdentityColumnSupport, .MySQLIdentityColumnSupport, org.hibernate.dialect.pagination.LimitHandler, .LimitLimitHandler, org.hibernate.dialect.sequence.NoSequenceSupport, .SequenceSupport, org.hibernate.dialect.temptable.TemporaryTable, .TemporaryTableKind, org.hibernate.engine.jdbc.Size, org.hibernate.engine.jdbc.dialect.spi.DialectResolutionInfo, org.hibernate.engine.jdbc.env.spi.IdentifierCaseStrategy, .IdentifierHelper, .IdentifierHelperBuilder, .NameQualifierSupport, org.hibernate.engine.spi.SessionFactoryImplementor, org.hibernate.exception.LockAcquisitionException, .LockTimeoutException, org.hibernate.exception.spi.SQLExceptionConversionDelegate, .TemplatedViolatedConstraintNameExtractor, .ViolatedConstraintNameExtractor, org.hibernate.internal.util.JdbcExceptionHelper, org.hibernate.metamodel.mapping.EntityMappingType, org.hibernate.metamodel.spi.RuntimeModelCreationContext, org.hibernate.query.sqm.CastType, .IntervalType, .TemporalUnit, org.hibernate.query.sqm.function.SqmFunctionRegistry, org.hibernate.query.sqm.mutation.internal.temptable.AfterUseAction, .BeforeUseAction, .LocalTemporaryTableInsertStrategy, .LocalTemporaryTableMutationStrategy, org.hibernate.query.sqm.mutation.spi.SqmMultiTableInsertStrategy, .SqmMultiTableMutationStrategy, org.hibernate.query.sqm.produce.function.FunctionParameterType, org.hibernate.service.ServiceRegistry, org.hibernate.sql.ast.SqlAstTranslator, .SqlAstTranslatorFactory, org.hibernate.sql.ast.spi.SqlAppender, .StandardSqlAstTranslatorFactory, org.hibernate.sql.ast.tree.Statement, org.hibernate.sql.exec.spi.JdbcOperation, org.hibernate.type.BasicTypeRegistry, .NullType, .SqlTypes, .StandardBasicTypes, org.hibernate.type.descriptor.java.JavaType, org.hibernate.type.descriptor.jdbc.JdbcType, .NullJdbcType, org.hibernate.type.descriptor.jdbc.spi.JdbcTypeRegistry, org.hibernate.type.descriptor.sql.internal.CapacityDependentDdlType, .DdlTypeImpl, .NativeEnumDdlTypeImpl, org.hibernate.type.descriptor.sql.spi.DdlTypeRegistry, jakarta.persistence.TemporalType
A SQL dialect for MySQL 5.7 and above.
Author
Gavin King

Field Summary

Modifier and TypeField and Description
private static final ViolatedConstraintNameExtractor
EXTRACTOR

Hides org.hibernate.dialect.Dialect.EXTRACTOR.

private final int
maxVarbinaryLength

private final int
maxVarcharLength

private static final DatabaseVersion
MINIMUM_VERSION

private final boolean
noBackslashEscapesEnabled

private final Dialect.SizeStrategy
sizeStrategy

Hides org.hibernate.dialect.Dialect.sizeStrategy.

private final MySQLStorageEngine
storageEngine

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

public
MySQLDialect(DatabaseVersion version)

public
MySQLDialect(DatabaseVersion version, int bytesPerCharacter)

public
MySQLDialect(DatabaseVersion version, MySQLServerConfiguration serverConfiguration)

public
MySQLDialect(DatabaseVersion version, int bytesPerCharacter, boolean noBackslashEscapes)

public
MySQLDialect(DialectResolutionInfo info)

Method Summary

Modifier and TypeMethod and Description
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
appendLiteral(SqlAppender appender, String literal)

Overrides org.hibernate.dialect.Dialect.appendLiteral.

Append a literal string to the given SqlAppender.
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
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.
protected 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( ...
public char
closeQuote()

Overrides org.hibernate.dialect.Dialect.closeQuote.

The character specific to this dialect used to close a quoted identifier.
protected 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
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.
private MySQLStorageEngine
createStorageEngine()

protected static DatabaseVersion
createVersion(DialectResolutionInfo info)

public String
currentTimestamp()

Overrides org.hibernate.dialect.Dialect.currentTimestamp.

MySQL 5.7 precision defaults to seconds, but microseconds is better
public static Replacer
datetimeFormat(String format)

public boolean
dropConstraints()

Overrides org.hibernate.dialect.Dialect.dropConstraints.

Do we need to drop constraints before dropping tables in this dialect?
public String
extractPattern(TemporalUnit
the first argument
unit)

Overrides org.hibernate.dialect.Dialect.extractPattern.

MySQL supports a limited list of temporal fields in the extract() function, but we can emulate some of them by using the appropriate named functions instead of extract().
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
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.
protected static int
getCharacterSetBytesPerCharacter(DatabaseMetaData databaseMetaData)

Deprecated
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[]
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
getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSelectString.

The command used to retrieve the current timestamp from the database.
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.
protected MySQLStorageEngine
getDefaultMySQLStorageEngine()

public String
getDisableConstraintsStatement()

Overrides org.hibernate.dialect.Dialect.getDisableConstraintsStatement.

A SQL statement that temporarily disables foreign key constraint checking for all tables.
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
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
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 SqmMultiTableInsertStrategy
getFallbackSqmInsertStrategy(EntityMappingType rootEntityDescriptor, 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 rootEntityDescriptor, 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 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(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 long
getFractionalSecondPrecisionInNanos()

Overrides org.hibernate.dialect.Dialect.getFractionalSecondPrecisionInNanos.

microsecond is the smallest unit for timestampadd() and timestampdiff(), and the highest precision for a timestamp.
public FunctionalDependencyAnalysisSupport
getFunctionalDependencyAnalysisSupport()

Overrides org.hibernate.dialect.Dialect.getFunctionalDependencyAnalysisSupport.

Get this dialect's level of support for primary key functional dependency analysis within GROUP BY and ORDER BY clauses.
public SelectItemReferenceStrategy
getGroupBySelectItemReferenceStrategy()

Overrides org.hibernate.dialect.Dialect.getGroupBySelectItemReferenceStrategy.

Determine how selected items are referenced in the group by clause.
public IdentityColumnSupport
getIdentityColumnSupport()

Overrides org.hibernate.dialect.Dialect.getIdentityColumnSupport.

Get the appropriate IdentityColumnSupport for this 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 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
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
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.
protected DatabaseVersion
getMinimumSupportedVersion()

Overrides org.hibernate.dialect.Dialect.getMinimumSupportedVersion.

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

public NameQualifierSupport
getNameQualifierSupport()

Overrides org.hibernate.dialect.Dialect.getNameQualifierSupport.

The support for qualified identifiers.
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
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, String
The hints to apply
hints)

Overrides org.hibernate.dialect.Dialect.getQueryHintString.

Apply a hint to the given SQL query.
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 ResultSet
getResultSet(CallableStatement
The callable statement.
ps)

Overrides org.hibernate.dialect.Dialect.getResultSet.

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

Overrides org.hibernate.dialect.Dialect.getSelectGUIDString.

Get the command used to select a GUID from the database.
public SequenceSupport
getSequenceSupport()

Overrides org.hibernate.dialect.Dialect.getSequenceSupport.

No support for sequences.
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 TemporaryTableKind
getSupportedTemporaryTableKind()

Overrides org.hibernate.dialect.Dialect.getSupportedTemporaryTableKind.

The kind of temporary tables that are supported on this database.
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 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
getTemporaryTableDropCommand()

Overrides org.hibernate.dialect.Dialect.getTemporaryTableDropCommand.

The command to drop a temporary table.
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 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
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 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 boolean
isCurrentTimestampSelectStringCallable()

Overrides org.hibernate.dialect.Dialect.isCurrentTimestampSelectStringCallable.

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

Overrides org.hibernate.dialect.Dialect.isJdbcLogWarningsEnabledByDefault.

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

private static int
maxVarbinaryLength(DatabaseVersion version)

private static int
maxVarcharLength(DatabaseVersion version, int bytesPerCharacter)

public char
openQuote()

Overrides org.hibernate.dialect.Dialect.openQuote.

The character specific to this dialect used to begin a quoted identifier.
public boolean
qualifyIndexName()

Overrides org.hibernate.dialect.Dialect.qualifyIndexName.

Do we need to qualify index names with the schema name?
protected 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 void
registerDefaultKeywords()

Overrides org.hibernate.dialect.Dialect.registerDefaultKeywords.

Register the reserved words of ANSI-standard SQL as keywords.
public int
registerResultSetOutParameter(CallableStatement
The callable statement.
statement, int
The bind position at which to register the output param.
col)

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 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.
pack-priv boolean
supportsAliasLocks()

public boolean
supportsAlterColumnType()

Overrides org.hibernate.dialect.Dialect.supportsAlterColumnType.

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

Overrides org.hibernate.dialect.Dialect.supportsCascadeDelete.

Does this dialect support on delete actions in foreign key definitions?
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?
pack-priv boolean
supportsForShare()

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

Overrides org.hibernate.dialect.Dialect.supportsIsTrue.

Does this dialect support the is true and is false operators?
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
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
supportsRecursiveCTE()

Overrides org.hibernate.dialect.Dialect.supportsRecursiveCTE.

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

Overrides org.hibernate.dialect.Dialect.supportsSkipLocked.

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

Overrides org.hibernate.dialect.Dialect.supportsSubqueryOnMutatingTable.

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

Overrides org.hibernate.dialect.Dialect.supportsTemporalLiteralOffset.

Does this dialect supports timezone offsets in temporal literals.
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 (..)?
private void
time(FunctionContributions queryEngine)

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

Overrides org.hibernate.dialect.Dialect.useMaterializedLobWhenCapacityExceeded.

Whether to switch:
private String
withTimeout(String lockString, int timeout)

Inherited from org.hibernate.dialect.Dialect:
addSqlHintOrCommentappendArrayLiteralappendBinaryLiteralappendBooleanValueStringappendIntervalLiteralappendLockHintappendUUIDLiteralapplyLocksToSqlaugmentPhysicalTableTypesaugmentRecognizedTableTypescanBatchTruncatecheckVersioncontributecontributeFunctionscreateOptionalTableUpdateOperationcurrentDatecurrentLocalTimecurrentLocalTimestampcurrentTimecurrentTimestampWithTimeZonedefaultScrollModedoesReadCommittedCauseWritersToBlockReadersdoesRepeatableReadCauseReadersToBlockWritersequivalentTypesescapeCommentforceLobAsLastValuegeneratedAsgetAddColumnStringgetAddColumnSuffixStringgetAddForeignKeyConstraintStringgetAddPrimaryKeyConstraintStringgetAggregateSupportgetAlterTableStringgetArrayTypeNamegetAuxiliaryDatabaseObjectExportergetBatchLoadSizingStrategygetCallableStatementSupportgetCascadeConstraintsStringgetCaseInsensitiveLikegetCheckConditiongetCheckConditiongetCheckConditiongetCheckConditiongetColumnAliasExtractorgetCreateEnumTypeCommandgetCreateEnumTypeCommandgetCreateIndexStringgetCreateIndexTailgetCreateMultisetTableStringgetCreateTableStringgetCreateTemporaryTableColumnAnnotationgetCreateUserDefinedTypeExtensionsStringgetCreateUserDefinedTypeKindStringgetCurrentSchemaCommandgetDefaultDecimalPrecisiongetDefaultIntervalSecondScalegetDefaultNonContextualLobCreationgetDefaultPropertiesgetDefaultStatementBatchSizegetDefaultTimestampPrecisiongetDefaultUseGetGeneratedKeysgetDisableConstraintStatementgetDmlTargetColumnQualifierSupportgetDoublePrecisiongetDropEnumTypeCommandgetDropEnumTypeCommandgetDropTableStringgetEnableConstraintStatementgetEnumTypeDeclarationgetFallbackSchemaManagementToolgetForeignKeyExportergetForUpdateStringgetForUpdateStringgetForUpdateStringgetForUpdateStringgetHqlTranslatorgetIndexExportergetInExpressionCountLimitgetKeywordsgetLobMergeStrategygetLockingStrategygetLockRowIdentifiergetLowercaseFunctiongetMaxNVarcharCapacitygetMaxNVarcharLengthgetMaxVarbinaryCapacitygetMaxVarcharCapacitygetMultiKeyLoadSizingStrategygetNationalizationSupportgetNativeIdentifierGeneratorStrategygetNativeParameterMarkerStrategygetNoColumnsInsertStringgetNullColumnStringgetParameterCountLimitgetPreferredSqlTypeCodeForArraygetQueryHintStringgetQuerySequencesStringgetReadRowLockStrategygetResultSetgetResultSetgetRowIdColumnStringgetSchemaNameResolvergetSelectClauseNullStringgetSequenceExportergetSequenceInformationExtractorgetSqmTranslatorFactorygetTableCleanergetTableExportergetTableMigratorgetTemporaryTableCreateOptionsgetTemporaryTableDdlTransactionHandlinggetTemporaryTableExportergetTemporaryTableTruncateCommandgetTimeoutInSecondsgetTimeZoneSupportgetTruncateTableStatementgetTruncateTableStatementsgetUniqueDelegategetUniqueKeyExportergetUserDefinedTypeCommentgetUserDefinedTypeExportergetVersionhasAlterTablehasDataTypeBeforeGeneratedAsinlineLiteralisAnsiNullOnisEmptyStringTreatedAsNullisLobisLockTimeoutParameterizedordinalprependCommentquotequoteCollationregisterKeywordregisterKeywordsregisterResultSetOutParameterrequiresCastForConcatenatingNonStringsrequiresFloatCastingOfIntegerDivisionrequiresParensForTupleCountsrequiresParensForTupleDistinctCountsresolveSqlTypeCoderesolveSqlTypeCoderesolveSqlTypeLengthrowIdrowIdSqlTypesupportsBatchUpdatessupportsBindAsCallableArgumentsupportsBitTypesupportsCaseInsensitiveLikesupportsCircularCascadeDeleteConstraintssupportsDistinctFromPredicatesupportsExistsInSelectsupportsExpectedLobUsagePatternsupportsFetchClausesupportsFractionalTimestampArithmeticsupportsIfExistsAfterAlterTablesupportsIfExistsAfterConstraintNamesupportsIfExistsAfterTableNamesupportsIfExistsAfterTypeNamesupportsIfExistsBeforeConstraintNamesupportsIfExistsBeforeTypeNamesupportsInsertReturningsupportsInsertReturningGeneratedKeyssupportsJdbcConnectionLobCreationsupportsMaterializedLobAccesssupportsNamedParameterssupportsNoColumnsInsertsupportsNonQueryWithCTEsupportsOrderByInSubquerysupportsOrdinalSelectItemReferencesupportsOuterJoinForUpdatesupportsParametersInInsertSelectsupportsPartitionBysupportsPredicateAsExpressionsupportsRefCursorssupportsResultSetPositionQueryMethodsOnForwardOnlyCursorsupportsStandardArrayssupportsStandardCurrentTimestampFunctionsupportsSubqueryInSelectsupportsSubselectAsInPredicateLHSsupportsTableChecksupportsTemporaryTablePrimaryKeysupportsTemporaryTablessupportsTruncateWithCastsupportsTupleCountssupportsTupleDistinctCountssupportsUnboundedLobLocatorMaterializationsupportsUnionAllsupportsUnionInSubquerysupportsValuesListsupportsValuesListForInserttoBooleanValueStringtoQuotedIdentifiertoStringtransformSelectStringtranslateDurationFieldtranslateExtractFieldtrimPatterntrimPatternuseArrayForMultiValuedParametersuseFollowOnLockinguseInputStreamToInsertBlob