org.hibernate.dialect.unique

Class DB2UniqueDelegate

java.lang.Object

org.hibernate.dialect.unique.DefaultUniqueDelegate

org.hibernate.dialect.unique.DB2UniqueDelegate

All Implemented Interfaces:

UniqueDelegate

public class DB2UniqueDelegate
extends DefaultUniqueDelegate

DB2 does not allow unique constraints on nullable columns. Rather than forcing "not null", use unique *indexes* instead.

Field Summary

Fields inherited from class org.hibernate.dialect.unique.DefaultUniqueDelegate

dialect

Constructor Summary

Constructors

Constructor and Description
DB2UniqueDelegate(Dialect dialect) Constructs a DB2UniqueDelegate

Method Summary

Methods

Modifier and Type	Method and Description
String	getAlterTableToAddUniqueKeyCommand(UniqueKey uniqueKey) Get the SQL ALTER TABLE command to be used to create the given UniqueKey.
String	getAlterTableToAddUniqueKeyCommand(UniqueKey uniqueKey, String defaultCatalog, String defaultSchema) Get the SQL ALTER TABLE command to be used to create the given UniqueKey.
String	getAlterTableToDropUniqueKeyCommand(UniqueKey uniqueKey) Get the SQL ALTER TABLE command to be used to drop the given UniqueKey.
String	getAlterTableToDropUniqueKeyCommand(UniqueKey uniqueKey, String defaultCatalog, String defaultSchema) Get the SQL ALTER TABLE command to be used to drop the given UniqueKey.

Methods inherited from class org.hibernate.dialect.unique.DefaultUniqueDelegate

getColumnDefinitionUniquenessFragment, getColumnDefinitionUniquenessFragment, getTableCreationUniqueConstraintsFragment, getTableCreationUniqueConstraintsFragment, uniqueConstraintSql, uniqueConstraintSql

Methods inherited from class java.lang.Object

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

Constructor Detail

DB2UniqueDelegate

public DB2UniqueDelegate(Dialect dialect)

Constructs a DB2UniqueDelegate

Parameters:

dialect - The dialect

Method Detail

getAlterTableToAddUniqueKeyCommand

public String getAlterTableToAddUniqueKeyCommand(UniqueKey uniqueKey,
                                        String defaultCatalog,
                                        String defaultSchema)

Description copied from interface: UniqueDelegate

Get the SQL ALTER TABLE command to be used to create the given UniqueKey.

Specified by:

getAlterTableToAddUniqueKeyCommand in interface UniqueDelegate

Overrides:

getAlterTableToAddUniqueKeyCommand in class DefaultUniqueDelegate

Parameters:

uniqueKey - The UniqueKey instance. Contains all information about the columns

defaultCatalog - The default catalog

defaultSchema - The default schema

Returns:

The ALTER TABLE command

getAlterTableToAddUniqueKeyCommand

public String getAlterTableToAddUniqueKeyCommand(UniqueKey uniqueKey)

Description copied from interface: UniqueDelegate

Get the SQL ALTER TABLE command to be used to create the given UniqueKey.

Specified by:

getAlterTableToAddUniqueKeyCommand in interface UniqueDelegate

Overrides:

getAlterTableToAddUniqueKeyCommand in class DefaultUniqueDelegate

Parameters:

uniqueKey - The UniqueKey instance. Contains all information about the columns, as well as schema/catalog

Returns:

The ALTER TABLE command

getAlterTableToDropUniqueKeyCommand

public String getAlterTableToDropUniqueKeyCommand(UniqueKey uniqueKey,
                                         String defaultCatalog,
                                         String defaultSchema)

Description copied from interface: UniqueDelegate

Get the SQL ALTER TABLE command to be used to drop the given UniqueKey.

Specified by:

getAlterTableToDropUniqueKeyCommand in interface UniqueDelegate

Overrides:

getAlterTableToDropUniqueKeyCommand in class DefaultUniqueDelegate

Parameters:

uniqueKey - The UniqueKey instance. Contains all information about the columns

defaultCatalog - The default catalog

defaultSchema - The default schema

Returns:

The ALTER TABLE command

getAlterTableToDropUniqueKeyCommand

public String getAlterTableToDropUniqueKeyCommand(UniqueKey uniqueKey)

Description copied from interface: UniqueDelegate

Get the SQL ALTER TABLE command to be used to drop the given UniqueKey.

Specified by:

getAlterTableToDropUniqueKeyCommand in interface UniqueDelegate

Overrides:

getAlterTableToDropUniqueKeyCommand in class DefaultUniqueDelegate

Parameters:

uniqueKey - The UniqueKey instance. Contains all information about the columns, as well as schema/catalog

Returns:

The ALTER TABLE command