- java.lang.Object
-
- org.apache.derby.vti.VTITemplate
-
- All Implemented Interfaces:
AutoCloseable,ResultSet,Wrapper,AwareVTI
- Direct Known Subclasses:
ForwardingVTI,SimpleJsonVTI,StringColumnVTI
public abstract class VTITemplate extends Object implements ResultSet, AwareVTI
An abstract implementation of ResultSet that is useful when writing table functions, read-only VTIs (virtual table interface), and the ResultSets returned by executeQuery in read-write VTI classes. This class implements most of the methods of the JDBC 4.0 interface java.sql.ResultSet, each one throwing a SQLException with the name of the method. A concrete subclass can then just implement the methods not implemented here and override any methods it needs to implement for correct functionality.The methods not implemented here are
- next()
- close()
For table functions and virtual tables, the database engine only calls methods defined in the JDBC 2.0 definition of java.sql.ResultSet.
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description static classVTITemplate.ColumnDescriptorA struct class which is useful for describing columns and parameters.
-
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
Constructors Constructor Description VTITemplate()
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description booleanabsolute(int row)voidafterLast()voidbeforeFirst()voidcancelRowUpdates()voidclearWarnings()voiddeleteRow()intfindColumn(String columnName)booleanfirst()ArraygetArray(int i)ArraygetArray(String colName)InputStreamgetAsciiStream(int columnIndex)InputStreamgetAsciiStream(String columnName)BigDecimalgetBigDecimal(int columnIndex)BigDecimalgetBigDecimal(int columnIndex, int scale)Deprecated.BigDecimalgetBigDecimal(String columnName)BigDecimalgetBigDecimal(String columnName, int scale)Deprecated.InputStreamgetBinaryStream(int columnIndex)InputStreamgetBinaryStream(String columnName)BlobgetBlob(int i)BlobgetBlob(String colName)booleangetBoolean(int columnIndex)booleangetBoolean(String columnName)bytegetByte(int columnIndex)bytegetByte(String columnName)byte[]getBytes(int columnIndex)byte[]getBytes(String columnName)ReadergetCharacterStream(int columnIndex)ReadergetCharacterStream(String columnName)ClobgetClob(int i)ClobgetClob(String colName)intgetConcurrency()VTIContextgetContext()Get the table function contextStringgetCursorName()DategetDate(int columnIndex)DategetDate(int columnIndex, Calendar cal)DategetDate(String columnName)DategetDate(String columnName, Calendar cal)doublegetDouble(int columnIndex)doublegetDouble(String columnName)intgetFetchDirection()intgetFetchSize()floatgetFloat(int columnIndex)floatgetFloat(String columnName)intgetHoldability()intgetInt(int columnIndex)intgetInt(String columnName)longgetLong(int columnIndex)longgetLong(String columnName)ResultSetMetaDatagetMetaData()ReadergetNCharacterStream(int columnIndex)ReadergetNCharacterStream(String columnLabel)NClobgetNClob(int columnIndex)NClobgetNClob(String columnLabel)StringgetNString(int columnIndex)StringgetNString(String columnLabel)ObjectgetObject(int columnIndex)<T> TgetObject(int columnIndex, Class<T> type)ObjectgetObject(int i, Map map)ObjectgetObject(String columnName)<T> TgetObject(String columnName, Class<T> type)ObjectgetObject(String colName, Map map)RefgetRef(int i)RefgetRef(String colName)VTITemplate.ColumnDescriptor[]getReturnTableSignature(Connection currentConnection)Get an array of descriptors for the return table shape declared for this AwareVTI by its CREATE FUNCTION statement.intgetRow()RowIdgetRowId(int columnIndex)RowIdgetRowId(String columnLabel)shortgetShort(int columnIndex)shortgetShort(String columnName)SQLXMLgetSQLXML(int columnIndex)SQLXMLgetSQLXML(String columnLabel)StatementgetStatement()StringgetString(int columnIndex)StringgetString(String columnName)TimegetTime(int columnIndex)TimegetTime(int columnIndex, Calendar cal)TimegetTime(String columnName)TimegetTime(String columnName, Calendar cal)TimestampgetTimestamp(int columnIndex)TimestampgetTimestamp(int columnIndex, Calendar cal)TimestampgetTimestamp(String columnName)TimestampgetTimestamp(String columnName, Calendar cal)intgetType()InputStreamgetUnicodeStream(int columnIndex)Deprecated.InputStreamgetUnicodeStream(String columnName)Deprecated.URLgetURL(int columnIndex)URLgetURL(String columnName)SQLWarninggetWarnings()voidinsertRow()booleanisAfterLast()booleanisBeforeFirst()booleanisClosed()booleanisFirst()booleanisLast()booleanisWrapperFor(Class<?> iface)booleanlast()voidmoveToCurrentRow()voidmoveToInsertRow()booleanprevious()voidrefreshRow()booleanrelative(int rows)booleanrowDeleted()booleanrowInserted()booleanrowUpdated()voidsetContext(VTIContext context)Set the table function contextvoidsetFetchDirection(int direction)voidsetFetchSize(int rows)<T> Tunwrap(Class<T> iface)voidupdateArray(int columnIndex, Array x)voidupdateArray(String columnName, Array x)voidupdateAsciiStream(int columnIndex, InputStream x)voidupdateAsciiStream(int columnIndex, InputStream x, int length)voidupdateAsciiStream(int columnIndex, InputStream x, long length)voidupdateAsciiStream(String columnName, InputStream x)voidupdateAsciiStream(String columnName, InputStream x, int length)voidupdateAsciiStream(String columnName, InputStream x, long length)voidupdateBigDecimal(int columnIndex, BigDecimal x)voidupdateBigDecimal(String columnName, BigDecimal x)voidupdateBinaryStream(int columnIndex, InputStream x)voidupdateBinaryStream(int columnIndex, InputStream x, int length)voidupdateBinaryStream(int columnIndex, InputStream x, long length)voidupdateBinaryStream(String columnName, InputStream x)voidupdateBinaryStream(String columnName, InputStream x, int length)voidupdateBinaryStream(String columnName, InputStream x, long length)voidupdateBlob(int columnIndex, InputStream x)voidupdateBlob(int columnIndex, InputStream x, long pos)voidupdateBlob(int columnIndex, Blob x)voidupdateBlob(String columnName, InputStream x)voidupdateBlob(String columnName, InputStream x, long pos)voidupdateBlob(String columnName, Blob x)voidupdateBoolean(int columnIndex, boolean x)voidupdateBoolean(String columnName, boolean x)voidupdateByte(int columnIndex, byte x)voidupdateByte(String columnName, byte x)voidupdateBytes(int columnIndex, byte[] x)voidupdateBytes(String columnName, byte[] x)voidupdateCharacterStream(int columnIndex, Reader x)voidupdateCharacterStream(int columnIndex, Reader x, int length)voidupdateCharacterStream(int columnIndex, Reader x, long length)voidupdateCharacterStream(String columnName, Reader x)voidupdateCharacterStream(String columnName, Reader x, int length)voidupdateCharacterStream(String columnName, Reader x, long length)voidupdateClob(int columnIndex, Reader x)voidupdateClob(int columnIndex, Reader x, long pos)voidupdateClob(int columnIndex, Clob x)voidupdateClob(String columnName, Reader x)voidupdateClob(String columnName, Reader x, long pos)voidupdateClob(String columnName, Clob x)voidupdateDate(int columnIndex, Date x)voidupdateDate(String columnName, Date x)voidupdateDouble(int columnIndex, double x)voidupdateDouble(String columnName, double x)voidupdateFloat(int columnIndex, float x)voidupdateFloat(String columnName, float x)voidupdateInt(int columnIndex, int x)voidupdateInt(String columnName, int x)voidupdateLong(int columnIndex, long x)voidupdateLong(String columnName, long x)voidupdateNCharacterStream(int columnIndex, Reader x)voidupdateNCharacterStream(int columnIndex, Reader x, long length)voidupdateNCharacterStream(String columnLabel, Reader reader)voidupdateNCharacterStream(String columnLabel, Reader reader, long length)voidupdateNClob(int columnIndex, Reader reader)voidupdateNClob(int columnIndex, Reader reader, long length)voidupdateNClob(int columnIndex, NClob nClob)voidupdateNClob(String columnLabel, Reader reader)voidupdateNClob(String columnLabel, Reader reader, long length)voidupdateNClob(String columnLabel, NClob nClob)voidupdateNString(int columnIndex, String nString)voidupdateNString(String columnLabel, String nString)voidupdateNull(int columnIndex)voidupdateNull(String columnName)voidupdateObject(int columnIndex, Object x)voidupdateObject(int columnIndex, Object x, int scale)voidupdateObject(String columnName, Object x)voidupdateObject(String columnName, Object x, int scale)voidupdateRef(int columnIndex, Ref x)voidupdateRef(String columnName, Ref x)voidupdateRow()voidupdateRowId(int columnIndex, RowId x)voidupdateRowId(String columnLabel, RowId x)voidupdateShort(int columnIndex, short x)voidupdateShort(String columnName, short x)voidupdateSQLXML(int columnIndex, SQLXML xmlObject)voidupdateSQLXML(String columnLabel, SQLXML xmlObject)voidupdateString(int columnIndex, String x)voidupdateString(String columnName, String x)voidupdateTime(int columnIndex, Time x)voidupdateTime(String columnName, Time x)voidupdateTimestamp(int columnIndex, Timestamp x)voidupdateTimestamp(String columnName, Timestamp x)booleanwasNull()-
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface java.sql.ResultSet
close, next, updateObject, updateObject, updateObject, updateObject
-
-
-
-
Method Detail
-
isWrapperFor
public boolean isWrapperFor(Class<?> iface) throws SQLException
- Specified by:
isWrapperForin interfaceWrapper- Throws:
SQLException
-
unwrap
public <T> T unwrap(Class<T> iface) throws SQLException
- Specified by:
unwrapin interfaceWrapper- Throws:
SQLException
-
getMetaData
public ResultSetMetaData getMetaData() throws SQLException
- Specified by:
getMetaDatain interfaceResultSet- Throws:
SQLException
-
getString
public String getString(String columnName) throws SQLException
- Specified by:
getStringin interfaceResultSet- Throws:
SQLException
-
getBoolean
public boolean getBoolean(String columnName) throws SQLException
- Specified by:
getBooleanin interfaceResultSet- Throws:
SQLException
-
getByte
public byte getByte(String columnName) throws SQLException
- Specified by:
getBytein interfaceResultSet- Throws:
SQLException
-
getShort
public short getShort(String columnName) throws SQLException
- Specified by:
getShortin interfaceResultSet- Throws:
SQLException
-
getInt
public int getInt(String columnName) throws SQLException
- Specified by:
getIntin interfaceResultSet- Throws:
SQLException
-
getLong
public long getLong(String columnName) throws SQLException
- Specified by:
getLongin interfaceResultSet- Throws:
SQLException
-
getFloat
public float getFloat(String columnName) throws SQLException
- Specified by:
getFloatin interfaceResultSet- Throws:
SQLException
-
getDouble
public double getDouble(String columnName) throws SQLException
- Specified by:
getDoublein interfaceResultSet- Throws:
SQLException
-
getBigDecimal
@Deprecated public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
Deprecated.- Specified by:
getBigDecimalin interfaceResultSet- Throws:
SQLException
-
getBytes
public byte[] getBytes(String columnName) throws SQLException
- Specified by:
getBytesin interfaceResultSet- Throws:
SQLException
-
getDate
public Date getDate(String columnName) throws SQLException
- Specified by:
getDatein interfaceResultSet- Throws:
SQLException
-
getTime
public Time getTime(String columnName) throws SQLException
- Specified by:
getTimein interfaceResultSet- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(String columnName) throws SQLException
- Specified by:
getTimestampin interfaceResultSet- Throws:
SQLException
-
getObject
public Object getObject(String columnName) throws SQLException
- Specified by:
getObjectin interfaceResultSet- Throws:
SQLException
-
getObject
public <T> T getObject(String columnName, Class<T> type) throws SQLException
- Specified by:
getObjectin interfaceResultSet- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(String columnName) throws SQLException
- Specified by:
getBigDecimalin interfaceResultSet- Throws:
SQLException
-
wasNull
public boolean wasNull() throws SQLException- Specified by:
wasNullin interfaceResultSet- Throws:
SQLException
-
getString
public String getString(int columnIndex) throws SQLException
- Specified by:
getStringin interfaceResultSet- Throws:
SQLException
-
getBoolean
public boolean getBoolean(int columnIndex) throws SQLException- Specified by:
getBooleanin interfaceResultSet- Throws:
SQLException
-
getByte
public byte getByte(int columnIndex) throws SQLException- Specified by:
getBytein interfaceResultSet- Throws:
SQLException
-
getShort
public short getShort(int columnIndex) throws SQLException- Specified by:
getShortin interfaceResultSet- Throws:
SQLException
-
getInt
public int getInt(int columnIndex) throws SQLException- Specified by:
getIntin interfaceResultSet- Throws:
SQLException
-
getLong
public long getLong(int columnIndex) throws SQLException- Specified by:
getLongin interfaceResultSet- Throws:
SQLException
-
getFloat
public float getFloat(int columnIndex) throws SQLException- Specified by:
getFloatin interfaceResultSet- Throws:
SQLException
-
getDouble
public double getDouble(int columnIndex) throws SQLException- Specified by:
getDoublein interfaceResultSet- Throws:
SQLException
-
getBigDecimal
@Deprecated public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
Deprecated.- Specified by:
getBigDecimalin interfaceResultSet- Throws:
SQLException
-
getBytes
public byte[] getBytes(int columnIndex) throws SQLException- Specified by:
getBytesin interfaceResultSet- Throws:
SQLException
-
getDate
public Date getDate(int columnIndex) throws SQLException
- Specified by:
getDatein interfaceResultSet- Throws:
SQLException
-
getTime
public Time getTime(int columnIndex) throws SQLException
- Specified by:
getTimein interfaceResultSet- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(int columnIndex) throws SQLException
- Specified by:
getTimestampin interfaceResultSet- Throws:
SQLException
-
getAsciiStream
public InputStream getAsciiStream(int columnIndex) throws SQLException
- Specified by:
getAsciiStreamin interfaceResultSet- Throws:
SQLException
-
getUnicodeStream
@Deprecated public InputStream getUnicodeStream(int columnIndex) throws SQLException
Deprecated.- Specified by:
getUnicodeStreamin interfaceResultSet- Throws:
SQLException
-
getBinaryStream
public InputStream getBinaryStream(int columnIndex) throws SQLException
- Specified by:
getBinaryStreamin interfaceResultSet- Throws:
SQLException
-
getAsciiStream
public InputStream getAsciiStream(String columnName) throws SQLException
- Specified by:
getAsciiStreamin interfaceResultSet- Throws:
SQLException
-
getUnicodeStream
@Deprecated public InputStream getUnicodeStream(String columnName) throws SQLException
Deprecated.- Specified by:
getUnicodeStreamin interfaceResultSet- Throws:
SQLException
-
getBinaryStream
public InputStream getBinaryStream(String columnName) throws SQLException
- Specified by:
getBinaryStreamin interfaceResultSet- Throws:
SQLException
-
getWarnings
public SQLWarning getWarnings() throws SQLException
- Specified by:
getWarningsin interfaceResultSet- Throws:
SQLException
-
clearWarnings
public void clearWarnings() throws SQLException- Specified by:
clearWarningsin interfaceResultSet- Throws:
SQLException
-
getCursorName
public String getCursorName() throws SQLException
- Specified by:
getCursorNamein interfaceResultSet- Throws:
SQLException
-
getObject
public Object getObject(int columnIndex) throws SQLException
- Specified by:
getObjectin interfaceResultSet- Throws:
SQLException
-
getObject
public <T> T getObject(int columnIndex, Class<T> type) throws SQLException- Specified by:
getObjectin interfaceResultSet- Throws:
SQLException
-
findColumn
public int findColumn(String columnName) throws SQLException
- Specified by:
findColumnin interfaceResultSet- Throws:
SQLException
-
getCharacterStream
public Reader getCharacterStream(int columnIndex) throws SQLException
- Specified by:
getCharacterStreamin interfaceResultSet- Throws:
SQLException
-
getCharacterStream
public Reader getCharacterStream(String columnName) throws SQLException
- Specified by:
getCharacterStreamin interfaceResultSet- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(int columnIndex) throws SQLException
- Specified by:
getBigDecimalin interfaceResultSet- Throws:
SQLException
-
isBeforeFirst
public boolean isBeforeFirst() throws SQLException- Specified by:
isBeforeFirstin interfaceResultSet- Throws:
SQLException
-
isAfterLast
public boolean isAfterLast() throws SQLException- Specified by:
isAfterLastin interfaceResultSet- Throws:
SQLException
-
isFirst
public boolean isFirst() throws SQLException- Specified by:
isFirstin interfaceResultSet- Throws:
SQLException
-
isLast
public boolean isLast() throws SQLException- Specified by:
isLastin interfaceResultSet- Throws:
SQLException
-
beforeFirst
public void beforeFirst() throws SQLException- Specified by:
beforeFirstin interfaceResultSet- Throws:
SQLException
-
afterLast
public void afterLast() throws SQLException- Specified by:
afterLastin interfaceResultSet- Throws:
SQLException
-
first
public boolean first() throws SQLException- Specified by:
firstin interfaceResultSet- Throws:
SQLException
-
last
public boolean last() throws SQLException- Specified by:
lastin interfaceResultSet- Throws:
SQLException
-
isClosed
public boolean isClosed() throws SQLException- Specified by:
isClosedin interfaceResultSet- Throws:
SQLException
-
getHoldability
public int getHoldability() throws SQLException- Specified by:
getHoldabilityin interfaceResultSet- Throws:
SQLException
-
getRow
public int getRow() throws SQLException- Specified by:
getRowin interfaceResultSet- Throws:
SQLException
-
absolute
public boolean absolute(int row) throws SQLException- Specified by:
absolutein interfaceResultSet- Throws:
SQLException
-
relative
public boolean relative(int rows) throws SQLException- Specified by:
relativein interfaceResultSet- Throws:
SQLException
-
previous
public boolean previous() throws SQLException- Specified by:
previousin interfaceResultSet- Throws:
SQLException
-
setFetchDirection
public void setFetchDirection(int direction) throws SQLException- Specified by:
setFetchDirectionin interfaceResultSet- Throws:
SQLException
-
getFetchDirection
public int getFetchDirection() throws SQLException- Specified by:
getFetchDirectionin interfaceResultSet- Throws:
SQLException
-
setFetchSize
public void setFetchSize(int rows) throws SQLException- Specified by:
setFetchSizein interfaceResultSet- Throws:
SQLException
-
getFetchSize
public int getFetchSize() throws SQLException- Specified by:
getFetchSizein interfaceResultSet- Throws:
SQLException
-
getType
public int getType() throws SQLException- Specified by:
getTypein interfaceResultSet- Throws:
SQLException
-
getConcurrency
public int getConcurrency() throws SQLException- Specified by:
getConcurrencyin interfaceResultSet- Throws:
SQLException
-
rowUpdated
public boolean rowUpdated() throws SQLException- Specified by:
rowUpdatedin interfaceResultSet- Throws:
SQLException
-
rowInserted
public boolean rowInserted() throws SQLException- Specified by:
rowInsertedin interfaceResultSet- Throws:
SQLException
-
rowDeleted
public boolean rowDeleted() throws SQLException- Specified by:
rowDeletedin interfaceResultSet- Throws:
SQLException
-
updateNull
public void updateNull(int columnIndex) throws SQLException- Specified by:
updateNullin interfaceResultSet- Throws:
SQLException
-
updateBoolean
public void updateBoolean(int columnIndex, boolean x) throws SQLException- Specified by:
updateBooleanin interfaceResultSet- Throws:
SQLException
-
updateByte
public void updateByte(int columnIndex, byte x) throws SQLException- Specified by:
updateBytein interfaceResultSet- Throws:
SQLException
-
updateBytes
public void updateBytes(int columnIndex, byte[] x) throws SQLException- Specified by:
updateBytesin interfaceResultSet- Throws:
SQLException
-
updateShort
public void updateShort(int columnIndex, short x) throws SQLException- Specified by:
updateShortin interfaceResultSet- Throws:
SQLException
-
updateInt
public void updateInt(int columnIndex, int x) throws SQLException- Specified by:
updateIntin interfaceResultSet- Throws:
SQLException
-
updateLong
public void updateLong(int columnIndex, long x) throws SQLException- Specified by:
updateLongin interfaceResultSet- Throws:
SQLException
-
updateFloat
public void updateFloat(int columnIndex, float x) throws SQLException- Specified by:
updateFloatin interfaceResultSet- Throws:
SQLException
-
updateDouble
public void updateDouble(int columnIndex, double x) throws SQLException- Specified by:
updateDoublein interfaceResultSet- Throws:
SQLException
-
updateBigDecimal
public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException- Specified by:
updateBigDecimalin interfaceResultSet- Throws:
SQLException
-
updateString
public void updateString(int columnIndex, String x) throws SQLException- Specified by:
updateStringin interfaceResultSet- Throws:
SQLException
-
updateDate
public void updateDate(int columnIndex, Date x) throws SQLException- Specified by:
updateDatein interfaceResultSet- Throws:
SQLException
-
updateTime
public void updateTime(int columnIndex, Time x) throws SQLException- Specified by:
updateTimein interfaceResultSet- Throws:
SQLException
-
updateTimestamp
public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException- Specified by:
updateTimestampin interfaceResultSet- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException- Specified by:
updateAsciiStreamin interfaceResultSet- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException- Specified by:
updateAsciiStreamin interfaceResultSet- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException- Specified by:
updateAsciiStreamin interfaceResultSet- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException- Specified by:
updateBinaryStreamin interfaceResultSet- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException- Specified by:
updateBinaryStreamin interfaceResultSet- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException- Specified by:
updateBinaryStreamin interfaceResultSet- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, Reader x) throws SQLException- Specified by:
updateCharacterStreamin interfaceResultSet- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException- Specified by:
updateCharacterStreamin interfaceResultSet- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException- Specified by:
updateCharacterStreamin interfaceResultSet- Throws:
SQLException
-
updateObject
public void updateObject(int columnIndex, Object x, int scale) throws SQLException- Specified by:
updateObjectin interfaceResultSet- Throws:
SQLException
-
updateObject
public void updateObject(int columnIndex, Object x) throws SQLException- Specified by:
updateObjectin interfaceResultSet- Throws:
SQLException
-
updateNull
public void updateNull(String columnName) throws SQLException
- Specified by:
updateNullin interfaceResultSet- Throws:
SQLException
-
updateBoolean
public void updateBoolean(String columnName, boolean x) throws SQLException
- Specified by:
updateBooleanin interfaceResultSet- Throws:
SQLException
-
updateByte
public void updateByte(String columnName, byte x) throws SQLException
- Specified by:
updateBytein interfaceResultSet- Throws:
SQLException
-
updateShort
public void updateShort(String columnName, short x) throws SQLException
- Specified by:
updateShortin interfaceResultSet- Throws:
SQLException
-
updateInt
public void updateInt(String columnName, int x) throws SQLException
- Specified by:
updateIntin interfaceResultSet- Throws:
SQLException
-
updateLong
public void updateLong(String columnName, long x) throws SQLException
- Specified by:
updateLongin interfaceResultSet- Throws:
SQLException
-
updateFloat
public void updateFloat(String columnName, float x) throws SQLException
- Specified by:
updateFloatin interfaceResultSet- Throws:
SQLException
-
updateDouble
public void updateDouble(String columnName, double x) throws SQLException
- Specified by:
updateDoublein interfaceResultSet- Throws:
SQLException
-
updateBigDecimal
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException
- Specified by:
updateBigDecimalin interfaceResultSet- Throws:
SQLException
-
updateString
public void updateString(String columnName, String x) throws SQLException
- Specified by:
updateStringin interfaceResultSet- Throws:
SQLException
-
updateBytes
public void updateBytes(String columnName, byte[] x) throws SQLException
- Specified by:
updateBytesin interfaceResultSet- Throws:
SQLException
-
updateDate
public void updateDate(String columnName, Date x) throws SQLException
- Specified by:
updateDatein interfaceResultSet- Throws:
SQLException
-
updateTime
public void updateTime(String columnName, Time x) throws SQLException
- Specified by:
updateTimein interfaceResultSet- Throws:
SQLException
-
updateTimestamp
public void updateTimestamp(String columnName, Timestamp x) throws SQLException
- Specified by:
updateTimestampin interfaceResultSet- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(String columnName, InputStream x) throws SQLException
- Specified by:
updateAsciiStreamin interfaceResultSet- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException
- Specified by:
updateAsciiStreamin interfaceResultSet- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(String columnName, InputStream x, long length) throws SQLException
- Specified by:
updateAsciiStreamin interfaceResultSet- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(String columnName, InputStream x) throws SQLException
- Specified by:
updateBinaryStreamin interfaceResultSet- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException
- Specified by:
updateBinaryStreamin interfaceResultSet- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(String columnName, InputStream x, long length) throws SQLException
- Specified by:
updateBinaryStreamin interfaceResultSet- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(String columnName, Reader x) throws SQLException
- Specified by:
updateCharacterStreamin interfaceResultSet- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(String columnName, Reader x, long length) throws SQLException
- Specified by:
updateCharacterStreamin interfaceResultSet- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(String columnName, Reader x, int length) throws SQLException
- Specified by:
updateCharacterStreamin interfaceResultSet- Throws:
SQLException
-
updateObject
public void updateObject(String columnName, Object x, int scale) throws SQLException
- Specified by:
updateObjectin interfaceResultSet- Throws:
SQLException
-
updateObject
public void updateObject(String columnName, Object x) throws SQLException
- Specified by:
updateObjectin interfaceResultSet- Throws:
SQLException
-
insertRow
public void insertRow() throws SQLException- Specified by:
insertRowin interfaceResultSet- Throws:
SQLException
-
updateRow
public void updateRow() throws SQLException- Specified by:
updateRowin interfaceResultSet- Throws:
SQLException
-
deleteRow
public void deleteRow() throws SQLException- Specified by:
deleteRowin interfaceResultSet- Throws:
SQLException
-
refreshRow
public void refreshRow() throws SQLException- Specified by:
refreshRowin interfaceResultSet- Throws:
SQLException
-
cancelRowUpdates
public void cancelRowUpdates() throws SQLException- Specified by:
cancelRowUpdatesin interfaceResultSet- Throws:
SQLException
-
moveToInsertRow
public void moveToInsertRow() throws SQLException- Specified by:
moveToInsertRowin interfaceResultSet- Throws:
SQLException
-
moveToCurrentRow
public void moveToCurrentRow() throws SQLException- Specified by:
moveToCurrentRowin interfaceResultSet- Throws:
SQLException
-
getStatement
public Statement getStatement() throws SQLException
- Specified by:
getStatementin interfaceResultSet- Throws:
SQLException
-
getDate
public Date getDate(int columnIndex, Calendar cal) throws SQLException
- Specified by:
getDatein interfaceResultSet- Throws:
SQLException
-
getDate
public Date getDate(String columnName, Calendar cal) throws SQLException
- Specified by:
getDatein interfaceResultSet- Throws:
SQLException
-
getTime
public Time getTime(int columnIndex, Calendar cal) throws SQLException
- Specified by:
getTimein interfaceResultSet- Throws:
SQLException
-
getTime
public Time getTime(String columnName, Calendar cal) throws SQLException
- Specified by:
getTimein interfaceResultSet- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException
- Specified by:
getTimestampin interfaceResultSet- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException
- Specified by:
getTimestampin interfaceResultSet- Throws:
SQLException
-
getURL
public URL getURL(int columnIndex) throws SQLException
- Specified by:
getURLin interfaceResultSet- Throws:
SQLException
-
getURL
public URL getURL(String columnName) throws SQLException
- Specified by:
getURLin interfaceResultSet- Throws:
SQLException
-
getObject
public Object getObject(int i, Map map) throws SQLException
- Specified by:
getObjectin interfaceResultSet- Throws:
SQLException
-
getRef
public Ref getRef(int i) throws SQLException
- Specified by:
getRefin interfaceResultSet- Throws:
SQLException
-
getBlob
public Blob getBlob(int i) throws SQLException
- Specified by:
getBlobin interfaceResultSet- Throws:
SQLException
-
getClob
public Clob getClob(int i) throws SQLException
- Specified by:
getClobin interfaceResultSet- Throws:
SQLException
-
getArray
public Array getArray(int i) throws SQLException
- Specified by:
getArrayin interfaceResultSet- Throws:
SQLException
-
getObject
public Object getObject(String colName, Map map) throws SQLException
- Specified by:
getObjectin interfaceResultSet- Throws:
SQLException
-
getRef
public Ref getRef(String colName) throws SQLException
- Specified by:
getRefin interfaceResultSet- Throws:
SQLException
-
getBlob
public Blob getBlob(String colName) throws SQLException
- Specified by:
getBlobin interfaceResultSet- Throws:
SQLException
-
getClob
public Clob getClob(String colName) throws SQLException
- Specified by:
getClobin interfaceResultSet- Throws:
SQLException
-
getArray
public Array getArray(String colName) throws SQLException
- Specified by:
getArrayin interfaceResultSet- Throws:
SQLException
-
getSQLXML
public SQLXML getSQLXML(int columnIndex) throws SQLException
- Specified by:
getSQLXMLin interfaceResultSet- Throws:
SQLException
-
getSQLXML
public SQLXML getSQLXML(String columnLabel) throws SQLException
- Specified by:
getSQLXMLin interfaceResultSet- Throws:
SQLException
-
updateRef
public void updateRef(int columnIndex, Ref x) throws SQLException- Specified by:
updateRefin interfaceResultSet- Throws:
SQLException
-
updateRef
public void updateRef(String columnName, Ref x) throws SQLException
- Specified by:
updateRefin interfaceResultSet- Throws:
SQLException
-
updateBlob
public void updateBlob(int columnIndex, Blob x) throws SQLException- Specified by:
updateBlobin interfaceResultSet- Throws:
SQLException
-
updateBlob
public void updateBlob(String columnName, Blob x) throws SQLException
- Specified by:
updateBlobin interfaceResultSet- Throws:
SQLException
-
updateBlob
public void updateBlob(int columnIndex, InputStream x) throws SQLException- Specified by:
updateBlobin interfaceResultSet- Throws:
SQLException
-
updateBlob
public void updateBlob(int columnIndex, InputStream x, long pos) throws SQLException- Specified by:
updateBlobin interfaceResultSet- Throws:
SQLException
-
updateBlob
public void updateBlob(String columnName, InputStream x) throws SQLException
- Specified by:
updateBlobin interfaceResultSet- Throws:
SQLException
-
updateBlob
public void updateBlob(String columnName, InputStream x, long pos) throws SQLException
- Specified by:
updateBlobin interfaceResultSet- Throws:
SQLException
-
updateClob
public void updateClob(int columnIndex, Clob x) throws SQLException- Specified by:
updateClobin interfaceResultSet- Throws:
SQLException
-
updateClob
public void updateClob(String columnName, Clob x) throws SQLException
- Specified by:
updateClobin interfaceResultSet- Throws:
SQLException
-
updateClob
public void updateClob(int columnIndex, Reader x) throws SQLException- Specified by:
updateClobin interfaceResultSet- Throws:
SQLException
-
updateClob
public void updateClob(int columnIndex, Reader x, long pos) throws SQLException- Specified by:
updateClobin interfaceResultSet- Throws:
SQLException
-
updateClob
public void updateClob(String columnName, Reader x) throws SQLException
- Specified by:
updateClobin interfaceResultSet- Throws:
SQLException
-
updateClob
public void updateClob(String columnName, Reader x, long pos) throws SQLException
- Specified by:
updateClobin interfaceResultSet- Throws:
SQLException
-
updateArray
public void updateArray(int columnIndex, Array x) throws SQLException- Specified by:
updateArrayin interfaceResultSet- Throws:
SQLException
-
updateArray
public void updateArray(String columnName, Array x) throws SQLException
- Specified by:
updateArrayin interfaceResultSet- Throws:
SQLException
-
getNCharacterStream
public Reader getNCharacterStream(int columnIndex) throws SQLException
- Specified by:
getNCharacterStreamin interfaceResultSet- Throws:
SQLException
-
getNCharacterStream
public Reader getNCharacterStream(String columnLabel) throws SQLException
- Specified by:
getNCharacterStreamin interfaceResultSet- Throws:
SQLException
-
getNClob
public NClob getNClob(int columnIndex) throws SQLException
- Specified by:
getNClobin interfaceResultSet- Throws:
SQLException
-
getNClob
public NClob getNClob(String columnLabel) throws SQLException
- Specified by:
getNClobin interfaceResultSet- Throws:
SQLException
-
getNString
public String getNString(int columnIndex) throws SQLException
- Specified by:
getNStringin interfaceResultSet- Throws:
SQLException
-
getNString
public String getNString(String columnLabel) throws SQLException
- Specified by:
getNStringin interfaceResultSet- Throws:
SQLException
-
getRowId
public RowId getRowId(int columnIndex) throws SQLException
- Specified by:
getRowIdin interfaceResultSet- Throws:
SQLException
-
getRowId
public RowId getRowId(String columnLabel) throws SQLException
- Specified by:
getRowIdin interfaceResultSet- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, Reader x) throws SQLException- Specified by:
updateNCharacterStreamin interfaceResultSet- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException- Specified by:
updateNCharacterStreamin interfaceResultSet- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(String columnLabel, Reader reader) throws SQLException
- Specified by:
updateNCharacterStreamin interfaceResultSet- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException
- Specified by:
updateNCharacterStreamin interfaceResultSet- Throws:
SQLException
-
updateNClob
public void updateNClob(int columnIndex, NClob nClob) throws SQLException- Specified by:
updateNClobin interfaceResultSet- Throws:
SQLException
-
updateNClob
public void updateNClob(int columnIndex, Reader reader) throws SQLException- Specified by:
updateNClobin interfaceResultSet- Throws:
SQLException
-
updateNClob
public void updateNClob(int columnIndex, Reader reader, long length) throws SQLException- Specified by:
updateNClobin interfaceResultSet- Throws:
SQLException
-
updateNClob
public void updateNClob(String columnLabel, NClob nClob) throws SQLException
- Specified by:
updateNClobin interfaceResultSet- Throws:
SQLException
-
updateNClob
public void updateNClob(String columnLabel, Reader reader) throws SQLException
- Specified by:
updateNClobin interfaceResultSet- Throws:
SQLException
-
updateNClob
public void updateNClob(String columnLabel, Reader reader, long length) throws SQLException
- Specified by:
updateNClobin interfaceResultSet- Throws:
SQLException
-
updateNString
public void updateNString(int columnIndex, String nString) throws SQLException- Specified by:
updateNStringin interfaceResultSet- Throws:
SQLException
-
updateNString
public void updateNString(String columnLabel, String nString) throws SQLException
- Specified by:
updateNStringin interfaceResultSet- Throws:
SQLException
-
updateRowId
public void updateRowId(int columnIndex, RowId x) throws SQLException- Specified by:
updateRowIdin interfaceResultSet- Throws:
SQLException
-
updateRowId
public void updateRowId(String columnLabel, RowId x) throws SQLException
- Specified by:
updateRowIdin interfaceResultSet- Throws:
SQLException
-
updateSQLXML
public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException- Specified by:
updateSQLXMLin interfaceResultSet- Throws:
SQLException
-
updateSQLXML
public void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException
- Specified by:
updateSQLXMLin interfaceResultSet- Throws:
SQLException
-
getContext
public VTIContext getContext()
Description copied from interface:AwareVTIGet the table function context- Specified by:
getContextin interfaceAwareVTI- Returns:
- the table function context
-
setContext
public void setContext(VTIContext context)
Description copied from interface:AwareVTISet the table function context- Specified by:
setContextin interfaceAwareVTI- Parameters:
context- The table function context
-
getReturnTableSignature
public VTITemplate.ColumnDescriptor[] getReturnTableSignature(Connection currentConnection) throws SQLException
Get an array of descriptors for the return table shape declared for this AwareVTI by its CREATE FUNCTION statement.
- Parameters:
currentConnection- The current connection to Derby- Returns:
- an array of descriptors of the columns returned by this VTI.
- Throws:
SQLException- on error
-
-