public Class SybaseASEDialect

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

mode: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.buildSQLExceptionConversionDelegate.

Doc from org.hibernate.dialect.Dialect.buildSQLExceptionConversionDelegate.

An instance of SQLExceptionConversionDelegate for interpreting dialect-specific error or SQLState codes.

If this method is overridden to return a non-null value, the default SQLExceptionConverter will use the returned SQLExceptionConversionDelegate in addition to the following standard delegates:

1. a "static" delegate based on the JDBC4-defined SQLException hierarchy, and
2. a delegate that interprets SQLState codes as either X/Open or SQL-2003 codes, depending on what is reported by the JDBC driver.

It is strongly recommended that every Dialect implementation override this method, since interpretation of a SQL error is much more accurate when based on the vendor-specific error code, rather than on the SQLState.

Returns:SQLExceptionConversionDelegate

The SQLExceptionConversionDelegate for this dialect

Annotations

@Override

Overrides org.hibernate.dialect.SybaseDialect.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.currentDate.

Doc from org.hibernate.dialect.Dialect.currentDate.

Translation of the HQL/JPQL current_date function, which maps to the Java type java.sql.Date, and of the HQL local_date function which maps to the Java type java.time.LocalDate.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.currentTime.

Doc from org.hibernate.dialect.Dialect.currentTime.

Translation of the HQL/JPQL current_time function, which maps to the Java type java.sql.Time which is a time with no time zone. This contradicts ANSI SQL where current_time has the type TIME WITH TIME ZONE.

It is recommended to override this in dialects for databases which support localtime or time at local.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.currentTimestamp.

Doc from org.hibernate.dialect.Dialect.currentTimestamp.

Translation of the HQL/JPQL current_timestamp function, which maps to the Java type java.sql.Timestamp which is a datetime with no time zone. This contradicts ANSI SQL where current_timestamp has the type TIMESTAMP WITH TIME ZONE.

It is recommended to override this in dialects for databases which support localtimestamp or timestamp at local.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getDoublePrecision.

Doc from org.hibernate.dialect.Dialect.getDoublePrecision.

This is the default precision for a generated column mapped to a Java Double or double. That is, a value representing "double precision".

Usually 53 binary digits, at least for databases with a conventional interpretation of the ANSI SQL specification.

Returns:int

a value representing "double precision", usually in binary digits, but sometimes in decimal digits

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getFloatPrecision.

Doc from org.hibernate.dialect.Dialect.getFloatPrecision.

This is the default precision for a generated column mapped to a Java Float or float. That is, a value representing "single precision".

Usually 24 binary digits, at least for databases with a conventional interpretation of the ANSI SQL specification.

Returns:int

a value representing "single precision", usually in binary digits, but sometimes in decimal digits

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getFractionalSecondPrecisionInNanos.

Sybase ASE in principle supports microsecond precision for {code bigdatetime}, but unfortunately its duration arithmetic functions have a nasty habit of overflowing. So to give ourselves a little extra headroom, we will use millisecond as the native unit of precision.

Returns:long

Doc from org.hibernate.dialect.Dialect.getFractionalSecondPrecisionInNanos.

the precision, specified as a quantity of nanoseconds

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getLimitHandler.

Doc from org.hibernate.dialect.Dialect.getLimitHandler.

Obtain a LimitHandler that implements pagination support for Query#setMaxResults(int) and Query#setFirstResult(int).

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getMaxAliasLength.

Doc from org.hibernate.dialect.Dialect.getMaxAliasLength.

What is the maximum length Hibernate can use for generated aliases?

Returns:int

The maximum length.

Annotations

@Override

Overrides org.hibernate.dialect.SybaseDialect.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.getMaxVarcharLength.

Doc from org.hibernate.dialect.Dialect.getMaxVarcharLength.

The biggest size value that can be supplied as argument to a java.sql.Types#VARCHAR-like type.

For longer column lengths, use some sort of text-like type for the column.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getSizeStrategy.

Doc from org.hibernate.dialect.Dialect.getSizeStrategy.

A custom SizeStrategy for column types.

Annotations

@Override

