Class SybaseDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.dialect.AbstractTransactSQLDialect

org.hibernate.dialect.SybaseDialect

All Implemented Interfaces:

CheckConstraintSupport, ForeignKeySupport, IdentifierSupport, KeywordSupport, LiteralSupport, AlterTableSupport, ColumnDefinitionSupport, ConstraintControlSupport, IndexDdlSupport, TableCreationSupport, TruncateSupport, CurrentTemporalSupport, TemporalFormatSupport, TemporalOperationSupport, ConversionContext

Direct Known Subclasses:

AbstractSybaseDialect, SybaseASEDialect

public class SybaseDialect
extends AbstractTransactSQLDialect
implements CurrentTemporalSupport, TemporalFormatSupport, TemporalOperationSupport

Superclass for all Sybase dialects.

Field Summary

Fields

Modifier and Type	Field	Description
protected final boolean	jtdsDriver	Deprecated, for removal: This API element is subject to removal in a future version.

Fields inherited from class Dialect

LEGACY_LOB_MERGE_STRATEGY, NEW_LOCATOR_LOB_MERGE_STRATEGY, STANDARD_MULTI_KEY_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY

Fields inherited from interface ConstraintControlSupport

NONE

Fields inherited from interface TruncateSupport

STANDARD

Constructor Summary

Constructors

Constructor	Description
SybaseDialect()
SybaseDialect(DatabaseVersion version)
SybaseDialect(DialectResolutionInfo info)

Method Summary

