org.apache.derbyTesting.functionTests.util

Class SampleVTI

java.lang.Object

org.apache.derby.vti.VTITemplate

org.apache.derbyTesting.functionTests.util.SampleVTI

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper, org.apache.derby.vti.AwareVTI

public class SampleVTI
extends org.apache.derby.vti.VTITemplate

A very simple, read-only, sample VTI.

This VTI is incomplete and has its quirks - it is intended for basic testing only! Supported getters:

• getString
• getInt

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.derby.vti.VTITemplate

org.apache.derby.vti.VTITemplate.ColumnDescriptor

Field Summary

Fields

Modifier and Type	Field and Description
private boolean	closed
private int	cols
private java.lang.String[][]	data
private int	index
private static java.lang.String[][]	oneColData
private int	rows
private boolean	wasNull

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

Modifier	Constructor and Description
private	SampleVTI(java.lang.String[][] data)

Method Summary

Modifier and Type	Method and Description
void	close()
static java.sql.ResultSet	emptySampleVTI() Returns a sample VTI that is empty (has zero rows).
private java.lang.String	getColumn(int columnIndex)
int	getHoldability()
int	getInt(int columnIndex)
java.io.Reader	getNCharacterStream(int columnIndex)
java.io.Reader	getNCharacterStream(java.lang.String columnLabel)
java.lang.String	getNString(int columnIndex)
java.lang.String	getNString(java.lang.String columnLabel)
<T> T	getObject(int columnIndex, java.lang.Class<T> type)
<T> T	getObject(java.lang.String columnLabel, java.lang.Class<T> type)
java.lang.String	getString(int columnIndex)
boolean	isClosed()
boolean	next()
static java.sql.ResultSet	oneColSampleVTI() Returns a sample VTI with the some test data.
static java.lang.String[][]	oneColSampleVTIData()
void	updateAsciiStream(int columnIndex, java.io.InputStream x)
void	updateAsciiStream(int columnIndex, java.io.InputStream x, long length)
void	updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)
void	updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length)
void	updateBinaryStream(int columnIndex, java.io.InputStream x)
void	updateBinaryStream(int columnIndex, java.io.InputStream x, long length)
void	updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)
void	updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length)
void	updateBlob(int columnIndex, java.io.InputStream inputStream)
void	updateBlob(int columnIndex, java.io.InputStream inputStream, long length)
void	updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream)
void	updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)
void	updateCharacterStream(int columnIndex, java.io.Reader x)
void	updateCharacterStream(int columnIndex, java.io.Reader x, long length)
void	updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
void	updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
void	updateClob(int columnIndex, java.io.Reader reader)
void	updateClob(int columnIndex, java.io.Reader reader, long length)
void	updateClob(java.lang.String columnLabel, java.io.Reader reader)
void	updateClob(java.lang.String columnLabel, java.io.Reader reader, long length)
void	updateNCharacterStream(int columnIndex, java.io.Reader x)
void	updateNCharacterStream(int columnIndex, java.io.Reader x, long length)
void	updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
void	updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
void	updateNClob(int columnIndex, java.io.Reader reader)
void	updateNClob(int columnIndex, java.io.Reader reader, long length)
void	updateNClob(java.lang.String columnLabel, java.io.Reader reader)
void	updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)
void	updateNString(int columnIndex, java.lang.String nString)
void	updateNString(java.lang.String columnLabel, java.lang.String nString)
boolean	wasNull()

Methods inherited from class org.apache.derby.vti.VTITemplate

absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getContext, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getInt, getLong, getLong, getMetaData, getNClob, getNClob, getObject, getObject, getObject, getObject, getRef, getRef, getReturnTableSignature, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, isWrapperFor, last, moveToCurrentRow, moveToInsertRow, notImplemented, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setContext, setFetchDirection, setFetchSize, unwrap, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNClob, updateNClob, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp

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

updateObject, updateObject, updateObject, updateObject

Field Detail

oneColData

