Package com.ptc.windchill.annotations.metadata

Enum Class ColumnType

java.lang.Object

java.lang.Enum<ColumnType>

com.ptc.windchill.annotations.metadata.ColumnType

All Implemented Interfaces:

Serializable, Comparable<ColumnType>, Constable

public enum ColumnType
extends Enum<ColumnType>

Specifies the relational storage type for the property.

Rose conversion note: Corresponds to Class Attribute Specification -> Windchill -> ColumnType.

Supported API: true

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
BLOB	Maps the property to a database blob.
INLINE_BLOB	Maps the property to both a BLOB and SMALL_BLOB, storing the data in either column depending on whether or not the value will fit in the SMALL_BLOB.
SEQUENCE	Maps the property to a number column backed by a database sequence specific to the column.
SMALL_BLOB	Maps the property as though it were a blob (storing its content using serialization) but stores it as a string, limiting its storage to the number of bytes supported by the database's string column.
USE_DEFAULT_MAPPING	Maps the property's type to the analogous SQL type.

Method Summary

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

USE_DEFAULT_MAPPING

public static final ColumnType USE_DEFAULT_MAPPING

Maps the property's type to the analogous SQL type. For example, maps a String to a VARCHAR2/NVARCHAR (for Oracle/SQL Server).

Rose conversion note: Corresponds to <Use Default Mapping>.

Supported API: true

BLOB

public static final ColumnType BLOB

Maps the property to a database blob.

Rose conversion note: Corresponds to BLOB.

Supported API: true

INLINE_BLOB

public static final ColumnType INLINE_BLOB

Maps the property to both a BLOB and SMALL_BLOB, storing the data in either column depending on whether or not the value will fit in the SMALL_BLOB.

Rose conversion note: Corresponds to INLINEBLOB.

Supported API: true

SMALL_BLOB

public static final ColumnType SMALL_BLOB

Maps the property as though it were a blob (storing its content using serialization) but stores it as a string, limiting its storage to the number of bytes supported by the database's string column.

Rose conversion note: Corresponds to SMALLBLOB.

Supported API: true

SEQUENCE

public static final ColumnType SEQUENCE

Maps the property to a number column backed by a database sequence specific to the column. The column will be automatically assigned to the next sequence value when the owning object is stored.

Notes:

• Properties of type SEQUENCE are frozen (non-modifiable)
• The sequence that's created starts at 1 and increments by 1invalid input: '<'/code
• The value isn't guaranteed to increase monotonically, as Oracle, in particular, caches a pool of numbers (with a default pool size of 20) and, conesequently, may skip numbers
• The number is assigned in the database and does not come back with the object -- if you store an object with a sequence attribute, you will need to refresh it if you wish to access the stored value for the property.

Rose conversion note: Corresponds to SEQUENCE.

Supported API: true