public abstract Class AbstractTransactSQLDialect

Overrides org.hibernate.dialect.Dialect.appendBinaryLiteral.

Doc from org.hibernate.dialect.Dialect.appendBinaryLiteral.

Append a binary literal to the given SqlAppender.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.appendLockHint.

Doc from 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.

Parameters

lockOptions:LockOptions

The lock options to apply

tableName:String

The name of the table to which to apply the lock hint.

Returns:String

The table with any required lock hints.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.applyLocksToSql.

Doc from org.hibernate.dialect.Dialect.applyLocksToSql.

Modifies the given SQL, applying the appropriate updates for the specified lock modes and key columns.

This allows emulation of SELECT FOR UPDATE for dialects which do not support the standard syntax.

Parameters

sql:String

the SQL string to modify

aliasedLockOptions:LockOptions

lock options indexed by aliased table names.

keyColumnNames:Map<String, String[]>

a map of key columns indexed by aliased table names.

Returns:String

the modified SQL string.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.doesReadCommittedCauseWritersToBlockReaders.

Doc from 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?

Returns:boolean

True if writers block readers to achieve READ_COMMITTED; false otherwise.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.doesRepeatableReadCauseReadersToBlockWriters.

Doc from 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?

Returns:boolean

True if readers block writers to achieve REPEATABLE_READ; false otherwise.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getAddColumnString.

Doc from 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.

Returns:String

The add column fragment.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSelectString.

Doc from org.hibernate.dialect.Dialect.getCurrentTimestampSelectString.

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

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getDefaultStatementBatchSize.

Doc from org.hibernate.dialect.Dialect.getDefaultStatementBatchSize.

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

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getFallbackSqmInsertStrategy.

Doc from org.hibernate.dialect.Dialect.getFallbackSqmInsertStrategy.

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

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getFallbackSqmMutationStrategy.

Doc from org.hibernate.dialect.Dialect.getFallbackSqmMutationStrategy.

The SqmMultiTableMutationStrategy to use when not specified by org.hibernate.query.spi.QueryEngineOptions#getCustomSqmMultiTableMutationStrategy.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getForUpdateString.

Doc from org.hibernate.dialect.Dialect.getForUpdateString.

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

Returns:String

The appropriate FOR UPDATE clause string.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getIdentityColumnSupport.

Doc from org.hibernate.dialect.Dialect.getIdentityColumnSupport.

Get the appropriate IdentityColumnSupport for this dialect.

Returns:IdentityColumnSupport

the IdentityColumnSupport

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getNullOrdering.

Doc from org.hibernate.dialect.Dialect.getNullOrdering.

Returns the default ordering of null.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getPreferredSqlTypeCodeForBoolean.

Doc from org.hibernate.dialect.Dialect.getPreferredSqlTypeCodeForBoolean.

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

Usually Types#BOOLEAN or Types#BIT.

Returns:int

one of the type codes defined by Types.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getResultSet.

Doc from org.hibernate.dialect.Dialect.getResultSet.

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

Parameters

ps:CallableStatement

The callable statement.

Returns:ResultSet

The extracted result set.

Annotations

@Override

Exceptions

SQLException:

Indicates problems extracting the result set.

Overrides org.hibernate.dialect.Dialect.getSelectGUIDString.

Doc from org.hibernate.dialect.Dialect.getSelectGUIDString.

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

Optional operation.

Returns:String

The appropriate command.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getSupportedTemporaryTableKind.

Doc from org.hibernate.dialect.Dialect.getSupportedTemporaryTableKind.

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

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getTemporaryTableAfterUseAction.

Doc from org.hibernate.dialect.Dialect.getTemporaryTableAfterUseAction.

The action to take after finishing use of a temporary table.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getTemporaryTableBeforeUseAction.

Doc from org.hibernate.dialect.Dialect.getTemporaryTableBeforeUseAction.

The action to take before beginning use of a temporary table.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getTemporaryTableCreateCommand.

Doc from org.hibernate.dialect.Dialect.getTemporaryTableCreateCommand.

The command to create a temporary table.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getWriteRowLockStrategy.

Doc from org.hibernate.dialect.Dialect.getWriteRowLockStrategy.

The row lock strategy to use for write locks.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.initializeFunctionRegistry.

Doc from org.hibernate.dialect.Dialect.initializeFunctionRegistry.

Initialize the given registry with any dialect-specific functions.

Support for certain SQL functions is required, and if the database does not support a required function, then the dialect must define a way to emulate it.

These required functions include the functions defined by the JPA query language specification:

• avg(arg) - aggregate function
• count([distinct ]arg) - aggregate function
• max(arg) - aggregate function
• min(arg) - aggregate function
• sum(arg) - aggregate function

