Package com.imsl.io

Class AbstractFlatFile

java.lang.Object
com.imsl.io.AbstractFlatFile
All Implemented Interfaces:
AutoCloseable, ResultSet, Wrapper
Direct Known Subclasses:
FlatFile
public abstract class AbstractFlatFile extends Object implements ResultSet
Reads a text or binary file as a ResultSet.

In Java, the result of a database query is normally returned as a ResultSet object. This class is intended to support reading of text or binary flat files and returning them as a ResultSet.

A flat file is a rectangular data set where each row is an observation and each column is a variable. The data type in any one column is the same for all of the rows.

  • Nested Class Summary

    Nested Classes
    Modifier and Type
    Class
    Description
    protected static class 
    AbstractFlatFile.FlatFileSQLException
    A SQLException thrown by the AbstractFlatFile class.
    protected static class 
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
    A SQLFeatureNotSupportedException thrown by the AbstractFlatFile class.

  • 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
    AbstractFlatFile()
    Initializes an AbstractFlatFile.

  • Method Summary

    Modifier and Type
    Method
    Description
    boolean
    absolute(int row)
    Moves the cursor to the given row number in this ResultSet object.
    void
    afterLast()
    Moves the cursor to the end of this ResultSet object, just after the last row.
    void
    beforeFirst()
    Moves the cursor to the front of this ResultSet object, just before the first row.
    protected void
    beginGet()
    This method should be called at the start of every get Type method.
    void
    cancelRowUpdates()
    Cancels the updates made to the current row in this ResultSet object.
    void
    clearWarnings()
    Clears all warnings reported on this ResultSet object.
    void
    close()
    Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
    void
    deleteRow()
    Deletes the current row from this ResultSet object and from the underlying database.
    protected abstract byte[]
    doGetBytes(int columnIndex)
    Implements the actual getBytes().
    protected abstract boolean
    doNext()
    Implements the operations on the file required by the method next().
    int
    findColumn(String columnLabel)
    Maps the given ResultSet column name to its ResultSet column index.
    protected String
    findColumnName(int columnIndex)
    Maps the given columnIndex into its column name.
    boolean
    first()
    Moves the cursor to the first row in this ResultSet object.
    Array
    getArray(int columnIndex)
    Deprecated. 
    Array
    getArray(String columnLabel)
    Returns the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
    InputStream
    getAsciiStream(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
    InputStream
    getAsciiStream(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
    BigDecimal
    getBigDecimal(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
    BigDecimal
    getBigDecimal(int columnIndex, int scale)
    Deprecated. 
    BigDecimal
    getBigDecimal(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
    BigDecimal
    getBigDecimal(String columnLabel, int scale)
    Deprecated. 
    InputStream
    getBinaryStream(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a binary stream of uninterpreted bytes.
    InputStream
    getBinaryStream(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.
    Blob
    getBlob(int columnIndex)
    Returns the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
    Blob
    getBlob(String columnLabel)
    Returns the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
    boolean
    getBoolean(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
    boolean
    getBoolean(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
    byte
    getByte(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
    byte
    getByte(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
    byte[]
    getBytes(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
    byte[]
    getBytes(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
    Reader
    getCharacterStream(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
    Reader
    getCharacterStream(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
    Clob
    getClob(int columnIndex)
    Returns the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.
    Clob
    getClob(String columnLabel)
    Returns the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.
    Class
    getColumnClass(int columnIndex)
    Returns the class of the items in the specified column.
    abstract int
    getColumnCount()
    Returns the number of columns in this ResultSet object.
    int
    getConcurrency()
    Returns the concurrency mode of this ResultSet object.
    String
    getCursorName()
    Gets the name of the SQL cursor used by this ResultSet object.
    Date
    getDate(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
    Date
    getDate(int columnIndex, Calendar cal)
    Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
    Date
    getDate(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
    Date
    getDate(String columnLabel, Calendar cal)
    Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
    double
    getDouble(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
    double
    getDouble(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
    int
    getFetchDirection()
    Returns the fetch direction for this ResultSet object.
    int
    getFetchSize()
    Returns the fetch size for this ResultSet object.
    float
    getFloat(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
    float
    getFloat(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
    int
    getInt(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
    int
    getInt(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
    long
    getLong(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
    long
    getLong(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
    ResultSetMetaData
    getMetaData()
    Retrieves the number, types and properties of this ResultSet object's columns.
    abstract Object
    getObject(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
    <T> T
    getObject(int columnIndex, Class<T> type)
    Returns the value of the designated column in the current row of this ResultSet object converted to the requested data type in the Java programming language.
    Object
    getObject(int columnIndex, Map map)
    Returns the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
    Object
    getObject(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
    <T> T
    getObject(String columnLabel, Class<T> type)
    Returns the value of the designated column in the current row of this ResultSet object converted to the requested data type in the Java programming language.
    Object
    getObject(String columnLabel, Map map)
    Returns the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
    Ref
    getRef(int columnIndex)
    Returns the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.
    Ref
    getRef(String columnLabel)
    Returns the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.
    int
    getRow()
    Retrieves the current row number.
    short
    getShort(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
    short
    getShort(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
    Statement
    getStatement()
    Returns the Statement object that produced this ResultSet object.
    String
    getString(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
    String
    getString(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
    Time
    getTime(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
    Time
    getTime(int columnIndex, Calendar cal)
    Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
    Time
    getTime(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
    Time
    getTime(String columnLabel, Calendar cal)
    Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
    Timestamp
    getTimestamp(int columnIndex)
    Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
    Timestamp
    getTimestamp(int columnIndex, Calendar cal)
    Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
    Timestamp
    getTimestamp(String columnLabel)
    Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object.
    Timestamp
    getTimestamp(String columnLabel, Calendar cal)
    Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
    int
    getType()
    Returns the type of this ResultSet object.
    InputStream
    getUnicodeStream(int columnIndex)
    Deprecated.
    Use getCharacterStream(int) instead.
    InputStream
    getUnicodeStream(String columnLabel)
    Deprecated.
    Use getCharacterStream(String) instead.
    URL
    getURL(int columnIndex)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object.
    URL
    getURL(String columnLabel)
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object.
    SQLWarning
    getWarnings()
    Returns the first warning reported by calls on this ResultSet object.
    void
    insertRow()
    Inserts the contents of the insert row into this ResultSet object and into the database.
    boolean
    isAfterLast()
    Indicates whether the cursor is after the last row in this ResultSet object.
    boolean
    isBeforeFirst()
    Indicates whether the cursor is before the first row in this ResultSet object.
    boolean
    isFirst()
    Indicates whether the cursor is on the first row of this ResultSet object.
    boolean
    isLast()
    Indicates whether the cursor is on the last row of this ResultSet object.
    boolean
    last()
    Moves the cursor to the last row in this ResultSet object.
    void
    moveToCurrentRow()
    Moves the cursor to the remembered cursor position, usually the current row.
    void
    moveToInsertRow()
    Moves the cursor to the insert row.
    boolean
    next()
    Moves the cursor down one row from its current position.
    boolean
    previous()
    Moves the cursor to the previous row in this ResultSet object.
    void
    refreshRow()
    Refreshes the current row with its most recent value in the database.
    boolean
    relative(int rows)
    Moves the cursor a relative number of rows, either positive or negative.
    boolean
    rowDeleted()
    Indicates whether a row has been deleted.
    boolean
    rowInserted()
    Indicates whether the current row has had an insertion.
    boolean
    rowUpdated()
    Indicates whether the current row has been updated.
    protected void
    setColumnClass(int columnIndex, Class columnClass)
    Sets a column class.
    protected void
    setColumnName(int columnIndex, String columnName)
    Sets a column name.
    void
    setFetchDirection(int direction)
    Gives a hint as to the direction in which the rows in this ResultSet object is processed.
    void
    setFetchSize(int rows)
    Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object.
    protected void
    setWarning(SQLWarning warning)
    Sets a SQLWarning.
    void
    updateArray(int column, Array x)
    Updates the designated column with an Array value.
    void
    updateArray(String columnLabel, Array x)
    Updates the designated column with an Array value.
    void
    updateAsciiStream(int columnIndex, InputStream x, int length)
    Updates the designated column with an ASCII stream value.
    void
    updateAsciiStream(String columnLabel, InputStream x, int length)
    Updates the designated column with an ASCII stream value.
    void
    updateBigDecimal(int columnIndex, BigDecimal x)
    Updates the designated column with a java.math.BigDecimal value.
    void
    updateBigDecimal(String columnLabel, BigDecimal x)
    Updates the designated column with a java.sql.BigDecimal value.
    void
    updateBinaryStream(int columnIndex, InputStream x, int length)
    Updates the designated column with a binary stream value.
    void
    updateBinaryStream(String columnLabel, InputStream x, int length)
    Updates the designated column with a binary stream value.
    void
    updateBlob(int column, Blob x)
    Updates the designated column with an java.sql.Blob value.
    void
    updateBlob(String columnLabel, Blob x)
    Updates the designated column with an java.sql.Blob value.
    void
    updateBoolean(int columnIndex, boolean x)
    Updates the designated column with a boolean value.
    void
    updateBoolean(String columnLabel, boolean x)
    Updates the designated column with a boolean value.
    void
    updateByte(int columnIndex, byte x)
    Updates the designated column with a byte value.
    void
    updateByte(String columnLabel, byte x)
    Updates the designated column with a byte value.
    void
    updateBytes(int columnIndex, byte[] x)
    Updates the designated column with a byte array value.
    void
    updateBytes(String columnLabel, byte[] x)
    Updates the designated column with a byte value.
    void
    updateCharacterStream(int columnIndex, Reader x, int length)
    Updates the designated column with a character stream value.
    void
    updateCharacterStream(String columnLabel, Reader reader, int length)
    Updates the designated column with a character stream value.
    void
    updateClob(int column, Clob x)
    Updates the designated column with an java.sql.Clob value.
    void
    updateClob(String columnLabel, Clob x)
    Updates the designated column with an java.sql.Clob value.
    void
    updateDate(int columnIndex, Date x)
    Updates the designated column with a java.sql.Date value.
    void
    updateDate(String columnLabel, Date x)
    Updates the designated column with a java.sql.Date value.
    void
    updateDouble(int columnIndex, double x)
    Updates the designated column with a double value.
    void
    updateDouble(String columnLabel, double x)
    Updates the designated column with a double value.
    void
    updateFloat(int columnIndex, float x)
    Updates the designated column with a float value.
    void
    updateFloat(String columnLabel, float x)
    Updates the designated column with a float value.
    void
    updateInt(int columnIndex, int x)
    Updates the designated column with an int value.
    void
    updateInt(String columnLabel, int x)
    Updates the designated column with an int value.
    void
    updateLong(int columnIndex, long x)
    Updates the designated column with a long value.
    void
    updateLong(String columnLabel, long x)
    Updates the designated column with a long value.
    void
    updateNull(int columnIndex)
    Gives a nullable column a null value.
    void
    updateNull(String columnLabel)
    Updates the designated column with a null value.
    void
    updateObject(int columnIndex, Object x)
    Updates the designated column with an Object value.
    void
    updateObject(int columnIndex, Object x, int scale)
    Updates the designated column with an Object value.
    void
    updateObject(String columnLabel, Object x)
    Updates the designated column with an Object value.
    void
    updateObject(String columnLabel, Object x, int scale)
    Updates the designated column with an Object value.
    void
    updateRef(int column, Ref x)
    Updates the designated column with an java.sql.Ref value.
    void
    updateRef(String columnLabel, Ref x)
    Updates the designated column with an java.sql.Ref value.
    void
    updateRow()
    Updates the underlying database with the new contents of the current row of this ResultSet object.
    void
    updateShort(int columnIndex, short x)
    Updates the designated column with a short value.
    void
    updateShort(String columnLabel, short x)
    Updates the designated column with a short value.
    void
    updateString(int columnIndex, String x)
    Updates the designated column with a String value.
    void
    updateString(String columnLabel, String x)
    Updates the designated column with a String value.
    void
    updateTime(int columnIndex, Time x)
    Updates the designated column with a java.sql.Time value.
    void
    updateTime(String columnLabel, Time x)
    Updates the designated column with a java.sql.Time value.
    void
    updateTimestamp(int columnIndex, Timestamp x)
    Updates the designated column with a java.sql.Timestamp value.
    void
    updateTimestamp(String columnLabel, Timestamp x)
    Updates the designated column with a java.sql.Timestamp value.
    boolean
    wasNull()
    Reports whether the last column read had a value of SQL NULL.

    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

    getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, isClosed, 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, updateObject, updateObject, updateObject, updateObject, updateRowId, updateRowId, updateSQLXML, updateSQLXML

    Methods inherited from interface java.sql.Wrapper

    isWrapperFor, unwrap

  • Constructor Details

    • AbstractFlatFile

      public AbstractFlatFile()
      Initializes an AbstractFlatFile. Since AbstractFlatFile is abstract, it cannot be directly instantiated.

  • Method Details

    • setColumnName

      protected void setColumnName(int columnIndex, String columnName)
      Sets a column name. A subclass can define its own mechanism for naming columns. An alternate mechanism would require overriding the methods findColumn and findColumnName.
      Parameters:
      columnIndex - an int specifying the column index of the column to be named
      columnName - a String specifying the name of the column
      See Also:

    • setColumnClass

      protected void setColumnClass(int columnIndex, Class columnClass)
      Sets a column class.
      Parameters:
      columnIndex - an int specifying the index of a column
      columnClass - a Class object used to specify the class of the data in the column

    • findColumn

      public int findColumn(String columnLabel) throws SQLException
      Maps the given ResultSet column name to its ResultSet column index.
      Specified by:
      findColumn in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      an int specifying the column index of the given column name
      Throws:
      SQLException - if the ResultSet object does not contain columnLabel or a database access error occurs

    • findColumnName

      protected String findColumnName(int columnIndex) throws SQLException
      Maps the given columnIndex into its column name.
      Parameters:
      columnIndex - an int specifying the index of a column for which the name is to be found
      Returns:
      a String containing the name of the column
      Throws:
      SQLException - if a database access error occurs

    • beginGet

      protected void beginGet()
      This method should be called at the start of every get Type method. It closes any InputStreams or Readers created by get methods in this object. It also resets the wasNull flag to false.

    • next

      public boolean next() throws SQLException
      Moves the cursor down one row from its current position. A ResultSet cursor is initially positioned before the first row, the first call to the method next makes the first row the current row, the second call makes the second row the current row, and so on.

      If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.

      Specified by:
      next in interface ResultSet
      Returns:
      a boolean, true if the new current row is valid, false if there are no more rows
      Throws:
      SQLException - if a database access error occurs or this method is called on a closed result set

    • doNext

      protected abstract boolean doNext() throws SQLException
      Implements the operations on the file required by the method next().
      Returns:
      a boolean, true if the new current row is valid, false if there are no more rows
      Throws:
      SQLException - if a database access error occurs

    • getColumnCount

      public abstract int getColumnCount() throws SQLException
      Returns the number of columns in this ResultSet object.
      Returns:
      an int that specifies the number of columns
      Throws:
      SQLException - if a database access error occurs

    • close

      public void close() throws SQLException
      Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
      Specified by:
      close in interface AutoCloseable
      Specified by:
      close in interface ResultSet
      Throws:
      SQLException - if a database access error occurs

    • getColumnClass

      public Class getColumnClass(int columnIndex) throws SQLException
      Returns the class of the items in the specified column. The default implementation returns the Class set using getColumnClass. If no class type is set the default implementation returns Object.class.
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a Class object used to specify the class of the data in the column
      Throws:
      SQLException - if a database access error occurs
      See Also:

    • wasNull

      public boolean wasNull() throws SQLException
      Reports whether the last column read had a value of SQL NULL. Note that you must first call one of the getType methods on a column to try to read its value and then call the method wasNull to see if the value read was SQL NULL.
      Specified by:
      wasNull in interface ResultSet
      Returns:
      a boolean, true if the last column value read was SQL NULL otherwise false
      Throws:
      SQLException - if a database access error occurs

    • getString

      public String getString(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
      Specified by:
      getString in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a String representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getBoolean

      public boolean getBoolean(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
      Specified by:
      getBoolean in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a boolean representation of the column value. If the value is SQL NULL, the value returned is false.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getByte

      public byte getByte(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
      Specified by:
      getByte in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a byte representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getShort

      public short getShort(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
      Specified by:
      getShort in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a short representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getInt

      public int getInt(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
      Specified by:
      getInt in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      an int representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getLong

      public long getLong(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
      Specified by:
      getLong in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a long representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getFloat

      public float getFloat(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
      Specified by:
      getFloat in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a float representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getDouble

      public double getDouble(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
      Specified by:
      getDouble in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a double representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getBigDecimal

      public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
      Deprecated.
      Gets the value of the designated column in the current row of this ResultSet object as a java.sql.BigDecimal in the Java programming language.
      Specified by:
      getBigDecimal in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      scale - an int that specifies the number of digits to the right of the decimal point
      Returns:
      a java.sql.BigDecimal representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getBytes

      public byte[] getBytes(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. The bytes represent the raw values returned by the driver.
      Specified by:
      getBytes in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a byte array representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • doGetBytes

      protected abstract byte[] doGetBytes(int columnIndex) throws SQLException
      Implements the actual getBytes(). The bytes represent the raw values returned by the driver.
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a byte array representation of the column value. If the value is SQL null, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getDate

      public Date getDate(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
      Specified by:
      getDate in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a java.sql.Date representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getTime

      public Time getTime(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
      Specified by:
      getTime in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a java.sql.Time representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getTimestamp

      public Timestamp getTimestamp(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
      Specified by:
      getTimestamp in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a java.sql.Timestamp representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getAsciiStream

      public InputStream getAsciiStream(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver does any necessary conversion from the database format into ASCII.

      Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getType method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

      Specified by:
      getAsciiStream in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a java.io.InputStream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getUnicodeStream

      public InputStream getUnicodeStream(int columnIndex) throws SQLException
      Deprecated.
      Use getCharacterStream(int) instead.
      Gets the value of the designated column in the current row of this ResultSet object as as a stream of Unicode characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver does any necessary conversion from the database format into Unicode. The byte format of the Unicode stream must be Java UTF-8, as specified in the Java virtual machine specification.

      Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getType method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

      Specified by:
      getUnicodeStream in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a java.io.InputStream that delivers the database column value as a stream in Java UTF-8 byte format. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getBinaryStream

      public InputStream getBinaryStream(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a binary stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.

      Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getType method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

      Specified by:
      getBinaryStream in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a java.io.InputStream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getString

      public String getString(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
      Specified by:
      getString in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a String representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getBoolean

      public boolean getBoolean(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
      Specified by:
      getBoolean in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a boolean representation of the column value. If the value is SQL NULL, the value returned is false.
      Throws:
      SQLException - if a database access error occurs

    • getByte

      public byte getByte(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
      Specified by:
      getByte in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a byte representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a database access error occurs

    • getShort

      public short getShort(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
      Specified by:
      getShort in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a short representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a database access error occurs

    • getInt

      public int getInt(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
      Specified by:
      getInt in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      an int representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a database access error occurs

    • getLong

      public long getLong(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
      Specified by:
      getLong in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a long representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a database access error occurs

    • getFloat

      public float getFloat(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
      Specified by:
      getFloat in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a float representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a database access error occurs

    • getDouble

      public double getDouble(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
      Specified by:
      getDouble in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a double representation of the column value. If the value is SQL NULL, the value returned is 0.
      Throws:
      SQLException - if a database access error occurs

    • getBigDecimal

      public BigDecimal getBigDecimal(String columnLabel, int scale) throws SQLException
      Deprecated.
      Gets the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal in the Java programming language.
      Specified by:
      getBigDecimal in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      scale - an int that specifies the number of digits to the right of the decimal point
      Returns:
      a java.math.BigDecimal representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getBytes

      public byte[] getBytes(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. The bytes represent the raw values returned by the driver.
      Specified by:
      getBytes in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a byte array representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getDate

      public Date getDate(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
      Specified by:
      getDate in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a java.sql.Date representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getTime

      public Time getTime(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
      Specified by:
      getTime in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a java.sql.Time representation of the column value. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getTimestamp

      public Timestamp getTimestamp(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object.
      Specified by:
      getTimestamp in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a java.sql.Timestamp representation of the column value, if the value is SQL NULL, the value returned is null
      Throws:
      SQLException - if a database access error occurs

    • getAsciiStream

      public InputStream getAsciiStream(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver does any necessary conversion from the database format into ASCII.

      Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getType method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

      Specified by:
      getAsciiStream in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a java.io.InputStream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getUnicodeStream

      public InputStream getUnicodeStream(String columnLabel) throws SQLException
      Deprecated.
      Use getCharacterStream(String) instead.
      Gets the value of the designated column in the current row of this ResultSet object as a stream of Unicode characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver does any necessary conversion from the database format into Unicode. The byte format of the Unicode stream must be Java UTF-8, as defined in the Java virtual machine specification.

      Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getType method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

      Specified by:
      getUnicodeStream in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a java.io.InputStream that delivers the database column value as a stream of two-byte Unicode characters. If the value is SQL NULL, the value returned is null.
      Throws:
      SQLException - if a database access error occurs

    • getBinaryStream

      public InputStream getBinaryStream(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.

      Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getType method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

      Specified by:
      getBinaryStream in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a java.io.InputStream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - if a database access error occurs

    • getWarnings

      public SQLWarning getWarnings() throws SQLException
      Returns the first warning reported by calls on this ResultSet object. Subsequent warnings on this ResultSet object are chained to the SQLWarning object that this method returns.

      The warning chain is automatically cleared each time a new row is read.

      Note: This warning chain only covers warnings caused by ResultSet methods. Any warning caused by Statement methods (such as reading OUT parameters) are chained on the Statement object.

      Specified by:
      getWarnings in interface ResultSet
      Returns:
      the first SQLWarning object reported or null
      Throws:
      SQLException - if a database access error occurs

    • clearWarnings

      public void clearWarnings() throws SQLException
      Clears all warnings reported on this ResultSet object. After this method is called, the method getWarnings returns null until a new warning is reported for this ResultSet object.
      Specified by:
      clearWarnings in interface ResultSet
      Throws:
      SQLException - if a database access error occurs

    • setWarning

      protected void setWarning(SQLWarning warning)
      Sets a SQLWarning.
      Parameters:
      warning - a SQLWarning that is to be added to this object.

    • getCursorName

      public String getCursorName() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Gets the name of the SQL cursor used by this ResultSet object. The default implementation throws a SQLException.
      Specified by:
      getCursorName in interface ResultSet
      Returns:
      a String that specifies the SQL name for this ResultSet object's cursor
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented

    • getMetaData

      public ResultSetMetaData getMetaData() throws SQLException
      Retrieves the number, types and properties of this ResultSet object's columns.
      Specified by:
      getMetaData in interface ResultSet
      Returns:
      a ResultSetMetaData which provides a description of this ResultSet object's columns
      Throws:
      SQLException - if a database access error occurs

    • getObject

      public abstract Object getObject(int columnIndex) throws SQLException

      Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

      This method returns the value of the given column as a Java object. The type of the Java object is the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.

      Specified by:
      getObject in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a java.lang.Object representation of the column value
      Throws:
      SQLException - if a database access error occurs

    • getObject

      public Object getObject(String columnLabel) throws SQLException

      Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

      This method returns the value of the given column as a Java object. The type of the Java object is the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.

      This method may also be used to read datatabase-specific abstract data types. In the JDBC 2.0 API, the behavior of the method getObject is extended to materialize data of SQL user-defined types. When a column contains a structured or distinct value, the behavior of this method is as if it were a call to: getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).

      Specified by:
      getObject in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a java.lang.Object representation of the column value
      Throws:
      SQLException - if a database access error occurs

    • getCharacterStream

      public Reader getCharacterStream(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
      Specified by:
      getCharacterStream in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a java.io.Reader object that contains the column value. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs

    • getCharacterStream

      public Reader getCharacterStream(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
      Specified by:
      getCharacterStream in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a java.io.Reader object that contains the column value. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs

    • getBigDecimal

      public BigDecimal getBigDecimal(int columnIndex) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
      Specified by:
      getBigDecimal in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a java.math.BigDecimal object that contains the column value. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a conversion or database access error occurs

    • getBigDecimal

      public BigDecimal getBigDecimal(String columnLabel) throws SQLException
      Gets the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
      Specified by:
      getBigDecimal in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a java.math.BigDecimal object that contains the column value. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs

    • getURL

      public URL getURL(String columnLabel) throws SQLException
      Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object.
      Specified by:
      getURL in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a java.net.URL object that contains the column value. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs

    • getURL

      public URL getURL(int columnIndex) throws SQLException
      Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object.
      Specified by:
      getURL in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a java.net.URL object that contains the column value. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a conversion or database access error occurs

    • isBeforeFirst

      public boolean isBeforeFirst() throws SQLException
      Indicates whether the cursor is before the first row in this ResultSet object.
      Specified by:
      isBeforeFirst in interface ResultSet
      Returns:
      a boolean whose value is true if the cursor is before the first row, false if the cursor is at any other position or the ResultSet contains no rows
      Throws:
      SQLException - if a database access error occurs

    • isAfterLast

      public boolean isAfterLast() throws SQLException
      Indicates whether the cursor is after the last row in this ResultSet object.
      Specified by:
      isAfterLast in interface ResultSet
      Returns:
      a boolean whose value is true if the cursor is after the last row, false if the cursor is at any other position or the ResultSet contains no rows
      Throws:
      SQLException - if a database access error occurs

    • isFirst

      public boolean isFirst() throws SQLException
      Indicates whether the cursor is on the first row of this ResultSet object.
      Specified by:
      isFirst in interface ResultSet
      Returns:
      a boolean whose value is true if the cursor is on the first row, false otherwise
      Throws:
      SQLException - if a database access error occurs

    • isLast

      public boolean isLast() throws SQLException
      Indicates whether the cursor is on the last row of this ResultSet object. Note: Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.
      Specified by:
      isLast in interface ResultSet
      Returns:
      a boolean whose value is true if the cursor is on the last row, false otherwise
      Throws:
      SQLException - if a database access error occurs

    • beforeFirst

      public void beforeFirst() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Moves the cursor to the front of this ResultSet object, just before the first row. This method has no effect if the result set contains no rows.
      Specified by:
      beforeFirst in interface ResultSet
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • afterLast

      public void afterLast() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Moves the cursor to the end of this ResultSet object, just after the last row. This method has no effect if the result set contains no rows.
      Specified by:
      afterLast in interface ResultSet
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • first

      public boolean first() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Moves the cursor to the first row in this ResultSet object.
      Specified by:
      first in interface ResultSet
      Returns:
      a boolean whose value is true if the cursor is on the result set, false otherwise
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • last

      public boolean last() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Moves the cursor to the last row in this ResultSet object.
      Specified by:
      last in interface ResultSet
      Returns:
      a boolean whose value is true if the cursor is on the result set, false otherwise
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • getRow

      public int getRow() throws SQLException
      Retrieves the current row number. The first row is number 1, the second number 2, and so on.
      Specified by:
      getRow in interface ResultSet
      Returns:
      an int that specifies the current row number; 0 if there is no current row
      Throws:
      SQLException - if a database access error occurs

    • absolute

      public boolean absolute(int row) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Moves the cursor to the given row number in this ResultSet object.
      Specified by:
      absolute in interface ResultSet
      Parameters:
      row - an int that specifies a row, of the ResultSet object, where the cursor is to be moved
      Returns:
      a boolean whose value is true if the cursor is on the result set, false otherwise
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • relative

      public boolean relative(int rows) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Moves the cursor a relative number of rows, either positive or negative.
      Specified by:
      relative in interface ResultSet
      Parameters:
      rows - an int that specifies the number of rows in the ResultSet object to advance or regress
      Returns:
      a boolean whose value is true if the cursor is on the result set, false otherwise
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • previous

      public boolean previous() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Moves the cursor to the previous row in this ResultSet object.
      Specified by:
      previous in interface ResultSet
      Returns:
      a boolean whose value is true if the cursor is on the result set, false otherwise
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • setFetchDirection

      public void setFetchDirection(int direction) throws SQLException
      Gives a hint as to the direction in which the rows in this ResultSet object is processed.
      Specified by:
      setFetchDirection in interface ResultSet
      Parameters:
      direction - an int that specifies the expected direction this ResultSet object is to be processed
      Throws:
      SQLException - if the fetch direction is not FETCH_FORWARD
      See Also:

    • getFetchDirection

      public int getFetchDirection() throws SQLException
      Returns the fetch direction for this ResultSet object.
      Specified by:
      getFetchDirection in interface ResultSet
      Returns:
      an int that specifies the current fetch direction for this ResultSet object. Always returns FETCH_FORWARD.
      Throws:
      SQLException - if a database access error occurs

    • setFetchSize

      public void setFetchSize(int rows) throws SQLException
      Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the Statement object that created the result set. The fetch size may be changed at any time.
      Specified by:
      setFetchSize in interface ResultSet
      Parameters:
      rows - an int that specifies the number of rows to fetch
      Throws:
      SQLException - if a database access error occurs or the condition 0 <= rows <= this.getMaxRows() is not satisfied

    • getFetchSize

      public int getFetchSize() throws SQLException
      Returns the fetch size for this ResultSet object.
      Specified by:
      getFetchSize in interface ResultSet
      Returns:
      an int that specifies the current fetch size for this ResultSet object
      Throws:
      SQLException - if a database access error occurs

    • getType

      public int getType() throws SQLException
      Returns the type of this ResultSet object. The type is determined by the Statement object that created the result set.
      Specified by:
      getType in interface ResultSet
      Returns:
      an int that specifies the type of this ResultSet object. Always returns TYPE_FORWARD_ONLY.
      Throws:
      SQLException - if a database access error occurs

    • getConcurrency

      public int getConcurrency() throws SQLException
      Returns the concurrency mode of this ResultSet object.
      Specified by:
      getConcurrency in interface ResultSet
      Returns:
      an int that specifies whether concurrency is read only or an update processes as well. Always returns CONCUR_READ_ONLY.
      Throws:
      SQLException - if a database access error occurs

    • rowUpdated

      public boolean rowUpdated() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Indicates whether the current row has been updated. Since updates are not allowed, this always returns false.
      Specified by:
      rowUpdated in interface ResultSet
      Returns:
      a boolean which indicates whether a row has been updated. Always returns false since updates are not allowed.
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • rowInserted

      public boolean rowInserted() throws SQLException
      Indicates whether the current row has had an insertion. Since updates are not allowed, this always returns false.
      Specified by:
      rowInserted in interface ResultSet
      Returns:
      a boolean which indicates whether the current row had an insertion. Always returns false since updates are not allowed.
      Throws:
      SQLException - if a database access error occurs

    • rowDeleted

      public boolean rowDeleted() throws SQLException
      Indicates whether a row has been deleted. Since updates are not allowed, this always returns false.
      Specified by:
      rowDeleted in interface ResultSet
      Returns:
      a boolean which indicates whether a row has been deleted. Always returns false since updates are not allowed.
      Throws:
      SQLException - if a database access error occurs

    • updateNull

      public void updateNull(int columnIndex) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Gives a nullable column a null value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateNull in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateBoolean

      public void updateBoolean(int columnIndex, boolean x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a boolean value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateBoolean in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a boolean that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateByte

      public void updateByte(int columnIndex, byte x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a byte value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateByte in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a byte that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateShort

      public void updateShort(int columnIndex, short x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a short value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateShort in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a short that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateInt

      public void updateInt(int columnIndex, int x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an int value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateInt in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - an int that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateLong

      public void updateLong(int columnIndex, long x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a long value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateLong in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a long that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateFloat

      public void updateFloat(int columnIndex, float x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a float value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateFloat in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a float that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateDouble

      public void updateDouble(int columnIndex, double x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a double value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateDouble in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a double that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateBigDecimal

      public void updateBigDecimal(int columnIndex, BigDecimal x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a java.math.BigDecimal value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateBigDecimal in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a java.math.BigDecimal that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateString

      public void updateString(int columnIndex, String x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a String value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateString in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a String that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateBytes

      public void updateBytes(int columnIndex, byte[] x) throws SQLException
      Updates the designated column with a byte array value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateBytes in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a byte array that specifies the new column value
      Throws:
      SQLException - is always thrown since updates are not allowed

    • updateDate

      public void updateDate(int columnIndex, Date x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a java.sql.Date value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateDate in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a java.sql.Date that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateTime

      public void updateTime(int columnIndex, Time x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a java.sql.Time value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateTime in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a java.sql.Time that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateTimestamp

      public void updateTimestamp(int columnIndex, Timestamp x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a java.sql.Timestamp value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateTimestamp in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a java.sql.Timestamp that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateAsciiStream

      public void updateAsciiStream(int columnIndex, InputStream x, int length) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an ASCII stream value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateAsciiStream in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - an InputStream that specifies the new column value
      length - an int that specifies the stream length
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateBinaryStream

      public void updateBinaryStream(int columnIndex, InputStream x, int length) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a binary stream value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateBinaryStream in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - an InputStream that specifies the new column value
      length - an int that specifies the stream length
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateCharacterStream

      public void updateCharacterStream(int columnIndex, Reader x, int length) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a character stream value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateCharacterStream in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a Reader that specifies the new column value
      length - an int that specifies the stream length
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateObject

      public void updateObject(int columnIndex, Object x, int scale) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an Object value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateObject in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - an Object that specifies the new column value
      scale - for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types this value is ignored.
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateObject

      public void updateObject(int columnIndex, Object x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an Object value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateObject in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - an Object that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateNull

      public void updateNull(String columnLabel) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a null value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateNull in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateBoolean

      public void updateBoolean(String columnLabel, boolean x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a boolean value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateBoolean in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a boolean that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateByte

      public void updateByte(String columnLabel, byte x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a byte value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateByte in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a byte that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateShort

      public void updateShort(String columnLabel, short x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a short value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateShort in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a short that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateInt

      public void updateInt(String columnLabel, int x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an int value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateInt in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - an int that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateLong

      public void updateLong(String columnLabel, long x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a long value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateLong in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a long that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateFloat

      public void updateFloat(String columnLabel, float x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a float value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateFloat in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a float that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateDouble

      public void updateDouble(String columnLabel, double x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a double value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateDouble in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a double that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateBigDecimal

      public void updateBigDecimal(String columnLabel, BigDecimal x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a java.sql.BigDecimal value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateBigDecimal in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a java.sql.BigDecimal that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateString

      public void updateString(String columnLabel, String x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a String value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateString in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a String that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateBytes

      public void updateBytes(String columnLabel, byte[] x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a byte value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateBytes in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a byte array that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateDate

      public void updateDate(String columnLabel, Date x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a java.sql.Date value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateDate in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a java.sql.Date that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateTime

      public void updateTime(String columnLabel, Time x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a java.sql.Time value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateTime in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a java.sql.Time that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateTimestamp

      public void updateTimestamp(String columnLabel, Timestamp x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a java.sql.Timestamp value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateTimestamp in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a java.sql.Timestamp that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateAsciiStream

      public void updateAsciiStream(String columnLabel, InputStream x, int length) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an ASCII stream value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateAsciiStream in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - an InputStream that specifies the new column value
      length - an int that specifies the stream length
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateBinaryStream

      public void updateBinaryStream(String columnLabel, InputStream x, int length) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a binary stream value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateBinaryStream in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - an InputStream that specifies the new column value
      length - an int that specifies the stream length
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateCharacterStream

      public void updateCharacterStream(String columnLabel, Reader reader, int length) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with a character stream value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateCharacterStream in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      reader - a Reader that specifies the new column value
      length - an int that specifies the stream length
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateObject

      public void updateObject(String columnLabel, Object x, int scale) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an Object value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateObject in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - an Object that specifies the new column value
      scale - for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types this value is ignored.
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateObject

      public void updateObject(String columnLabel, Object x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an Object value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateObject in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a java.sql.Object that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateArray

      public void updateArray(String columnLabel, Array x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an Array value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateArray in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a java.sql.Array that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateArray

      public void updateArray(int column, Array x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an Array value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateArray in interface ResultSet
      Parameters:
      column - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a java.sql.Array that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateClob

      public void updateClob(String columnLabel, Clob x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an java.sql.Clob value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateClob in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a java.sql.Clob that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateBlob

      public void updateBlob(int column, Blob x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an java.sql.Blob value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateBlob in interface ResultSet
      Parameters:
      column - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a java.sql.Blob that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateBlob

      public void updateBlob(String columnLabel, Blob x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an java.sql.Blob value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateBlob in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a java.sql.Blob that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateClob

      public void updateClob(int column, Clob x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an java.sql.Clob value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateClob in interface ResultSet
      Parameters:
      column - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a java.sql.Clob that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateRef

      public void updateRef(String columnLabel, Ref x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an java.sql.Ref value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateRef in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      x - a java.sql.Ref that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateRef

      public void updateRef(int column, Ref x) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the designated column with an java.sql.Ref value. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateRef in interface ResultSet
      Parameters:
      column - an int that specifies the column. The first column is 1, the second is 2, and so on.
      x - a java.sql.Ref that specifies the new column value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • insertRow

      public void insertRow() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Inserts the contents of the insert row into this ResultSet object and into the database. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      insertRow in interface ResultSet
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • updateRow

      public void updateRow() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Updates the underlying database with the new contents of the current row of this ResultSet object. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      updateRow in interface ResultSet
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • deleteRow

      public void deleteRow() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Deletes the current row from this ResultSet object and from the underlying database. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      deleteRow in interface ResultSet
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • refreshRow

      public void refreshRow() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Refreshes the current row with its most recent value in the database. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      refreshRow in interface ResultSet
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • cancelRowUpdates

      public void cancelRowUpdates() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Cancels the updates made to the current row in this ResultSet object. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      cancelRowUpdates in interface ResultSet
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • moveToInsertRow

      public void moveToInsertRow() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Moves the cursor to the insert row. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      moveToInsertRow in interface ResultSet
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • moveToCurrentRow

      public void moveToCurrentRow() throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Moves the cursor to the remembered cursor position, usually the current row. Since updates are not allowed, this method always throws a SQLException.
      Specified by:
      moveToCurrentRow in interface ResultSet
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • getStatement

      public Statement getStatement() throws SQLException
      Returns the Statement object that produced this ResultSet object. Since there is no java.sqlStatement, this method always throws a SQLException.
      Specified by:
      getStatement in interface ResultSet
      Returns:
      the Statment object that produced this ResultSet object or null if the result set was produced some other way
      Throws:
      SQLException - is always thrown since updates are not allowed

    • getObject

      public Object getObject(int columnIndex, Map map) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Returns the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. This method uses the given Map object for the custom mapping of the SQL structured or distinct type that is being retrieved.
      Specified by:
      getObject in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      map - a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
      Returns:
      an Object in the Java programming language representing the SQL value
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • getObject

      public <T> T getObject(String columnLabel, Class<T> type) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Returns the value of the designated column in the current row of this ResultSet object converted to the requested data type in the Java programming language.
      Specified by:
      getObject in interface ResultSet
      Type Parameters:
      T - the argument type that to be unwrapped
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      type - a Java data type to convert to
      Returns:
      an Object representing the SQL value in the specified column
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • getObject

      public <T> T getObject(int columnIndex, Class<T> type) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Returns the value of the designated column in the current row of this ResultSet object converted to the requested data type in the Java programming language.
      Specified by:
      getObject in interface ResultSet
      Type Parameters:
      T - the argument type that to be unwrapped
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      type - a Java data type to convert to
      Returns:
      an Object representing the SQL value in the specified column
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • getRef

      public Ref getRef(int columnIndex) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Returns the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.
      Specified by:
      getRef in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a Ref object representing the SQL REF value in the specified column
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • getBlob

      public Blob getBlob(int columnIndex) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

      NOTE: java.sql.Blob.free() has not been implemented (they are empty methods) in the instance returned. java.sql.Blob.getBinaryStream(long, long) returns null and java.sql.Blob.setBinaryStream(long) throws a SQLException.

      Specified by:
      getBlob in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a Blob object representing the SQL BLOB value in the specified column
      Throws:
      SQLException - if a database access error occurs

    • getClob

      public Clob getClob(int columnIndex) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.

      NOTE: java.sql.Clob.free() has not been implemented (they are empty methods) in the instance returned. java.sql.Clob.getCharacterStream(long, long) returns null. java.sql.Clob.position(Clob, long), java.sql.Clob.setAsciiStream(long), java.sql.Clob.setCharacterStream(long), java.sql.Clob.setString(long, String), and java.sql.Clob.setString(long, String, int, int) throw a SQLException.

      Specified by:
      getClob in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      a Clob object representing an SQL Clob value in the specified column
      Throws:
      SQLException - if a database access error occurs

    • getArray

      public Array getArray(int columnIndex) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Deprecated.
      Returns the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
      Specified by:
      getArray in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      Returns:
      an Array object representing an SQL Array value in the specified column
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • getObject

      public Object getObject(String columnLabel, Map map) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Returns the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. This method uses the specified Map object for custom mapping if appropriate.
      Specified by:
      getObject in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      map - a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
      Returns:
      an Object representing the SQL value in the specified column
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • getRef

      public Ref getRef(String columnLabel) throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
      Returns the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.
      Specified by:
      getRef in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a Ref object representing the SQL REF value in the specified column
      Throws:
      AbstractFlatFile.FlatFileSQLFeatureNotSupportedException - this feature has not been implemented.

    • getBlob

      public Blob getBlob(String columnLabel) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
      Specified by:
      getBlob in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a Blob object representing the SQL BLOB value in the specified column
      Throws:
      SQLException - if a database access error occurs

    • getClob

      public Clob getClob(String columnLabel) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.
      Specified by:
      getClob in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      a Clob object representing the SQL CLOB value in the specified column
      Throws:
      SQLException - if a database access error occurs

    • getArray

      public Array getArray(String columnLabel) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
      Specified by:
      getArray in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      Returns:
      an Array object representing the SQL ARRAY value in the specified column
      Throws:
      SQLException - if a database access error occurs

    • getDate

      public Date getDate(int columnIndex, Calendar cal) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.
      Specified by:
      getDate in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      cal - the java.util.Calendar object to use in constructing the date
      Returns:
      the column value as a java.sql.Date object. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs

    • getDate

      public Date getDate(String columnLabel, Calendar cal) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.
      Specified by:
      getDate in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      cal - the java.util.Calendar object to use in constructing the date
      Returns:
      the column value as a java.sql.Date object. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs

    • getTime

      public Time getTime(int columnIndex, Calendar cal) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the time if the underlying database does not store timezone information.
      Specified by:
      getTime in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      cal - the java.util.Calendar object to use in constructing the time
      Returns:
      the column value as a java.sql.Time object. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs

    • getTime

      public Time getTime(String columnLabel, Calendar cal) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the time if the underlying database does not store timezone information.
      Specified by:
      getTime in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      cal - the java.util.Calendar object to use in constructing the time
      Returns:
      the column value as a java.sql.Time object. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs

    • getTimestamp

      public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.
      Specified by:
      getTimestamp in interface ResultSet
      Parameters:
      columnIndex - an int that specifies the column. The first column is 1, the second is 2, and so on.
      cal - the java.util.Calendar object to use in constructing the timestamp
      Returns:
      the column value as a java.sql.Timestamp object. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs

    • getTimestamp

      public Timestamp getTimestamp(String columnLabel, Calendar cal) throws SQLException
      Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.
      Specified by:
      getTimestamp in interface ResultSet
      Parameters:
      columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
      cal - the java.util.Calendar object to use in constructing the timestamp
      Returns:
      the column value as a java.sql.Timestamp object. If the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs