ForeignTableVTI (Apache Derby 10.10 API Documentation)

Overview

Package

Class

Tree

Deprecated

Index

Help

Apache Derby 10.10

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.apache.derby.vti
Class ForeignTableVTI

java.lang.Object
  org.apache.derby.vti.VTITemplate
      org.apache.derby.vti.ForeignTableVTI

All Implemented Interfaces:: java.sql.ResultSet, java.sql.Wrapper, RestrictedVTI

public class ForeignTableVTI
extends VTITemplate
implements RestrictedVTI
extends VTITemplate
implements RestrictedVTI

This class contains a table function which can be used to bulk-import data from a foreign database. Because the table function is a RestrictedVTI, it can also be used to periodically and efficiently integrate data streams from a foreign database.

If you need to siphon data out of the foreign database on an ongoing basis, you can restrict the data you SELECT. Note that the local views are backed by RestrictedVTIs. That means that the actual query sent to the foreign database will only involve the columns you SELECT. In addition, the query will include the WHERE clause, provided that it is simple enough (see the javadoc for RestrictedVTI):

The following script shows how to use this table function:

 -- create a foreign database with a table in it
 connect 'jdbc:derby:memory:db;create=true;user=test_dbo;password=test_dbopassword';
 
 call syscs_util.syscs_create_user( 'test_dbo', 'test_dbopassword' );
 
 create table employee
 (
     firstName   varchar( 50 ),
     lastName    varchar( 50 ),
     employeeID  int primary key
 );
 
 insert into employee values ( 'Billy', 'Goatgruff', 1 );
 insert into employee values ( 'Mary', 'Hadalittlelamb', 2 );
 
 connect 'jdbc:derby:memory:db;shutdown=true';
 
 -- now create the database where we will do our work
 connect 'jdbc:derby:memory:db1;create=true';
 
 -- register a table function with the shape of the foreign table
 create function employeeFunction
 (
     schemaName  varchar( 32672 ),
     tableName   varchar( 32672 ),
     connectionURL        varchar( 32672 )
 )
 returns table
 (
     firstName   varchar( 50 ),
     lastName    varchar( 50 ),
     employeeID  int    
 )
 language java parameter style derby_jdbc_result_set no sql
 external name 'org.apache.derby.vti.ForeignTableVTI.readForeignTable'
 ;
 
 -- create a convenience view to factor out the function parameters
 create view foreignEmployee
 as select firstName, lastName, employeeID
 from table
 (
     employeeFunction
     (
         'TEST_DBO',
         'EMPLOYEE',
         'jdbc:derby:memory:db;user=test_dbo;password=test_dbopassword'
     )
 ) s;
 
 -- now select from the view as though it were a local table
 select * from foreignEmployee;
 select lastName from foreignEmployee where employeeID = 2;

Field Summary

Fields inherited from interface java.sql.ResultSet
`CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE`

Constructor Summary
`protected`	`ForeignTableVTI(java.lang.String foreignSchemaName, java.lang.String foreignTableName, java.lang.String connectionURL)`

Method Summary
`boolean`	`absolute(int arg0)`
`void`	`afterLast()`
`void`	`beforeFirst()`
`void`	`cancelRowUpdates()`
`void`	`clearWarnings()`
`void`	`close()`
`void`	`deleteRow()`
`int`	`findColumn(java.lang.String arg0)`
`boolean`	`first()`
`java.sql.Array`	`getArray(int arg0)`
`java.sql.Array`	`getArray(java.lang.String arg0)`
`java.io.InputStream`	`getAsciiStream(int i)`
`java.io.InputStream`	`getAsciiStream(java.lang.String arg0)`
`java.math.BigDecimal`	`getBigDecimal(int i)`
`java.math.BigDecimal`	`getBigDecimal(int i, int scale)`
`java.io.InputStream`	`getBinaryStream(int i)`
`java.io.InputStream`	`getBinaryStream(java.lang.String arg0)`
`java.sql.Blob`	`getBlob(int i)`
`java.sql.Blob`	`getBlob(java.lang.String arg0)`
`boolean`	`getBoolean(int i)`
`byte`	`getByte(int i)`
`byte[]`	`getBytes(int i)`
`java.io.Reader`	`getCharacterStream(int i)`
`java.io.Reader`	`getCharacterStream(java.lang.String arg0)`
`java.sql.Clob`	`getClob(int i)`
`java.sql.Clob`	`getClob(java.lang.String arg0)`
`int`	`getConcurrency()`
`java.lang.String`	`getCursorName()`
`java.sql.Date`	`getDate(int i)`
`java.sql.Date`	`getDate(int i, java.util.Calendar cal)`
`java.sql.Date`	`getDate(java.lang.String arg0, java.util.Calendar arg1)`
`double`	`getDouble(int i)`
`int`	`getFetchDirection()`
`int`	`getFetchSize()`
`float`	`getFloat(int i)`
`int`	`getInt(int i)`
`long`	`getLong(int i)`
`java.sql.ResultSetMetaData`	`getMetaData()`
`java.lang.Object`	`getObject(int i)`
`java.lang.Object`	`getObject(int arg0, java.util.Map arg1)`
`java.lang.Object`	`getObject(java.lang.String arg0, java.util.Map arg1)`
`java.sql.Ref`	`getRef(int arg0)`
`java.sql.Ref`	`getRef(java.lang.String arg0)`
`int`	`getRow()`
`short`	`getShort(int i)`
`java.sql.Statement`	`getStatement()`
`java.lang.String`	`getString(int i)`
`java.sql.Time`	`getTime(int i)`
`java.sql.Time`	`getTime(int i, java.util.Calendar cal)`
`java.sql.Time`	`getTime(java.lang.String arg0, java.util.Calendar arg1)`
`java.sql.Timestamp`	`getTimestamp(int i)`
`java.sql.Timestamp`	`getTimestamp(int i, java.util.Calendar cal)`
`java.sql.Timestamp`	`getTimestamp(java.lang.String arg0, java.util.Calendar arg1)`
`int`	`getType()`
`java.io.InputStream`	`getUnicodeStream(int arg0)`
`java.io.InputStream`	`getUnicodeStream(java.lang.String arg0)`
`java.net.URL`	`getURL(int arg0)`
`java.net.URL`	`getURL(java.lang.String arg0)`
`java.sql.SQLWarning`	`getWarnings()`
`void`	`initScan(java.lang.String[] columnNames, Restriction restriction)` Initialize a scan of a ResultSet.
`void`	`insertRow()`
`boolean`	`isAfterLast()`
`boolean`	`isBeforeFirst()`
`boolean`	`isClosed()`
`boolean`	`isFirst()`
`boolean`	`isLast()`
`boolean`	`last()`
`void`	`moveToCurrentRow()`
`void`	`moveToInsertRow()`
`boolean`	`next()`
`protected java.sql.SQLException`	`notImplemented(java.lang.String arg0)`
`boolean`	`previous()`
`static ForeignTableVTI`	`readForeignTable(java.lang.String foreignSchemaName, java.lang.String foreignTableName, java.lang.String connectionURL)` Table function to read a table in a foreign database.
`void`	`refreshRow()`
`boolean`	`relative(int arg0)`
`boolean`	`rowDeleted()`
`boolean`	`rowInserted()`
`boolean`	`rowUpdated()`
`void`	`setFetchDirection(int arg0)`
`void`	`setFetchSize(int arg0)`
`void`	`updateArray(int arg0, java.sql.Array arg1)`
`void`	`updateArray(java.lang.String arg0, java.sql.Array arg1)`
`void`	`updateAsciiStream(int arg0, java.io.InputStream arg1, int arg2)`
`void`	`updateAsciiStream(java.lang.String arg0, java.io.InputStream arg1, int arg2)`
`void`	`updateBigDecimal(int arg0, java.math.BigDecimal arg1)`
`void`	`updateBigDecimal(java.lang.String arg0, java.math.BigDecimal arg1)`
`void`	`updateBinaryStream(int arg0, java.io.InputStream arg1, int arg2)`
`void`	`updateBinaryStream(java.lang.String arg0, java.io.InputStream arg1, int arg2)`
`void`	`updateBlob(int arg0, java.sql.Blob arg1)`
`void`	`updateBlob(java.lang.String arg0, java.sql.Blob arg1)`
`void`	`updateBoolean(int arg0, boolean arg1)`
`void`	`updateBoolean(java.lang.String arg0, boolean arg1)`
`void`	`updateByte(int arg0, byte arg1)`
`void`	`updateByte(java.lang.String arg0, byte arg1)`
`void`	`updateBytes(int arg0, byte[] arg1)`
`void`	`updateBytes(java.lang.String arg0, byte[] arg1)`
`void`	`updateCharacterStream(int arg0, java.io.Reader arg1, int arg2)`
`void`	`updateCharacterStream(java.lang.String arg0, java.io.Reader arg1, int arg2)`
`void`	`updateClob(int arg0, java.sql.Clob arg1)`
`void`	`updateClob(java.lang.String arg0, java.sql.Clob arg1)`
`void`	`updateDate(int arg0, java.sql.Date arg1)`
`void`	`updateDate(java.lang.String arg0, java.sql.Date arg1)`
`void`	`updateDouble(int arg0, double arg1)`
`void`	`updateDouble(java.lang.String arg0, double arg1)`
`void`	`updateFloat(int arg0, float arg1)`
`void`	`updateFloat(java.lang.String arg0, float arg1)`
`void`	`updateInt(int arg0, int arg1)`
`void`	`updateInt(java.lang.String arg0, int arg1)`
`void`	`updateLong(int arg0, long arg1)`
`void`	`updateLong(java.lang.String arg0, long arg1)`
`void`	`updateNull(int arg0)`
`void`	`updateNull(java.lang.String arg0)`
`void`	`updateObject(int arg0, java.lang.Object arg1)`
`void`	`updateObject(int arg0, java.lang.Object arg1, int arg2)`
`void`	`updateObject(java.lang.String arg0, java.lang.Object arg1)`
`void`	`updateObject(java.lang.String arg0, java.lang.Object arg1, int arg2)`
`void`	`updateRef(int arg0, java.sql.Ref arg1)`
`void`	`updateRef(java.lang.String arg0, java.sql.Ref arg1)`
`void`	`updateRow()`
`void`	`updateShort(int arg0, short arg1)`
`void`	`updateShort(java.lang.String arg0, short arg1)`
`void`	`updateString(int arg0, java.lang.String arg1)`
`void`	`updateString(java.lang.String arg0, java.lang.String arg1)`
`void`	`updateTime(int arg0, java.sql.Time arg1)`
`void`	`updateTime(java.lang.String arg0, java.sql.Time arg1)`
`void`	`updateTimestamp(int arg0, java.sql.Timestamp arg1)`
`void`	`updateTimestamp(java.lang.String arg0, java.sql.Timestamp arg1)`
`boolean`	`wasNull()`