• coalesce(arg0, arg1, ...)
• nullif(arg0, arg1)

• lower(arg)
• upper(arg)
• length(arg)
• concat(arg0, arg1, ...)
• locate(pattern, string[, start])
• substring(string, start[, length])
• trim([[spec ][character ]from] string)

• abs(arg)
• mod(arg0, arg1)
• sqrt(arg)

• current date
• current time
• current timestamp

• any(arg) - aggregate function
• every(arg) - aggregate function

• var_samp(arg) - aggregate function
• var_pop(arg) - aggregate function
• stddev_samp(arg) - aggregate function
• stddev_pop(arg) - aggregate function

• cast(arg as Type)
• extract(field from arg)

• ln(arg)
• exp(arg)
• power(arg0, arg1)
• floor(arg)
• ceiling(arg)

• position(pattern in string)
• substring(string from start[ for length])
• overlay(string placing replacement from start[ for length])

• local date
• local time
• local datetime
• offset datetime
• instant

• left(string, length)
• right(string, length)
• replace(string, pattern, replacement)
• pad(string with length spec[ character])
• repeat(string, times)

• pi
• log10(arg)
• log(base, arg)
• sign(arg)
• sin(arg)
• cos(arg)
• tan(arg)
• asin(arg)
• acos(arg)
• atan(arg)
• atan2(arg0, arg1)
• round(arg0[, arg1])
• truncate(arg0[, arg1])
• sinh(arg)
• tanh(arg)
• cosh(arg)
• least(arg0, arg1, ...)
• greatest(arg0, arg1, ...)
• degrees(arg)
• radians(arg)

• format(datetime as pattern)
• collate(string as collation)
• str(arg) - synonym of cast(a as String)
• ifnull(arg0, arg1) - synonym of coalesce(a, b)

• second(arg) - synonym of extract(second from a)
• minute(arg) - synonym of extract(minute from a)
• hour(arg) - synonym of extract(hour from a)
• day(arg) - synonym of extract(day from a)
• month(arg) - synonym of extract(month from a)
• year(arg) - synonym of extract(year from a)

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.isCurrentTimestampSelectStringCallable.

Doc from org.hibernate.dialect.Dialect.isCurrentTimestampSelectStringCallable.

Is the command returned by getCurrentTimestampSelectString treated as callable?

Typically, this indicates the use of the JDBC escape syntax.

Returns:boolean

if the getCurrentTimestampSelectString is treated as callable; false otherwise.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.qualifyIndexName.

Doc from org.hibernate.dialect.Dialect.qualifyIndexName.

Do we need to qualify index names with the schema name?

Returns:boolean

true if we do

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.registerResultSetOutParameter.

Doc from 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.

Parameters

statement:CallableStatement

The callable statement.

col:int

The bind position at which to register the output param.

Returns:int

The number of (contiguous) bind positions used.

Annotations

@Override

Exceptions

SQLException:

Indicates problems registering the param.

Annotations

@Deprecated

forRemoval:true

Overrides org.hibernate.dialect.Dialect.requiresCastForConcatenatingNonStrings.

Doc from org.hibernate.dialect.Dialect.requiresCastForConcatenatingNonStrings.

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

Returns:boolean

true if casting using cast() is required

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.resolveSqlTypeDescriptor.

Doc from 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.

Parameters

columnTypeName:String

the column type name

jdbcTypeCode:int

the type code

precision:int

the precision or 0

scale:int

the scale or 0

Returns:JdbcType

an appropriate instance of JdbcType

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsCurrentTimestampSelection.

Doc from org.hibernate.dialect.Dialect.supportsCurrentTimestampSelection.

Does this dialect support some way to retrieve the current timestamp value from the database?

Returns:boolean

True if the current timestamp can be retrieved; false otherwise.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsExistsInSelect.

Doc from org.hibernate.dialect.Dialect.supportsExistsInSelect.

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

Returns:boolean

True if exists checks are allowed in the select clause; false otherwise.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsPartitionBy.

Doc from org.hibernate.dialect.Dialect.supportsPartitionBy.

Does is dialect support partition by?

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsTupleDistinctCounts.

Doc from org.hibernate.dialect.Dialect.supportsTupleDistinctCounts.

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

Returns:boolean

True if the database supports counting distinct tuples; false otherwise.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.trimPattern.

Doc from org.hibernate.dialect.Dialect.trimPattern.

Obtain a pattern for the SQL equivalent to a trim() function call. The resulting pattern must contain a ?1 placeholder for the argument of type String and a ?2 placeholder for the trim character if isWhitespace was false.

Parameters

specification:TrimSpec

leading, trailing or both

isWhitespace: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

Annotations

@Override