Modifier and Type	Method	Description
boolean	addPartitionKeyToPrimaryKey()	Whether every table partition key must also occur in its primary key.
String	alterColumnType(AlterColumnTypeRequest request)
void	appendDateTimeLiteral(SqlAppender appender, TemporalAccessor temporalAccessor, TemporalType precision, TimeZone jdbcTimeZone)	Append a datetime literal for a java.time value.
void	appendDateTimeLiteral(SqlAppender appender, Calendar calendar, TemporalType precision, TimeZone jdbcTimeZone)	Append a datetime literal for a Calendar value.
void	appendDateTimeLiteral(SqlAppender appender, Date date, TemporalType precision, TimeZone jdbcTimeZone)	Append a datetime literal for a legacy Date value.
void	appendDefinition(SqlAppender appender, ColumnDefinitionRequest request)
void	appendFormat(SqlAppender appender, String format)	Append the database translation of the supplied Hibernate format pattern.
IdentifierHelper	buildIdentifierHelper(IdentifierHelperBuildRequest request)	Build and supply the configured identifier helper from the stable JDBC metadata snapshot and selected keyword strategy.
String	castPattern(CastType from, CastType to)	Obtain a pattern for the SQL equivalent to a cast() function call.
void	contributeTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)	Contribute database-specific Java, JDBC, DDL, and basic type descriptors.
String	currentTimestamp()	Render the current SQL timestamp expression used for java.sql.Timestamp.
String	extractPattern(TemporalUnit unit)	Return an extraction pattern containing ?1 for the field and ?2 for the value.
CallableStatementSupport	getCallableStatementSupport()	Supply the callable-statement protocol for this database and JDBC driver.
CteSupport	getCteSupport()	The common-table-expression capabilities of this Dialect.
CurrentTemporalSupport	getCurrentTemporalSupport()	Supply current temporal expressions and database-side timestamp retrieval.
DirectJavaTimeJdbcSupport	getDirectJavaTimeJdbcSupport()	Supply direct JDBC access capabilities for Java Time classes.
DmlTargetColumnQualifierSupport	getDmlTargetColumnQualifierSupport()	The qualifier form accepted for target-column references in update and delete statements.
SybaseDriverKind	getDriverKind()
IdentityColumnSupport	getIdentityColumnSupport()	Supply the identity profile matching the resolved Sybase JDBC driver.
JdbcMetadataOverrides	getJdbcMetadataOverrides()	Supply the stable overrides applied to raw JDBC metadata reports.
LockingSupport	getLockingSupport()	Supplies the cohesive pessimistic-locking profile for this Dialect.
int	getMaxIdentifierLength()	Return the database's maximum identifier length.
protected DatabaseVersion	getMinimumSupportedVersion()	Get the version of the SQL dialect that is the minimum supported by this implementation.
MutationSyntaxSupport	getMutationSyntaxSupport()	The native SQL mutation-syntax capabilities of this Dialect.
NameQualifierSupport	getNameQualifierSupport()	Supply catalog and schema qualification support, or return null to use DatabaseMetaData.
NamespaceSupport	getNamespaceSupport()	Supply catalog and schema lifecycle behavior to schema tooling.
NationalizationSupport	getNationalizationSupport()	Describe how this database represents nationalized character data.
NullOrderingSupport	getNullOrderingSupport()	Supply the database's default null ordering and explicit null-precedence syntax capabilities.
ParameterLimits	getParameterLimits()	Supplies the database limits for IN-expression elements and total JDBC statement parameters.
RowValueSupport	getRowValueSupport()	The native row-value syntax of this Dialect.
SchemaNameResolver	getSchemaNameResolver()	Supply the strategy which resolves the current schema for a JDBC connection.
SqlAstTranslatorFactory	getSqlAstTranslatorFactory()	Supply the factory for this Dialect's single-use SQL AST translators.
StringValueSemantics	getStringValueSemantics()	Supply the database's stable string-value semantics.
SyntheticTableGroupSupport	getSyntheticTableGroupSupport()	Supply the strategy for synthetic table roots required while converting grouping and ordering expressions to SQL AST.
TemporalFormatSupport	getTemporalFormatSupport()	Supply datetime-format translation.
TemporalOperationSupport	getTemporalOperationSupport()	Supply extraction and timestamp-arithmetic syntax.
UniqueDelegate	getUniqueDelegate()	Supply the stable strategy used for unique-key representation and DDL.
ValuesListSupport	getValuesListSupport()	The contexts in which this Dialect supports native multi-row values syntax.
void	initializeFunctionRegistry(FunctionContributions functionContributions)	Contribute the database-specific function descriptors after independent function contributors have run.
JdbcType	resolveSqlTypeDescriptor(String columnTypeName, int jdbcTypeCode, int precision, int scale, JdbcTypeRegistry jdbcTypeRegistry)	Resolve the non-null JDBC descriptor for result-set metadata.
int	resolveSqlTypeLength(String columnTypeName, int jdbcTypeCode, int precision, int scale, int displaySize)	Normalize JDBC result-set metadata to Hibernate's resolved column length.
boolean	supportsNationalizedMethods()	Determine whether the JDBC driver correctly implements the nationalized ResultSet, PreparedStatement, and CallableStatement methods.
String	timestampaddPattern(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType)	Return a timestamp-add pattern containing ?1, ?2, and ?3.
String	timestampdiffPattern(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)	Return a timestamp-difference pattern containing ?1, ?2, and ?3.
String	translateExtractField(TemporalUnit unit)	Translate an extraction field name.
boolean	usesStandardCurrentTimestampFunction()	Whether CurrentTemporalSupport.currentTimestamp() uses the standard SQL current_timestamp function.

Methods inherited from class AbstractTransactSQLDialect

addColumnPrefix, appendBinaryLiteral, columnType, contributeDefaultProperties, getCurrentTimestampSelection, getExpressionCoercionSupport, getLocalTemporaryTableStrategy, getLockingClauseStrategy, getMultiTableMutationSupport, getPreferredSqlTypeCodeForBoolean, getSubquerySupport, getTupleCountSupport, nameQualification, replaceLtrimRtrim, trimPattern

Methods inherited from class Dialect

