public class ForeignTableVTI 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;
Modifier | Constructor and Description |
---|---|
protected |
ForeignTableVTI(java.lang.String foreignSchemaName,
java.lang.String foreignTableName,
java.lang.String connectionURL) |
Modifier and Type | Method and Description |
---|---|
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() |
getBigDecimal, getBigDecimal, getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLong, getObject, getShort, getString, getTime, getTimestamp
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
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
protected ForeignTableVTI(java.lang.String foreignSchemaName, java.lang.String foreignTableName, java.lang.String connectionURL)
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.
foreignSchemaName
- Case-sensitive name of foreign schemaforeignTableName
- Case-sensitive name of foreign tableconnectionURL
- URL for connecting to foreign database via DriverManager.getConnection()public void close() throws java.sql.SQLException
close
in interface java.sql.ResultSet
close
in class VTITemplate
java.sql.SQLException
public boolean next() throws java.sql.SQLException
next
in interface java.sql.ResultSet
next
in class VTITemplate
java.sql.SQLException
public boolean isClosed()
isClosed
in interface java.sql.ResultSet
public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.InputStream getAsciiStream(int i) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int i) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int i, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.InputStream getBinaryStream(int i) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Blob getBlob(int i) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
java.sql.SQLException
public boolean getBoolean(int i) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
java.sql.SQLException
public byte getByte(int i) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
java.sql.SQLException
public byte[] getBytes(int i) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.Reader getCharacterStream(int i) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Clob getClob(int i) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Date getDate(int i) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Date getDate(int i, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
java.sql.SQLException
public double getDouble(int i) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
java.sql.SQLException
public float getFloat(int i) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
java.sql.SQLException
public int getInt(int i) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
java.sql.SQLException
public long getLong(int i) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.Object getObject(int i) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public short getShort(int i) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.String getString(int i) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Time getTime(int i) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Time getTime(int i, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int i) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int i, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public void initScan(java.lang.String[] columnNames, Restriction restriction) throws java.sql.SQLException
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:
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.
initScan
in interface RestrictedVTI
java.sql.SQLException
public java.io.InputStream getUnicodeStream(int arg0) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.InputStream getAsciiStream(java.lang.String arg0) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.InputStream getUnicodeStream(java.lang.String arg0) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.InputStream getBinaryStream(java.lang.String arg0) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
getWarnings
in interface java.sql.ResultSet
java.sql.SQLException
public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.String getCursorName() throws java.sql.SQLException
getCursorName
in interface java.sql.ResultSet
java.sql.SQLException
public int findColumn(java.lang.String arg0) throws java.sql.SQLException
findColumn
in interface java.sql.ResultSet
java.sql.SQLException
public java.io.Reader getCharacterStream(java.lang.String arg0) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isBeforeFirst() throws java.sql.SQLException
isBeforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isAfterLast() throws java.sql.SQLException
isAfterLast
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isFirst() throws java.sql.SQLException
isFirst
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isLast() throws java.sql.SQLException
isLast
in interface java.sql.ResultSet
java.sql.SQLException
public void beforeFirst() throws java.sql.SQLException
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
public void afterLast() throws java.sql.SQLException
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
public boolean first() throws java.sql.SQLException
first
in interface java.sql.ResultSet
java.sql.SQLException
public boolean last() throws java.sql.SQLException
last
in interface java.sql.ResultSet
java.sql.SQLException
public int getRow() throws java.sql.SQLException
getRow
in interface java.sql.ResultSet
java.sql.SQLException
public boolean absolute(int arg0) throws java.sql.SQLException
absolute
in interface java.sql.ResultSet
java.sql.SQLException
public boolean relative(int arg0) throws java.sql.SQLException
relative
in interface java.sql.ResultSet
java.sql.SQLException
public boolean previous() throws java.sql.SQLException
previous
in interface java.sql.ResultSet
java.sql.SQLException
public void setFetchDirection(int arg0) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
public int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
public void setFetchSize(int arg0) throws java.sql.SQLException
setFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
public int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
public int getType() throws java.sql.SQLException
getType
in interface java.sql.ResultSet
java.sql.SQLException
public int getConcurrency() throws java.sql.SQLException
getConcurrency
in interface java.sql.ResultSet
java.sql.SQLException
public boolean rowUpdated() throws java.sql.SQLException
rowUpdated
in interface java.sql.ResultSet
java.sql.SQLException
public boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
java.sql.SQLException
public boolean rowDeleted() throws java.sql.SQLException
rowDeleted
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNull(int arg0) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBoolean(int arg0, boolean arg1) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
java.sql.SQLException
public void updateByte(int arg0, byte arg1) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
java.sql.SQLException
public void updateShort(int arg0, short arg1) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
java.sql.SQLException
public void updateInt(int arg0, int arg1) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
java.sql.SQLException
public void updateLong(int arg0, long arg1) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
java.sql.SQLException
public void updateFloat(int arg0, float arg1) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
java.sql.SQLException
public void updateDouble(int arg0, double arg1) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBigDecimal(int arg0, java.math.BigDecimal arg1) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public void updateString(int arg0, java.lang.String arg1) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBytes(int arg0, byte[] arg1) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
java.sql.SQLException
public void updateDate(int arg0, java.sql.Date arg1) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
java.sql.SQLException
public void updateTime(int arg0, java.sql.Time arg1) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
java.sql.SQLException
public void updateTimestamp(int arg0, java.sql.Timestamp arg1) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public void updateAsciiStream(int arg0, java.io.InputStream arg1, int arg2) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBinaryStream(int arg0, java.io.InputStream arg1, int arg2) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateCharacterStream(int arg0, java.io.Reader arg1, int arg2) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateObject(int arg0, java.lang.Object arg1, int arg2) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
java.sql.SQLException
public void updateObject(int arg0, java.lang.Object arg1) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
java.sql.SQLException
public void updateNull(java.lang.String arg0) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBoolean(java.lang.String arg0, boolean arg1) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
java.sql.SQLException
public void updateByte(java.lang.String arg0, byte arg1) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
java.sql.SQLException
public void updateShort(java.lang.String arg0, short arg1) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
java.sql.SQLException
public void updateInt(java.lang.String arg0, int arg1) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
java.sql.SQLException
public void updateLong(java.lang.String arg0, long arg1) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
java.sql.SQLException
public void updateFloat(java.lang.String arg0, float arg1) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
java.sql.SQLException
public void updateDouble(java.lang.String arg0, double arg1) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBigDecimal(java.lang.String arg0, java.math.BigDecimal arg1) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public void updateString(java.lang.String arg0, java.lang.String arg1) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBytes(java.lang.String arg0, byte[] arg1) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
java.sql.SQLException
public void updateDate(java.lang.String arg0, java.sql.Date arg1) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
java.sql.SQLException
public void updateTime(java.lang.String arg0, java.sql.Time arg1) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
java.sql.SQLException
public void updateTimestamp(java.lang.String arg0, java.sql.Timestamp arg1) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public void updateAsciiStream(java.lang.String arg0, java.io.InputStream arg1, int arg2) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBinaryStream(java.lang.String arg0, java.io.InputStream arg1, int arg2) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateCharacterStream(java.lang.String arg0, java.io.Reader arg1, int arg2) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public void updateObject(java.lang.String arg0, java.lang.Object arg1, int arg2) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
java.sql.SQLException
public void updateObject(java.lang.String arg0, java.lang.Object arg1) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
java.sql.SQLException
public void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
public void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
public void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
public void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
public void cancelRowUpdates() throws java.sql.SQLException
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
public void moveToInsertRow() throws java.sql.SQLException
moveToInsertRow
in interface java.sql.ResultSet
java.sql.SQLException
public void moveToCurrentRow() throws java.sql.SQLException
moveToCurrentRow
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Statement getStatement() throws java.sql.SQLException
getStatement
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Date getDate(java.lang.String arg0, java.util.Calendar arg1) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Time getTime(java.lang.String arg0, java.util.Calendar arg1) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String arg0, java.util.Calendar arg1) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public java.net.URL getURL(int arg0) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public java.net.URL getURL(java.lang.String arg0) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.Object getObject(int arg0, java.util.Map arg1) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Ref getRef(int arg0) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Array getArray(int arg0) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
java.sql.SQLException
public java.lang.Object getObject(java.lang.String arg0, java.util.Map arg1) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Ref getRef(java.lang.String arg0) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Blob getBlob(java.lang.String arg0) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Clob getClob(java.lang.String arg0) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Array getArray(java.lang.String arg0) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
java.sql.SQLException
public void updateRef(int arg0, java.sql.Ref arg1) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
public void updateRef(java.lang.String arg0, java.sql.Ref arg1) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(int arg0, java.sql.Blob arg1) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(java.lang.String arg0, java.sql.Blob arg1) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateClob(int arg0, java.sql.Clob arg1) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateClob(java.lang.String arg0, java.sql.Clob arg1) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateArray(int arg0, java.sql.Array arg1) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
public void updateArray(java.lang.String arg0, java.sql.Array arg1) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
protected java.sql.SQLException notImplemented(java.lang.String arg0)
Apache Derby 10.10 API Documentation - Copyright © 2004,2014 The Apache Software Foundation. All Rights Reserved.