Methods inherited from class org.apache.derby.vti.VTITemplate
`getBigDecimal, getBigDecimal, getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLong, getObject, getShort, getString, getTime, getTimestamp`

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Methods inherited from interface java.sql.ResultSet
getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateRowId, updateRowId, updateSQLXML, updateSQLXML

Methods inherited from interface java.sql.ResultSet

getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateRowId, updateRowId, updateSQLXML, updateSQLXML

Methods inherited from interface java.sql.Wrapper
`isWrapperFor, unwrap`

Constructor Detail

ForeignTableVTI

protected ForeignTableVTI(java.lang.String foreignSchemaName,
                          java.lang.String foreignTableName,
                          java.lang.String connectionURL)

Method Detail

readForeignTable

public static ForeignTableVTI readForeignTable(java.lang.String foreignSchemaName,
                                               java.lang.String foreignTableName,
                                               java.lang.String connectionURL)

Table function to read a table in a foreign database.

Parameters:: foreignSchemaName - Case-sensitive name of foreign schema; foreignTableName - Case-sensitive name of foreign table; connectionURL - URL for connecting to foreign database via DriverManager.getConnection()

close

public void close()
           throws java.sql.SQLException

Specified by:: close in interface java.sql.ResultSet
Specified by:: close in class VTITemplate