appendArrayLiteral, augmentPhysicalTableTypes, augmentRecognizedTableTypes, buildLockingClauseStrategy, buildSQLExceptionConversionDelegate, buildStringToBooleanCast, buildStringToBooleanCastDecode, castType, causesRollback, constraintControlMode, contributeKeywords, createOptionalTableUpdateOperation, defaultScrollMode, determineDatabaseVersion, equivalentTypes, getAggregateSupport, getAlterTableSupport, getArraySupport, getArrayTypeName, getBatchLoadSizingStrategy, getCatalogSeparator, getCheckConstraintSupport, getColumnAliasExtractor, getColumnDefinitionSupport, getConstraintControlSupport, getDefaultOrdinalityColumnName, getDefaultProperties, getEntityLockingStrategyFactory, getEnumSupport, getFetchClauseSupport, getForeignKeyExporter, getForeignKeySupport, getFunctionalDependencyAnalysisSupport, getGeneratedValuesSupport, getGlobalTemporaryTableStrategy, getIdentifierSupport, getIfExistsSupport, getIndexDdlSupport, getIndexExporter, getInformationExtractor, getKeywords, getKeywordSupport, getLimitHandler, getLiteralSupport, getLobMergeStrategy, getLobSupport, getLowercaseFunction, getMultiKeyLoadSizingStrategy, getNativeParameterMarkerStrategy, getNativeValueGenerationStrategy, getObjectNullBindingStrategy, getPersistentTemporaryTableStrategy, getPredicateSupport, getPreferredSqlTypeCodeForArray, getQueryHintPlacement, getQueryHintString, getQueryHintString, getRefCursorSupportFactory, getRowIdSupport, getRowLevelSecurity, getSchemaCommentSupport, getSchemaDropSupport, getSelectClauseNullString, getSequenceExporter, getSequenceInformationExtractor, getSequenceSupport, getSetOperationSupport, getSetOperatorSqlString, getSingleRowTableSupport, getSizeStrategy, getTableCleaner, getTableCreationSupport, getTableExporter, getTableMigrator, getTemporalTableSupport, getTemporalValueSemantics, getTemporaryTableExporter, getTimeZoneSupport, getTruncateSupport, getTypeSizingProfile, getUserDefinedTypeExporter, getVersion, getViolatedConstraintNameExtractor, getWindowFunctionSupport, isJdbcLogWarningsEnabledByDefault, narrowCastType, registerColumnTypes, resolveSqlTypeCode, resolveSqlTypeCode, supportsCrossJoin, supportsFilterClause, supportsOrdinalSelectItemReference, supportsUserDefinedTypes, throttleDdl, toString, truncateMode

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface AlterTableSupport

addColumnSuffix, alterTableCommand

Methods inherited from interface CheckConstraintSupport

render, supports

Methods inherited from interface ConstraintControlSupport

disableCommands, disableConstraintCommands, enableCommands, enableConstraintCommands

Methods inherited from interface CurrentTemporalSupport

currentDate, currentLocalTime, currentLocalTimestamp, currentTime, currentTimestampWithTimeZone, getCurrentTimestampSelection, isCurrentTimestampStable

Methods inherited from interface ForeignKeySupport

renderAddConstraint, renderDropConstraint, requiresSelfReferentialForeignKeyNullification, supportsAlterTableConstraints, supportsOnDeleteAction

Methods inherited from interface IdentifierSupport

closeQuote, getMaxAliasLength, openQuote, quote, quoteCollation, toQuotedIdentifier

Methods inherited from interface IndexDdlSupport

createCommand, createTail

Methods inherited from interface KeywordSupport

acceptsJdbcKeyword

Methods inherited from interface LiteralSupport

appendBooleanValueString, appendIntervalLiteral, appendIntervalLiteral, appendLiteral, appendUUIDLiteral, toBooleanValueString

Methods inherited from interface TableCreationSupport

createTableCommand, requiresViewColumnList, tableCreationOptions

Methods inherited from interface TemporalOperationSupport

fractionalSecondPrecisionInNanos, translateDurationField

Methods inherited from interface TruncateSupport

renderCommands

Field Details

jtdsDriver

@Deprecated(forRemoval=true)
protected final boolean jtdsDriver

Deprecated, for removal: This API element is subject to removal in a future version.

Constructor Details

SybaseDialect

public SybaseDialect()

SybaseDialect

public SybaseDialect(DatabaseVersion version)

SybaseDialect

public SybaseDialect(DialectResolutionInfo info)

Method Details

getTemporalOperationSupport

@SPI({IMPLEMENT,SUPPLY})
public TemporalOperationSupport getTemporalOperationSupport()

Description copied from class: Dialect

Supply extraction and timestamp-arithmetic syntax. Return one stable, non-null, thread-safe implementation. Providers may implement TemporalOperationSupport directly and return this.

Overrides:

getTemporalOperationSupport in class Dialect

See Also:

• TemporalOperationSupport

getTemporalFormatSupport

@SPI({IMPLEMENT,SUPPLY})
public TemporalFormatSupport getTemporalFormatSupport()

Description copied from class: Dialect

