AwareVTIpublic abstract class StringColumnVTI extends VTITemplate
This is an abstract table function which assumes that all columns are strings and which coerces the strings to reasonable values for various getXXX() methods. Subclasses must implement the following ResultSet methods:
and the following protected method introduced by this class:
VTITemplate.ColumnDescriptor| Constructor | Description |
|---|---|
StringColumnVTI(java.lang.String[] columnNames) |
Build a StringColumnVTI with the given column names
|
| Modifier and Type | Method | Description |
|---|---|---|
int |
findColumn(java.lang.String columnName) |
|
java.io.InputStream |
getAsciiStream(int columnIndex) |
|
java.math.BigDecimal |
getBigDecimal(int columnIndex) |
|
java.io.InputStream |
getBinaryStream(int columnIndex) |
|
java.sql.Blob |
getBlob(int columnIndex) |
|
boolean |
getBoolean(int columnIndex) |
|
byte |
getByte(int columnIndex) |
|
byte[] |
getBytes(int columnIndex) |
|
java.sql.Clob |
getClob(int columnIndex) |
|
int |
getColumnCount() |
Get the number of columns.
|
java.lang.String |
getColumnName(int columnNumber) |
Get name of a column (1-based indexing).
|
java.sql.Date |
getDate(int columnIndex) |
|
double |
getDouble(int columnIndex) |
|
float |
getFloat(int columnIndex) |
|
int |
getInt(int columnIndex) |
|
long |
getLong(int columnIndex) |
|
short |
getShort(int columnIndex) |
|
java.lang.String |
getString(int columnIndex) |
|
java.sql.Time |
getTime(int columnIndex) |
|
java.sql.Timestamp |
getTimestamp(int columnIndex) |
|
void |
setColumnNames(java.lang.String[] columnNames) |
Set the column names for this table function.
|
boolean |
wasNull() |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitclose, next, updateObject, updateObject, updateObject, updateObjectabsolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, deleteRow, first, getArray, getArray, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBlob, getBoolean, getByte, getBytes, getCharacterStream, getCharacterStream, getClob, getConcurrency, getContext, getCursorName, getDate, getDate, getDate, getDouble, getFetchDirection, getFetchSize, getFloat, getHoldability, getInt, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getReturnTableSignature, getRow, getRowId, getRowId, getShort, getSQLXML, getSQLXML, getStatement, getString, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, isWrapperFor, last, moveToCurrentRow, moveToInsertRow, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setContext, setFetchDirection, setFetchSize, unwrap, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamppublic StringColumnVTI(java.lang.String[] columnNames)
Build a StringColumnVTI with the given column names
public void setColumnNames(java.lang.String[] columnNames)
throws java.sql.SQLException
Set the column names for this table function. This is useful for AwareVTIs, which need to figure out their column names after analyzing their execution context. Throws an exception if the column names have already been set.
java.sql.SQLExceptionpublic int getColumnCount()
Get the number of columns.
public java.lang.String getColumnName(int columnNumber)
Get name of a column (1-based indexing).
public boolean wasNull()
throws java.sql.SQLException
wasNull in class VTITemplatejava.sql.SQLExceptionpublic int findColumn(java.lang.String columnName)
throws java.sql.SQLException
findColumn in class VTITemplatejava.sql.SQLExceptionpublic java.lang.String getString(int columnIndex)
throws java.sql.SQLException
getString in class VTITemplatejava.sql.SQLExceptionpublic boolean getBoolean(int columnIndex)
throws java.sql.SQLException
getBoolean in class VTITemplatejava.sql.SQLExceptionpublic byte getByte(int columnIndex)
throws java.sql.SQLException
getByte in class VTITemplatejava.sql.SQLExceptionpublic short getShort(int columnIndex)
throws java.sql.SQLException
getShort in class VTITemplatejava.sql.SQLExceptionpublic int getInt(int columnIndex)
throws java.sql.SQLException
getInt in class VTITemplatejava.sql.SQLExceptionpublic long getLong(int columnIndex)
throws java.sql.SQLException
getLong in class VTITemplatejava.sql.SQLExceptionpublic float getFloat(int columnIndex)
throws java.sql.SQLException
getFloat in class VTITemplatejava.sql.SQLExceptionpublic double getDouble(int columnIndex)
throws java.sql.SQLException
getDouble in class VTITemplatejava.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(int columnIndex)
throws java.sql.SQLException
getBigDecimal in class VTITemplatejava.sql.SQLExceptionpublic byte[] getBytes(int columnIndex)
throws java.sql.SQLException
getBytes in class VTITemplatejava.sql.SQLExceptionpublic java.sql.Date getDate(int columnIndex)
throws java.sql.SQLException
getDate in class VTITemplatejava.sql.SQLExceptionpublic java.sql.Time getTime(int columnIndex)
throws java.sql.SQLException
getTime in class VTITemplatejava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(int columnIndex)
throws java.sql.SQLException
getTimestamp in class VTITemplatejava.sql.SQLExceptionpublic java.io.InputStream getAsciiStream(int columnIndex)
throws java.sql.SQLException
getAsciiStream in class VTITemplatejava.sql.SQLExceptionpublic java.io.InputStream getBinaryStream(int columnIndex)
throws java.sql.SQLException
getBinaryStream in class VTITemplatejava.sql.SQLExceptionpublic java.sql.Blob getBlob(int columnIndex)
throws java.sql.SQLException
getBlob in class VTITemplatejava.sql.SQLExceptionpublic java.sql.Clob getClob(int columnIndex)
throws java.sql.SQLException
getClob in class VTITemplatejava.sql.SQLExceptionApache Derby 10.14 API Documentation - Copyright © 2004,2017 The Apache Software Foundation. All Rights Reserved.