JMSLTM Numerical Library 6.1

com.imsl.io
Class AbstractFlatFile

java.lang.Object
  extended by com.imsl.io.AbstractFlatFile
All Implemented Interfaces:
ResultSet
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
protected static class AbstractFlatFile.FlatFileSQLException
          A SQLException 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
AbstractFlatFile()
          Initializes an AbstractFlatFile.
 
Method Summary
 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 getType 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 columnName)
          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)
          Returns the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
 Array getArray(String columnName)
          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 columnName)
          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(String columnName)
          Gets the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
 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 columnName)
          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 columnName)
          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 columnName)
          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 columnName)
          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 columnName)
          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 columnName)
          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 columnName)
          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 columnName)
          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 columnName, 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 columnName)
          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 columnName)
          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 columnName)
          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 columnName)
          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.
 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 columnName)
          Gets 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 columnName, 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 columnName)
          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 columnName)
          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 columnName)
          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 columnName)
          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 columnName, 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 columnName)
          Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object.
 Timestamp getTimestamp(String columnName, 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.
 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 columnName)
          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 will be 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, long x)
          Updates the designated column with a long value.
 void updateNull(int columnIndex)
          Gives a nullable column a null value.
 void updateNull(String columnName)
          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 columnName, Object x)
          Updates the designated column with an Object value.
 void updateObject(String columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, 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
getBigDecimal, getBigDecimal, getUnicodeStream, getUnicodeStream
 

Constructor Detail

AbstractFlatFile

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

Method Detail

absolute

public boolean absolute(int row)
                 throws SQLException
Moves the cursor to the given row number in this ResultSet object.

Specified by:
absolute in interface ResultSet
Parameters:
row - an int which 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.FlatFileSQLException - is always thrown since only forward operations are allowed
SQLException

afterLast

public void afterLast()
               throws SQLException
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.FlatFileSQLException - is always thrown since this method has not been implemented
SQLException

beforeFirst

public void beforeFirst()
                 throws SQLException
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.FlatFileSQLException - is always thrown since only forward operations are allowed
SQLException

beginGet

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


cancelRowUpdates

public void cancelRowUpdates()
                      throws SQLException
Cancels the updates made to the current row in this ResultSet object. Since updates are not allowed, this method always throws an SQLException.

Specified by:
cancelRowUpdates in interface ResultSet
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 ResultSet
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

deleteRow

public void deleteRow()
               throws SQLException
Deletes the current row from this ResultSet object and from the underlying database. Since updates are not allowed, this method always throws an SQLException.

Specified by:
deleteRow in interface ResultSet
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a byte array representation of the column value; if the value is SQL null, the value returned is null
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

findColumn

public int findColumn(String columnName)
               throws SQLException
Maps the given ResultSet column name to its ResultSet column index.

Specified by:
findColumn in interface ResultSet
Parameters:
columnName - a String specifying the name of the column
Returns:
an int specifying the column index of the given column name
Throws:
AbstractFlatFile.FlatFileSQLException - if the ResultSet object does not contain columnName or a database access error occurs
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

first

public boolean first()
              throws SQLException
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.FlatFileSQLException - is always thrown since only forward operations are allowed
SQLException

getArray

public Array getArray(int columnIndex)
               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:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Returns:
a Array object representing an SQL Array value in the specified column
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since this method is not implemented
SQLException

getArray

public Array getArray(String columnName)
               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:
columnName - a String which specifies the SQL name of the column
Returns:
an Array object representing the SQL ARRAY value in the specified column
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 will do 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 which specifies the column. The first column is 1, the second is 2, ...
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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getAsciiStream

public InputStream getAsciiStream(String columnName)
                           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 will do 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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
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:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

getBigDecimal

public BigDecimal getBigDecimal(String columnName)
                         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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getBinaryStream

public InputStream getBinaryStream(String columnName)
                            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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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.

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

getBlob

public Blob getBlob(String columnName)
             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:
columnName - a String which specifies the SQL name of the column
Returns:
a Blob object representing the SQL BLOB value in the specified column
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a boolean representation of the column value; if the value is SQL NULL, the value returned is false
Throws:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

getBoolean

public boolean getBoolean(String columnName)
                   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:
columnName - a String which specifies the SQL name of the column
Returns:
a boolean representation of the column value; if the value is SQL NULL, the value returned is false
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a byte representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

getByte

public byte getByte(String columnName)
             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:
columnName - a String which specifies the SQL name of the column
Returns:
a byte representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a byte array representation of the column value; if the value is SQL NULL, the value returned is null
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getBytes

public byte[] getBytes(String columnName)
                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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getCharacterStream

public Reader getCharacterStream(String columnName)
                          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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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.

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

getClob

public Clob getClob(String columnName)
             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:
columnName - a String which specifies the SQL name of the column
Returns:
a Clob object representing the SQL CLOB value in the specified column
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a Class object used to specify the class of the data in the column
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException
See Also:
setColumnClass(int,Class)

getColumnCount

public abstract int getColumnCount()
                            throws SQLException
Returns the number of columns in this ResultSet object.

Returns:
an int which specifies the number of columns
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getConcurrency

public int getConcurrency()
                   throws SQLException
Returns the concurrency mode of this ResultSet object.

Specified by:
getConcurrency in interface ResultSet
Returns:
an int which specifies whether concurrency is read only or for update processes as well. Always returns CONCUR_READ_ONLY.
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getCursorName

public String getCursorName()
                     throws SQLException
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 which specifies the SQL name for this ResultSet object's cursor.
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a java.sql.Date representation of the column value; if the value is SQL NULL, the value returned is null
Throws:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getDate

public Date getDate(String columnName)
             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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getDate

public Date getDate(String columnName,
                    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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a double representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

getDouble

public double getDouble(String columnName)
                 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:
columnName - a String which specifies the SQL name of the column
Returns:
a double representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getFetchDirection

public int getFetchDirection()
                      throws SQLException
Returns the fetch direction for this ResultSet object.

Specified by:
getFetchDirection in interface ResultSet
Returns:
an int which specifies the current fetch direction for this ResultSet object. Always returns FETCH_FORWARD.
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getFetchSize

public int getFetchSize()
                 throws SQLException
Returns the fetch size for this ResultSet object.

Specified by:
getFetchSize in interface ResultSet
Returns:
an int which specifies the current fetch size for this ResultSet object
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a float representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

getFloat

public float getFloat(String columnName)
               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:
columnName - a String which specifies the SQL name of the column
Returns:
a float representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
an int representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

getInt

public int getInt(String columnName)
           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:
columnName - a String which specifies the SQL name of the column
Returns:
a int representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a long representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

getLong

public long getLong(String columnName)
             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:
columnName - a String which specifies the SQL name of the column
Returns:
a long representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 will return the value of the given column as a Java object. The type of the Java object will be 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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a java.lang.Object representation of the column value
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getObject

public Object getObject(int columnIndex,
                        Map map)
                 throws SQLException
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 which specifies the column. The first column is 1, the second is 2, ...
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.FlatFileSQLException - is always thrown since this method has not been implimented
SQLException

getObject

public Object getObject(String columnName)
                 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 will return the value of the given column as a Java object. The type of the Java object will be 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:
columnName - a String which specifies the SQL name of the column
Returns:
a java.lang.Object representation of the column value
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getObject

public Object getObject(String columnName,
                        Map map)
                 throws SQLException
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:
columnName - a String which specifies the SQL 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.FlatFileSQLException - is always thrown since this method is not implemented
SQLException

getRef

public Ref getRef(int columnIndex)
           throws SQLException
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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a Ref object representing the SQL REF value in the specified column
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since this method has not been implimented
SQLException

getRef

public Ref getRef(String columnName)
           throws SQLException
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:
columnName - a String which specifies the SQL name of the column
Returns:
a Ref object representing the SQL REF value in the specified column
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since this method is not implemented
SQLException

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 which specifies the current row number; 0 if there is no current row
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a short representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

getShort

public short getShort(String columnName)
               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:
columnName - a String which specifies the SQL name of the column
Returns:
a short representation of the column value; if the value is SQL NULL, the value returned is 0
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getStatement

public Statement getStatement()
                       throws SQLException
Returns the Statement object that produced this ResultSet object. Since there is not statement, this method always throws an 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:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a String representation of the column value; if the value is SQL NULL, the value returned is null
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getString

public String getString(String columnName)
                 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:
columnName - a String which specifies the SQL name of the column
Returns:
a String representation of the column value; if the value is SQL NULL, the value returned is null
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a java.sql.Time representation of the column value; if the value is SQL NULL, the value returned is null
Throws:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getTime

public Time getTime(String columnName)
             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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getTime

public Time getTime(String columnName,
                    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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
Returns:
a java.sql.Timestamp representation of the column value; if the value is SQL NULL, the value returned is null
Throws:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getTimestamp

public Timestamp getTimestamp(String columnName)
                       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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getTimestamp

public Timestamp getTimestamp(String columnName,
                              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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getType

public int getType()
            throws SQLException
Returns the type of this ResultSet object. The type is determined by the Statement object hat created the result set.

Specified by:
getType in interface ResultSet
Returns:
an int which specifies the type of this ResultSet object. Always returns TYPE_FORWARD_ONLY.
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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 which specifies the column. The first column is 1, the second is 2, ...
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:
AbstractFlatFile.FlatFileSQLException - if a conversion or database access error occurs
SQLException

getURL

public URL getURL(String columnName)
           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:
columnName - a String which specifies the SQL 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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

getWarnings

public SQLWarning getWarnings()
                       throws SQLException
Returns the first warning reported by calls on this ResultSet object. Subsequent warnings on this ResultSet object will be 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) will be chained on the Statement object.

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

insertRow

public void insertRow()
               throws SQLException
Inserts the contents of the insert row into this ResultSet object and into the database. Since updates are not allowed, this method always throws an SQLException.

Specified by:
insertRow in interface ResultSet
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

last

public boolean last()
             throws SQLException
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.FlatFileSQLException - is always thrown since this method has not been implemented
SQLException

moveToCurrentRow

public void moveToCurrentRow()
                      throws SQLException
Moves the cursor to the remembered cursor position, usually the current row. Since updates are not allowed, this method always throws an SQLException.

Specified by:
moveToCurrentRow in interface ResultSet
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

moveToInsertRow

public void moveToInsertRow()
                     throws SQLException
Moves the cursor to the insert row. Since updates are not allowed, this method always throws an SQLException.

Specified by:
moveToInsertRow in interface ResultSet
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

previous

public boolean previous()
                 throws SQLException
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.FlatFileSQLException - is always thrown since only forward operations are allowed
SQLException

refreshRow

public void refreshRow()
                throws SQLException
Refreshes the current row with its most recent value in the database. Since updates are not allowed, this method always throws an SQLException.

Specified by:
refreshRow in interface ResultSet
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

relative

public boolean relative(int rows)
                 throws SQLException
Moves the cursor a relative number of rows, either positive or negative.

Specified by:
relative in interface ResultSet
Parameters:
rows - an int which 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.FlatFileSQLException - is always thrown since only forward operations are allowed
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

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:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

rowUpdated

public boolean rowUpdated()
                   throws SQLException
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.FlatFileSQLException - if a database access error occurs
SQLException

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

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:
findColumn(String), findColumnName(int)

setFetchDirection

public void setFetchDirection(int direction)
                       throws SQLException
Gives a hint as to the direction in which the rows in this ResultSet object will be processed.

Specified by:
setFetchDirection in interface ResultSet
Parameters:
direction - an int which specifies the expected direction this ResultSet object is to be processed
Throws:
AbstractFlatFile.FlatFileSQLException - if the fetch direction is not FETCH_FORWARD
SQLException
See Also:
Statement.setFetchDirection(int)

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 which specifies the number of rows to fetch
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs or the condition 0 <= rows <= this.getMaxRows() is not satisfied
SQLException

setWarning

protected void setWarning(SQLWarning warning)
Sets a SQLWarning.

Parameters:
warning - a SQLWarning that is to be added to this object.

updateArray

public void updateArray(int column,
                        Array x)
                 throws SQLException
Updates the designated column with an Array value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateArray in interface ResultSet
Parameters:
column - an int which specifies the column. The first column is 1, the second is 2, ...
x - a java.sql.Array which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateArray

public void updateArray(String columnName,
                        Array x)
                 throws SQLException
Updates the designated column with an Array value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateArray in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a java.sql.Array which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream x,
                              int length)
                       throws SQLException
Updates the designated column with an ascii stream value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateAsciiStream in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a InputStream which specifies the new column value
length - an int which specifies the stream length
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream x,
                              int length)
                       throws SQLException
Updates the designated column with an ascii stream value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateAsciiStream in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a InputStream which specifies the new column value
length - an int which specifies the stream length
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             BigDecimal x)
                      throws SQLException
