Top Description Fields Constructors Methods
org.hibernate.dialect

public Class SQLServer2005Dialect

extends SQLServerDialect
Class Inheritance
Known Direct Subclasses
org.hibernate.dialect.SQLServer2008Dialect
Annotations
@SuppressWarnings:deprecation
Imports
java.sql.SQLException, .Types, org.hibernate.JDBCException, .LockMode, .LockOptions, .QueryTimeoutException, org.hibernate.dialect.function.NoArgSQLFunction, org.hibernate.dialect.pagination.LimitHandler, .SQLServer2005LimitHandler, org.hibernate.exception.LockTimeoutException, org.hibernate.exception.spi.SQLExceptionConversionDelegate, org.hibernate.internal.util.JdbcExceptionHelper, org.hibernate.type.StandardBasicTypes
A dialect for Microsoft SQL 2005. (HHH-3936 fix)
Authors
Yoryos Valotasios, Lukasz Antoniak (lukasz dot antoniak at gmail dot com)

Field Summary

Modifier and TypeField and Description
private static final int
MAX_LENGTH

Constructor Summary

AccessConstructor and Description
public
SQLServer2005Dialect()

Constructs a SQLServer2005Dialect

Method Summary

Modifier and TypeMethod and Description
public String
appendLockHint(LockOptions
The lock options to apply
lockOptions, String
The name of the table to which to apply the lock hint.
tableName)

Overrides org.hibernate.dialect.SQLServerDialect.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.
public SQLExceptionConversionDelegate
buildSQLExceptionConversionDelegate()

Overrides org.hibernate.dialect.Dialect.buildSQLExceptionConversionDelegate.

Build an instance of a SQLExceptionConversionDelegate for interpreting dialect-specific error or SQLState codes.
protected LimitHandler
getDefaultLimitHandler()

Overrides org.hibernate.dialect.SQLServerDialect.getDefaultLimitHandler.

public boolean
supportsNonQueryWithCTE()

Overrides org.hibernate.dialect.Dialect.supportsNonQueryWithCTE.

Does this dialect/database support non-query statements (e.g. INSERT, UPDATE, DELETE) with CTE (Common Table Expressions)?
public boolean
supportsNoWait()

Overrides org.hibernate.dialect.Dialect.supportsNoWait.

Does this dialect/database support NO_WAIT timeout.
public boolean
supportsSkipLocked()

Overrides org.hibernate.dialect.Dialect.supportsSkipLocked.

Does this dialect/database support SKIP_LOCKED timeout.
Inherited from org.hibernate.dialect.SQLServerDialect:
areStringComparisonsCaseInsensitivebuildIdentifierHelpercloseQuotedoesReadCommittedCauseWritersToBlockReadersdoesRepeatableReadCauseReadersToBlockWritersgetAfterSelectInsertPointgetCreateTemporaryTableColumnAnnotationgetCurrentSchemaCommandgetCurrentTimestampSelectStringgetIdentityColumnSupportgetInExpressionCountLimitgetLimitHandlergetLimitStringgetNameQualifierSupportgetNoColumnsInsertStringgetSqlTypeDescriptorOverrideopenQuotesupportsCircularCascadeDeleteConstraintssupportsLimitsupportsLimitOffsetsupportsLobValueChangePropogationsupportsResultSetPositionQueryMethodsOnForwardOnlyCursorsupportsVariableLimituseMaxForLimit

Field Detail

MAX_LENGTHback to summary
private static final int MAX_LENGTH

Constructor Detail

SQLServer2005Dialectback to summary
public SQLServer2005Dialect()

Constructs a SQLServer2005Dialect

Method Detail

appendLockHintback to summary
public String appendLockHint(LockOptions lockOptions, String tableName)

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

contributed by Helge Schulz

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
buildSQLExceptionConversionDelegateback to summary
public SQLExceptionConversionDelegate buildSQLExceptionConversionDelegate()

Overrides org.hibernate.dialect.Dialect.buildSQLExceptionConversionDelegate.

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

Build an instance of a SQLExceptionConversionDelegate for interpreting dialect-specific error or SQLState codes.

When buildSQLExceptionConverter returns null, the default SQLExceptionConverter is used to interpret SQLState and error 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 JDBC 4 defined SQLException hierarchy;
  2. a delegate that interprets SQLState codes for either X/Open or SQL-2003 codes, depending on java.sql.DatabaseMetaData#getSQLStateType

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

Specific Dialects may override to return whatever is most appropriate for that vendor.

Returns:SQLExceptionConversionDelegate

The SQLExceptionConversionDelegate for this dialect

Annotations
@Override
getDefaultLimitHandlerback to summary
protected LimitHandler getDefaultLimitHandler()

Overrides org.hibernate.dialect.SQLServerDialect.getDefaultLimitHandler.

Annotations
@Override
supportsNonQueryWithCTEback to summary
public boolean supportsNonQueryWithCTE()

Overrides org.hibernate.dialect.Dialect.supportsNonQueryWithCTE.

Doc from org.hibernate.dialect.Dialect.supportsNonQueryWithCTE.

Does this dialect/database support non-query statements (e.g. INSERT, UPDATE, DELETE) with CTE (Common Table Expressions)?

Returns:boolean

true if non-query statements are supported with CTE

Annotations
@Override
supportsNoWaitback to summary
public boolean supportsNoWait()

Overrides org.hibernate.dialect.Dialect.supportsNoWait.

Doc from org.hibernate.dialect.Dialect.supportsNoWait.

Does this dialect/database support NO_WAIT timeout.

Returns:boolean

true if NO_WAIT is supported

Annotations
@Override
supportsSkipLockedback to summary
public boolean supportsSkipLocked()

Overrides org.hibernate.dialect.Dialect.supportsSkipLocked.

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

Does this dialect/database support SKIP_LOCKED timeout.

Returns:boolean

true if SKIP_LOCKED is supported

Annotations
@Override