public Class MySQLDialect

buildIdentifierHelper(IdentifierHelperBuilder

A semi-configured IdentifierHelper builder.

builder, DatabaseMetaData

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

Warning

may be null

dbMetaData)

Overrides org.hibernate.dialect.Dialect.buildIdentifierHelper.

Build the IdentifierHelper indicated by this Dialect for handling identifier conversions.

canCreateCatalog()

Overrides org.hibernate.dialect.Dialect.canCreateCatalog.

Does this dialect support catalog creation?

closeQuote()

Overrides org.hibernate.dialect.Dialect.closeQuote.

The character specific to this dialect used to close a quoted identifier.

getAddForeignKeyConstraintString(String

The FK constraint name.

constraintName, String[]

The names of the columns comprising the FK

foreignKey, String

The table referenced by the FK

referencedTable, String[]

The explicit columns in the referencedTable referenced by this FK.

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.

getColumnComment(String

The comment to apply

comment)

Overrides org.hibernate.dialect.Dialect.getColumnComment.

Get the comment into a form supported for column definition.

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

getDefaultMultiTableBulkIdStrategy()

Overrides org.hibernate.dialect.Dialect.getDefaultMultiTableBulkIdStrategy.

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

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

getForUpdateString()

Overrides org.hibernate.dialect.Dialect.getForUpdateString.

Get the string to append to SELECT statements to acquire locks for this dialect.

getLimitHandler()

Overrides org.hibernate.dialect.Dialect.getLimitHandler.

Returns the delegate managing LIMIT clause.

getNameQualifierSupport()

Overrides org.hibernate.dialect.Dialect.getNameQualifierSupport.

By default interpret this based on DatabaseMetaData.

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.

getSelectGUIDString()

Overrides org.hibernate.dialect.Dialect.getSelectGUIDString.

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

getTableTypeString()

Overrides org.hibernate.dialect.Dialect.getTableTypeString.

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 WRITE locks for this dialect.

isCurrentTimestampSelectStringCallable()

Overrides org.hibernate.dialect.Dialect.isCurrentTimestampSelectStringCallable.

Should the value returned by getCurrentTimestampSelectString be treated as callable.

openQuote()

Overrides org.hibernate.dialect.Dialect.openQuote.

The character specific to this dialect used to begin a quoted identifier.

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 (either OUT, or the new REF_CURSOR param type available in Java 8) capable of returning ResultSet *by position*.

renderOrderByElement(String

The SQL order expression. In case of @OrderBy annotation user receives property placeholder (e.g. attribute name enclosed in '{' and '}' signs).

expression, String

Collation string in format collate IDENTIFIER, or null if expression has not been explicitly specified.

collation, String

Order direction. Possible values: asc, desc, or null if expression has not been explicitly specified.

order, NullPrecedence

Nulls precedence. Default value: NullPrecedence#NONE.

nulls)

Overrides org.hibernate.dialect.Dialect.renderOrderByElement.

Renders an ordering fragment

supportsCascadeDelete()

Overrides org.hibernate.dialect.Dialect.supportsCascadeDelete.

Does this dialect support cascaded delete on foreign key definitions?

supportsEmptyInList()

Overrides org.hibernate.dialect.Dialect.supportsEmptyInList.

Does this dialect support empty IN lists?

supportsLimit()

Overrides org.hibernate.dialect.Dialect.supportsLimit.

Does this dialect support some form of limiting query results via a SQL clause?

supportsLockTimeouts()

Overrides org.hibernate.dialect.Dialect.supportsLockTimeouts.

Informational metadata about whether this dialect is known to support specifying timeouts for requested lock acquisitions.

supportsRowValueConstructorSyntaxInSet()

Overrides org.hibernate.dialect.Dialect.supportsRowValueConstructorSyntaxInSet.

Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax, sometimes called tuple syntax, in the SET clause;

Basically, does it support syntax like "...

supportsSubqueryOnMutatingTable()

Overrides org.hibernate.dialect.Dialect.supportsSubqueryOnMutatingTable.

Does this dialect support referencing the table being mutated in a subquery.