oracle.javatools.db

Class UniqueConstraint

java.lang.Object

oracle.javatools.db.AbstractDBObject

oracle.javatools.db.AbstractBuildableObject

oracle.javatools.db.AbstractChildBuildableObject

oracle.javatools.db.Constraint

oracle.javatools.db.ColumnConstraint

oracle.javatools.db.UniqueConstraint

All Implemented Interfaces:

ChildDBObject, DBObject, Copyable, DynamicPropertySet

Direct Known Subclasses:

PKConstraint

public class UniqueConstraint
extends ColumnConstraint

A UniqueConstraint prohibits multiple rows from having the same value in the same column or combination of columns but allows some values to be null.

The list of columns constrained by the UniqueConstraint is stored by column name.

Nested Class Summary

Nested classes/interfaces inherited from class oracle.javatools.db.Constraint

Constraint.DeferrableState

Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject

AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	CONSTRAINT_TYPE

Fields inherited from class oracle.javatools.db.Constraint

TYPE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

Constructors

Constructor and Description
UniqueConstraint() Creates a new Constraint.
UniqueConstraint(java.lang.String name, Relation relation) Creates a new Constraint of the specified name for the specified relation.

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	getConstraintType() Retrieves the type of constraint represented by this instance.
DBObjectID	getIndexID() Get the Index that implements this UniqueConstraint
static boolean	isUnique(Column col) Returns true if the given table is constrained by a UniqueConstraint (including PKConstraint) in its parent table.
void	setIndexID(DBObjectID id) Set the Index that implements this UniqueConstraint

Methods inherited from class oracle.javatools.db.ColumnConstraint

addColumn, addColumnImpl, getColumnIDs, getColumns, isConstrained, removeColumn, setColumnIDs, setColumns

Methods inherited from class oracle.javatools.db.Constraint

getConstraints, getConstraintTypes, getDeferrableState, getRelation, getType, isEnabled, setDeferrableState, setEnabled, setRelation

Methods inherited from class oracle.javatools.db.AbstractChildBuildableObject

setParent

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

checkInit, checkInit, copyToImpl, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization

Methods inherited from class oracle.javatools.db.AbstractDBObject

addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties, setProperty, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent

Methods inherited from interface oracle.javatools.db.DBObject

addObjectListener, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getReferenceIDs, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperty, getProperty, setProperties, setProperty

Field Detail

CONSTRAINT_TYPE

public static final java.lang.String CONSTRAINT_TYPE

See Also:

Constant Field Values

Constructor Detail

UniqueConstraint

public UniqueConstraint()

Creates a new Constraint.

UniqueConstraint

public UniqueConstraint(java.lang.String name,
                Relation relation)

Creates a new Constraint of the specified name for the specified relation. The new constraint will not be added to the Table, this must be done using Relation.addConstraint(Constraint) when the constraint definition is complete.

Parameters:

name - a string containing the name of the constraint

relation - the Relation being constrained

Method Detail

getConstraintType

public java.lang.String getConstraintType()

Description copied from class: Constraint

Retrieves the type of constraint represented by this instance. Valid constraint types can vary depending on the database. Examples of constraint types include primary key constraints, foreign key constraints, and check constraints.

Specified by:

getConstraintType in class Constraint

Returns:

a string value indicating the type of constraint.

getIndexID

public DBObjectID getIndexID()

Get the Index that implements this UniqueConstraint

Returns:

the ID of the Index

setIndexID

public void setIndexID(DBObjectID id)

Set the Index that implements this UniqueConstraint

Parameters:

id - the ID of the Index

isUnique

public static boolean isUnique(Column col)

Returns true if the given table is constrained by a UniqueConstraint (including PKConstraint) in its parent table. This is just a convinience wrapper around ColumnConstraint.isConstrained(oracle.javatools.db.Column, java.lang.String...).

Parameters:

col - the column to test

Returns:

true if the column is uniquely constrained