Java Doc for View.java in  » Database-DBMS » hsql » org » hsqldb » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » hsql » org.hsqldb   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.hsqldb.BaseTable       org.hsqldb.Table          org.hsqldb.View View class View extends Table (Code) Represents an SQL VIEW based on a SELECT statement. author:    leptipre@users author:    fredt@users version:    1.8.0 since:    1.7.0 Field Summary  HsqlName compileTimeSchema       Select viewSelect       SubQuery viewSubQuery       SubQuery[] viewSubqueries      List of subqueries in this view in order of materialization. Constructor Summary   View(Session session, Database db, HsqlName name, String definition, HsqlName[] columns)      Constructor. Method Summary  void compile(Session session)      Compiles the SELECT statement and sets up the columns.  HsqlName[] getSchemas()       String getStatement()      Returns the SELECT statement for the view.  boolean hasColumn(Table table, String colname)      Returns true if the view references the named column of the named table, otherwise false.  boolean hasSequence(NumberSequence sequence)      Returns true if the view references the named SEQUENCE, otherwise false.  boolean hasTable(Table table)      Returns true if the view references any column of the named table.  boolean hasView(View view)       void setDataReadOnly(boolean value)      Overridden to disable SET TABLE READONLY DDL for View objects. static  String trimStatement(String s)      Returns the SELECT statement trimmed of any terminating SQL whitespace, separators or SQL comments. Field Detail compileTimeSchema HsqlName compileTimeSchema(Code) schema at the time of compilation viewSelect Select viewSelect(Code) viewSubQuery SubQuery viewSubQuery(Code) viewSubqueries SubQuery[] viewSubqueries(Code) List of subqueries in this view in order of materialization. Last element is the view itself. Constructor Detail View View(Session session, Database db, HsqlName name, String definition, HsqlName[] columns) throws HsqlException(Code) Constructor. Parameters:   Session - Parameters:   db - database Parameters:   name - HsqlName of the view Parameters:   definition - SELECT statement of the view Parameters:   columns - array of HsqlName column names throws:   HsqlException - Method Detail compile void compile(Session session) throws HsqlException(Code) Compiles the SELECT statement and sets up the columns. getSchemas HsqlName[] getSchemas()(Code) Returns list of schemas getStatement String getStatement()(Code) Returns the SELECT statement for the view. hasColumn boolean hasColumn(Table table, String colname)(Code) Returns true if the view references the named column of the named table, otherwise false. hasSequence boolean hasSequence(NumberSequence sequence)(Code) Returns true if the view references the named SEQUENCE, otherwise false. hasTable boolean hasTable(Table table)(Code) Returns true if the view references any column of the named table. hasView boolean hasView(View view)(Code) setDataReadOnly void setDataReadOnly(boolean value) throws HsqlException(Code) Overridden to disable SET TABLE READONLY DDL for View objects. trimStatement static String trimStatement(String s) throws HsqlException(Code) Returns the SELECT statement trimmed of any terminating SQL whitespace, separators or SQL comments. Fields inherited from org.hsqldb.Table final public static int CACHED_TABLE(Code)(Java Doc) final public static int MEMORY_TABLE(Code)(Java Doc) final public static int SYSTEM_SUBQUERY(Code)(Java Doc) final public static int SYSTEM_TABLE(Code)(Java Doc) final static int SYSTEM_VIEW(Code)(Java Doc) final public static int TEMP_TABLE(Code)(Java Doc) final public static int TEMP_TEXT_TABLE(Code)(Java Doc) final public static int TEXT_TABLE(Code)(Java Doc) final public static int VIEW(Code)(Java Doc) Index bestIndex(Code)(Java Doc) int[] bestIndexForColumn(Code)(Java Doc) int[] bestRowIdentifierCols(Code)(Java Doc) boolean bestRowIdentifierStrict(Code)(Java Doc) protected DataFileCache cache(Code)(Java Doc) protected int columnCount(Code)(Java Doc) public HashMappedList columnList(Code)(Java Doc) Constraint[] constraintList(Code)(Java Doc) HashSet constraintPath(Code)(Java Doc) public Database database(Code)(Java Doc) int identityColumn(Code)(Java Doc) NumberSequence identitySequence(Code)(Java Doc) Index[] indexList(Code)(Java Doc) protected int indexType(Code)(Java Doc) protected boolean isCached(Code)(Java Doc) protected boolean isLogged(Code)(Java Doc) protected boolean isMemory(Code)(Java Doc) protected boolean isReadOnly(Code)(Java Doc) protected boolean isTemp(Code)(Java Doc) protected boolean isText(Code)(Java Doc) protected boolean onCommitPreserve(Code)(Java Doc) NumberSequence rowIdSequence(Code)(Java Doc) PersistentStore rowStore(Code)(Java Doc) boolean sqlEnforceSize(Code)(Java Doc) protected HsqlName tableName(Code)(Java Doc) HashMappedList tableUpdateList(Code)(Java Doc) HsqlArrayList[] triggerLists(Code)(Java Doc) Methods inherited from org.hsqldb.Table void addColumn(Column column) throws HsqlException(Code)(Java Doc) void addColumns(Result.ResultMetaData metadata, int count) throws HsqlException(Code)(Java Doc) void addColumns(Select select) throws HsqlException(Code)(Java Doc) void addConstraint(Constraint c)(Code)(Java Doc) void addTrigger(TriggerDef trigDef)(Code)(Java Doc) static void checkCascadeDelete(Session session, Table table, HashMappedList tableUpdateLists, Row row, boolean delete, HashSet path) throws HsqlException(Code)(Java Doc) static void checkCascadeUpdate(Session session, Table table, HashMappedList tableUpdateLists, Row orow, Object[] nrow, int[] cols, Table ref, HashSet path) throws HsqlException(Code)(Java Doc) void checkColumnInCheckConstraint(String colname) throws HsqlException(Code)(Java Doc) void checkColumnInFKConstraint(int colIndex) throws HsqlException(Code)(Java Doc) void checkColumnInFKConstraint(int colIndex, int actionType) throws HsqlException(Code)(Java Doc) void checkColumnsMatch(int[] col, Table other, int[] othercol) throws HsqlException(Code)(Java Doc) void checkDataReadOnly() throws HsqlException(Code)(Java Doc) void checkDropIndex(String indexname, HashSet ignore, boolean dropPK) throws HsqlException(Code)(Java Doc) void checkRowDataInsert(Session session, Object[] data) throws HsqlException(Code)(Java Doc) void checkRowDataUpdate(Session session, Object[] data, int[] cols) throws HsqlException(Code)(Java Doc) void clearAllRows(Session session)(Code)(Java Doc) static void clearUpdateLists(HashMappedList tableUpdateList)(Code)(Java Doc) void commitRowToStore(Row row)(Code)(Java Doc) public void connect(Session session) throws HsqlException(Code)(Java Doc) Index createIndex(Session session, int[] column, HsqlName name, boolean unique, boolean constraint, boolean forward) throws HsqlException(Code)(Java Doc) Index createIndexStructure(int[] columns, HsqlName name, boolean unique, boolean constraint, boolean forward) throws HsqlException(Code)(Java Doc) int createIndexStructureGetNo(int[] column, HsqlName name, boolean unique, boolean constraint, boolean forward) throws HsqlException(Code)(Java Doc) void createPrimaryIndex(int[] pkcols, HsqlName name) throws HsqlException(Code)(Java Doc) void createPrimaryKey(int[] cols) throws HsqlException(Code)(Java Doc) void createPrimaryKey() throws HsqlException(Code)(Java Doc) void createPrimaryKey(HsqlName indexName, int[] columns, boolean columnsNotNull) throws HsqlException(Code)(Java Doc) int delete(Session session, HsqlArrayList deleteList) throws HsqlException(Code)(Java Doc) public void deleteNoCheckFromLog(Session session, Object[] data) throws HsqlException(Code)(Java Doc) void deleteNoCheckRollback(Session session, Row row, boolean log) throws HsqlException(Code)(Java Doc) public void disconnect(Session session) throws HsqlException(Code)(Java Doc) void drop() throws HsqlException(Code)(Java Doc) void dropIndex(Session session, String indexname) throws HsqlException(Code)(Java Doc) void dropIndexFromRows(Session session, int index) throws HsqlException(Code)(Java Doc) void dropTrigger(String name)(Code)(Java Doc) void dropTriggers()(Code)(Java Doc) protected Table duplicate() throws HsqlException(Code)(Java Doc) void enforceFieldValueLimits(Object[] data, int[] cols) throws HsqlException(Code)(Java Doc) protected void enforceNullConstraints(Object[] data) throws HsqlException(Code)(Java Doc) boolean equals(Session session, String name)(Code)(Java Doc) boolean equals(String name)(Code)(Java Doc) boolean equals(HsqlName name)(Code)(Java Doc) int findColumn(String c)(Code)(Java Doc) void fireAll(Session session, int trigVecIndx, Object[] oldrow, Object[] newrow)(Code)(Java Doc) void fireAll(Session session, int trigVecIndex)(Code)(Java Doc) int[] getBestRowIdentifiers()(Code)(Java Doc) DataFileCache getCache()(Code)(Java Doc) String getCatalogName()(Code)(Java Doc) Column getColumn(int i)(Code)(Java Doc) public int getColumnCount()(Code)(Java Doc) int[] getColumnMap()(Code)(Java Doc) int getColumnNr(String c) throws HsqlException(Code)(Java Doc) public int[] getColumnTypes()(Code)(Java Doc) Constraint getConstraint(String constraintName)(Code)(Java Doc) Constraint getConstraintForColumns(Table tablemain, int[] colmain, int[] colref)(Code)(Java Doc) int getConstraintIndex(String constraintName)(Code)(Java Doc) Constraint[] getConstraints()(Code)(Java Doc) protected String getDataSource()(Code)(Java Doc) public Object[] getEmptyRowData()(Code)(Java Doc) public String getHeader()(Code)(Java Doc) public int getId()(Code)(Java Doc) int getIdentityColumn()(Code)(Java Doc) Index getIndex(int[] exclude, int colIndex)(Code)(Java Doc) Index getIndex(String indexName)(Code)(Java Doc) public Index getIndex(int i)(Code)(Java Doc) public int getIndexCount()(Code)(Java Doc) Index getIndexForColumn(Session session, int column)(Code)(Java Doc) Index getIndexForColumns(boolean[] columnCheck)(Code)(Java Doc) Index getIndexForColumns(int[] col, boolean unique) throws HsqlException(Code)(Java Doc) int getIndexIndex(String indexName)(Code)(Java Doc) String getIndexRoots()(Code)(Java Doc) public int[] getIndexRootsArray()(Code)(Java Doc) final int getIndexType()(Code)(Java Doc) public Index[] getIndexes()(Code)(Java Doc) int getInternalColumnCount()(Code)(Java Doc) public HsqlName getName()(Code)(Java Doc) boolean[] getNewColumnCheckList()(Code)(Java Doc) int[] getNewColumnMap()(Code)(Java Doc) Object[] getNewRowData(Session session, boolean[] exists) throws HsqlException(Code)(Java Doc) int getNextConstraintIndex(int from, int type)(Code)(Java Doc) Constraint getPrimaryConstraint()(Code)(Java Doc) public Index getPrimaryIndex()(Code)(Java Doc) public int[] getPrimaryKey()(Code)(Java Doc) public int[] getPrimaryKeyTypes()(Code)(Java Doc) CachedRow getRow(int pos, Node primarynode) throws HsqlException(Code)(Java Doc) CachedRow getRow(int pos)(Code)(Java Doc) CachedRow getRow(long id)(Code)(Java Doc) public int getRowCount(Session session) throws HsqlException(Code)(Java Doc) public String getSchemaName()(Code)(Java Doc) final public int getTableType()(Code)(Java Doc) Constraint getUniqueConstraintForColumns(int[] cols)(Code)(Java Doc) Index getUniqueConstraintIndexForColumns(int[] col)(Code)(Java Doc) Constraint getUniqueOrPKConstraintForIndex(Index index)(Code)(Java Doc) public boolean hasPrimaryKey()(Code)(Java Doc) void indexRow(Session session, Row row) throws HsqlException(Code)(Java Doc) int insert(Session session, Result ins) throws HsqlException(Code)(Java Doc) void insert(Session session, Object[] data) throws HsqlException(Code)(Java Doc) public void insertData(Session session, Object[] data) throws HsqlException(Code)(Java Doc) public void insertFromScript(Object[] data) throws HsqlException(Code)(Java Doc) protected void insertFromTextSource(CachedRow row) throws HsqlException(Code)(Java Doc) void insertIntoTable(Session session, Result result) throws HsqlException(Code)(Java Doc) public void insertNoCheckFromLog(Session session, Object[] data) throws HsqlException(Code)(Java Doc) void insertNoCheckRollback(Session session, Row row, boolean log) throws HsqlException(Code)(Java Doc) int insertResult(Session session, Result ins) throws HsqlException(Code)(Java Doc) int insertSys(Result ins) throws HsqlException(Code)(Java Doc) public void insertSys(Object[] data) throws HsqlException(Code)(Java Doc) boolean isBestRowIdentifiersStrict()(Code)(Java Doc) public boolean isCached()(Code)(Java Doc) public boolean isConnected()(Code)(Java Doc) public boolean isDataReadOnly()(Code)(Java Doc) protected boolean isDescDataSource()(Code)(Java Doc) public boolean isEmpty(Session session)(Code)(Java Doc) boolean isFileBased()(Code)(Java Doc) boolean isIndexCached()(Code)(Java Doc) boolean isIndexingMutable()(Code)(Java Doc) final public boolean isReadOnly()(Code)(Java Doc) final public boolean isTemp()(Code)(Java Doc) final public boolean isText()(Code)(Java Doc) final boolean isView()(Code)(Java Doc) boolean isWritable()(Code)(Java Doc) HsqlName makeSysPKName() throws HsqlException(Code)(Java Doc) static boolean mergeKeepUpdate(Session session, HashMappedList rowSet, int[] cols, int[] colTypes, Row row, Object[] newData) throws HsqlException(Code)(Java Doc) static void mergeUpdate(HashMappedList rowSet, Row row, Object[] newData, int[] cols)(Code)(Java Doc) void moveData(Session session, Table from, int colindex, int adjust) throws HsqlException(Code)(Java Doc) Table moveDefinition(int[] removeIndex, Column newColumn, int colIndex, int adjust) throws HsqlException(Code)(Java Doc) Table moveDefinitionPK(int[] pkCols, boolean withIdentity) throws HsqlException(Code)(Java Doc) Row newRow(Object[] o) throws HsqlException(Code)(Java Doc) void releaseRowFromStore(Row row) throws HsqlException(Code)(Java Doc) void removeConstraint(String name)(Code)(Java Doc) void removeRowFromStore(Row row) throws HsqlException(Code)(Java Doc) void rename(Session session, String newname, boolean isquoted) throws HsqlException(Code)(Java Doc) void renameColumn(Column column, String newName, boolean isquoted) throws HsqlException(Code)(Java Doc) void resetDefaultsFlag()(Code)(Java Doc) public void resetRowId(Session session) throws HsqlException(Code)(Java Doc) Row restoreRow(Row oldrow) throws HsqlException(Code)(Java Doc) void setBestRowIdentifiers()(Code)(Java Doc) void setColumnTypeVars(int i)(Code)(Java Doc) void setDataReadOnly(boolean value) throws HsqlException(Code)(Java Doc) protected void setDataSource(Session s, String source, boolean isDesc, boolean newFile) throws HsqlException(Code)(Java Doc) void setDefaultExpression(int columnIndex, Expression def)(Code)(Java Doc) public void setHeader(String header) throws HsqlException(Code)(Java Doc) protected void setIdentityColumn(Session session, Object[] data) throws HsqlException(Code)(Java Doc) public void setIndexRoots(int[] roots) throws HsqlException(Code)(Java Doc) void setIndexRoots(String s) throws HsqlException(Code)(Java Doc) protected void setIsReadOnly(boolean newReadOnly)(Code)(Java Doc) int update(Session session, HashMappedList updateList, int[] cols) throws HsqlException(Code)(Java Doc) void updateConstraintsTables(Session session, Table old, int colindex, int adjust) throws HsqlException(Code)(Java Doc) protected void updateIdentityValue(Object[] data) throws HsqlException(Code)(Java Doc) void updateRowSet(Session session, HashMappedList rowSet, int[] cols, boolean nodelete) throws HsqlException(Code)(Java Doc) Methods inherited from org.hsqldb.BaseTable abstract Index getPrimaryIndex()(Code)(Java Doc) public RowIterator rowIterator(Session session) throws HsqlException(Code)(Java Doc) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)