com.wrq.apptrieve.jdbc
Class ApptrieveResultSet

java.lang.Object
  extended by com.wrq.apptrieve.jdbc.ApptrieveResultSet
All Implemented Interfaces:
java.sql.ResultSet, java.sql.Wrapper

public class ApptrieveResultSet
extends java.lang.Object
implements java.sql.ResultSet

This class implements the JDBC specification for the ResultSet interface. The class is designed to hold the results of database queries.


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
 
Method Summary
 boolean absolute(int row)
          Moves the cursor to an absolute position.
 void afterLast()
          Moves the cursor to the end of the result set, just after the last row.
 void beforeFirst()
          Moves the cursor to the front of the result set, just before the first row.
 void cancelRowUpdates()
          This method is not supported by the Host Integrator driver.
 void clearWarnings()
          This method is not supported by the Host Integrator driver.
 void close()
          Closes a result set.
 void deleteRow()
          This method is not supported by the Host Integrator driver.
 int findColumn(java.lang.String name)
          Returns the column number for a given column name name.
 boolean first()
          Moves the cursor to the first row in the result set.
 java.sql.Array getArray(int columnIndex)
          This method is not supported by the Host Integrator driver.
 java.sql.Array getArray(java.lang.String columnName)
          This method is not supported by the Host Integrator driver.
 java.io.InputStream getAsciiStream(int columnIndex)
          Gets the value for an indexed column as an ASCII stream.
 java.io.InputStream getAsciiStream(java.lang.String columnName)
          Gets the value for a named column as an ASCII stream.
 java.math.BigDecimal getBigDecimal(int columnIndex)
          Gets the value of a column in the current row as a java.math.BigDecimal object with full precision
 java.math.BigDecimal getBigDecimal(int columnIndex, int scale)
          Deprecated. use getBigDecimal(String columnIndex)
 java.math.BigDecimal getBigDecimal(java.lang.String columnName)
          Gets the value of a column in the current row as a java.math.BigDecimal object with full precision
 java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale)
          Deprecated. use getBigDecimal(String columnName)
 java.io.InputStream getBinaryStream(int columnIndex)
          Gets the value for an indexed column as a stream of uninterpreted bytes.
 java.io.InputStream getBinaryStream(java.lang.String columnName)
          Gets the value for a named column as a stream of uninterpreted bytes.
 java.sql.Blob getBlob(int columnIndex)
          This method is not supported by the Host Integrator driver.
 java.sql.Blob getBlob(java.lang.String columnName)
          This method is not supported by the Host Integrator driver.
 boolean getBoolean(int columnIndex)
          Retrieves an indexed column as a boolean value.
 boolean getBoolean(java.lang.String columnName)
          Retrieves a named column as a boolean value.
 byte getByte(int columnIndex)
          Retrieves an indexed column as a byte.
 byte getByte(java.lang.String columnName)
          Retrieves a named column as a byte.
 byte[] getBytes(int columnIndex)
          Retrieves an indexed column as a byte array.
 byte[] getBytes(java.lang.String columnName)
          Retrieves a named column as a byte array.
 java.io.Reader getCharacterStream(int columnIndex)
          Retrieves an indexed column as a character stream.
 java.io.Reader getCharacterStream(java.lang.String columnName)
          Retrieves a named column as a character stream.
 java.sql.Clob getClob(int columnIndex)
          This method is not supported by the Host Integrator driver.
 java.sql.Clob getClob(java.lang.String columnName)
          This method is not supported by the Host Integrator driver.
 int getConcurrency()
          Gets the concurrency type for this ResultSet object.
 java.lang.String getCursorName()
          This method is not supported by the Host Integrator driver.
 java.sql.Date getDate(int columnIndex)
          This method is not supported by the Host Integrator driver.
 java.sql.Date getDate(int columnIndex, java.util.Calendar cal)
          This method is not supported by the Host Integrator driver.
 java.sql.Date getDate(java.lang.String columnName)
          This method is not supported by the Host Integrator driver.
 java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal)
          This method is not supported by the Host Integrator driver.
 double getDouble(int columnIndex)
          Retrieves an indexed column as a double.
 double getDouble(java.lang.String columnName)
          Retrieves a named column as a double.
 int getFetchDirection()
          Gets the fetch direction for this ResultSet object.
 int getFetchSize()
          This method is not supported by the Host Integrator driver.
 float getFloat(int columnIndex)
          Retrieves an indexed column as a float.
 float getFloat(java.lang.String columnName)
          Retrieves a named column as a float.
 int getHoldability()
           
 int getInt(int columnIndex)
          Retrieves an indexed column as an int.
 int getInt(java.lang.String columnName)
          Retrieves a named column as an int.
 long getLong(int column)
          Retrieves an indexed column as a long.
 long getLong(java.lang.String columnName)
          Retrieves a named column as a long.
 java.sql.ResultSetMetaData getMetaData()
          Returns meta-deta on a ResultSet.
 java.io.Reader getNCharacterStream(int columnIndex)
           
 java.io.Reader getNCharacterStream(java.lang.String columnLabel)
           
 java.sql.NClob getNClob(int columnIndex)
           
 java.sql.NClob getNClob(java.lang.String columnLabel)
           
 java.lang.String getNString(int columnIndex)
           
 java.lang.String getNString(java.lang.String columnLabel)
           
 java.lang.Object getObject(int columnIndex)
          Retrieves an indexed column as an Object.
 java.lang.Object getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map)
          This method is not supported by the Host Integrator driver.
 java.lang.Object getObject(java.lang.String columnName)
          Retrieves a named column as an Object.
 java.lang.Object getObject(java.lang.String columnName, java.util.Map<java.lang.String,java.lang.Class<?>> map)
          This method is not supported by the Host Integrator driver.
 java.sql.Ref getRef(int columnIndex)
          This method is not supported by the Host Integrator driver.
 java.sql.Ref getRef(java.lang.String colName)
          This method is not supported by the Host Integrator driver.
 int getRow()
          Retrieves the current row number of this ResultSet object.
 int getRowCount()
          Gets the number of rows in this ResultSet object.
 java.sql.RowId getRowId(int columnIndex)
           
 java.sql.RowId getRowId(java.lang.String columnLabel)
           
 short getShort(int columnIndex)
          Retrieves an indexed column as a short.
 short getShort(java.lang.String columnName)
          Retrieves a named column as a short.
 java.sql.SQLXML getSQLXML(int columnIndex)
           
 java.sql.SQLXML getSQLXML(java.lang.String columnLabel)
           
 java.sql.Statement getStatement()
          Retrieves the Statement object that produced this ResultSet object.
 java.lang.String getString(int columnIndex)
          Retrieves an indexed column as a String object.
 java.lang.String getString(java.lang.String columnName)
          Retrieves a named column as a String object.
 java.sql.Time getTime(int columnIndex)
          This method is not supported by the Host Integrator driver.
 java.sql.Time getTime(int columnIndex, java.util.Calendar cal)
          This method is not supported by the Host Integrator driver.
 java.sql.Time getTime(java.lang.String columnName)
          This method is not supported by the Host Integrator driver.
 java.sql.Time getTime(java.lang.String columnName, java.util.Calendar cal)
          This method is not supported by the Host Integrator driver.
 java.sql.Timestamp getTimestamp(int columnIndex)
          This method is not supported by the Host Integrator driver.
 java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal)
          This method is not supported by the Host Integrator driver.
 java.sql.Timestamp getTimestamp(java.lang.String columnName)
          This method is not supported by the Host Integrator driver.
 java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal)
          This method is not supported by the Host Integrator driver.
 int getType()
          Obtains the type of this ResultSet object.
 java.io.InputStream getUnicodeStream(int columnIndex)
          Deprecated. - use getCharacterStream instead
 java.io.InputStream getUnicodeStream(java.lang.String columnName)
          Deprecated. - use getCharacterStream instead
 java.net.URL getURL(int columnIndex)
          This method is not supported by the Host Integrator driver.
 java.net.URL getURL(java.lang.String columnName)
          This method is not supported by the Host Integrator driver.
 java.lang.Object getValueAt(int aRow, int aColumn)
          Retrieves the value at a particular row, column.
 java.sql.SQLWarning getWarnings()
          This method is not supported by the Host Integrator driver.
 void insertRow()
          Inserts a row into the ResultSet object The Host Integrator driver does this method.
 boolean isAfterLast()
          Discovers whether the cursor is after the last row in the result set.
 boolean isBeforeFirst()
          Discovers whether the cursor is before the first row in the result set
 boolean isClosed()
           
 boolean isFirst()
          Discovers whether the cursor is on the first row of the result set.
 boolean isLast()
          Discovers whether the cursor is on the last row of the result set Returns false when the result set contains no rows.
 boolean isWrapperFor(java.lang.Class<?> iface)
           
 boolean last()
          Moves the cursor to the last row in the result set.
 void moveToCurrentRow()
          Moves the cursor to the remembered cursor position in this ResultSet object.
 void moveToInsertRow()
          Moves the cursor to the insert row for this ResultSet object.
 boolean next()
          Moves the current cursor to the next row, returning true if there is another row for processing.
 boolean previous()
          Moves the current cursor to the previous row, returning true if there is another row for processing.
 void refreshRow()
          Replaces the values in the current row of this ResultSet object with their current values in the database.
 boolean relative(int rows)
          Moves the current cursor relative to the current row, returning true if the new row is a valid row.
 boolean rowDeleted()
          Discovers whether the current row in this ResultSet has been deleted.
 boolean rowInserted()
          Discovers whether the current row in this ResultSet has been inserted.
 boolean rowUpdated()
          Discovers whether the current row in this ResultSet has been updated.
 void setFetchDirection(int direction)
          Sets the fetch direction for this ResultSet object.
 void setFetchSize(int rows)
          This method is not supported by the Host Integrator driver.
 java.lang.String toString()
          Converts the ResultSet to a String object