Throws:: java.sql.SQLException

public boolean next()
             throws java.sql.SQLException

Specified by:: next in interface java.sql.ResultSet
Specified by:: next in class VTITemplate

Throws:: java.sql.SQLException

isClosed

public boolean isClosed()

Specified by:: isClosed in interface java.sql.ResultSet

wasNull

public boolean wasNull()
                throws java.sql.SQLException

Specified by:: wasNull in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Specified by:: getMetaData in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getAsciiStream

public java.io.InputStream getAsciiStream(int i)
                                   throws java.sql.SQLException

Specified by:: getAsciiStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(int i)
                                   throws java.sql.SQLException

Specified by:: getBigDecimal in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(int i,
                                          int scale)
                                   throws java.sql.SQLException

Specified by:: getBigDecimal in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getBinaryStream

public java.io.InputStream getBinaryStream(int i)
                                    throws java.sql.SQLException

Specified by:: getBinaryStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getBlob

public java.sql.Blob getBlob(int i)
                      throws java.sql.SQLException

Specified by:: getBlob in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getBoolean

public boolean getBoolean(int i)
                   throws java.sql.SQLException

Specified by:: getBoolean in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getByte

public byte getByte(int i)
             throws java.sql.SQLException

Specified by:: getByte in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getBytes

public byte[] getBytes(int i)
                throws java.sql.SQLException

Specified by:: getBytes in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getCharacterStream

public java.io.Reader getCharacterStream(int i)
                                  throws java.sql.SQLException

Specified by:: getCharacterStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getClob

public java.sql.Clob getClob(int i)
                      throws java.sql.SQLException

Specified by:: getClob in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getDate

public java.sql.Date getDate(int i)
                      throws java.sql.SQLException

Specified by:: getDate in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getDate

public java.sql.Date getDate(int i,
                             java.util.Calendar cal)
                      throws java.sql.SQLException

Specified by:: getDate in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getDouble

public double getDouble(int i)
                 throws java.sql.SQLException

Specified by:: getDouble in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getFloat

public float getFloat(int i)
               throws java.sql.SQLException

Specified by:: getFloat in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getInt

public int getInt(int i)
           throws java.sql.SQLException

Specified by:: getInt in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getLong

public long getLong(int i)
             throws java.sql.SQLException

Specified by:: getLong in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getObject

public java.lang.Object getObject(int i)
                           throws java.sql.SQLException

Specified by:: getObject in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getShort

public short getShort(int i)
               throws java.sql.SQLException

Specified by:: getShort in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getString

public java.lang.String getString(int i)
                           throws java.sql.SQLException

Specified by:: getString in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getTime

public java.sql.Time getTime(int i)
                      throws java.sql.SQLException

Specified by:: getTime in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getTime

public java.sql.Time getTime(int i,
                             java.util.Calendar cal)
                      throws java.sql.SQLException

Specified by:: getTime in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(int i)
                                throws java.sql.SQLException