Supply datetime-format translation. Return one stable, non-null, thread-safe implementation.

Overrides:

getTemporalFormatSupport in class Dialect

See Also:

• TemporalFormatSupport

getCurrentTemporalSupport

@SPI({IMPLEMENT,SUPPLY})
public CurrentTemporalSupport getCurrentTemporalSupport()

Description copied from class: Dialect

Supply current temporal expressions and database-side timestamp retrieval. Return one stable, non-null, thread-safe implementation. Providers may implement CurrentTemporalSupport directly and return this.

Overrides:

getCurrentTemporalSupport in class AbstractTransactSQLDialect

See Also:

• CurrentTemporalSupport

getMinimumSupportedVersion

@SPI({IMPLEMENT,SUPPLY})
protected DatabaseVersion getMinimumSupportedVersion()

Description copied from class: Dialect

Get the version of the SQL dialect that is the minimum supported by this implementation.

This method is called during superclass construction. Implementations must return construction-safe immutable data and must not depend on subclass initialization.

Overrides:

getMinimumSupportedVersion in class Dialect

getDriverKind

public SybaseDriverKind getDriverKind()

getDirectJavaTimeJdbcSupport

public DirectJavaTimeJdbcSupport getDirectJavaTimeJdbcSupport()

Description copied from class: Dialect

Supply direct JDBC access capabilities for Java Time classes. Return one stable, non-null, thread-safe implementation.

Overrides:

getDirectJavaTimeJdbcSupport in class Dialect

Returns:

the direct Java Time JDBC support for this Dialect and driver

See Also:

• DirectJavaTimeJdbcSupport

resolveSqlTypeDescriptor

@SPI({USE,IMPLEMENT})
public JdbcType resolveSqlTypeDescriptor(String columnTypeName,
 int jdbcTypeCode,
 int precision,
 int scale,
 JdbcTypeRegistry jdbcTypeRegistry)

Description copied from class: Dialect

Resolve the non-null JDBC descriptor for result-set metadata.

Preserve vendor replacement and array-component resolution, and delegate unmatched codes to jdbcTypeRegistry.

Overrides:

resolveSqlTypeDescriptor in class AbstractTransactSQLDialect

resolveSqlTypeLength

@SPI({USE,IMPLEMENT})
public int resolveSqlTypeLength(String columnTypeName,
 int jdbcTypeCode,
 int precision,
 int scale,
 int displaySize)

Description copied from class: Dialect

Normalize JDBC result-set metadata to Hibernate's resolved column length.

JDBC precision may represent character length. Providers should retain their vendor formulas using all supplied metadata values.

Overrides:

resolveSqlTypeLength in class Dialect

getSyntheticTableGroupSupport

public SyntheticTableGroupSupport getSyntheticTableGroupSupport()

Description copied from class: Dialect

Supply the strategy for synthetic table roots required while converting grouping and ordering expressions to SQL AST.

Return one non-null immutable or thread-safe strategy whose answers remain stable for this Dialect's lifetime. This strategy controls query structure; it does not apply to DDL, temporary tables, or no-column inserts.

Overrides:

getSyntheticTableGroupSupport in class Dialect

Returns:

the synthetic-table strategy

See Also:

• SyntheticTableGroupSupport

getSqlAstTranslatorFactory

@SPI({IMPLEMENT,SUPPLY})
public SqlAstTranslatorFactory getSqlAstTranslatorFactory()

Description copied from class: Dialect

Supply the factory for this Dialect's single-use SQL AST translators.

Return null to use StandardSqlAstTranslatorFactory. A custom Dialect should normally return a reusable factory derived from that class and create translators derived from AbstractSqlAstTranslator or an appropriate supported family base. The factory must not retain translation requests, and every translator it returns is used for one translation.

Overrides:

getSqlAstTranslatorFactory in class Dialect

See Also:

• SqlAstTranslatorFactory
• JdbcEnvironment.getSqlAstTranslatorFactory()

getLockingSupport

public LockingSupport getLockingSupport()

Description copied from class: Dialect

Supplies the cohesive pessimistic-locking profile for this Dialect.

The profile coordinates capability metadata, statement-clause rendering, table hints, already-rendered SQL rewriting, connection timeout handling, and follow-on locking. A custom Dialect should supply one internally consistent profile instead of overriding those behaviors independently. The returned support must be non-null and stable for the Dialect lifetime; its components may be reused concurrently and must not retain per-query requests.