<T> T
unwrap(java.lang.Class<T> iface)
           
 void updateArray(int columnIndex, java.sql.Array x)
          This method is not supported by the Host Integrator driver.
 void updateArray(java.lang.String columnName, java.sql.Array x)
          This method is not supported by the Host Integrator driver.
 void updateAsciiStream(int columnIndex, java.io.InputStream x)
           
 void updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
          Updates an indexed column with a java.io.InputStream object.
 void updateAsciiStream(int columnIndex, java.io.InputStream x, long length)
           
 void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)
           
 void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)
          Updates a named column with a java.io.InputStream object.
 void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length)
           
 void updateBigDecimal(int columnIndex, java.math.BigDecimal x)
          Updates an indexed column with a BigDecimal object.
 void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)
          Updates a named column with a BigDecimal object.
 void updateBinaryStream(int columnIndex, java.io.InputStream x)
           
 void updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
          Updates an indexed column with a java.io.InputStream object.
 void updateBinaryStream(int columnIndex, java.io.InputStream x, long length)
           
 void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)
           
 void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)
          Updates a named column with a java.io.InputStream object.
 void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length)
           
 void updateBlob(int columnIndex, java.sql.Blob x)
          This method is not supported by the Host Integrator driver.
 void updateBlob(int columnIndex, java.io.InputStream inputStream)
           
 void updateBlob(int columnIndex, java.io.InputStream inputStream, long length)
           
 void updateBlob(java.lang.String columnName, java.sql.Blob x)
          This method is not supported by the Host Integrator driver.
 void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream)
           
 void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)
           
 void updateBoolean(int columnIndex, boolean x)
          Updates an indexed column with a boolean value.
 void updateBoolean(java.lang.String columnName, boolean x)
          Updates a named column with a boolean value.
 void updateByte(int columnIndex, byte x)
          Updates an indexed column with a byte value.
 void updateByte(java.lang.String columnName, byte x)
          Updates a named column with a byte value.
 void updateBytes(int columnIndex, byte[] x)
          Updates an indexed column with a byte array.
 void updateBytes(java.lang.String columnName, byte[] x)
          Updates a named column with a byte array.
 void updateCharacterStream(int columnIndex, java.io.Reader x)
           
 void updateCharacterStream(int columnIndex, java.io.Reader x, int length)
          Updates an indexed column with a Reader object.
 void updateCharacterStream(int columnIndex, java.io.Reader x, long length)
           
 void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
           
 void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length)
          Updates a named column with a Reader object.
 void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
           
 void updateClob(int columnIndex, java.sql.Clob x)
          This method is not supported by the Host Integrator driver.
 void updateClob(int columnIndex, java.io.Reader reader)
           
 void updateClob(int columnIndex, java.io.Reader reader, long length)
           
 void updateClob(java.lang.String columnName, java.sql.Clob x)
          This method is not supported by the Host Integrator driver.
 void updateClob(java.lang.String columnLabel, java.io.Reader reader)
           
 void updateClob(java.lang.String columnLabel, java.io.Reader reader, long length)
           
 void updateDate(int columnIndex, java.sql.Date x)
          Updates an indexed column with a Date object.
 void updateDate(java.lang.String columnName, java.sql.Date x)
          Updates a named column with a Date object.
 void updateDouble(int columnIndex, double x)
          Updates an indexed column with a double value.
 void updateDouble(java.lang.String columnName, double x)
          Updates a named column with a double value.
 void updateFloat(int columnIndex, float x)
          Updates an indexed column with a float value.
 void updateFloat(java.lang.String columnName, float x)
          Updates a named column with a float value.
 void updateInt(int columnIndex, int x)
          Updates an indexed column with an int value.
 void updateInt(java.lang.String columnName, int x)
          Updates a named column with an int value.
 void updateLong(int columnIndex, long x)
          Updates an indexed column with a long value.
 void updateLong(java.lang.String columnName, long x)
          Updates a named column with a long value.
 void updateNCharacterStream(int columnIndex, java.io.Reader x)
           
 void updateNCharacterStream(int columnIndex, java.io.Reader x, long length)
           
 void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
           
 void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
           
 void updateNClob(int columnIndex, java.sql.NClob nClob)
           
 void updateNClob(int columnIndex, java.io.Reader reader)
           
 void updateNClob(int columnIndex, java.io.Reader reader, long length)
           
 void updateNClob(java.lang.String columnLabel, java.sql.NClob nClob)
           
 void updateNClob(java.lang.String columnLabel, java.io.Reader reader)
           
 void updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)
           
 void updateNString(int columnIndex, java.lang.String nString)
           
 void updateNString(java.lang.String columnLabel, java.lang.String nString)
           
 void updateNull(int columnIndex)
          Updates an indexed column with a null.
 void updateNull(java.lang.String columnName)
          Updates a named column with a null.
 void updateObject(int columnIndex, java.lang.Object x)
          Updates an indexed column with an Object value.
 void updateObject(int columnIndex, java.lang.Object x, int scale)
          Updates an indexed column with a Object value.
 void updateObject(java.lang.String columnName, java.lang.Object x)
          Updates a named column with an Object value.
 void updateObject(java.lang.String columnName, java.lang.Object x, int scale)
          Updates a named column with an Object value.
 void updateRef(int columnIndex, java.sql.Ref x)
          This method is not supported by the Host Integrator driver.
 void updateRef(java.lang.String columnName, java.sql.Ref x)
          This method is not supported by the Host Integrator driver.
 void updateRow()
          Updates the current row in this ResultSet object.
 void updateRowId(int columnIndex, java.sql.RowId x)
           
 void updateRowId(java.lang.String columnLabel, java.sql.RowId x)
           
 void updateShort(int columnIndex, short x)
          Updates an indexed column with a short value.
 void updateShort(java.lang.String columnName, short x)
          Updates a named column with a short value.
 void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject)
           
 void updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject)
           
 void updateString(int columnIndex, java.lang.String x)
          Updates an indexed column with a java.lang.String object.
 void updateString(java.lang.String columnName, java.lang.String x)
          Updates a named column with a java.lang.String object.
 void updateTime(int columnIndex, java.sql.Time x)
          Updates an indexed column with a Time object.
 void updateTime(java.lang.String columnName, java.sql.Time x)
          Updates a named column with a Time object.
 void updateTimestamp(int columnIndex, java.sql.Timestamp x)
          Updates an indexed column with a Timestamp object.
 void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x)
          Updates a named column with a java.io.InputStream object.
 boolean wasNull()
          Determines whether the last value read was null.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Method Detail

absolute

public boolean absolute(int row)
                 throws java.sql.SQLException
Moves the cursor to an absolute position.

Specified by:
absolute in interface java.sql.ResultSet
Parameters:
row - int - the new row position for the cursor
Returns:
boolean - true if the cursor is moved to a position
Throws:
java.sql.SQLException - - thrown if row is 0
See Also:
ResultSet.absolute(int)

afterLast

public void afterLast()
               throws java.sql.SQLException
Moves the cursor to the end of the result set, just after the last row. Has no effect if the result set contains no rows.

Specified by:
afterLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.afterLast()

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException
Moves the cursor to the front of the result set, just before the first row. Has no effect if the result set contains no rows.

Specified by:
beforeFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.beforeFirst()

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
cancelRowUpdates in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.cancelRowUpdates()

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
clearWarnings in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.clearWarnings()

close

public void close()
           throws java.sql.SQLException
Closes a result set.

Specified by:
close in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.close()

deleteRow

public void deleteRow()
               throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
deleteRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.deleteRow()

findColumn

public int findColumn(java.lang.String name)
               throws java.sql.SQLException
Returns the column number for a given column name name. Column name to number mappings are kept inside a Hashtable. Applications that do not need the overhead of this calculation are not penalized since the mapping only occurs on the first attempt to access a column number by name.

Specified by:
findColumn in interface java.sql.ResultSet
Parameters:
name - java.lang.String - the name of the column desired
Returns:
int - the column number, 1 being the first column
Throws:
java.sql.SQLException - thrown if a bad name is passed
See Also:
ResultSet.findColumn(java.lang.String)

first

public boolean first()
              throws java.sql.SQLException
Moves the cursor to the first row in the result set.

Specified by:
first in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.first()

getArray

public java.sql.Array getArray(java.lang.String columnName)
                        throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getArray(int)

getArray

public java.sql.Array getArray(int columnIndex)
                        throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getArray(int)

getAsciiStream

public java.io.InputStream getAsciiStream(int columnIndex)
                                   throws java.sql.SQLException
Gets the value for an indexed column as an ASCII stream. A column value can be retrieved as a stream of ASCII characters and then 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 get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.

Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
columnIndex - int - the first column is 1, the second is 2, ...
Returns:
java.io.Stream - delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null.
Throws:
java.sql.SQLException - if a database-access error occurs.
See Also:
ResultSet.getAsciiStream(int)

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String columnName)
                                   throws java.sql.SQLException
Gets the value for a named column as an ASCII stream. Very large ascii values in a LONGVARCHAR column can be read in small chunks from a java.io.InputStream.

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 get method implicitly closes the stream.

Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - name of the column
Returns:
java.io.String - the java input stream that contains the ascii value
Throws:
java.sql.SQLException
See Also:
ResultSet.getAsciiStream(int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex,
                                          int scale)
                                   throws java.sql.SQLException
Deprecated. use getBigDecimal(String columnIndex)

Gets the value of an indexed column in the current row as a java.math.BigDecimal object with a specified number of digits of precision.

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnIndex - int - index of the column
scale - int - the number of digits to the right of the decimal
Returns:
BigDecimal - the value of the column
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(int, int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                          int scale)
                                   throws java.sql.SQLException
Deprecated. use getBigDecimal(String columnName)

Gets the value of a named column in the current row as a java.math.BigDecimal object with a specified number of digits of precision.

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnName - int - index of the column
scale - int - the number of digits to the right of the decimal
Returns:
BigDecimal - the value of the column
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(int, int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex)
                                   throws java.sql.SQLException
Gets the value of a column in the current row as a java.math.BigDecimal object with full precision

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get. The first column is 1, the second is 2, ...
Returns:
BigDecimal - the column value (full precision); if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(int, int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName)
                                   throws java.sql.SQLException
Gets the value of a column in the current row as a java.math.BigDecimal object with full precision

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - the name of the column to get.
Returns:
BigDecimal - the column value (full precision); if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException

getBinaryStream

public java.io.InputStream getBinaryStream(int columnIndex)
                                    throws java.sql.SQLException
Gets the value for an indexed column as a stream of uninterpreted bytes. A column value can be retrieved as a stream of uninterpreted bytes and then 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 get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.

Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get. The first column is 1, the second is 2, ...
Returns:
java.io.InputStream - delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL then the result is null.
Throws:
java.sql.SQLException - if a database-access error occurs.
See Also:
ResultSet.getBinaryStream(int)

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String columnName)
                                    throws java.sql.SQLException
Gets the value for a named column as a stream of uninterpreted bytes. Very large binary values in a LONGVARBINARY column can be read in small chunks from a java.io.InputStream.

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 get method implicitly closes the stream.

Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - name of the column to get
Returns:
java.io.InputStream - the java input stream which contains the binary value
Throws:
java.sql.SQLException
See Also:
ResultSet.getBinaryStream(int)

getBlob

public java.sql.Blob getBlob(java.lang.String columnName)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getArray(int)

getBlob

public java.sql.Blob getBlob(int columnIndex)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getArray(int)

getBoolean

public boolean getBoolean(int columnIndex)
                   throws java.sql.SQLException
Retrieves an indexed column as a boolean value.

Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get
Returns:
boolean - true if the column is equal, ignoring case, to the string "true".
Throws:
java.sql.SQLException
See Also:
ResultSet.getBoolean(int)

getBoolean

public boolean getBoolean(java.lang.String columnName)
                   throws java.sql.SQLException
Retrieves a named column as a boolean value.

Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - the name of the column to get
Returns:
boolean - true if the column is equal, ignoring case, to the string "true".
Throws:
java.sql.SQLException
See Also:
ResultSet.getBoolean(int)

getByte

public byte getByte(int columnIndex)
             throws java.sql.SQLException
Retrieves an indexed column as a byte.

Specified by:
getByte in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get. The first column is 1, the second is 2, ...
Returns:
byte - the column value; if the value is SQL NULL the result is 0
Throws:
java.sql.SQLException
See Also:
ResultSet.getByte(int)

getByte

public byte getByte(java.lang.String columnName)
             throws java.sql.SQLException
Retrieves a named column as a byte.

Specified by:
getByte in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - the name of the column to get.
Returns:
byte - the column value; if the value is SQL NULL the result is 0
Throws:
java.sql.SQLException
See Also:
ResultSet.getByte(int)

getBytes

public byte[] getBytes(int columnIndex)
                throws java.sql.SQLException
Retrieves an indexed column as a byte array.

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get
Returns:
byte[] - a byte array that is the value of the column. If the value is SQL NULL, the result is null
Throws:
java.sql.SQLException
See Also:
ResultSet.getBytes(int)

getBytes

public byte[] getBytes(java.lang.String columnName)
                throws java.sql.SQLException
Retrieves a named column as a byte array. The bytes represent the raw values returned by the driver.

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - name of the column to get
Returns:
byte[] - a byte array that is the value of the column. If the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.
See Also:
ResultSet.getBytes(int)

getCharacterStream

public java.io.Reader getCharacterStream(int columnIndex)
                                  throws java.sql.SQLException
Retrieves an indexed column as a character stream.

Specified by:
getCharacterStream in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get
Returns:
Reader - a character stream that is the value of the column. If the value is SQL NULL, the result is null
Throws:
java.sql.SQLException
See Also:
ResultSet.getCharacterStream(int)

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String columnName)
                                  throws java.sql.SQLException
Retrieves a named column as a character stream.

Specified by:
getCharacterStream in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - name of the column to get
Returns:
Reader - a character stream that is the value of the column. If the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.
See Also:
ResultSet.getCharacterStream(int)

getClob

public java.sql.Clob getClob(java.lang.String columnName)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getArray(int)

getClob

public java.sql.Clob getClob(int columnIndex)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getArray(int)

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException
Gets the concurrency type for this ResultSet object.

Specified by:
getConcurrency in interface java.sql.ResultSet
Returns:
int - the type of concurrency - always ResultSet.CONCUR_READ_ONLY
Throws:
java.sql.SQLException
See Also:
ResultSet.getConcurrency()

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getCursorName in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getCursorName()

getDate

public java.sql.Date getDate(int columnIndex)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getDate(int)

getDate

public java.sql.Date getDate(java.lang.String columnName)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getDate(int)

getDate