Specified by:: getTimestamp in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(int i,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException

Specified by:: getTimestamp in interface java.sql.ResultSet

Throws:: java.sql.SQLException

initScan

public void initScan(java.lang.String[] columnNames,
                     Restriction restriction)
              throws java.sql.SQLException

Description copied from interface: RestrictedVTI

Initialize a scan of a ResultSet. This method is called once before the scan begins. It is called before any ResultSet method is called. This method performs two tasks:

Column names - Tells the ResultSet which columns need to be fetched.

Limits - Gives the ResultSet simple bounds to apply in order to limit which rows are returned. Note that the ResultSet does not have to enforce all of these bounds. Derby will redundantly enforce these limits on all rows returned by the ResultSet. That is, filtering not performed inside the ResultSet will still happen outside the ResultSet.

The columnNames argument is an array of columns which need to be fetched. This is an array of the column names declared in the Table Function's CREATE FUNCTION statement. Column names which were double-quoted in the CREATE FUNCTION statement appear case-sensitive in this array. Column names which were not double-quoted appear upper-cased. Derby asks the Table Function to fetch all columns mentioned in the query. This includes columns mentioned in the SELECT list as well as columns mentioned in the WHERE clause. Note that a column could be mentioned in the WHERE clause in a complex expression which could not be passed to the Table Function via the restriction argument.

The array has one slot for each column declared in the CREATE FUNCTION statement. Slot 0 corresponds to the first column declared in the CREATE FUNCTION statement and so on. If a column does not need to be fetched, then the corresponding slot is null. If a column needs to be fetched, then the corresponding slot holds the column's name.

Note that even though the array may have gaps, it is expected that columns in the ResultSet will occur at the positions declared in the CREATE FUNCTION statement. Consider the following declaration:

  create function foreignEmployeeTable()
  returns table
  (
      id        int,
      birthDay  date,
      firstName varchar( 100 ),
      lastName  varchar( 100 )
  )
 ...

and the following query:

 select lastName from table( foreignEmployeeTable() ) s

In this example, the array passed to this method will have 4 slots. Slots 0, 1, and 2 will be null and slot 3 will hold the String "LASTNAME". Last names will be retrieved from the ResultSet by calls to getString( 4 )--remember that JDBC column ids are 1-based.

The restriction argument is a simple expression which should be evaluated inside the Table Function in order to eliminate rows. The expression is a binary tree built out of ANDs, ORs, and column qualifiers. The column qualifiers are simple comparisons between constant values and columns in the Table Function. The Table Function only returns rows which satisfy the expression. The restriction is redundantly enforced by Derby on the rows returned by the ResultSet--this means that restriction gives the Table Function a hint about how to optimize its performance but the Table Function is not required to enforce the entire restriction.

Specified by:: initScan in interface RestrictedVTI

Throws:: java.sql.SQLException

getUnicodeStream

public java.io.InputStream getUnicodeStream(int arg0)
                                     throws java.sql.SQLException

Specified by:: getUnicodeStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String arg0)
                                   throws java.sql.SQLException

Specified by:: getAsciiStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String arg0)
                                     throws java.sql.SQLException

Specified by:: getUnicodeStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String arg0)
                                    throws java.sql.SQLException

Specified by:: getBinaryStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Specified by:: getWarnings in interface java.sql.ResultSet

Throws:: java.sql.SQLException

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:: clearWarnings in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException

Specified by:: getCursorName in interface java.sql.ResultSet

Throws:: java.sql.SQLException

findColumn

public int findColumn(java.lang.String arg0)
               throws java.sql.SQLException

Specified by:: findColumn in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String arg0)
                                  throws java.sql.SQLException

Specified by:: getCharacterStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException

Specified by:: isBeforeFirst in interface java.sql.ResultSet

Throws:: java.sql.SQLException

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException

Specified by:: isAfterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException

isFirst

public boolean isFirst()
                throws java.sql.SQLException

Specified by:: isFirst in interface java.sql.ResultSet

Throws:: java.sql.SQLException

isLast

public boolean isLast()
               throws java.sql.SQLException

Specified by:: isLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException

Specified by:: beforeFirst in interface java.sql.ResultSet

Throws:: java.sql.SQLException

afterLast

public void afterLast()
               throws java.sql.SQLException

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException

first

public boolean first()
              throws java.sql.SQLException

Specified by:: first in interface java.sql.ResultSet

Throws:: java.sql.SQLException

last

public boolean last()
             throws java.sql.SQLException

Specified by:: last in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getRow

public int getRow()
           throws java.sql.SQLException

Specified by:: getRow in interface java.sql.ResultSet

Throws:: java.sql.SQLException

absolute

public boolean absolute(int arg0)
                 throws java.sql.SQLException

Specified by:: absolute in interface java.sql.ResultSet

Throws:: java.sql.SQLException

relative

public boolean relative(int arg0)
                 throws java.sql.SQLException

Specified by:: relative in interface java.sql.ResultSet

Throws:: java.sql.SQLException

public boolean previous()
                 throws java.sql.SQLException