Overrides:

getLockingSupport in class Dialect

See Also:

• LockingSupport

getNullOrderingSupport

public NullOrderingSupport getNullOrderingSupport()

Description copied from class: Dialect

Supply the database's default null ordering and explicit null-precedence syntax capabilities.

Override this method with a stable, non-null profile when the database's default null placement differs from NullOrderingSupport.STANDARD, or when it cannot render nulls first and nulls last natively. Dialect subclasses refining a family profile should copy Dialect.getNullOrderingSupport() from the superclass and change only the values which differ.

Overrides:

getNullOrderingSupport in class AbstractTransactSQLDialect

Returns:

the stable, non-null null-ordering-support profile

getParameterLimits

public ParameterLimits getParameterLimits()

Description copied from class: Dialect

Supplies the database limits for IN-expression elements and total JDBC statement parameters.

Return a non-null, immutable profile whose values remain stable for this Dialect's lifetime. Use ParameterLimits.UNLIMITED when neither limit applies and ParameterLimits.of(int) when both limits are identical. Keep the dimensions independent when the database imposes different expression and statement limits; Hibernate uses them for different planning decisions.

Overrides:

getParameterLimits in class Dialect

Returns:

the non-null parameter-limit profile

contributeTypes

@SPI({IMPLEMENT,SUPPLY})
public void contributeTypes(TypeContributions typeContributions,
 ServiceRegistry serviceRegistry)

Description copied from class: Dialect

Contribute database-specific Java, JDBC, DDL, and basic type descriptors.

Override this method when the database or JDBC driver requires descriptors beyond the inherited registrations. Invoke super first unless the Dialect intentionally replaces the complete inherited contribution protocol. Obtain reusable dialect-specific JDBC descriptors from the family facades in org.hibernate.dialect.type.spi, and preserve whether a descriptor replaces an existing registration or is added only when absent.

Overrides:

contributeTypes in class AbstractTransactSQLDialect

Parameters:

typeContributions - the Hibernate-supplied contribution registry

serviceRegistry -

the Hibernate-supplied services, including class loading used by driver-backed descriptor factories

Mutate the supplied boot-scoped registries only during this callback and do not retain the contribution context or a mutable registry afterward. Implement an independent TypeContributor instead when the contribution is not owned by a Dialect.

getNationalizationSupport

@SPI({IMPLEMENT,SUPPLY})
public NationalizationSupport getNationalizationSupport()

Description copied from class: Dialect

Describe how this database represents nationalized character data.

This database SQL-type capability is independent of whether the JDBC driver correctly implements nationalized access methods. Override Dialect.supportsNationalizedMethods() separately when the driver cannot use those methods.

Overrides:

getNationalizationSupport in class Dialect

Returns:

the database nationalization profile

See Also:

• NationalizationSupport
• Dialect.supportsNationalizedMethods()

supportsNationalizedMethods

@SPI({IMPLEMENT,SUPPLY})
public boolean supportsNationalizedMethods()

Description copied from class: Dialect

Determine whether the JDBC driver correctly implements the nationalized ResultSet, PreparedStatement, and CallableStatement methods.

This driver capability is independent of the database SQL-type semantics described by Dialect.getNationalizationSupport(). A provider should return false when the driver requires the ordinary character methods even if the database supports explicit nationalized types.

Overrides:

supportsNationalizedMethods in class Dialect

Returns:

true when nationalized JDBC access methods may be used

See Also:

• NationalizationSupport
• Dialect.getNationalizationSupport()

getStringValueSemantics

@SPI({IMPLEMENT,SUPPLY})
public StringValueSemantics getStringValueSemantics()

Description copied from class: Dialect

Supply the database's stable string-value semantics.

Overrides:

getStringValueSemantics in class Dialect

Returns:

the non-null string-value profile

See Also:

• StringValueSemantics

initializeFunctionRegistry

@SPI({IMPLEMENT,SUPPLY})
public void initializeFunctionRegistry(FunctionContributions functionContributions)

Description copied from class: Dialect

Contribute the database-specific function descriptors after independent function contributors have run.