private static final java.lang.String[][] oneColData

data

private final java.lang.String[][] data

rows

private final int rows

cols

private final int cols

index

private int index

wasNull

private boolean wasNull

closed

private boolean closed

Constructor Detail

SampleVTI

private SampleVTI(java.lang.String[][] data)

Method Detail

emptySampleVTI

public static java.sql.ResultSet emptySampleVTI()

Returns a sample VTI that is empty (has zero rows).

oneColSampleVTI

public static java.sql.ResultSet oneColSampleVTI()

Returns a sample VTI with the some test data.

Returns:

A result set with a single column with string data (five rows).

oneColSampleVTIData

public static java.lang.String[][] oneColSampleVTIData()

getColumn

private java.lang.String getColumn(int columnIndex)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

next

public boolean next()
             throws java.sql.SQLException

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Throws:

java.sql.SQLException

getString

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

Specified by:

getString in interface java.sql.ResultSet

Overrides:

getString in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getInt

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

Specified by:

getInt in interface java.sql.ResultSet

Overrides:

getInt in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

wasNull

public boolean wasNull()

Specified by:

wasNull in interface java.sql.ResultSet

Overrides:

wasNull in class org.apache.derby.vti.VTITemplate

getHoldability

public int getHoldability()
                   throws java.sql.SQLException

Specified by:

getHoldability in interface java.sql.ResultSet

Overrides:

getHoldability in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

Specified by:

isClosed in interface java.sql.ResultSet

Overrides:

isClosed in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateNString

public void updateNString(int columnIndex,
                          java.lang.String nString)
                   throws java.sql.SQLException

Specified by:

updateNString in interface java.sql.ResultSet

Overrides:

updateNString in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateNString

public void updateNString(java.lang.String columnLabel,
                          java.lang.String nString)
                   throws java.sql.SQLException

Specified by:

updateNString in interface java.sql.ResultSet

Overrides:

updateNString in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getNString

public java.lang.String getNString(int columnIndex)
                            throws java.sql.SQLException

Specified by:

getNString in interface java.sql.ResultSet

Overrides:

getNString in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getNString

public java.lang.String getNString(java.lang.String columnLabel)
                            throws java.sql.SQLException

Specified by:

getNString in interface java.sql.ResultSet

Overrides:

getNString in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getNCharacterStream

public java.io.Reader getNCharacterStream(int columnIndex)
                                   throws java.sql.SQLException

Specified by:

getNCharacterStream in interface java.sql.ResultSet

Overrides:

getNCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getNCharacterStream

public java.io.Reader getNCharacterStream(java.lang.String columnLabel)
                                   throws java.sql.SQLException

Specified by:

getNCharacterStream in interface java.sql.ResultSet

Overrides:

getNCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x,
                                   long length)
                            throws java.sql.SQLException

Specified by:

updateNCharacterStream in interface java.sql.ResultSet

Overrides:

updateNCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(java.lang.String columnLabel,
                                   java.io.Reader reader,
                                   long length)
                            throws java.sql.SQLException

Specified by:

updateNCharacterStream in interface java.sql.ResultSet

Overrides:

updateNCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x,
                              long length)
                       throws java.sql.SQLException

Specified by:

updateAsciiStream in interface java.sql.ResultSet

Overrides:

updateAsciiStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x,
                               long length)
                        throws java.sql.SQLException

Specified by:

updateBinaryStream in interface java.sql.ResultSet

Overrides:

updateBinaryStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  long length)
                           throws java.sql.SQLException

Specified by:

updateCharacterStream in interface java.sql.ResultSet

Overrides:

updateCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x,
                              long length)
                       throws java.sql.SQLException

Specified by:

updateAsciiStream in interface java.sql.ResultSet

Overrides:

updateAsciiStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x,
                               long length)
                        throws java.sql.SQLException

Specified by:

updateBinaryStream in interface java.sql.ResultSet

Overrides:

updateBinaryStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader,
                                  long length)
                           throws java.sql.SQLException