public java.sql.Date getDate(int columnIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getDate(int)

getDate

public java.sql.Date getDate(java.lang.String columnName,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getDate(int)

getDouble

public double getDouble(int columnIndex)
                 throws java.sql.SQLException
Retrieves an indexed column as a double.

Specified by:
getDouble in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get
Returns:
double - the column value as a double
Throws:
java.sql.SQLException
See Also:
ResultSet.getDouble(int)

getDouble

public double getDouble(java.lang.String columnName)
                 throws java.sql.SQLException
Retrieves a named column as a double.

Specified by:
getDouble in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - the name of the column to get
Returns:
double - the column value as a double
Throws:
java.sql.SQLException
See Also:
ResultSet.getDouble(int)

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException
Gets the fetch direction for this ResultSet object. This is intended to be a hint to the driver for improving performance. Host Integrator driver ignores this setting.

Specified by:
getFetchDirection in interface java.sql.ResultSet
Returns:
int - the current fetch direction
Throws:
java.sql.SQLException
See Also:
ResultSet.getFetchDirection()

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getFetchSize in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getFetchSize()

getFloat

public float getFloat(int columnIndex)
               throws java.sql.SQLException
Retrieves an indexed column as a float.

Specified by:
getFloat in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get
Returns:
float - the column value as a float
Throws:
java.sql.SQLException
See Also:
ResultSet.getFloat(int)

getFloat

public float getFloat(java.lang.String columnName)
               throws java.sql.SQLException
Retrieves a named column as a float.

Specified by:
getFloat in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - the name of the column to get
Returns:
float - the column value as a float
Throws:
java.sql.SQLException
See Also:
ResultSet.getFloat(int)

getInt

public int getInt(int columnIndex)
           throws java.sql.SQLException
Retrieves an indexed column as an int.

Specified by:
getInt in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get
Returns:
int - the column value as an int
Throws:
java.sql.SQLException
See Also:
ResultSet.getInt(int)

getInt

public int getInt(java.lang.String columnName)
           throws java.sql.SQLException
Retrieves a named column as an int.

Specified by:
getInt in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - the name of the column to get
Returns:
int - the column value as an int
Throws:
java.sql.SQLException
See Also:
ResultSet.getInt(int)

getLong

public long getLong(int column)
             throws java.sql.SQLException
Retrieves an indexed column as a long.

Specified by:
getLong in interface java.sql.ResultSet
Parameters:
column - int - the index of the column to get
Returns:
long - the column value as a long
Throws:
java.sql.SQLException
See Also:
ResultSet.getLong(int)

getLong

public long getLong(java.lang.String columnName)
             throws java.sql.SQLException
Retrieves a named column as a long.

Specified by:
getLong in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - the name of the column to get
Returns:
long - the column value as a long
Throws:
java.sql.SQLException
See Also:
ResultSet.getLong(int)

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException
Returns meta-deta on a ResultSet.

Specified by:
getMetaData in interface java.sql.ResultSet
Returns:
ResultSetMetaData - object containing result set info
Throws:
java.sql.SQLException - thrown on error getting meta-data
See Also:
ResultSet.getMetaData()

getObject

public java.lang.Object getObject(int columnIndex)
                           throws java.sql.SQLException
Retrieves an indexed column as an Object. An integral value is returned as its java.lang equivalent object. A LONGVARCHAR or LONGVARBINARY value is returned as a java.io.InputStream.

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get
Returns:
Object - the value of the column as an Object. Returns null if the value is null.
Throws:
java.sql.SQLException
See Also:
ResultSet.getObject(int)

getObject

public java.lang.Object getObject(java.lang.String columnName)
                           throws java.sql.SQLException
Retrieves a named column as an Object. An integral value is returned as its java.lang equivalent object. A LONGVARCHAR or LONGVARBINARY value is returned as a java.io.InputStream.

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - the name of the column to get
Returns:
Object - the value of the column as an Object. Returns null if the value is null.
Throws:
java.sql.SQLException
See Also:
ResultSet.getObject(int)

getObject

public java.lang.Object getObject(java.lang.String columnName,
                                  java.util.Map<java.lang.String,java.lang.Class<?>> map)
                           throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getObject(int)

getObject

public java.lang.Object getObject(int columnIndex,
                                  java.util.Map<java.lang.String,java.lang.Class<?>> map)
                           throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getObject(int)

getRef

public java.sql.Ref getRef(java.lang.String colName)
                    throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getRef(int)

getRef

public java.sql.Ref getRef(int columnIndex)
                    throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getRef(int)

getRow

public int getRow()
           throws java.sql.SQLException
Retrieves the current row number of this ResultSet object. The first row is number 1, the second number 2, and so on.

Specified by:
getRow in interface java.sql.ResultSet
Returns:
int - the current row number; 0 if there is no current row
Throws:
java.sql.SQLException
See Also:
ResultSet.getRow()

getRowCount

public int getRowCount()
Gets the number of rows in this ResultSet object.

Note: java.sql.Statement.executeQuery and java.sql.Statement.getResultSet return java.sql.ResultSet. You must cast it to com.wrq.apptrieve.jdbc.ApptrieveResultSet to use this method.

Returns:
int - the number of rows

getShort

public short getShort(int columnIndex)
               throws java.sql.SQLException
Retrieves an indexed column as a short.

Specified by:
getShort in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get
Returns:
short - the column value as a short
Throws:
java.sql.SQLException
See Also:
ResultSet.getShort(int)

getShort

public short getShort(java.lang.String columnName)
               throws java.sql.SQLException
Retrieves a named column as a short.

Specified by:
getShort in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - the name of the column to get
Returns:
short - the column value as a short
Throws:
java.sql.SQLException
See Also:
ResultSet.getShort(int)

getStatement

public java.sql.Statement getStatement()
                                throws java.sql.SQLException
Retrieves the Statement object that produced this ResultSet object.

Specified by:
getStatement in interface java.sql.ResultSet
Returns:
Statement - the Statement object that produced this ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getStatement()

getString

public java.lang.String getString(int columnIndex)
                           throws java.sql.SQLException
Retrieves an indexed column as a String object.

Specified by:
getString in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get
Returns:
String - the column value as a String object
Throws:
java.sql.SQLException
See Also:
ResultSet.getString(int)

getString

public java.lang.String getString(java.lang.String columnName)
                           throws java.sql.SQLException
Retrieves a named column as a String object.

Specified by:
getString in interface java.sql.ResultSet
Parameters:
columnName - int - the index of the column to get
Returns:
String - the column value as a String object
Throws:
java.sql.SQLException
See Also:
ResultSet.getString(int)

getTime

public java.sql.Time getTime(int columnIndex)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getTime(int)

getTime

public java.sql.Time getTime(java.lang.String columnName)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getTime(int)

getTime

public java.sql.Time getTime(int columnIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getTime(int)

getTime

public java.sql.Time getTime(java.lang.String columnName,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getTime(int)

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex)
                                throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getTimestamp(int)

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName)
                                throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getTimestamp(int)

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getTimestamp(int)

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getTimestamp(int)

getType

public int getType()
            throws java.sql.SQLException
Obtains the type of this ResultSet object.

Specified by:
getType in interface java.sql.ResultSet
Returns:
ResultSet.TYPE_SCROLL_INSENSITIVE. Host Integrator only supports insensitive scrollable ResultSets.
Throws:
java.sql.SQLException
See Also:
ResultSet.getType()

getUnicodeStream

public java.io.InputStream getUnicodeStream(int columnIndex)
                                     throws java.sql.SQLException
Deprecated. - use getCharacterStream instead

Gets the value for an indexed column as a UTF-8 encoded UNICODE stream.

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
columnIndex - int - the index of the column to get. The first column is 1, the second is 2, ...
Returns:
java.io.InputStream - delivers the database column value as a stream of Unicode characters. If the value is SQL NULL then the result is null.
Throws:
java.sql.SQLException - if a database-access error occurs.
See Also:
ResultSet.getUnicodeStream(int)

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String columnName)
                                     throws java.sql.SQLException
Deprecated. - use getCharacterStream instead

Gets the value for a named column as a UTF-8 encoded UNICODE stream.

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
columnName - java.lang.String - the name of the column to get.
Returns:
java.io.InputStream - delivers the database column value as a stream of Unicode characters. If the value is SQL NULL then the result is null.
Throws:
java.sql.SQLException - if a database-access error occurs.
See Also:
ResultSet.getUnicodeStream(int)

getURL

public java.net.URL getURL(int columnIndex)
                    throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getURL in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getURL(int)

getURL

public java.net.URL getURL(java.lang.String columnName)
                    throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getURL in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.getURL(String)

getValueAt

public java.lang.Object getValueAt(int aRow,
                                   int aColumn)
                            throws java.sql.SQLException
Retrieves the value at a particular row, column.

Parameters:
aRow - int
aColumn - int
Returns:
java.lang.Object
Throws:
java.sql.SQLException

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
getWarnings in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
Statement.getWarnings()

insertRow

public void insertRow()
               throws java.sql.SQLException
Inserts a row into the ResultSet object The Host Integrator driver does this method.

Specified by:
insertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown because ApptrieveResultSet objects are read-only.
See Also:
ResultSet.insertRow()

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException
Discovers whether the cursor is after the last row in the result set.

Specified by:
isAfterLast in interface java.sql.ResultSet
Returns:
boolean - true if the cursor is after the last row, false otherwise. Returns false when the result set contains no rows.
Throws:
java.sql.SQLException
See Also:
ResultSet.isAfterLast()

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException
Discovers whether the cursor is before the first row in the result set

Specified by:
isBeforeFirst in interface java.sql.ResultSet
Returns:
boolean - true if the cursor is before the first row, false otherwise. Returns false when the result set contains no rows.
Throws:
java.sql.SQLException
See Also:
ResultSet.isBeforeFirst()

isFirst

public boolean isFirst()
                throws java.sql.SQLException
Discovers whether the cursor is on the first row of the result set. Returns false when the result set contains no rows.

Specified by:
isFirst in interface java.sql.ResultSet
Returns:
boolean - true if the cursor is on the first row, false otherwise
Throws:
java.sql.SQLException
See Also:
ResultSet.isFirst()

isLast

public boolean isLast()
               throws java.sql.SQLException
Discovers whether the cursor is on the last row of the result set Returns false when the result set contains no rows.

Specified by:
isLast in interface java.sql.ResultSet
Returns:
boolean - true if the cursor is on the last row, false otherwise
Throws:
java.sql.SQLException
See Also:
ResultSet.isLast()

last

public boolean last()
             throws java.sql.SQLException
Moves the cursor to the last row in the result set.

Specified by:
last in interface java.sql.ResultSet
Returns:
boolean - true if cursor is on a valid row of the ResultSet, false otherwise
Throws:
java.sql.SQLException
See Also:
ResultSet.last()

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException
Moves the cursor to the remembered cursor position in this ResultSet object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
moveToCurrentRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.moveToCurrentRow()

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException
Moves the cursor to the insert row for this ResultSet object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
moveToInsertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.moveToInsertRow()

next

public boolean next()
             throws java.sql.SQLException
Moves the current cursor to the next row, returning true if there is another row for processing.

Specified by:
next in interface java.sql.ResultSet
Returns:
boolean - true if there are more rows to process, otherwise false
Throws:
java.sql.SQLException
See Also:
ResultSet.next()

previous

public boolean previous()
                 throws java.sql.SQLException
Moves the current cursor to the previous row, returning true if there is another row for processing.

Specified by:
previous in interface java.sql.ResultSet
Returns:
boolean - true if there are more rows to process, otherwise false
Throws:
java.sql.SQLException
See Also:
ResultSet.previous()

refreshRow

public void refreshRow()
                throws java.sql.SQLException
Replaces the values in the current row of this ResultSet object with their current values in the database. The Host Integrator driver does not support this method.

Specified by:
refreshRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since ApptrieveResultSet objects have concurrency CONCUR_READ_ONLY.
See Also:
ResultSet.refreshRow()

relative

public boolean relative(int rows)
                 throws java.sql.SQLException
Moves the current cursor relative to the current row, returning true if the new row is a valid row.

Specified by:
relative in interface java.sql.ResultSet
Returns:
boolean - true if the new row is valid, otherwise false
Throws:
java.sql.SQLException
See Also:
ResultSet.relative(int)

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException
Discovers whether the current row in this ResultSet has been deleted. The Host Integrator driver does not support this method.

Specified by:
rowDeleted in interface java.sql.ResultSet
Returns:
boolean - true if the row has been deleted
Throws:
java.sql.SQLException - - always thrown since ApptrieveResultSet objects have concurrency CONCUR_READ_ONLY.
See Also:
ResultSet.rowDeleted()

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException
Discovers whether the current row in this ResultSet has been inserted. The Host Integrator driver does not support this method.

Specified by:
rowInserted in interface java.sql.ResultSet
Returns:
boolean - true if the row has been inserted
Throws:
java.sql.SQLException - - always thrown since ApptrieveResultSet objects have concurrency CONCUR_READ_ONLY.
See Also:
ResultSet.rowInserted()

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException
Discovers whether the current row in this ResultSet has been updated. The Host Integrator driver does not support this method.

Specified by:
rowUpdated in interface java.sql.ResultSet
Returns:
boolean - true if the row has been updated
Throws:
java.sql.SQLException - - always thrown since ApptrieveResultSet objects have concurrency CONCUR_READ_ONLY.
See Also:
ResultSet.rowInserted()

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException
Sets the fetch direction for this ResultSet object. This is intended to be a hint to the driver for improving performance. Host Integrator driver ignores this setting.

Specified by:
setFetchDirection in interface java.sql.ResultSet
Parameters:
direction - int - the new fetch direction
Throws:
java.sql.SQLException
See Also:
ResultSet.setFetchDirection(int)

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
setFetchSize in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.setFetchSize(int)

toString

public java.lang.String toString()
Converts the ResultSet to a String object

Overrides:
toString in class java.lang.Object
Returns:
java.lang.String - the ResultSet as a String

updateArray

public void updateArray(int columnIndex,
                        java.sql.Array x)
                 throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
updateArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.updateArray(int, Array)

updateArray

public void updateArray(java.lang.String columnName,
                        java.sql.Array x)
                 throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
updateArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.updateArray(String, Array)

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException
Updates an indexed column with a java.io.InputStream object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateAsciiStream(int, java.io.InputStream, int)

updateAsciiStream

public void updateAsciiStream(java.lang.String columnName,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException
Updates a named column with a java.io.InputStream object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateAsciiStream(int, java.io.InputStream, int)

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException
Updates an indexed column with a BigDecimal object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateBigDecimal(int, java.math.BigDecimal)

updateBigDecimal

public void updateBigDecimal(java.lang.String columnName,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException
Updates a named column with a BigDecimal object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateBigDecimal(int, java.math.BigDecimal)

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException
Updates an indexed column with a java.io.InputStream object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateBinaryStream(int, java.io.InputStream, int)

updateBinaryStream

public void updateBinaryStream(java.lang.String columnName,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException
Updates a named column with a java.io.InputStream object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateBinaryStream(int, java.io.InputStream, int)

updateBlob

public void updateBlob(int columnIndex,
                       java.sql.Blob x)
                throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
updateBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.updateBlob(int, Blob)

updateBlob

public void updateBlob(java.lang.String columnName,
                       java.sql.Blob x)
                throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
updateBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.updateBlob(String, Blob)

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean x)
                   throws java.sql.SQLException
Updates an indexed column with a boolean value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateBoolean in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateBoolean(int, boolean)

updateBoolean

public void updateBoolean(java.lang.String columnName,
                          boolean x)
                   throws java.sql.SQLException
Updates a named column with a boolean value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateBoolean in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateBoolean(int, boolean)

updateByte

public void updateByte(int columnIndex,
                       byte x)
                throws java.sql.SQLException
Updates an indexed column with a byte value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateByte in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateByte(int, byte)

updateByte

public void updateByte(java.lang.String columnName,
                       byte x)
                throws java.sql.SQLException
Updates a named column with a byte value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateByte in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateByte(int, byte)

updateBytes

public void updateBytes(int columnIndex,
                        byte[] x)
                 throws java.sql.SQLException
Updates an indexed column with a byte array. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateBytes in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateBytes(int, byte[])

updateBytes

public void updateBytes(java.lang.String columnName,
                        byte[] x)
                 throws java.sql.SQLException
Updates a named column with a byte array. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateBytes in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateBytes(int, byte[])

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  int length)
                           throws java.sql.SQLException
Updates an indexed column with a Reader object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateCharacterStream(int, java.io.Reader, int)

updateCharacterStream

public void updateCharacterStream(java.lang.String columnName,
                                  java.io.Reader reader,
                                  int length)
                           throws java.sql.SQLException
Updates a named column with a Reader object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateCharacterStream(int, java.io.Reader, int)

updateClob

public void updateClob(int columnIndex,
                       java.sql.Clob x)
                throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
updateClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.updateClob(int, Clob)

updateClob

public void updateClob(java.lang.String columnName,
                       java.sql.Clob x)
                throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
updateClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.updateClob(String, Clob)

updateDate

public void updateDate(int columnIndex,
                       java.sql.Date x)
                throws java.sql.SQLException
Updates an indexed column with a Date object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateDate(int, java.sql.Date)

updateDate

public void updateDate(java.lang.String columnName,
                       java.sql.Date x)
                throws java.sql.SQLException
Updates a named column with a Date object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateDate(int, java.sql.Date)

updateDouble

public void updateDouble(int columnIndex,
                         double x)
                  throws java.sql.SQLException
Updates an indexed column with a double value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateDouble(int, double)

updateDouble

public void updateDouble(java.lang.String columnName,
                         double x)
                  throws java.sql.SQLException
Updates a named column with a double value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateDouble(int, double)

updateFloat

public void updateFloat(int columnIndex,
                        float x)
                 throws java.sql.SQLException
Updates an indexed column with a float value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateFloat(int, float)

updateFloat

public void updateFloat(java.lang.String columnName,
                        float x)
                 throws java.sql.SQLException
Updates a named column with a float value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateFloat(int, float)

updateInt

public void updateInt(int columnIndex,
                      int x)
               throws java.sql.SQLException
Updates an indexed column with an int value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateInt(int, int)

updateInt

public void updateInt(java.lang.String columnName,
                      int x)
               throws java.sql.SQLException
Updates a named column with an int value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateInt(int, int)

updateLong

public void updateLong(int columnIndex,
                       long x)
                throws java.sql.SQLException
Updates an indexed column with a long value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateLong(int, long)

updateLong

public void updateLong(java.lang.String columnName,
                       long x)
                throws java.sql.SQLException
Updates a named column with a long value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateLong(int, long)

updateNull

public void updateNull(int columnIndex)
                throws java.sql.SQLException
Updates an indexed column with a null. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateNull in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateNull(int)

updateNull

public void updateNull(java.lang.String columnName)
                throws java.sql.SQLException
Updates a named column with a null. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateNull in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateNull(int)

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x,
                         int scale)
                  throws java.sql.SQLException
Updates an indexed column with a Object value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateObject(int, java.lang.Object, int)

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x)
                  throws java.sql.SQLException
