Package org.apache.derbyDemo.vtis.example

Class LineListVTI

java.lang.Object
org.apache.derby.vti.VTITemplate
org.apache.derby.vti.StringColumnVTI
org.apache.derbyDemo.vtis.core.FlatFileVTI
org.apache.derbyDemo.vtis.example.LineListVTI
All Implemented Interfaces:
AutoCloseable, ResultSet, Wrapper, org.apache.derby.vti.AwareVTI
public class LineListVTI extends FlatFileVTI

This VTI makes a table out of a text file. The table has one column, containing the contents of a line in the file. Leading and trailing white space are trimmed.

  • 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
    Description
    private static final String[]
    COLUMN_NAMES
     
    private static final int
    LINE
     

    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
    LineListVTI(String fileName)
    Build a LineListVTI given the name of a file.

  • Method Summary

    Modifier and Type
    Method
    Description
    static ResultSet
    lineListVTI(String fileName)
    This is the method which is registered as a table function.
    protected String[]
    parseRow()
    Parse the next chunk of text, using readLine(), and return the next row.

    Methods inherited from class org.apache.derbyDemo.vtis.core.FlatFileVTI

    close, getLineNumber, getMetaData, getRawColumn, getTextFileName, next, readLine, wrap, wrap

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

    findColumn, getAsciiStream, getBigDecimal, getBinaryStream, getBlob, getBoolean, getByte, getBytes, getClob, getColumnCount, getColumnName, getDate, getDouble, getFloat, getInt, getLong, getShort, getString, getTime, getTimestamp, setColumnNames, wasNull

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

    absolute, 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, 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, notImplemented, 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, 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 Details

  • Constructor Details

    • LineListVTI

      public LineListVTI(String fileName)

      Build a LineListVTI given the name of a file.

  • Method Details