Updates the designated column with a java.math.BigDecimal value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateBigDecimal in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a java.math.BigDecimal which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateBigDecimal

public void updateBigDecimal(String columnName,
                             BigDecimal x)
                      throws SQLException
Updates the designated column with a java.sql.BigDecimal value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateBigDecimal in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a java.sql.BigDecimal which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream x,
                               int length)
                        throws SQLException
Updates the designated column with a binary stream value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateBinaryStream in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a InputStream which specifies the new column value
length - an int which specifies the stream length
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream x,
                               int length)
                        throws SQLException
Updates the designated column with a binary stream value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateBinaryStream in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a InputStream which specifies the new column value
length - an int which specifies the stream length
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateBlob

public void updateBlob(int column,
                       Blob x)
                throws SQLException
Updates the designated column with an java.sql.Blob value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateBlob in interface ResultSet
Parameters:
column - an int which specifies the column. The first column is 1, the second is 2, ...
x - a java.sql.Blob which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateBlob

public void updateBlob(String columnName,
                       Blob x)
                throws SQLException
Updates the designated column with an java.sql.Blob value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateBlob in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a java.sql.Blob which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean x)
                   throws SQLException
Updates the designated column with a boolean value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateBoolean in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a boolean which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateBoolean

public void updateBoolean(String columnName,
                          boolean x)
                   throws SQLException
Updates the designated column with a boolean value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateBoolean in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a boolean which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateByte

public void updateByte(int columnIndex,
                       byte x)
                throws SQLException
Updates the designated column with a byte value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateByte in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a byte which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateByte

public void updateByte(String columnName,
                       byte x)
                throws SQLException
Updates the designated column with a byte value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateByte in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a byte which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

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 an SQLException.

Specified by:
updateBytes in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a byte which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateBytes

public void updateBytes(String columnName,
                        byte[] x)
                 throws SQLException
Updates the designated column with a byte value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateBytes in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a byte which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader x,
                                  int length)
                           throws SQLException
Updates the designated column with a character stream value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateCharacterStream in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a Reader which specifies the new column value
length - an int which specifies the stream length
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader reader,
                                  int length)
                           throws SQLException
Updates the designated column with a character stream value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateCharacterStream in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
reader - a Reader which specifies the new column value
length - an int which specifies the stream length
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateClob

public void updateClob(int column,
                       Clob x)
                throws SQLException
Updates the designated column with an java.sql.Clob value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateClob in interface ResultSet
Parameters:
column - an int which specifies the column. The first column is 1, the second is 2, ...
x - a java.sql.Clob which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateClob

public void updateClob(String columnName,
                       Clob x)
                throws SQLException
Updates the designated column with an java.sql.Clob value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateClob in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a java.sql.Clob which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateDate

public void updateDate(int columnIndex,
                       Date x)
                throws SQLException
Updates the designated column with a java.sql.Date value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateDate in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a java.sql.Date which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateDate

public void updateDate(String columnName,
                       Date x)
                throws SQLException
Updates the designated column with a java.sql.Date value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateDate in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a java.sql.Date which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateDouble

public void updateDouble(int columnIndex,
                         double x)
                  throws SQLException
Updates the designated column with a double value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateDouble in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a double which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateDouble

public void updateDouble(String columnName,
                         double x)
                  throws SQLException
Updates the designated column with a double value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateDouble in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a double which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateFloat

public void updateFloat(int columnIndex,
                        float x)
                 throws SQLException
Updates the designated column with a float value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateFloat in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a float which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateFloat

public void updateFloat(String columnName,
                        float x)
                 throws SQLException
Updates the designated column with a float value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateFloat in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a float which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateInt

public void updateInt(int columnIndex,
                      int x)
               throws SQLException
Updates the designated column with an int value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateInt in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - an int which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateInt

public void updateInt(String columnName,
                      int x)
               throws SQLException
