public Class SybaseDialect

Overrides org.hibernate.dialect.Dialect.appendDatetimeFormat.

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

Since it's never possible to translate every pattern letter sequences understood by DateTimeFormatter, only the following subset of pattern letters is accepted by Hibernate:

• G: era
• y: year of era
• Y: year of week-based year
• M: month of year
• w: week of week-based year (ISO week number)
• W: week of month
• E: day of week (name)
• e: day of week (number)
• d: day of month
• D: day of year
• a: AM/PM
• H: hour of day (24 hour time)
• h: hour of AM/PM (12 hour time)
• m: minutes
• s: seconds
• z,Z,x: timezone offset

In addition, punctuation characters and single-quoted literal strings are accepted.

Appends a pattern accepted by the function that formats dates and times in this dialect to a SQL fragment that is being constructed.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.appendDateTimeLiteral.

Doc from org.hibernate.dialect.Dialect.appendDateTimeLiteral.

Append a datetime literal representing the given java.time value to the given SqlAppender.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.appendDateTimeLiteral.

Doc from org.hibernate.dialect.Dialect.appendDateTimeLiteral.

Append a datetime literal representing the given Date value to the given SqlAppender.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.appendDateTimeLiteral.

Doc from org.hibernate.dialect.Dialect.appendDateTimeLiteral.

Append a datetime literal representing the given Calendar value to the given SqlAppender.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.buildIdentifierHelper.

Doc from org.hibernate.dialect.Dialect.buildIdentifierHelper.

The IdentifierHelper indicated by this dialect for handling identifier conversions. Returning null is allowed and indicates that Hibernate should fall back to building a "standard" helper. In the fallback path, any changes made to the IdentifierHelperBuilder during this call will still be incorporated into the built IdentifierHelper.

The incoming builder will have the following set:

• IdentifierHelperBuilder#isGloballyQuoteIdentifiers()
• IdentifierHelperBuilder#getUnquotedCaseStrategy() - initialized to UPPER
• IdentifierHelperBuilder#getQuotedCaseStrategy() - initialized to MIXED

By default, Hibernate will do the following:

• Call IdentifierHelperBuilder#applyIdentifierCasing(DatabaseMetaData)
• Call IdentifierHelperBuilder#applyReservedWords(DatabaseMetaData)
• Applies AnsiSqlKeywords#sql2003() as reserved words
• Applies the {#link #sqlKeywords} collected here as reserved words
• Applies the Dialect's NameQualifierSupport, if it defines one

Parameters

builder:IdentifierHelperBuilder

A partially-configured IdentifierHelperBuilder.

dbMetaData:DatabaseMetaData

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

Warning

it may be null.

Returns:IdentifierHelper

The IdentifierHelper instance to use, or null to indicate Hibernate should use its fallback path

Annotations

@Override

Exceptions

SQLException:

Accessing the DatabaseMetaData can throw it. Just rethrow and Hibernate will handle it.

Overrides org.hibernate.dialect.Dialect.canCreateSchema.

Doc from org.hibernate.dialect.Dialect.canCreateSchema.

Does this dialect support creating and dropping schema?

Returns:boolean

True if the dialect supports schema creation; false otherwise.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.castPattern.

Doc from org.hibernate.dialect.Dialect.castPattern.

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

Parameters

from:CastType

a CastType indicating the type of the value argument

to:CastType

a CastType indicating the type the value argument is cast to

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.contributeTypes.

Doc from org.hibernate.dialect.Dialect.contributeTypes.

A callback which allows the Dialect to contribute types.

Parameters

typeContributions:TypeContributions

Callback to contribute the types

serviceRegistry:ServiceRegistry

The service registry

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.extractPattern.

Doc from org.hibernate.dialect.Dialect.extractPattern.

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

This method does not need to handle TemporalUnit#NANOSECOND, TemporalUnit#NATIVE, TemporalUnit#OFFSET, TemporalUnit#DATE, TemporalUnit#TIME, TemporalUnit#WEEK_OF_YEAR, or TemporalUnit#WEEK_OF_MONTH, which are already desugared by ExtractFunction.

Parameters

unit:TemporalUnit

the first argument

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getAlterColumnTypeString.

Doc from 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. Often alter column col_name set data type col_type.

Parameters

columnName:String

the name of the column

columnType:String

the new type of the column

columnDefinition:String

the full column definition

Returns:String

a fragment to be appended to alter table

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getCallableStatementSupport.

Doc from org.hibernate.dialect.Dialect.getCallableStatementSupport.

The CallableStatementSupport for this database. Does this database support returning cursors?

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getCurrentSchemaCommand.

Doc from org.hibernate.dialect.Dialect.getCurrentSchemaCommand.

Get the SQL command used to retrieve the current schema name.

Works in conjunction with getSchemaNameResolver(), unless the resulting SchemaNameResolver does not need this information. For example, a custom implementation might make use of the Java 1.7 Connection#getSchema() method.

Returns:String

The current schema retrieval SQL

Annotations

@Override

Overrides org.hibernate.dialect.AbstractTransactSQLDialect.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.getInExpressionCountLimit.

Doc from org.hibernate.dialect.Dialect.getInExpressionCountLimit.

Return the limit that the underlying database places on the number of elements in an IN predicate. If the database defines no such limits, simply return zero or a number smaller than zero.

Returns:int

The limit, or a non-positive integer to indicate no limit.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getMaxIdentifierLength.

Doc from org.hibernate.dialect.Dialect.getMaxIdentifierLength.

What is the maximum identifier length supported by this dialect?

Returns:int

The maximum length.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getNameQualifierSupport.

Doc from org.hibernate.dialect.Dialect.getNameQualifierSupport.

The support for qualified identifiers.

By default, decide based on DatabaseMetaData.

Returns:NameQualifierSupport

The NameQualifierSupport, or null to use DatabaseMetaData.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getNationalizationSupport.

Doc from org.hibernate.dialect.Dialect.getNationalizationSupport.

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

That is, whether the use of Types#NCHAR, Types#NVARCHAR, and Types#NCLOB is required for nationalized character data.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getNullColumnString.

Doc from org.hibernate.dialect.Dialect.getNullColumnString.

The keyword used to specify a nullable column, usually "", but sometimes " null".

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getParameterCountLimit.

Doc from 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. If the database defines no such limits, simply return zero or a number smaller than zero. By default, Dialect returns the same value as getInExpressionCountLimit().

Returns:int

The limit, or a non-positive integer to indicate no limit.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getSqlAstTranslatorFactory.

Doc from org.hibernate.dialect.Dialect.getSqlAstTranslatorFactory.

Return a SqlAstTranslatorFactory specific to this dialect, or null to use the standard translator.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getSqmTranslatorFactory.

Doc from org.hibernate.dialect.Dialect.getSqmTranslatorFactory.

Return a SqmTranslatorFactory specific to this dialect, or null to use the standard translator.

Note that SessionFactoryOptions#getCustomSqmTranslatorFactory() has higher precedence since it comes directly from the user config.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getUniqueDelegate.

Doc from org.hibernate.dialect.Dialect.getUniqueDelegate.

Get the UniqueDelegate supported by this dialect

Returns:UniqueDelegate

The UniqueDelegate

Annotations

@Override

Overrides org.hibernate.dialect.AbstractTransactSQLDialect.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.AbstractTransactSQLDialect.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.supportsAlterColumnType.

Doc from org.hibernate.dialect.Dialect.supportsAlterColumnType.

Does this dialect support modifying the type of an existing column?

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsFractionalTimestampArithmetic.

Doc from org.hibernate.dialect.Dialect.supportsFractionalTimestampArithmetic.

Whether the database supports adding a fractional interval to a timestamp, for example timestamp + 0.5 second.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsNamedParameters.

Doc from org.hibernate.dialect.Dialect.supportsNamedParameters.

Override DatabaseMetaData#supportsNamedParameters().

Annotations

@Override

Exceptions

SQLException:

Accessing the DatabaseMetaData cause an exception. Just rethrow and Hibernate will handle it.

Overrides org.hibernate.dialect.Dialect.supportsNullPrecedence.

Doc from org.hibernate.dialect.Dialect.supportsNullPrecedence.

Does this dialect support nulls first and nulls last?

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsStandardCurrentTimestampFunction.

Doc from org.hibernate.dialect.Dialect.supportsStandardCurrentTimestampFunction.

Does this dialect have an ANSI SQL current_timestamp function?

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.timestampaddPattern.

Doc from org.hibernate.dialect.Dialect.timestampaddPattern.

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

Parameters

unit:TemporalUnit

The unit to add to the temporal

temporalType:TemporalType

The type of the temporal

intervalType:IntervalType

The type of interval to add or null if it's not a native interval

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.timestampdiffPattern.

Doc from org.hibernate.dialect.Dialect.timestampdiffPattern.

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

Parameters

unit:TemporalUnit

the first argument

fromTemporalType:TemporalType

true if the first argument is a timestamp, false if a date

toTemporalType:TemporalType

true if the second argument is

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.translateExtractField.

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

This method does not need to handle TemporalUnit#NANOSECOND, TemporalUnit#NATIVE, TemporalUnit#OFFSET, TemporalUnit#DATE, TemporalUnit#TIME, TemporalUnit#WEEK_OF_YEAR, nor TemporalUnit#WEEK_OF_MONTH, which are already desugared by ExtractFunction.

Annotations

@Override