Top Description Constructors Methods
org.hibernate.dialect

public Class SybaseASE15Dialect

extends AbstractTransactSQLDialect
Class Inheritance
Known Direct Subclasses
org.hibernate.dialect.SybaseASE157Dialect
Imports
java.sql.Types, org.hibernate.dialect.function.AnsiTrimEmulationFunction, .NoArgSQLFunction, .SQLFunctionTemplate, .VarArgsSQLFunction, org.hibernate.type.StandardBasicTypes
An SQL dialect targeting Sybase Adaptive Server Enterprise (ASE) 15 and higher.

TODO : verify if this also works with 12/12.5

Author
Gavin King

Constructor Summary

AccessConstructor and Description
public
SybaseASE15Dialect()

Method Summary

Modifier and TypeMethod and Description
public boolean
areStringComparisonsCaseInsensitive()

Overrides org.hibernate.dialect.Dialect.areStringComparisonsCaseInsensitive.

By default, Sybase string comparisons are case-insensitive.
public String
getCrossJoinSeparator()

Overrides org.hibernate.dialect.Dialect.getCrossJoinSeparator.

Get the separator to use for defining cross joins when translating HQL queries.
public String
getCurrentTimestampSQLFunctionName()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSQLFunctionName.

The name of the database-specific SQL function for retrieving the current timestamp.
public int
getMaxAliasLength()

Overrides org.hibernate.dialect.Dialect.getMaxAliasLength.

What is the maximum length Hibernate can use for generated aliases?
private void
registerSybaseKeywords()

public boolean
supportsCascadeDelete()

Overrides org.hibernate.dialect.Dialect.supportsCascadeDelete.

public boolean

Returns:

false.
supportsExpectedLobUsagePattern()

Overrides org.hibernate.dialect.Dialect.supportsExpectedLobUsagePattern.

Actually Sybase does not support LOB locators at al.
public boolean
supportsUniqueConstraintInCreateAlterTable()

Overrides org.hibernate.dialect.Dialect.supportsUniqueConstraintInCreateAlterTable.

Does this dialect support adding Unique constraints via create and alter table ?
Inherited from org.hibernate.dialect.AbstractTransactSQLDialect:
appendIdentitySelectToInsertappendLockHintapplyLocksToSqldoesReadCommittedCauseWritersToBlockReadersdoesRepeatableReadCauseReadersToBlockWritersdropTemporaryTableAfterUsegenerateTemporaryTableNamegetAddColumnStringgetCurrentTimestampSelectStringgetForUpdateStringgetIdentityColumnStringgetIdentitySelectStringgetNullColumnStringgetResultSetgetSelectGUIDStringisCurrentTimestampSelectStringCallablequalifyIndexNameregisterResultSetOutParametersupportsCurrentTimestampSelectionsupportsEmptyInListsupportsExistsInSelectsupportsIdentityColumnssupportsInsertSelectIdentitysupportsTemporaryTablessupportsTupleDistinctCountssupportsUnionAll

Constructor Detail

SybaseASE15Dialectback to summary
public SybaseASE15Dialect()

Method Detail

areStringComparisonsCaseInsensitiveback to summary
public boolean areStringComparisonsCaseInsensitive()

Overrides org.hibernate.dialect.Dialect.areStringComparisonsCaseInsensitive.

By default, Sybase string comparisons are case-insensitive.

If the DB is configured to be case-sensitive, then this return value will be incorrect.

Returns:boolean

Doc from org.hibernate.dialect.Dialect.areStringComparisonsCaseInsensitive.

True if comparisons are case insensitive.

getCrossJoinSeparatorback to summary
public String getCrossJoinSeparator()

Overrides org.hibernate.dialect.Dialect.getCrossJoinSeparator.

Doc from org.hibernate.dialect.Dialect.getCrossJoinSeparator.

Get the separator to use for defining cross joins when translating HQL queries.

Typically this will be either [ cross join ] or [, ]

Note that the spaces are important!

getCurrentTimestampSQLFunctionNameback to summary
public String getCurrentTimestampSQLFunctionName()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSQLFunctionName.

Doc from org.hibernate.dialect.Dialect.getCurrentTimestampSQLFunctionName.

The name of the database-specific SQL function for retrieving the current timestamp.

Returns:String

The function name.

getMaxAliasLengthback to summary
public int getMaxAliasLength()

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.

registerSybaseKeywordsback to summary
private void registerSybaseKeywords()
supportsCascadeDeleteback to summary
public boolean supportsCascadeDelete()

Overrides org.hibernate.dialect.Dialect.supportsCascadeDelete.

supportsExpectedLobUsagePatternback to summary
public boolean supportsExpectedLobUsagePattern()

Overrides org.hibernate.dialect.Dialect.supportsExpectedLobUsagePattern.

Actually Sybase does not support LOB locators at al.

Returns:boolean

false.

supportsUniqueConstraintInCreateAlterTableback to summary
public boolean supportsUniqueConstraintInCreateAlterTable()

Overrides org.hibernate.dialect.Dialect.supportsUniqueConstraintInCreateAlterTable.

Doc from org.hibernate.dialect.Dialect.supportsUniqueConstraintInCreateAlterTable.

Does this dialect support adding Unique constraints via create and alter table ?

Returns:boolean

boolean