org.hsqldb

Class View

java.lang.Object

org.hsqldb.TableBase

org.hsqldb.Table

org.hsqldb.TableDerived

org.hsqldb.View

All Implemented Interfaces:

SchemaObject

public class View
extends TableDerived

Represents an SQL VIEW based on a query expression

Since:

1.7.0

Nested Class Summary

Nested classes/interfaces inherited from interface org.hsqldb.SchemaObject

SchemaObject.ConstraintTypes, SchemaObject.Deferable, SchemaObject.Nullability, SchemaObject.ParameterModes, SchemaObject.ReferentialAction, SchemaObject.ViewCheckModes

Field Summary

Fields inherited from class org.hsqldb.TableDerived

emptyArray

Fields inherited from class org.hsqldb.Table

columnList

Fields inherited from class org.hsqldb.TableBase

CACHED_TABLE, CHANGE_SET_TABLE, database, FUNCTION_TABLE, INFO_SCHEMA_TABLE, isSessionBased, MEMORY_TABLE, persistenceId, persistenceScope, RESULT_TABLE, SCOPE_FULL, SCOPE_ROUTINE, SCOPE_SESSION, SCOPE_STATEMENT, SCOPE_TRANSACTION, store, SYSTEM_SUBQUERY, SYSTEM_TABLE, TEMP_TABLE, TEMP_TEXT_TABLE, TEXT_TABLE, TRANSITION_TABLE, VIEW_TABLE

Fields inherited from interface org.hsqldb.SchemaObject

ASSERTION, CATALOG, CHARSET, COLLATION, COLUMN, CONSTRAINT, CURSOR, DOMAIN, FUNCTION, GRANTEE, INDEX, LABEL, PARAMETER, PROCEDURE, ROUTINE, SCHEMA, SEARCH, SEQUENCE, SERVER, SPECIFIC_ROUTINE, SUBQUERY, TABLE, TRANSITION, TRIGGER, TYPE, VARIABLE, VIEW, WRAPPER

Method Summary

Modifier and Type	Method and Description
void	compile(Session session, SchemaObject parentObject) Compiles the query expression and sets up the columns.
int	getCheckOption()
OrderedHashSet	getComponents()
OrderedHashSet	getReferences()
java.lang.String	getSQL()
java.lang.String	getStatement() Returns the query expression for the view.
int	getType()
int[]	getUpdatableColumns()
boolean	isInsertable()
boolean	isTriggerDeletable()
boolean	isTriggerInsertable()
boolean	isTriggerUpdatable()
boolean	isUpdatable()
TableDerived	newDerivedTable(Session session)
void	setDataReadOnly(boolean value) Overridden to disable SET TABLE READONLY DDL for View objects.
void	setStatement(java.lang.String sql)

Methods inherited from class org.hsqldb.TableDerived

getBaseTable, getBaseTableColumnMap, getDataExpression, getId, getNavigator, getQueryExpression, getValue, getValues, isQueryBased, isRecompiled, isWritable, materialise, materialiseCorrelated, prepareTable, prepareTable, setSQL

Methods inherited from class org.hsqldb.Table

addColumn, addColumnNoCheck, addConstraint, checkDataReadOnly, clearAllData, clearAllData, compareRows, createPrimaryKey, createPrimaryKey, createPrimaryKeyConstraint, enforceRowConstraints, enforceTypeLimits, findColumn, getBestRowIdentifiers, getCatalogName, getChangeTimestamp, getClusteredIndex, getColumn, getColumnIndex, getColumnListSQL, getColumnListWithTypeSQL, getColumnNames, getColumnNameSet, getColumnNameSet, getColumnNameSet, getConstraint, getConstraints, getDefaultRanges, getDeleteRowFromLog, getDependentExternalConstraints, getFKConstraints, getIndexRootsArray, getIndexRootsSQL, getName, getNextIdentity, getOwner, getPrimaryConstraint, getReferencesForDependents, getRowStore, getSchemaName, getSQLForClustered, getSQLForReadOnly, getSQLForTableSpace, getSQLForTextSource, getTriggerIndex, getTriggers, getTriggerSQL, getUniqueConstraintForIndex, getUniqueOrPKConstraintForIndex, getUniquePKConstraintNames, hasGeneratedColumn, hasIdentityColumn, hasLobColumn, insertData, insertFromScript, insertNoCheckFromLog, insertSys, insertSys, isBestRowIdentifiersStrict, isCached, isConnected, isDataReadOnly, isDropped, isFileBased, isReadOnly, isSchemaBaseTable, isTemp, isText, isView, isWithDataSource, rowIteratorClustered, rowIteratorClustered, setGeneratedColumns, setIndexRoots, setName, systemSetIdentityColumn

Methods inherited from class org.hsqldb.TableBase

createAndAddIndexStructure, createIndex, createPrimaryIndex, dropIndex, duplicate, getColumnCount, getColumnNotNull, getColumnTypes, getDataColumnCount, getEmptyRowData, getFullIndex, getIndex, getIndexCount, getIndexList, getNewColumnCheckList, getPersistenceId, getPrimaryIndex, getPrimaryKey, getPrimaryKeyTypes, getSpaceID, getTableType, hasPrimaryKey, isEmpty, isTransactional, onCommitPreserve, rowIterator, rowIterator, setBestRowIdentifiers, setIndexes, setSpaceID, setTransactional

Methods inherited from class java.lang.Object

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

Method Detail

getType

public int getType()

Specified by:

getType in interface SchemaObject

Overrides:

getType in class Table

getReferences

public OrderedHashSet getReferences()

Specified by:

getReferences in interface SchemaObject

Overrides:

getReferences in class Table

getComponents

public OrderedHashSet getComponents()

Specified by:

getComponents in interface SchemaObject

Overrides:

getComponents in class Table

compile

public void compile(Session session,
                    SchemaObject parentObject)

Compiles the query expression and sets up the columns.

Specified by:

compile in interface SchemaObject

Overrides:

compile in class Table

getSQL

public java.lang.String getSQL()

Specified by:

getSQL in interface SchemaObject

Overrides:

getSQL in class Table

getUpdatableColumns

public int[] getUpdatableColumns()

Overrides:

getUpdatableColumns in class TableDerived

isTriggerInsertable

public boolean isTriggerInsertable()

Overrides:

isTriggerInsertable in class TableDerived

isTriggerUpdatable

public boolean isTriggerUpdatable()

Overrides:

isTriggerUpdatable in class TableDerived

isTriggerDeletable

public boolean isTriggerDeletable()

Overrides:

isTriggerDeletable in class TableDerived

isInsertable

public boolean isInsertable()

Overrides:

isInsertable in class TableDerived

isUpdatable

public boolean isUpdatable()

Overrides:

isUpdatable in class TableDerived

setDataReadOnly

public void setDataReadOnly(boolean value)

Overridden to disable SET TABLE READONLY DDL for View objects.

Overrides:

setDataReadOnly in class Table

getCheckOption

public int getCheckOption()

getStatement

public java.lang.String getStatement()

Returns the query expression for the view.

setStatement

public void setStatement(java.lang.String sql)

newDerivedTable

public TableDerived newDerivedTable(Session session)

Overrides:

newDerivedTable in class TableDerived