Specified by:: previous in interface java.sql.ResultSet

Throws:: java.sql.SQLException

setFetchDirection

public void setFetchDirection(int arg0)
                       throws java.sql.SQLException

Specified by:: setFetchDirection in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException

Specified by:: getFetchDirection in interface java.sql.ResultSet

Throws:: java.sql.SQLException

setFetchSize

public void setFetchSize(int arg0)
                  throws java.sql.SQLException

Specified by:: setFetchSize in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException

Specified by:: getFetchSize in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getType

public int getType()
            throws java.sql.SQLException

Specified by:: getType in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException

Specified by:: getConcurrency in interface java.sql.ResultSet

Throws:: java.sql.SQLException

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException

Specified by:: rowUpdated in interface java.sql.ResultSet

Throws:: java.sql.SQLException

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException

Specified by:: rowInserted in interface java.sql.ResultSet

Throws:: java.sql.SQLException

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException

Specified by:: rowDeleted in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateNull

public void updateNull(int arg0)
                throws java.sql.SQLException

Specified by:: updateNull in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateBoolean

public void updateBoolean(int arg0,
                          boolean arg1)
                   throws java.sql.SQLException

Specified by:: updateBoolean in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateByte

public void updateByte(int arg0,
                       byte arg1)
                throws java.sql.SQLException

Specified by:: updateByte in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateShort

public void updateShort(int arg0,
                        short arg1)
                 throws java.sql.SQLException

Specified by:: updateShort in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateInt

public void updateInt(int arg0,
                      int arg1)
               throws java.sql.SQLException

Specified by:: updateInt in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateLong

public void updateLong(int arg0,
                       long arg1)
                throws java.sql.SQLException

Specified by:: updateLong in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateFloat

public void updateFloat(int arg0,
                        float arg1)
                 throws java.sql.SQLException

Specified by:: updateFloat in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateDouble

public void updateDouble(int arg0,
                         double arg1)
                  throws java.sql.SQLException

Specified by:: updateDouble in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateBigDecimal

public void updateBigDecimal(int arg0,
                             java.math.BigDecimal arg1)
                      throws java.sql.SQLException

Specified by:: updateBigDecimal in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateString

public void updateString(int arg0,
                         java.lang.String arg1)
                  throws java.sql.SQLException

Specified by:: updateString in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateBytes

public void updateBytes(int arg0,
                        byte[] arg1)
                 throws java.sql.SQLException

Specified by:: updateBytes in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateDate

public void updateDate(int arg0,
                       java.sql.Date arg1)
                throws java.sql.SQLException

Specified by:: updateDate in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateTime

public void updateTime(int arg0,
                       java.sql.Time arg1)
                throws java.sql.SQLException

Specified by:: updateTime in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateTimestamp

public void updateTimestamp(int arg0,
                            java.sql.Timestamp arg1)
                     throws java.sql.SQLException

Specified by:: updateTimestamp in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int arg0,
                              java.io.InputStream arg1,
                              int arg2)
                       throws java.sql.SQLException

Specified by:: updateAsciiStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int arg0,
                               java.io.InputStream arg1,
                               int arg2)
                        throws java.sql.SQLException

Specified by:: updateBinaryStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int arg0,
                                  java.io.Reader arg1,
                                  int arg2)
                           throws java.sql.SQLException

Specified by:: updateCharacterStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateObject

public void updateObject(int arg0,
                         java.lang.Object arg1,
                         int arg2)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateObject

public void updateObject(int arg0,
                         java.lang.Object arg1)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateNull

public void updateNull(java.lang.String arg0)
                throws java.sql.SQLException

Specified by:: updateNull in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateBoolean

public void updateBoolean(java.lang.String arg0,
                          boolean arg1)
                   throws java.sql.SQLException

Specified by:: updateBoolean in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateByte

public void updateByte(java.lang.String arg0,
                       byte arg1)
                throws java.sql.SQLException

Specified by:: updateByte in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateShort

public void updateShort(java.lang.String arg0,
                        short arg1)
                 throws java.sql.SQLException

Specified by:: updateShort in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateInt

public void updateInt(java.lang.String arg0,
                      int arg1)
               throws java.sql.SQLException

Specified by:: updateInt in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateLong

public void updateLong(java.lang.String arg0,
                       long arg1)
                throws java.sql.SQLException

Specified by:: updateLong in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateFloat

public void updateFloat(java.lang.String arg0,
                        float arg1)
                 throws java.sql.SQLException

Specified by:: updateFloat in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateDouble

public void updateDouble(java.lang.String arg0,
                         double arg1)
                  throws java.sql.SQLException

Specified by:: updateDouble in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateBigDecimal

public void updateBigDecimal(java.lang.String arg0,
                             java.math.BigDecimal arg1)
                      throws java.sql.SQLException

Specified by:: updateBigDecimal in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateString

public void updateString(java.lang.String arg0,
                         java.lang.String arg1)
                  throws java.sql.SQLException

Specified by:: updateString in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateBytes

public void updateBytes(java.lang.String arg0,
                        byte[] arg1)
                 throws java.sql.SQLException

Specified by:: updateBytes in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateDate

public void updateDate(java.lang.String arg0,
                       java.sql.Date arg1)
                throws java.sql.SQLException

Specified by:: updateDate in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateTime

public void updateTime(java.lang.String arg0,
                       java.sql.Time arg1)
                throws java.sql.SQLException

Specified by:: updateTime in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateTimestamp

public void updateTimestamp(java.lang.String arg0,
                            java.sql.Timestamp arg1)
                     throws java.sql.SQLException

Specified by:: updateTimestamp in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String arg0,
                              java.io.InputStream arg1,
                              int arg2)
                       throws java.sql.SQLException

Specified by:: updateAsciiStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String arg0,
                               java.io.InputStream arg1,
                               int arg2)
                        throws java.sql.SQLException

Specified by:: updateBinaryStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String arg0,
                                  java.io.Reader arg1,
                                  int arg2)
                           throws java.sql.SQLException

Specified by:: updateCharacterStream in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateObject

public void updateObject(java.lang.String arg0,
                         java.lang.Object arg1,
                         int arg2)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateObject

public void updateObject(java.lang.String arg0,
                         java.lang.Object arg1)
                  throws java.sql.SQLException

Specified by:: updateObject in interface java.sql.ResultSet

Throws:: java.sql.SQLException

insertRow

public void insertRow()
               throws java.sql.SQLException

Specified by:: insertRow in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateRow

public void updateRow()
               throws java.sql.SQLException

Specified by:: updateRow in interface java.sql.ResultSet

Throws:: java.sql.SQLException

deleteRow

public void deleteRow()
               throws java.sql.SQLException

Specified by:: deleteRow in interface java.sql.ResultSet

Throws:: java.sql.SQLException

refreshRow

public void refreshRow()
                throws java.sql.SQLException

Specified by:: refreshRow in interface java.sql.ResultSet

Throws:: java.sql.SQLException

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException

Specified by:: cancelRowUpdates in interface java.sql.ResultSet

Throws:: java.sql.SQLException

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException

Specified by:: moveToInsertRow in interface java.sql.ResultSet

Throws:: java.sql.SQLException

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException

Specified by:: moveToCurrentRow in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getStatement

public java.sql.Statement getStatement()
                                throws java.sql.SQLException

Specified by:: getStatement in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getDate

public java.sql.Date getDate(java.lang.String arg0,
                             java.util.Calendar arg1)
                      throws java.sql.SQLException

Specified by:: getDate in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getTime

public java.sql.Time getTime(java.lang.String arg0,
                             java.util.Calendar arg1)
                      throws java.sql.SQLException

Specified by:: getTime in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String arg0,
                                       java.util.Calendar arg1)
                                throws java.sql.SQLException

Specified by:: getTimestamp in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getURL

public java.net.URL getURL(int arg0)
                    throws java.sql.SQLException

Specified by:: getURL in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getURL