Updates the designated column with an int value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateInt in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - an int which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateLong

public void updateLong(int columnIndex,
                       long x)
                throws SQLException
Updates the designated column with a long value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateLong in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a long which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateLong

public void updateLong(String columnName,
                       long x)
                throws SQLException
Updates the designated column with a long value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateLong in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a long which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateNull

public void updateNull(int columnIndex)
                throws SQLException
Gives a nullable column a null value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateNull in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateNull

public void updateNull(String columnName)
                throws SQLException
Updates the designated column with a null value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateNull in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateObject

public void updateObject(int columnIndex,
                         Object x)
                  throws SQLException
Updates the designated column with an Object value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateObject in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - an Object which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateObject

public void updateObject(int columnIndex,
                         Object x,
                         int scale)
                  throws SQLException
Updates the designated column with an Object value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateObject in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - an Object which 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 will be ignored.
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateObject

public void updateObject(String columnName,
                         Object x)
                  throws SQLException
Updates the designated column with an Object value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateObject in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a java.sql.Object which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateObject

public void updateObject(String columnName,
                         Object x,
                         int scale)
                  throws SQLException
Updates the designated column with an Object value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateObject in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - an Object which 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 will be ignored.
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateRef

public void updateRef(int column,
                      Ref x)
               throws SQLException
Updates the designated column with an java.sql.Ref value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateRef in interface ResultSet
Parameters:
column - an int which specifies the column. The first column is 1, the second is 2, ...
x - a java.sql.Ref which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateRef

public void updateRef(String columnName,
                      Ref x)
               throws SQLException
Updates the designated column with an java.sql.Ref value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateRef in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a java.sql.Ref which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateRow

public void updateRow()
               throws SQLException
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 an SQLException.

Specified by:
updateRow in interface ResultSet
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateShort

public void updateShort(int columnIndex,
                        short x)
                 throws SQLException
Updates the designated column with a short value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateShort in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a short which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateShort

public void updateShort(String columnName,
                        short x)
                 throws SQLException
Updates the designated column with a short value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateShort in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a short which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateString

public void updateString(int columnIndex,
                         String x)
                  throws SQLException
Updates the designated column with a String value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateString in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a String which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateString

public void updateString(String columnName,
                         String x)
                  throws SQLException
Updates the designated column with a String value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateString in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a String which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateTime

public void updateTime(int columnIndex,
                       Time x)
                throws SQLException
Updates the designated column with a java.sql.Time value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateTime in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a java.sql.Time which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateTime

public void updateTime(String columnName,
                       Time x)
                throws SQLException
Updates the designated column with a java.sql.Time value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateTime in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a java.sql.Time which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateTimestamp

public void updateTimestamp(int columnIndex,
                            Timestamp x)
                     throws SQLException
Updates the designated column with a java.sql.Timestamp value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateTimestamp in interface ResultSet
Parameters:
columnIndex - an int which specifies the column. The first column is 1, the second is 2, ...
x - a java.sql.Timestamp which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

updateTimestamp

public void updateTimestamp(String columnName,
                            Timestamp x)
                     throws SQLException
Updates the designated column with a java.sql.Timestamp value. Since updates are not allowed, this method always throws an SQLException.

Specified by:
updateTimestamp in interface ResultSet
Parameters:
columnName - a String which specifies the SQL name of the column
x - a java.sql.Timestamp which specifies the new column value
Throws:
AbstractFlatFile.FlatFileSQLException - is always thrown since updates are not allowed
SQLException

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 and false otherwise
Throws:
AbstractFlatFile.FlatFileSQLException - if a database access error occurs
SQLException

JMSLTM Numerical Library 6.1

Copyright © 1970-2010 Visual Numerics, Inc.
Built July 30 2010.