| java.lang.Object
 org.axiondb.engine.tables.ExternalDatabaseTable
| ExternalDatabaseTable | | public class ExternalDatabaseTable implements ExternalTable,TransactableTable(Code) | | Base implementation of ExternalTable interface.
Example:
create external table emp (lname varchar(80), sid integer(6),
fname varchar(80), id integer(6) not null, dob timestamp(6))
organization (loadtype='remote' SERVER='myserver'
REMOTETABLE='mytablename' SCHEMA='myschema' WHERE='id > 1000');
Note : We have tested this for Oracle 8i/9i/10g , SQL Server, Sybase and DB2.
version:
$Revision: 1.27 $ $Date: 2006/01/10 21:02:36 $
author:
Jonathan Giron
author:
Rahul Dwivedi
author:
Ahimanikya Satapathy
See Also: org.axiondb.DatabaseLink |
| Method Summary | |
| public void | addColumn(Column col)
Add the given
Column to this table. | | public void | addConstraint(Constraint constraint)
| | public void | addConstraint(Constraint constraint, boolean checkExistingRows)
| | public void | addIndex(Index index)
| | public void | addRow(Row row)
| | public void | addTableModificationListener(TableModificationListener listener)
| | public void | apply()
| | public void | applyDeletes(IntCollection rowIds)
| | public void | applyInserts(RowCollection rows)
| | public void | applyUpdates(RowCollection rows)
| | protected void | checkConstraints(RowEvent event)
| | public void | checkpoint()
| | public void | commit()
| | public void | deleteRow(Row row)
| | public void | drop()
| | public void | freeRowId(int id)
| | final public Column | getColumn(int index)
| | public Column | getColumn(String name)
| | final public int | getColumnCount()
| | public List | getColumnIdentifiers()
| | public int | getColumnIndex(String name)
| | final public Constraint | getConstraint(String name)
| | public Iterator | getConstraints()
| | public String | getDBLinkName()
| | protected String | getDeleteSQL()
| | public Index | getIndexForColumn(Column column)
| | public RowIterator | getIndexedRows(RowSource source, Selectable node, boolean readOnly)
| | public RowIterator | getIndexedRows(Selectable node, boolean readOnly)
| | public Iterator | getIndices()
| | protected String | getInsertSQL()
| | public RowIterator | getMatchingRows(List selectables, List values, boolean readOnly)
| | final public String | getName()
| | public int | getNextRowId()
| | public Row | getRow(int id)
| | public int | getRowCount()
| | public RowIterator | getRowIterator(boolean readOnly)
| | protected RowIterator | getRowIterator()
| | protected String | getSchemaWildcardForRemoteDB()
Gets appropriate string for use in indicating wildcard search for schemas. | | protected String | getSelectSQL(String where)
| | final public Sequence | getSequence()
| | public Iterator | getTableModificationListeners()
| | public Properties | getTableProperties()
| | final public String | getType()
| | protected String | getUpdateSQL()
| | public boolean | hasColumn(ColumnIdentifier id)
| | public boolean | hasIndex(String name)
| | public boolean | isColumnIndexed(Column column)
| | public boolean | isPrimaryKeyConstraintExists(String columnName)
| | public boolean | isUniqueConstraintExists(String columnName)
| | public boolean | loadExternalTable(Properties props)
| | public RowDecorator | makeRowDecorator()
| | public TransactableTable | makeTransactableTable()
| | public void | migrate()
| | public void | populateIndex(Index index)
| | public void | remount()
| | public void | remount(File dir, boolean datafilesonly)
| | public Constraint | removeConstraint(String name)
| | public void | removeIndex(Index index)
| | public void | removeTableModificationListener(TableModificationListener listener)
| | public void | rename(String oldName, String newName)
| | public void | rollback()
| | public void | setDeferAllConstraints(boolean deferAll)
| | public void | setSequence(Sequence seq)
| | protected void | setUp(DatabaseLink server)
| | public void | shutdown()
| | public String | toString()
| | public void | truncate()
| | public void | updateRow(Row oldrow, Row newrow)
| | public void | updateRow(Row oldrow, Row newrow, List cols)
|
| freeRowId | | public void freeRowId(int id)(Code) | | |
| getColumnCount | | final public int getColumnCount()(Code) | | |
| getColumnIdentifiers | | public List getColumnIdentifiers()(Code) | | |
| getNextRowId | | public int getNextRowId()(Code) | | |
| getRowCount | | public int getRowCount()(Code) | | |
| getSchemaWildcardForRemoteDB | | protected String getSchemaWildcardForRemoteDB()(Code) | | Gets appropriate string for use in indicating wildcard search for schemas.
wildcard string. |
| getTableModificationListeners | | public Iterator getTableModificationListeners()(Code) | | |
| isColumnIndexed | | public boolean isColumnIndexed(Column column)(Code) | | |
| isPrimaryKeyConstraintExists | | public boolean isPrimaryKeyConstraintExists(String columnName)(Code) | | |
| isUniqueConstraintExists | | public boolean isUniqueConstraintExists(String columnName)(Code) | | check if unique constraint exists on a column
Parameters:
columnName - name of the column true if uniqueConstraint exists on the column |
| setDeferAllConstraints | | public void setDeferAllConstraints(boolean deferAll)(Code) | | |
|
|