public java.net.URL getURL(java.lang.String arg0)
                    throws java.sql.SQLException

Specified by:: getURL in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getObject

public java.lang.Object getObject(int arg0,
                                  java.util.Map arg1)
                           throws java.sql.SQLException

Specified by:: getObject in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getRef

public java.sql.Ref getRef(int arg0)
                    throws java.sql.SQLException

Specified by:: getRef in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getArray

public java.sql.Array getArray(int arg0)
                        throws java.sql.SQLException

Specified by:: getArray in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getObject

public java.lang.Object getObject(java.lang.String arg0,
                                  java.util.Map arg1)
                           throws java.sql.SQLException

Specified by:: getObject in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getRef

public java.sql.Ref getRef(java.lang.String arg0)
                    throws java.sql.SQLException

Specified by:: getRef in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getBlob

public java.sql.Blob getBlob(java.lang.String arg0)
                      throws java.sql.SQLException

Specified by:: getBlob in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getClob

public java.sql.Clob getClob(java.lang.String arg0)
                      throws java.sql.SQLException

Specified by:: getClob in interface java.sql.ResultSet

Throws:: java.sql.SQLException

getArray

public java.sql.Array getArray(java.lang.String arg0)
                        throws java.sql.SQLException

Specified by:: getArray in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateRef

public void updateRef(int arg0,
                      java.sql.Ref arg1)
               throws java.sql.SQLException

Specified by:: updateRef in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateRef

public void updateRef(java.lang.String arg0,
                      java.sql.Ref arg1)
               throws java.sql.SQLException

Specified by:: updateRef in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateBlob

public void updateBlob(int arg0,
                       java.sql.Blob arg1)
                throws java.sql.SQLException

Specified by:: updateBlob in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String arg0,
                       java.sql.Blob arg1)
                throws java.sql.SQLException

Specified by:: updateBlob in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateClob

public void updateClob(int arg0,
                       java.sql.Clob arg1)
                throws java.sql.SQLException

Specified by:: updateClob in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateClob

public void updateClob(java.lang.String arg0,
                       java.sql.Clob arg1)
                throws java.sql.SQLException

Specified by:: updateClob in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateArray

public void updateArray(int arg0,
                        java.sql.Array arg1)
                 throws java.sql.SQLException

Specified by:: updateArray in interface java.sql.ResultSet

Throws:: java.sql.SQLException

updateArray

public void updateArray(java.lang.String arg0,
                        java.sql.Array arg1)
                 throws java.sql.SQLException

Specified by:: updateArray in interface java.sql.ResultSet

Throws:: java.sql.SQLException

notImplemented

protected java.sql.SQLException notImplemented(java.lang.String arg0)

Overview

Package

Class

Tree

Deprecated

Index

Help

Built on Wed 2013-06-12 15:21:56+0000, from revision ???

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.apache.derby.vti Class ForeignTableVTI

ForeignTableVTI

readForeignTable

close

next

isClosed

wasNull

getMetaData

getAsciiStream

getBigDecimal

getBigDecimal

getBinaryStream

getBlob

getBoolean

getByte

getBytes

getCharacterStream

getClob

getDate

getDate

getDouble

getFloat

getInt

getLong

getObject

getShort

getString

getTime

getTime

getTimestamp

getTimestamp

initScan

getUnicodeStream

getAsciiStream

getUnicodeStream

getBinaryStream

getWarnings

clearWarnings

getCursorName

findColumn

getCharacterStream

isBeforeFirst

isAfterLast

isFirst

isLast

beforeFirst

afterLast

first

last

getRow

absolute

relative

previous

setFetchDirection

getFetchDirection

setFetchSize

getFetchSize

getType

getConcurrency

rowUpdated

rowInserted

rowDeleted

updateNull

updateBoolean

updateByte

updateShort

updateInt

updateLong

updateFloat

updateDouble

updateBigDecimal

updateString

updateBytes

updateDate

updateTime

updateTimestamp

updateAsciiStream

updateBinaryStream

updateCharacterStream

updateObject

org.apache.derby.vti
Class ForeignTableVTI