Override this callback to extend or replace the inherited function set. Invoke super first to retain Hibernate's standard and emulated registrations; omitting it deliberately replaces that set. Mutate the supplied boot-scoped function registry only during this callback, and do not retain the contribution context or registry afterward. Implement an independent FunctionContributor instead when the contribution is not owned by a Dialect.

Overrides:

initializeFunctionRegistry in class AbstractTransactSQLDialect

Parameters:

functionContributions - the Hibernate-supplied function contribution target

See Also:

• FunctionContributions
• FunctionContributor
• SqmFunctionRegistry
• SqmFunctionDescriptor
• CommonFunctionFactory

appendDefinition

@SPI({USE,IMPLEMENT})
public void appendDefinition(SqlAppender appender,
 ColumnDefinitionRequest request)

Specified by:

appendDefinition in interface ColumnDefinitionSupport

getSchemaNameResolver

@SPI({IMPLEMENT,SUPPLY})
public SchemaNameResolver getSchemaNameResolver()

Description copied from class: Dialect

Supply the strategy which resolves the current schema for a JDBC connection.

Return a stable, non-null resolver. Use the default resolver unless the driver cannot implement Connection.getSchema() correctly.

Overrides:

getSchemaNameResolver in class Dialect

See Also:

• SchemaNameResolver

getNamespaceSupport

@SPI({IMPLEMENT,SUPPLY})
public NamespaceSupport getNamespaceSupport()

Description copied from class: Dialect

Supply catalog and schema lifecycle behavior to schema tooling.

Return one stable, non-null strategy. Prefer a complete immutable profile from NamespaceSupports, and implement NamespaceSupport directly only for custom or multi-command namespace SQL.

Overrides:

getNamespaceSupport in class Dialect

See Also:

• NamespaceSupport

getMaxIdentifierLength

@SPI({USE,IMPLEMENT})
public int getMaxIdentifierLength()

Description copied from interface: IdentifierSupport

Return the database's maximum identifier length.

Specified by:

getMaxIdentifierLength in interface IdentifierSupport

castPattern

@SPI({USE,IMPLEMENT})
public String castPattern(CastType from,
 CastType to)

Description copied from class: Dialect

Obtain a pattern for the SQL equivalent to a cast() function call. The resulting pattern must contain ?1 and ?2 placeholders for the arguments.

Overrides:

castPattern in class Dialect

Parameters:

from - a CastType indicating the type of the value argument

to - a CastType indicating the type the value argument is cast to

appendDateTimeLiteral

@SPI({USE,IMPLEMENT})
public void appendDateTimeLiteral(SqlAppender appender,
 TemporalAccessor temporalAccessor,
 TemporalType precision,
 TimeZone jdbcTimeZone)

Description copied from class: Dialect

Append a datetime literal for a java.time value.

Preserve the value's offset only when the Dialect's temporal-value semantics permit it. Append immediately and retain no invocation state.

Specified by:

appendDateTimeLiteral in interface LiteralSupport

Overrides:

appendDateTimeLiteral in class Dialect

appendDateTimeLiteral

@SPI({USE,IMPLEMENT})
public void appendDateTimeLiteral(SqlAppender appender,
 Date date,
 TemporalType precision,
 TimeZone jdbcTimeZone)

Description copied from class: Dialect

Append a datetime literal for a legacy Date value.

Apply the supplied JDBC time zone where required, append immediately, and retain no invocation state.

Specified by:

appendDateTimeLiteral in interface LiteralSupport

Overrides:

appendDateTimeLiteral in class Dialect

appendDateTimeLiteral

@SPI({USE,IMPLEMENT})
public void appendDateTimeLiteral(SqlAppender appender,
 Calendar calendar,
 TemporalType precision,
 TimeZone jdbcTimeZone)

Description copied from class: Dialect

Append a datetime literal for a Calendar value.

Preserve Calendar-specific time-zone and millisecond semantics, append immediately, and retain no invocation state.

Specified by:

appendDateTimeLiteral in interface LiteralSupport

Overrides:

appendDateTimeLiteral in class Dialect

translateExtractField

@SPI({USE,IMPLEMENT})
public String translateExtractField(TemporalUnit unit)

Description copied from interface: TemporalOperationSupport

Translate an extraction field name.

Specified by:

translateExtractField in interface TemporalOperationSupport

extractPattern