Specified by:

updateCharacterStream in interface java.sql.ResultSet

Overrides:

updateCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex,
                       java.io.InputStream inputStream,
                       long length)
                throws java.sql.SQLException

Specified by:

updateBlob in interface java.sql.ResultSet

Overrides:

updateBlob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String columnLabel,
                       java.io.InputStream inputStream,
                       long length)
                throws java.sql.SQLException

Specified by:

updateBlob in interface java.sql.ResultSet

Overrides:

updateBlob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateClob

public void updateClob(int columnIndex,
                       java.io.Reader reader,
                       long length)
                throws java.sql.SQLException

Specified by:

updateClob in interface java.sql.ResultSet

Overrides:

updateClob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateClob

public void updateClob(java.lang.String columnLabel,
                       java.io.Reader reader,
                       long length)
                throws java.sql.SQLException

Specified by:

updateClob in interface java.sql.ResultSet

Overrides:

updateClob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException

Specified by:

updateNClob in interface java.sql.ResultSet

Overrides:

updateNClob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException

Specified by:

updateNClob in interface java.sql.ResultSet

Overrides:

updateNClob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x)
                            throws java.sql.SQLException

Specified by:

updateNCharacterStream in interface java.sql.ResultSet

Overrides:

updateNCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(java.lang.String columnLabel,
                                   java.io.Reader reader)
                            throws java.sql.SQLException

Specified by:

updateNCharacterStream in interface java.sql.ResultSet

Overrides:

updateNCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x)
                       throws java.sql.SQLException

Specified by:

updateAsciiStream in interface java.sql.ResultSet

Overrides:

updateAsciiStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x)
                        throws java.sql.SQLException

Specified by:

updateBinaryStream in interface java.sql.ResultSet

Overrides:

updateBinaryStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x)
                           throws java.sql.SQLException

Specified by:

updateCharacterStream in interface java.sql.ResultSet

Overrides:

updateCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x)
                       throws java.sql.SQLException

Specified by:

updateAsciiStream in interface java.sql.ResultSet

Overrides:

updateAsciiStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x)
                        throws java.sql.SQLException

Specified by:

updateBinaryStream in interface java.sql.ResultSet

Overrides:

updateBinaryStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader)
                           throws java.sql.SQLException

Specified by:

updateCharacterStream in interface java.sql.ResultSet

Overrides:

updateCharacterStream in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex,
                       java.io.InputStream inputStream)
                throws java.sql.SQLException

Specified by:

updateBlob in interface java.sql.ResultSet

Overrides:

updateBlob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String columnLabel,
                       java.io.InputStream inputStream)
                throws java.sql.SQLException

Specified by:

updateBlob in interface java.sql.ResultSet

Overrides:

updateBlob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateClob

public void updateClob(int columnIndex,
                       java.io.Reader reader)
                throws java.sql.SQLException

Specified by:

updateClob in interface java.sql.ResultSet

Overrides:

updateClob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateClob

public void updateClob(java.lang.String columnLabel,
                       java.io.Reader reader)
                throws java.sql.SQLException

Specified by:

updateClob in interface java.sql.ResultSet

Overrides:

updateClob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.io.Reader reader)
                 throws java.sql.SQLException

Specified by:

updateNClob in interface java.sql.ResultSet

Overrides:

updateNClob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader)
                 throws java.sql.SQLException

Specified by:

updateNClob in interface java.sql.ResultSet

Overrides:

updateNClob in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getObject

public <T> T getObject(int columnIndex,
                       java.lang.Class<T> type)
                throws java.sql.SQLException

Specified by:

getObject in interface java.sql.ResultSet

Overrides:

getObject in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException

getObject

public <T> T getObject(java.lang.String columnLabel,
                       java.lang.Class<T> type)
                throws java.sql.SQLException

Specified by:

getObject in interface java.sql.ResultSet

Overrides:

getObject in class org.apache.derby.vti.VTITemplate

Throws:

java.sql.SQLException