Overrides org.hibernate.dialect.SybaseDialect.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.getTableTypeString.

Doc from org.hibernate.dialect.Dialect.getTableTypeString.

An arbitrary fragment appended to the end of the create table statement.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getViolatedConstraintNameExtractor.

Implements org.hibernate.exception.spi.ConversionContext.getViolatedConstraintNameExtractor.

Doc from org.hibernate.dialect.Dialect.getViolatedConstraintNameExtractor.

A ViolatedConstraintNameExtractor for extracting the name of a violated constraint from a SQLException.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.isAnsiNullOn.

Doc from org.hibernate.dialect.Dialect.isAnsiNullOn.

A setting specific to SybaseASEDialect.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.resolveSqlTypeLength.

Doc from org.hibernate.dialect.Dialect.resolveSqlTypeLength.

Determine the length/precision of a column based on information in the JDBC java.sql.ResultSetMetaData. Note that what JDBC reports as a "precision" might actually be the column length.

Parameters

columnTypeName:String

the name of the column type

jdbcTypeCode:int

the JDBC type code of the column type

precision:int

the (numeric) precision or (character) length of the column

scale:int

the scale of a numeric column

displaySize:int

the display size of the column

Returns:int

the precision or length of the column

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsBitType.

The Sybase ASE BIT type does not allow null values, so we don't use it.

Returns:boolean

false

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsCascadeDelete.

Doc from org.hibernate.dialect.Dialect.supportsCascadeDelete.

Does this dialect support on delete actions in foreign key definitions?

Returns:boolean

true if the dialect does support the on delete clause.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsDistinctFromPredicate.

Doc from org.hibernate.dialect.Dialect.supportsDistinctFromPredicate.

Does this dialect support some kind of distinct from predicate?

That is, does it support syntax like:

... where FIRST_NAME IS DISTINCT FROM LAST_NAME

Returns:boolean

True if this SQL dialect is known to support some kind of distinct from predicate; false otherwise

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsLobValueChangePropagation.

Doc from org.hibernate.dialect.Dialect.supportsLobValueChangePropagation.

Does the dialect support propagating changes to LOB values back to the database? Talking about mutating the internal value of the locator, as opposed to supplying a new locator instance.

• For BLOBs, the internal value might be changed by: Blob#setBinaryStream, Blob#setBytes(long, byte[]), Blob#setBytes(long, byte[], int, int), or Blob#truncate(long).
• For CLOBs, the internal value might be changed by: Clob#setAsciiStream(long), Clob#setCharacterStream(long), Clob#setString(long, String), Clob#setString(long, String, int, int), or Clob#truncate(long).

Returns:boolean

True if the changes are propagated back to the database; false otherwise.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsLockTimeouts.

Doc from org.hibernate.dialect.Dialect.supportsLockTimeouts.

Does this dialect support specifying timeouts when requesting locks.

Returns:boolean

True is this dialect supports specifying lock timeouts.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsOrderByInSubquery.

Doc from org.hibernate.dialect.Dialect.supportsOrderByInSubquery.

Does this dialect support the order by clause in subqueries?

For example:

select * from Table1 where col1 in (select col1 from Table2 order by col2 limit 1)

Returns:boolean

true if it does

Annotations

@Override

Overrides org.hibernate.dialect.AbstractTransactSQLDialect.supportsPartitionBy.

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

Does is dialect support partition by?

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsSkipLocked.

Doc from org.hibernate.dialect.Dialect.supportsSkipLocked.

Does this dialect support SKIP_LOCKED timeout.

Returns:boolean

true if SKIP_LOCKED is supported

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsUnionInSubquery.

Doc from org.hibernate.dialect.Dialect.supportsUnionInSubquery.

Does this dialect support UNION in a subquery.

Returns:boolean

True if UNION is supported in a subquery; false otherwise.

Annotations

@Override

Overrides org.hibernate.dialect.SybaseDialect.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.SybaseDialect.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.toQuotedIdentifier.

Doc from org.hibernate.dialect.Dialect.toQuotedIdentifier.

Apply dialect-specific quoting.

Parameters

name:String

The value to be quoted.

Returns:String

The quoted value.

Annotations

@Override