org.unitils.core.dbsupport
Class MsSqlDbSupport

java.lang.Object
  org.unitils.core.dbsupport.DbSupport
      org.unitils.core.dbsupport.MsSqlDbSupport

public class MsSqlDbSupport
extends DbSupport

Implementation of DbSupport for a MsSQL database.

Special thanks to Niki Driessen who donated the initial version of the Derby support code.

Author:

Tim Ducheyne, Niki Driessen, Filip Neven

Field Summary

Fields inherited from class org.unitils.core.dbsupport.DbSupport

PROPKEY_IDENTIFIER_QUOTE_STRING, PROPKEY_STORED_IDENTIFIER_CASE

Constructor Summary

MsSqlDbSupport()
Creates a new DB support instance for MS SQL.

Method Summary

protected void	disableNotNullConstraints(String tableName) Disables not-null constraints on the given table.
void	disableReferentialConstraints() Disables all referential constraints (e.g. foreign keys) on all table in the schema
protected void	disableReferentialConstraints(String tableName)
void	disableValueConstraints() Disables all value constraints (e.g. not null) on all tables in the schema
protected void	disableValueConstraints(String tableName)
Set<String>	getColumnNames(String tableName) Gets the names of all columns of the given table.
Set<String>	getIdentityColumnNames(String tableName) Gets the names of all identity columns of the given table.
Set<String>	getSynonymNames() Retrieves the names of all synonyms in the database schema.
Set<String>	getTableNames() Returns the names of all tables in the database.
Set<String>	getTriggerNames() Retrieves the names of all the triggers in the database schema.
Set<String>	getTypeNames() Retrieves the names of all the types in the database schema.
Set<String>	getViewNames() Retrieves the names of all the views in the database schema.
void	incrementIdentityColumnToValue(String tableName, String identityColumnName, long identityValue) Increments the identity value for the specified identity column on the specified table to the given value.
boolean	supportsIdentityColumns() Identity columns are supported.
boolean	supportsSynonyms() Synonyms are supported.
boolean	supportsTriggers() Triggers are supported.
boolean	supportsTypes() Types are supported

Methods inherited from class org.unitils.core.dbsupport.DbSupport

dropMaterializedView, dropSequence, dropSynonym, dropTable, dropTrigger, dropType, dropView, getDatabaseDialect, getIdentifierQuoteString, getLongDataType, getMaterializedViewNames, getSchemaName, getSequenceNames, getSequenceValue, getSQLHandler, getStoredIdentifierCase, getTextDataType, incrementSequenceToValue, init, qualified, quoted, supportsCascade, supportsMaterializedViews, supportsSequences, toCorrectCaseIdentifier

Methods inherited from class java.lang.Object

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

Constructor Detail

MsSqlDbSupport

public MsSqlDbSupport()

Creates a new DB support instance for MS SQL.

Method Detail

getTableNames

public Set<String> getTableNames()

Returns the names of all tables in the database.

Specified by:

getTableNames in class DbSupport

Returns:

The names of all tables in the database

getColumnNames

public Set<String> getColumnNames(String tableName)

Gets the names of all columns of the given table.

Specified by:

getColumnNames in class DbSupport

Parameters:

tableName - The table, not null

Returns:

The names of the columns of the table with the given name

getViewNames

public Set<String> getViewNames()

Retrieves the names of all the views in the database schema.

Specified by:

getViewNames in class DbSupport

Returns:

The names of all views in the database

getSynonymNames

public Set<String> getSynonymNames()

Retrieves the names of all synonyms in the database schema.

Overrides:

getSynonymNames in class DbSupport

Returns:

The names of all synonyms in the database

getTriggerNames

public Set<String> getTriggerNames()

Retrieves the names of all the triggers in the database schema.

Overrides:

getTriggerNames in class DbSupport

Returns:

The names of all triggers in the database

getTypeNames

public Set<String> getTypeNames()

Retrieves the names of all the types in the database schema.

Overrides:

getTypeNames in class DbSupport

Returns:

The names of all types in the database

getIdentityColumnNames

public Set<String> getIdentityColumnNames(String tableName)

Gets the names of all identity columns of the given table.

Overrides:

getIdentityColumnNames in class DbSupport

Parameters:

tableName - The table, not null

Returns:

The names of the identity columns of the table with the given name

disableReferentialConstraints

public void disableReferentialConstraints()

Disables all referential constraints (e.g. foreign keys) on all table in the schema

Specified by:

disableReferentialConstraints in class DbSupport

disableReferentialConstraints

protected void disableReferentialConstraints(String tableName)

disableValueConstraints

public void disableValueConstraints()

Disables all value constraints (e.g. not null) on all tables in the schema

Specified by:

disableValueConstraints in class DbSupport

disableValueConstraints

protected void disableValueConstraints(String tableName)

incrementIdentityColumnToValue

public void incrementIdentityColumnToValue(String tableName,
                                           String identityColumnName,
                                           long identityValue)

Increments the identity value for the specified identity column on the specified table to the given value. If there is no identity specified on the given primary key, the method silently finishes without effect.

Overrides:

incrementIdentityColumnToValue in class DbSupport

Parameters:

tableName - The table with the identity column, not null

identityColumnName - The column, not null

identityValue - The new value

supportsSynonyms

public boolean supportsSynonyms()

Synonyms are supported.

Overrides:

supportsSynonyms in class DbSupport

Returns:

True

supportsTriggers

public boolean supportsTriggers()

Triggers are supported.

Overrides:

supportsTriggers in class DbSupport

Returns:

True

supportsTypes

public boolean supportsTypes()

Types are supported

Overrides:

supportsTypes in class DbSupport

Returns:

true

supportsIdentityColumns

public boolean supportsIdentityColumns()

Identity columns are supported.

Overrides:

supportsIdentityColumns in class DbSupport

Returns:

True

disableNotNullConstraints

protected void disableNotNullConstraints(String tableName)

Disables not-null constraints on the given table.

For primary keys, row-guid, identity and computed columns not-null constrains cannot be disabled in MS-Sql.

Parameters:

tableName - The table, not null