Updates an indexed column with an Object value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateObject(int, java.lang.Object, int)

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object x,
                         int scale)
                  throws java.sql.SQLException
Updates a named column with an Object value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateObject(int, java.lang.Object, int)

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object x)
                  throws java.sql.SQLException
Updates a named column with an Object value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateObject(int, java.lang.Object, int)

updateRef

public void updateRef(int columnIndex,
                      java.sql.Ref x)
               throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
updateRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.updateRef(int, Ref)

updateRef

public void updateRef(java.lang.String columnName,
                      java.sql.Ref x)
               throws java.sql.SQLException
This method is not supported by the Host Integrator driver.

Specified by:
updateRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown
See Also:
ResultSet.updateRef(String, Ref)

updateRow

public void updateRow()
               throws java.sql.SQLException
Updates the current row in this ResultSet object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateRow()

updateShort

public void updateShort(int columnIndex,
                        short x)
                 throws java.sql.SQLException
Updates an indexed column with a short value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateShort(int, short)

updateShort

public void updateShort(java.lang.String columnName,
                        short x)
                 throws java.sql.SQLException
Updates a named column with a short value. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateShort(int, short)

updateString

public void updateString(int columnIndex,
                         java.lang.String x)
                  throws java.sql.SQLException