@SPI({USE,IMPLEMENT})
public String extractPattern(TemporalUnit unit)

Description copied from interface: TemporalOperationSupport

Return an extraction pattern containing ?1 for the field and ?2 for the value.

Specified by:

extractPattern in interface TemporalOperationSupport

timestampaddPattern

@SPI({USE,IMPLEMENT})
public String timestampaddPattern(TemporalUnit unit,
 TemporalType temporalType,
 IntervalType intervalType)

Description copied from interface: TemporalOperationSupport

Return a timestamp-add pattern containing ?1, ?2, and ?3.

Specified by:

timestampaddPattern in interface TemporalOperationSupport

timestampdiffPattern

@SPI({USE,IMPLEMENT})
public String timestampdiffPattern(TemporalUnit unit,
 TemporalType fromTemporalType,
 TemporalType toTemporalType)

Description copied from interface: TemporalOperationSupport

Return a timestamp-difference pattern containing ?1, ?2, and ?3.

Specified by:

timestampdiffPattern in interface TemporalOperationSupport

appendFormat

@SPI({USE,IMPLEMENT})
public void appendFormat(SqlAppender appender,
 String format)

Description copied from interface: TemporalFormatSupport

Append the database translation of the supplied Hibernate format pattern.

Specified by:

appendFormat in interface TemporalFormatSupport

usesStandardCurrentTimestampFunction

@SPI({USE,IMPLEMENT})
public boolean usesStandardCurrentTimestampFunction()

Description copied from interface: CurrentTemporalSupport

Whether CurrentTemporalSupport.currentTimestamp() uses the standard SQL current_timestamp function. This capability is useful when SQL text supplied outside the Dialect, such as a column default, assumes the standard spelling.

Specified by:

usesStandardCurrentTimestampFunction in interface CurrentTemporalSupport

currentTimestamp

@SPI({USE,IMPLEMENT})
public String currentTimestamp()

Description copied from interface: CurrentTemporalSupport

Render the current SQL timestamp expression used for java.sql.Timestamp.

Specified by:

currentTimestamp in interface CurrentTemporalSupport

buildIdentifierHelper

@SPI({USE,IMPLEMENT,SUPPLY})
public IdentifierHelper buildIdentifierHelper(IdentifierHelperBuildRequest request)

Description copied from interface: IdentifierSupport

Build and supply the configured identifier helper from the stable JDBC metadata snapshot and selected keyword strategy.

This inherited implementation initializes identifier casing, keywords, and namespace support from the request. Invoke it before replacing any of those values with authoritative provider settings, then build the final helper from the same builder. Settings which this implementation does not initialize may be applied before invoking it. If builder configuration cannot express a database rule, decorate the final helper with DelegatingIdentifierHelper. Do not retain the request, builder, or metadata view.

Specified by:

buildIdentifierHelper in interface IdentifierSupport

See Also:

• IdentifierHelper

getNameQualifierSupport

@SPI({IMPLEMENT,SUPPLY})
public NameQualifierSupport getNameQualifierSupport()

Description copied from class: Dialect

Supply catalog and schema qualification support, or return null to use DatabaseMetaData.

This value does not define the catalog separator; override Dialect.getCatalogSeparator() independently when the metadata-free fallback is not ..

Overrides:

getNameQualifierSupport in class Dialect

See Also:

• NameQualifierSupport

getUniqueDelegate

@SPI({IMPLEMENT,SUPPLY})
public UniqueDelegate getUniqueDelegate()

Description copied from class: Dialect

Supply the stable strategy used for unique-key representation and DDL.

Return a stock profile from UniqueDelegates, or a stable provider-owned implementation or decorator. Do not import a Hibernate .internal leaf.

Overrides:

getUniqueDelegate in class Dialect

See Also:

• UniqueDelegate

getCallableStatementSupport

@SPI({IMPLEMENT,SUPPLY})
public CallableStatementSupport getCallableStatementSupport()

Description copied from class: Dialect

Supply the callable-statement protocol for this database and JDBC driver.

Return one non-null strategy whose behavior remains stable for this Dialect's lifetime. Use CallableStatementSupports for the standard and stock database protocols.

Overrides:

getCallableStatementSupport in class Dialect

Returns:

the callable-statement strategy

See Also:

• CallableStatementSupport

getJdbcMetadataOverrides

@SPI({IMPLEMENT,SUPPLY})
public JdbcMetadataOverrides getJdbcMetadataOverrides()

Description copied from class: Dialect

Supply the stable overrides applied to raw JDBC metadata reports.

Return one non-null immutable profile whose identity and answers remain stable for this Dialect's lifetime. Use REPORTED to retain Hibernate's interpreted driver answer, and force SUPPORTED or UNSUPPORTED only when the selected driver report is known to be inaccurate. This profile controls effective JDBC behavior, not callable SQL syntax.

Overrides:

getJdbcMetadataOverrides in class Dialect

Returns:

the effective JDBC metadata overrides

See Also:

• JdbcMetadataOverrides

alterColumnType

@SPI({USE,IMPLEMENT})
public String alterColumnType(AlterColumnTypeRequest request)

Specified by:

alterColumnType in interface AlterTableSupport

getIdentityColumnSupport

@SPI({IMPLEMENT,SUPPLY})
public IdentityColumnSupport getIdentityColumnSupport()

Supply the identity profile matching the resolved Sybase JDBC driver. Preserve the inferred generated-keys path for jTDS and the appended-select path for jConnect and other drivers.

Overrides:

getIdentityColumnSupport in class AbstractTransactSQLDialect

Since:

8.0

getDmlTargetColumnQualifierSupport

@SPI({USE,IMPLEMENT,SUPPLY})
public DmlTargetColumnQualifierSupport getDmlTargetColumnQualifierSupport()

Description copied from class: Dialect

The qualifier form accepted for target-column references in update and delete statements.

Translators use this value when rendering assignments and predicates. A custom Dialect should return the least permissive form required by the database, not a form used only by an emulation.

Overrides:

getDmlTargetColumnQualifierSupport in class Dialect

Returns:

the non-null target-column qualifier support

See Also:

• DmlTargetColumnQualifierSupport

getValuesListSupport

public ValuesListSupport getValuesListSupport()

Description copied from class: Dialect

The contexts in which this Dialect supports native multi-row values syntax.

The returned immutable profile must be non-null and stable for the lifetime of this Dialect. Report only native syntax support; translator emulation is selected separately.

Overrides:

getValuesListSupport in class Dialect

getMutationSyntaxSupport

public MutationSyntaxSupport getMutationSyntaxSupport()

Description copied from class: Dialect

The native SQL mutation-syntax capabilities of this Dialect.

The returned immutable profile must be non-null and stable for the lifetime of this Dialect. Report syntax which the translator may use directly; do not report a capability merely because it can be emulated. QueryMutationRenderingSupport consumes this profile when selecting a native or emulated plan.

Overrides:

getMutationSyntaxSupport in class Dialect

getRowValueSupport

public RowValueSupport getRowValueSupport()

Description copied from class: Dialect

The native row-value syntax of this Dialect.

Override this method to supply explicit row(a, b) construction, row equality, ordering, and distinctness comparisons, row-valued IN lists, row-valued IN subqueries, and quantified row comparisons. Treat each feature as an exact native-syntax declaration: do not infer IN-subquery support from IN-list support or explicit row construction from comparison support. Copy the superclass profile when refining an inherited Dialect family. Return one immutable, non-null profile whose values remain stable for the lifetime of this Dialect.

Overrides:

getRowValueSupport in class Dialect

Returns:

this Dialect's stable row-value-support profile

getCteSupport

public CteSupport getCteSupport()

Description copied from class: Dialect

The common-table-expression capabilities of this Dialect.

The returned immutable profile must be non-null and stable for the lifetime of this Dialect. Hibernate may cache and reuse it. Overrides may construct a new profile or copy CteSupport.STANDARD; invoking super is not required. This method is called only after Dialect construction, has no corresponding shutdown lifecycle, and failures propagate to the operation which obtains the profile.

Overrides:

getCteSupport in class Dialect

addPartitionKeyToPrimaryKey

@SPI({USE,IMPLEMENT})
public boolean addPartitionKeyToPrimaryKey()

Description copied from class: Dialect

Whether every table partition key must also occur in its primary key.

Return true only when the database requires the rule for both ordinary and temporal-history tables. This has nothing to do with window-function partitioning.

Overrides:

addPartitionKeyToPrimaryKey in class Dialect