Updates an indexed column with a java.lang.String object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateString in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateString(int, java.lang.String)

updateString

public void updateString(java.lang.String columnName,
                         java.lang.String x)
                  throws java.sql.SQLException
Updates a named column with a java.lang.String object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateString in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateString(int, java.lang.String)

updateTime

public void updateTime(int columnIndex,
                       java.sql.Time x)
                throws java.sql.SQLException
Updates an indexed column with a Time object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateTime(int, java.sql.Time)

updateTime

public void updateTime(java.lang.String columnName,
                       java.sql.Time x)
                throws java.sql.SQLException
Updates a named column with a Time object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateTime(int, java.sql.Time)

updateTimestamp

public void updateTimestamp(int columnIndex,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException
Updates an indexed column with a Timestamp object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateTimestamp(int, java.sql.Timestamp)

updateTimestamp

public void updateTimestamp(java.lang.String columnName,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException
Updates a named column with a java.io.InputStream object. This method is unsupported by the Host Integrator driver since ResultSet objects are read-only.

Specified by:
updateTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException - - always thrown since the ResultSet has a concurrency type of CONCUR_READ_ONLY.
See Also:
ResultSet.updateTimestamp(int, java.sql.Timestamp)

getRowId

public java.sql.RowId getRowId(int columnIndex)
                        throws java.sql.SQLException
Specified by:
getRowId in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getRowId

public java.sql.RowId getRowId(java.lang.String columnLabel)
                        throws java.sql.SQLException
Specified by:
getRowId in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateRowId

public void updateRowId(int columnIndex,
                        java.sql.RowId x)
                 throws java.sql.SQLException
Specified by:
updateRowId in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateRowId

public void updateRowId(java.lang.String columnLabel,
                        java.sql.RowId x)
                 throws java.sql.SQLException
Specified by:
updateRowId in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getHoldability

public int getHoldability()
                   throws java.sql.SQLException
Specified by:
getHoldability in interface java.sql.ResultSet
Throws:
java.sql.SQLException

isClosed

public boolean isClosed()
                 throws java.sql.SQLException
Specified by:
isClosed in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNString

public void updateNString(int columnIndex,
                          java.lang.String nString)
                   throws java.sql.SQLException
Specified by:
updateNString in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNString

public void updateNString(java.lang.String columnLabel,
                          java.lang.String nString)
                   throws java.sql.SQLException
Specified by:
updateNString in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.sql.NClob nClob)
                 throws java.sql.SQLException
Specified by:
updateNClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.sql.NClob nClob)
                 throws java.sql.SQLException
Specified by:
updateNClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getNClob

public java.sql.NClob getNClob(int columnIndex)
                        throws java.sql.SQLException
Specified by:
getNClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getNClob

public java.sql.NClob getNClob(java.lang.String columnLabel)
                        throws java.sql.SQLException
Specified by:
getNClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getSQLXML

public java.sql.SQLXML getSQLXML(int columnIndex)
                          throws java.sql.SQLException
Specified by:
getSQLXML in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getSQLXML

public java.sql.SQLXML getSQLXML(java.lang.String columnLabel)
                          throws java.sql.SQLException
Specified by:
getSQLXML in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateSQLXML

public void updateSQLXML(int columnIndex,
                         java.sql.SQLXML xmlObject)
                  throws java.sql.SQLException
Specified by:
updateSQLXML in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateSQLXML

public void updateSQLXML(java.lang.String columnLabel,
                         java.sql.SQLXML xmlObject)
                  throws java.sql.SQLException
Specified by:
updateSQLXML in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getNString

public java.lang.String getNString(int columnIndex)
                            throws java.sql.SQLException
Specified by:
getNString in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getNString

public java.lang.String getNString(java.lang.String columnLabel)
                            throws java.sql.SQLException
Specified by:
getNString in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getNCharacterStream

public java.io.Reader getNCharacterStream(int columnIndex)
                                   throws java.sql.SQLException
Specified by:
getNCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getNCharacterStream

public java.io.Reader getNCharacterStream(java.lang.String columnLabel)
                                   throws java.sql.SQLException
Specified by:
getNCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x,
                                   long length)
                            throws java.sql.SQLException
Specified by:
updateNCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(java.lang.String columnLabel,
                                   java.io.Reader reader,
                                   long length)
                            throws java.sql.SQLException
Specified by:
updateNCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x,
                              long length)
                       throws java.sql.SQLException
Specified by:
updateAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x,
                               long length)
                        throws java.sql.SQLException
Specified by:
updateBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  long length)
                           throws java.sql.SQLException
Specified by:
updateCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x,
                              long length)
                       throws java.sql.SQLException
Specified by:
updateAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x,
                               long length)
                        throws java.sql.SQLException
Specified by:
updateBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader,
                                  long length)
                           throws java.sql.SQLException
Specified by:
updateCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex,
                       java.io.InputStream inputStream,
                       long length)
                throws java.sql.SQLException
Specified by:
updateBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String columnLabel,
                       java.io.InputStream inputStream,
                       long length)
                throws java.sql.SQLException
Specified by:
updateBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateClob

public void updateClob(int columnIndex,
                       java.io.Reader reader,
                       long length)
                throws java.sql.SQLException
Specified by:
updateClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateClob

public void updateClob(java.lang.String columnLabel,
                       java.io.Reader reader,
                       long length)
                throws java.sql.SQLException
Specified by:
updateClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException
Specified by:
updateNClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException
Specified by:
updateNClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x)
                            throws java.sql.SQLException
Specified by:
updateNCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(java.lang.String columnLabel,
                                   java.io.Reader reader)
                            throws java.sql.SQLException
Specified by:
updateNCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x)
                       throws java.sql.SQLException
Specified by:
updateAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x)
                        throws java.sql.SQLException
Specified by:
updateBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x)
                           throws java.sql.SQLException
Specified by:
updateCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x)
                       throws java.sql.SQLException
Specified by:
updateAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x)
                        throws java.sql.SQLException
Specified by:
updateBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader)
                           throws java.sql.SQLException
Specified by:
updateCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex,
                       java.io.InputStream inputStream)
                throws java.sql.SQLException
Specified by:
updateBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String columnLabel,
                       java.io.InputStream inputStream)
                throws java.sql.SQLException
Specified by:
updateBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateClob

public void updateClob(int columnIndex,
                       java.io.Reader reader)
                throws java.sql.SQLException
Specified by:
updateClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateClob

public void updateClob(java.lang.String columnLabel,
                       java.io.Reader reader)
                throws java.sql.SQLException
Specified by:
updateClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.io.Reader reader)
                 throws java.sql.SQLException
Specified by:
updateNClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader)
                 throws java.sql.SQLException
Specified by:
updateNClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

unwrap

public <T> T unwrap(java.lang.Class<T> iface)
         throws java.sql.SQLException
Specified by:
unwrap in interface java.sql.Wrapper
Throws:
java.sql.SQLException

isWrapperFor

public boolean isWrapperFor(java.lang.Class<?> iface)
                     throws java.sql.SQLException
Specified by:
isWrapperFor in interface java.sql.Wrapper
Throws:
java.sql.SQLException

wasNull

public boolean wasNull()
                throws java.sql.SQLException
Determines whether the last value read was null.

Specified by:
wasNull in interface java.sql.ResultSet
Returns:
false. The Host Integrator does not return SQL nulls.
Throws:
java.sql.SQLException
See Also:
ResultSet.wasNull()