com.ibm.as400.access
Class AS400JDBCArrayResultSet

java.lang.Object
  extended by com.ibm.as400.access.AS400JDBCArrayResultSet
All Implemented Interfaces:
ResultSet, Wrapper

public class AS400JDBCArrayResultSet
extends Object
implements ResultSet

AS400JDBCArrayResultSet is a JDBC ResultSet that contains Array data. This is a client-side only object. This is used to navigating through returned data from IBM i DB2 using Toolbox JDBC. No updates will be functional nor will they be sent back to the host server. Note that this ResultSet is limited in its functionality since it is not tied back to a cursor in the database. Its primary purpose is for retrieving data back from the database.


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)
          Positions the cursor to an absolute row number.
 void afterLast()
          Positions the cursor after the last row.
 void beforeFirst()
          Sets cursor position before the first row.
 void cancelRowUpdates()
          Cancels all pending updates that have been made since the last call to updateRow().
 void clearWarnings()
          Clears all warnings that have been reported for the result set.
 void close()
          Closes this ResultSet
 void deleteRow()
          Deletes the current row from the result set and the database.
 int findColumn(String columnName)
          Returns the column index for the specified column name.
 boolean first()
          Positions the cursor to the first row.
 Array getArray(int column)
          Returns the value of a column as an Array object.
 Array getArray(String columnName)
          Returns the value of a column as an Array object.
 InputStream getAsciiStream(int column)
          Returns the value of a column as a stream of ASCII characters.
 InputStream getAsciiStream(String columnName)
          Returns the value of a column as a stream of ASCII characters.
 BigDecimal getBigDecimal(int column)
          Returns the value of a column as a BigDecimal object.
 BigDecimal getBigDecimal(int column, int scale)
          Deprecated. Use getBigDecimal(int) instead.
 BigDecimal getBigDecimal(String columnName)
          Returns the value of a column as a BigDecimal object.
 BigDecimal getBigDecimal(String columnName, int scale)
          Deprecated. Use getBigDecimal(int) instead.
 InputStream getBinaryStream(int column)
          Returns the value of a column as a stream of uninterpreted bytes.
 InputStream getBinaryStream(String columnName)
          Returns the value of a column as a stream of uninterpreted bytes.
 Blob getBlob(int column)
          Returns the value of a column as a Blob object.
 Blob getBlob(String columnName)
          Returns the value of a column as a Blob object.
 boolean getBoolean(int column)
          Returns the value of a column as a Java boolean value.
 boolean getBoolean(String columnName)
          Returns the value of a column as a Java boolean value.
 byte getByte(int column)
          Returns the value of a column as a Java byte value.
 byte getByte(String columnName)
          Returns the value of a column as a Java byte value.
 byte[] getBytes(int column)
          Returns the value of a column as a Java byte array.
 byte[] getBytes(String columnName)
          Returns the value of a column as a Java byte array.
 Reader getCharacterStream(int column)
          Returns the value of a column as a character stream.
 Reader getCharacterStream(String columnName)
          Returns the value of a column as a character stream.
 Clob getClob(int column)
          Returns the value of a column as a Clob object.
 Clob getClob(String columnName)
          Returns the value of a column as a Clob object.
 int getConcurrency()
          Returns the result set concurrency.
 String getCursorName()
          Returns the name of the SQL cursor in use by the result set.
 Date getDate(int column)
          Returns the value of a column as a java.sql.Date object using the default calendar.
 Date getDate(int column, Calendar calendar)
          Returns the value of a column as a java.sql.Date object using a calendar other than the default.
 Date getDate(String columnName)
          Returns the value of a column as a java.sql.Date object using the default calendar.
 Date getDate(String columnName, Calendar calendar)
          Returns the value of a column as a java.sql.Date object using a calendar other than the default.
 double getDouble(int column)
          Returns the value of a column as a Java double value.
 double getDouble(String columnName)
          Returns the value of a column as a Java double value.
 int getFetchDirection()
          Returns the fetch direction.
 int getFetchSize()
          Returns the fetch size.
 float getFloat(int column)
          Returns the value of a column as a Java float value.
 float getFloat(String columnName)
          Returns the value of a column as a Java float value.
 int getHoldability()
          Retrieves the holdability.
 int getInt(int column)
          Returns the value of a column as a Java int value.
 int getInt(String columnName)
          Returns the value of a column as a Java int value.
 long getLong(int column)
          Returns the value of a column as a Java long value.
 long getLong(String columnName)
          Returns the value of a column as a Java long value.
 ResultSetMetaData getMetaData()
          Returns the ResultSetMetaData object that describes the result set's columns.
 Reader getNCharacterStream(int column)
          Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
 Reader getNCharacterStream(String columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
 NClob getNClob(int column)
          Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.
 NClob getNClob(String columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.
 String getNString(int column)
          Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
 String getNString(String columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
 Object getObject(int column)
          Returns the value of a column as a Java Object.
 Object getObject(int column, Map map)
          Returns the value of a column as a Java Object.
 Object getObject(String columnName)
          Returns the value of a column as a Java Object.
 Object getObject(String columnName, Map map)
          Returns the value of a column as a Java Object.
 Ref getRef(int column)
          Returns the value of a column as a Ref object.
 Ref getRef(String columnName)
          Returns the value of a column as a Ref object.
 int getRow()
          Retrieves the current row number.
 RowId getRowId(int column)
          Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.
 RowId getRowId(String columnName)
          Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.
 short getShort(int column)
          Returns the value of a column as a Java short value.
 short getShort(String columnName)
          Returns the value of a column as a Java short value.
 SQLXML getSQLXML(int column)
          Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.
 SQLXML getSQLXML(String columnName)
          Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.
 Statement getStatement()
          Returns the statement for this result set.
 String getString(int column)
          Returns the value of a column as a String object.
 String getString(String columnName)
          Returns the value of a column as a String object.
 Time getTime(int column)
          Returns the value of a column as a java.sql.Time object using the default calendar.
 Time getTime(int column, Calendar calendar)
          Returns the value of a column as a java.sql.Time object using the default calendar.
 Time getTime(String columnName)
          Returns the value of a column as a java.sql.Time object using the default calendar.
 Time getTime(String columnName, Calendar calendar)
          Returns the value of a column as a java.sql.Time object using the default calendar.
 Timestamp getTimestamp(int column)
          Returns the value of a column as a java.sql.Timestamp object using the default calendar.
 Timestamp getTimestamp(int column, Calendar calendar)
          Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default.
 Timestamp getTimestamp(String columnName)
          Returns the value of a column as a java.sql.Timestamp object using the default calendar.
 Timestamp getTimestamp(String columnName, Calendar calendar)
          Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default.
 int getType()
          Returns the result set type.
 InputStream getUnicodeStream(int column)
          Deprecated. Use getCharacterStream(int) instead.
 InputStream getUnicodeStream(String columnName)
          Deprecated. Use getCharacterStream(String) instead.
 URL getURL(int column)
          Returns the value of an SQL DATALINK output parameter as a java.net.URL object.
 URL getURL(String columnName)
          Returns the value of an SQL DATALINK output parameter as a java.net.URL object.
protected  String[] getValidWrappedList()
           
 SQLWarning getWarnings()
          Returns the first warning reported for the result set.
 void insertRow()
          Inserts the contents of the insert row into the result set and the database.
 boolean isAfterLast()
          Indicates if the cursor is positioned after the last row.
 boolean isBeforeFirst()
          Indicates if the cursor is positioned before the first row.
 boolean isClosed()
          Indicates if the result set is closed.
 boolean isFirst()
          Indicates if the cursor is positioned on the first row.
 boolean isLast()
          Indicates if the cursor is positioned on the last row.
 boolean isWrapperFor(Class<?> iface)
          Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
 boolean last()
          Positions the cursor to the last row.
 void moveToCurrentRow()
          Positions the cursor to the current row.
 void moveToInsertRow()
          Positions the cursor to the insert row.
 boolean next()
          Positions the cursor to the next row.
 boolean previous()
          Positions the cursor to the previous row.
 void refreshRow()
          Refreshes the current row from the database.
 boolean relative(int rows)
          Positions the cursor to a relative row number.
 boolean rowDeleted()
          Indicates if the current row has been deleted.
 boolean rowInserted()
          Indicates if the current row has been inserted.
 boolean rowUpdated()
          Indicates if the current row has been updated.
 void setFetchDirection(int direction)
          Sets the direction in which the rows in a result set are processed.
 void setFetchSize(int rows)
          Sets the number of rows to be fetched from the database when more rows are needed.
<T> T
unwrap(Class<T> iface)
          Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
 void updateArray(int column, Array x)
          Updates the value of a column as an Array object.
 void updateArray(String columnName, Array x)
          Updates the value of a column as an Array object.
 void updateAsciiStream(int column, InputStream x)
          Updates the designated column with an ascii stream value, which will have the specified number of bytes.
 void updateAsciiStream(int column, InputStream x, int length)
          Updates the designated column with an ascii stream value, which will have the specified number of bytes.
 void updateAsciiStream(int column, InputStream x, long length)
          Updates the designated column with an ascii stream value, which will have the specified number of bytes.
 void updateAsciiStream(String columnName, InputStream x)
          Updates the designated column with an ascii stream value, which will have the specified number of bytes.
 void updateAsciiStream(String columnName, InputStream x, int length)
          Updates the designated column with an ascii stream value, which will have the specified number of bytes.
 void updateAsciiStream(String columnName, InputStream x, long length)
          Updates the designated column with an ascii stream value, which will have the specified number of bytes.
 void updateBigDecimal(int column, BigDecimal x)
          Updates a column in the current row using a BigDecimal value.
 void updateBigDecimal(String columnName, BigDecimal x)
          Updates a column in the current row using a BigDecimal value.
 void updateBinaryStream(int column, InputStream x)
          Updates the designated column with a binary stream value.
 void updateBinaryStream(int column, InputStream x, int length)
          Updates the designated column with a binary stream value, which will have the specified number of bytes.
 void updateBinaryStream(int column, InputStream x, long length)
          Updates the designated column with a binary stream value.
 void updateBinaryStream(String columnName, InputStream x)
          Updates the designated column with a binary stream value.
 void updateBinaryStream(String columnName, InputStream x, int length)
          Updates the designated column with a binary stream value, which will have the specified number of bytes.
 void updateBinaryStream(String columnName, InputStream x, long length)
          Updates the designated column with a binary stream value.
 void updateBlob(int column, Blob x)
          Updates a column in the current row using a Java Blob value.
 void updateBlob(int column, InputStream x)
          Updates the designated column using the given input stream.
 void updateBlob(int column, InputStream x, long length)
          Updates the designated column using the given input stream.
 void updateBlob(String columnName, Blob x)
          Updates a column in the current row using a Java Blob value.
 void updateBlob(String columnName, InputStream x)
          Updates the designated column using the given input stream.
 void updateBlob(String columnName, InputStream x, long length)
          Updates the designated column using the given input stream.
 void updateBoolean(int column, boolean x)
          Updates a column in the current row using a Java boolean value.
 void updateBoolean(String columnName, boolean x)
          Updates a column in the current row using a Java boolean value.
 void updateByte(int column, byte x)
          Updates a column in the current row using a Java byte value.
 void updateByte(String columnName, byte x)
          Updates a column in the current row using a Java byte value.
 void updateBytes(int column, byte[] x)
          Updates a column in the current row using a Java byte array value.
 void updateBytes(String columnName, byte[] x)
          Updates a column in the current row using a Java byte array value.
 void updateCharacterStream(int column, Reader x)
          Updates the designated column with a character stream value.
 void updateCharacterStream(int column, Reader x, int length)
          Updates a column in the current row using a Reader value.
 void updateCharacterStream(int column, Reader x, long length)
          Updates the designated column with a character stream value.
 void updateCharacterStream(String columnName, Reader x)
          Updates the designated column with a character stream value.
 void updateCharacterStream(String columnName, Reader x, int length)
          Updates a column in the current row using a Reader value.
 void updateCharacterStream(String columnName, Reader x, long length)
          Updates the designated column with a character stream value.
 void updateClob(int column, Clob x)
          Updates a column in the current row using a Java Clob value.
 void updateClob(int column, Reader x)
          Updates the designated column using the given Reader object.
 void updateClob(int column, Reader x, long length)
          Updates the designated column using the given Reader object.
 void updateClob(String columnName, Clob x)
          Updates a column in the current row using a Java Clob value.
 void updateClob(String columnName, Reader x)
          Updates the designated column using the given Reader object.
 void updateClob(String columnName, Reader x, long length)
          Updates the designated column using the given Reader object.
 void updateDate(int column, Date x)
          Updates a column in the current row using a java.sql.Date value.
 void updateDate(String columnName, Date x)
          Updates a column in the current row using a java.sql.Date value.
 void updateDouble(int column, double x)
          Updates a column in the current row using a Java double value.
 void updateDouble(String columnName, double x)
          Updates a column in the current row using a Java double value.
 void updateFloat(int column, float x)
          Updates a column in the current row using a Java float value.
 void updateFloat(String columnName, float x)
          Updates a column in the current row using a Java float value.
 void updateInt(int column, int x)
          Updates a column in the current row using a Java int value.
 void updateInt(String columnName, int x)
          Updates a column in the current row using a Java int value.
 void updateLong(int column, long x)
          Updates a column in the current row using a Java long value.
 void updateLong(String columnName, long x)
          Updates a column in the current row using a Java long value.
 void updateNCharacterStream(int column, Reader x)
          Updates the designated column with a character stream value.
 void updateNCharacterStream(int column, Reader x, long length)
          Updates the designated column with a character stream value.
 void updateNCharacterStream(String columnName, Reader x)
          Updates the designated column with a character stream value.
 void updateNCharacterStream(String columnName, Reader x, long length)
          Updates the designated column with a character stream value.
 void updateNClob(int column, NClob x)
          Updates the designated column using the given Reader
 void updateNClob(int column, Reader x)
          Updates the designated column using the given Reader
 void updateNClob(int column, Reader x, long length)
          Updates the designated column using the given Reader
 void updateNClob(String columnName, NClob x)
          Updates the designated column using the given Reader
 void updateNClob(String columnName, Reader x)
          Updates the designated column using the given Reader
 void updateNClob(String columnName, Reader x, long length)
          Updates the designated column using the given Reader
 void updateNString(int column, String x)
          Updates the designated column with a String value.
 void updateNString(String columnName, String x)
          Updates the designated column with a String value.
 void updateNull(int column)
          Updates a column in the current row using SQL NULL.
 void updateNull(String columnName)
          Updates a column in the current row using SQL NULL.
 void updateObject(int column, Object x)
          Updates a column in the current row using an Object value.
 void updateObject(int column, Object x, int scale)
          Updates a column in the current row using an Object value.
 void updateObject(String columnName, Object x)
          Updates a column in the current row using an Object value.
 void updateObject(String columnName, Object x, int scale)
          Updates a column in the current row using an Object value.
 void updateRef(int column, Ref x)
          Updates the value of an SQL REF output parameter as a Ref value.
 void updateRef(String columnName, Ref x)
          Updates the value of an SQL REF output parameter as a Ref value.
 void updateRow()
          Cancels all pending updates that have been made since the last call to updateRow().
 void updateRowId(int column, RowId x)
          Updates the designated column with a RowId value.
 void updateRowId(String columnName, RowId x)
          Updates the designated column with a RowId value.
 void updateShort(int column, short x)
          Updates a column in the current row using a Java short value.
 void updateShort(String columnName, short x)
          Updates a column in the current row using a Java short value.
 void updateSQLXML(int column, SQLXML x)
          Updates the designated column with a java.sql.SQLXML value.
 void updateSQLXML(String columnName, SQLXML x)
          Updates the designated column with a java.sql.SQLXML value.
 void updateString(int column, String x)
          Updates a column in the current row using a String value.
 void updateString(String columnName, String x)
          Updates a column in the current row using a String value.
 void updateTime(int column, Time x)
          Updates a column in the current row using a java.sql.Time value.
 void updateTime(String columnName, Time x)
          Updates a column in the current row using a java.sql.Time value.
 void updateTimestamp(int column, Timestamp x)
          Updates a column in the current row using a java.sql.Timestamp value.
 void updateTimestamp(String columnName, Timestamp x)
          Updates a column in the current row using a java.sql.Timestamp value.
 boolean wasNull()
          Indicates if the last column read has the value of SQL NULL.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
 

Method Detail

close

public void close()
           throws SQLException
Closes this ResultSet

Specified by:
close in interface ResultSet
Throws:
SQLException - If an error occurs.

isBeforeFirst

public boolean isBeforeFirst()
                      throws SQLException
Indicates if the cursor is positioned before the first row.

Specified by:
isBeforeFirst in interface ResultSet
Returns:
true if the cursor is positioned before the first row; false if the cursor is not positioned before the first row or if the result set contains no rows.
Throws:
SQLException - If the result set is not open.

isAfterLast

public boolean isAfterLast()
                    throws SQLException
Indicates if the cursor is positioned after the last row.

Specified by:
isAfterLast in interface ResultSet
Returns:
true if the cursor is positioned after the last row; false if the cursor is not positioned after the last row or if the result set contains no rows.
Throws:
SQLException - If the result set is not open.

isFirst

public boolean isFirst()
                throws SQLException
Indicates if the cursor is positioned on the first row.

Specified by:
isFirst in interface ResultSet
Returns:
true if the cursor is positioned on the first row; false if the cursor is not positioned on the first row or the row number can not be determined.
Throws:
SQLException - If the result set is not open.

isLast

public boolean isLast()
               throws SQLException
Indicates if the cursor is positioned on the last row.

Specified by:
isLast in interface ResultSet
Returns:
true if the cursor is positioned on the last row; false if the cursor is not positioned on the last row or the row number can not be determined.
Throws:
SQLException - If the result set is not open.

beforeFirst

public void beforeFirst()
                 throws SQLException
Sets cursor position before the first row.

Specified by:
beforeFirst in interface ResultSet
Throws:
SQLException - If the result set is not open.

afterLast

public void afterLast()
               throws SQLException
Positions the cursor after the last row.

Specified by:
afterLast in interface ResultSet
Throws:
SQLException - If the result set is not open, the result set is not scrollable, or an error occurs.

first

public boolean first()
              throws SQLException
Positions the cursor to the first row.

Specified by:
first in interface ResultSet
Returns:
true if the requested cursor position is valid; false otherwise.
Throws:
SQLException - If the result set is not open, the result set is not scrollable, or an error occurs.

last

public boolean last()
             throws SQLException
Positions the cursor to the last row.

Specified by:
last in interface ResultSet
Returns:
true if the requested cursor position is valid; false otherwise.
Throws:
SQLException - If the result set is not open, the result set is not scrollable, or an error occurs.

previous

public boolean previous()
                 throws SQLException
Positions the cursor to the previous row.

Specified by:
previous in interface ResultSet
Returns:
true if the requested cursor position is valid; false otherwise.
Throws:
SQLException - If the result set is not open, the result set is not scrollable, or an error occurs.

next

public boolean next()
             throws SQLException
Positions the cursor to the next row.

Specified by:
next in interface ResultSet
Returns:
true if the requested cursor position is valid; false if there are no more rows.
Throws:
SQLException - If the result set is not open, or an error occurs.

absolute

public boolean absolute(int row)
                 throws SQLException
Positions the cursor to an absolute row number.

Specified by:
absolute in interface ResultSet
Parameters:
row - The absolute row number. If the absolute row number is positive, this positions the cursor with respect to the beginning of the result set. If the absolute row number is negative, this positions the cursor with respect to the end of result set.
Returns:
true if the requested cursor position is valid; false otherwise.
Throws:
SQLException - If the result set is not open, the result set is not scrollable, the row number is 0, or an error occurs.

relative

public boolean relative(int rows)
                 throws SQLException
Positions the cursor to a relative row number.

Attempting to move beyond the first row positions the cursor before the first row. Attempting to move beyond the last row positions the cursor after the last row.

Specified by:
relative in interface ResultSet
Parameters:
rows - The relative row number. If the relative row number is positive, this positions the cursor after the current position. If the relative row number is negative, this positions the cursor before the current position. If the relative row number is 0, then the cursor position does not change.
Returns:
true if the requested cursor position is valid, false otherwise.
Throws:
SQLException - If the result set is not open, the result set is not scrollable, the cursor is not positioned on a valid row, or an error occurs.

getConcurrency

public int getConcurrency()
                   throws SQLException
Returns the result set concurrency.

Specified by:
getConcurrency in interface ResultSet
Returns:
The result set concurrency. Valid values are:
  • CONCUR_READ_ONLY
  • CONCUR_UPDATABLE
Throws:
SQLException - If the result set is not open.

getType

public int getType()
            throws SQLException
Returns the result set type.

Specified by:
getType in interface ResultSet
Returns:
The result set type. Valid values are:
  • TYPE_FORWARD_ONLY
  • TYPE_SCROLL_INSENSITIVE
  • TYPE_SCROLL_SENSITIVE
Throws:
SQLException - If the result set is not open.

getFetchDirection

public int getFetchDirection()
                      throws SQLException
Returns the fetch direction.

Specified by:
getFetchDirection in interface ResultSet
Returns:
The fetch direction. Valid values are:
  • FETCH_FORWARD
  • FETCH_REVERSE
  • FETCH_UNKNOWN
Throws:
SQLException - If the result is not open.

setFetchDirection

public void setFetchDirection(int direction)
                       throws SQLException
Sets the direction in which the rows in a result set are processed.

Specified by:
setFetchDirection in interface ResultSet
Parameters:
direction - The fetch direction for processing rows. Valid values are:
  • FETCH_FORWARD
  • FETCH_REVERSE
  • FETCH_UNKNOWN
The default is the statement's fetch direction.
Throws:
SQLException - If the result set is not open, the result set is scrollable and the input value is not ResultSet.FETCH_FORWARD, or the input value is not valid.

getFetchSize

public int getFetchSize()
                 throws SQLException
Returns the fetch size.

Specified by:
getFetchSize in interface ResultSet
Returns:
The fetch size.
Throws:
SQLException - If the result is not open.

setFetchSize

public void setFetchSize(int rows)
                  throws SQLException
Sets the number of rows to be fetched from the database when more rows are needed. This may be changed at any time. If the value specified is zero, then the driver will choose an appropriate fetch size.

Specified by:
setFetchSize in interface ResultSet
Parameters:
rows - The number of rows. This must be greater than or equal to 0 and less than or equal to the maximum rows limit. The default is the statement's fetch size.
Throws:
SQLException - If the result set is not open or the input value is not valid.

getCursorName

public String getCursorName()
                     throws SQLException
Returns the name of the SQL cursor in use by the result set.

Specified by:
getCursorName in interface ResultSet
Returns:
The cursor name.
Throws:
SQLException - If the result is not open.

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException
Returns the ResultSetMetaData object that describes the result set's columns. ResultSetMetadata on Array columns is not supported and the getMetaData method will return null.

Specified by:
getMetaData in interface ResultSet
Returns:
The metadata object.
Throws:
SQLException - If an error occurs.

getStatement

public Statement getStatement()
                       throws SQLException
Returns the statement for this result set.

Specified by:
getStatement in interface ResultSet
Returns:
The statement for this result set, or null if the result set was returned by a DatabaseMetaData catalog method.
Throws:
SQLException - If an error occurs.

getWarnings

public SQLWarning getWarnings()
                       throws SQLException
Returns the first warning reported for the result set. Subsequent warnings may be chained to this warning.

Specified by:
getWarnings in interface ResultSet
Returns:
The first warning or null if no warnings have been reported.
Throws:
SQLException - If an error occurs.

clearWarnings

public void clearWarnings()
                   throws SQLException
Clears all warnings that have been reported for the result set. After this call, getWarnings() returns null until a new warning is reported for the result set.

Specified by:
clearWarnings in interface ResultSet
Throws:
SQLException - If an error occurs.

findColumn

public int findColumn(String columnName)
               throws SQLException
Returns the column index for the specified column name.

Specified by:
findColumn in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column index (1-based).
Throws:
SQLException - If the result set is not open or the column name is not found.

getRow

public int getRow()
           throws SQLException
Retrieves the current row number. The first row is number 1, the second number 2, and so on.

Specified by:
getRow in interface ResultSet
Returns:
The current row number (1-based), or 0 if the current row is not valid.
Throws:
SQLException - If the result set is not open.

wasNull

public boolean wasNull()
                throws SQLException
Indicates if the last column read has the value of SQL NULL.

Specified by:
wasNull in interface ResultSet
Returns:
true if the value is SQL NULL; false otherwise.
Throws:
SQLException - If the result set is not open.

getBoolean

public boolean getBoolean(int column)
                   throws SQLException
Returns the value of a column as a Java boolean value.

Specified by:
getBoolean in interface ResultSet
Parameters:
column - The column name.
Returns:
The column value or false if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getBoolean

public boolean getBoolean(String columnName)
                   throws SQLException
Returns the value of a column as a Java boolean value.

Specified by:
getBoolean in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or false if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getByte

public byte getByte(int column)
             throws SQLException
Returns the value of a column as a Java byte value.

Specified by:
getByte in interface ResultSet
Parameters:
column - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getByte

public byte getByte(String columnName)
             throws SQLException
Returns the value of a column as a Java byte value.

Specified by:
getByte in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getShort

public short getShort(int column)
               throws SQLException
Returns the value of a column as a Java short value.

Specified by:
getShort in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getShort

public short getShort(String columnName)
               throws SQLException
Returns the value of a column as a Java short value.

Specified by:
getShort in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getInt

public int getInt(int column)
           throws SQLException
Returns the value of a column as a Java int value.

Specified by:
getInt in interface ResultSet
Parameters:
column - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.

getInt

public int getInt(String columnName)
           throws SQLException
Returns the value of a column as a Java int value.

Specified by:
getInt in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.

getLong

public long getLong(int column)
             throws SQLException
Returns the value of a column as a Java long value.

Specified by:
getLong in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getLong

public long getLong(String columnName)
             throws SQLException
Returns the value of a column as a Java long value.

Specified by:
getLong in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getFloat

public float getFloat(int column)
               throws SQLException
Returns the value of a column as a Java float value.

Specified by:
getFloat in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getFloat

public float getFloat(String columnName)
               throws SQLException
Returns the value of a column as a Java float value.

Specified by:
getFloat in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getDouble

public double getDouble(int column)
                 throws SQLException
Returns the value of a column as a Java double value.

Specified by:
getDouble in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.

getDouble

public double getDouble(String columnName)
                 throws SQLException
Returns the value of a column as a Java double value.

Specified by:
getDouble in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column name is not found, or the requested conversion is not valid.

getBigDecimal

public BigDecimal getBigDecimal(int column)
                         throws SQLException
Returns the value of a column as a BigDecimal object.

Specified by:
getBigDecimal in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getBigDecimal

public BigDecimal getBigDecimal(String columnName)
                         throws SQLException
Returns the value of a column as a BigDecimal object.

Specified by:
getBigDecimal in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getBigDecimal

public BigDecimal getBigDecimal(int column,
                                int scale)
                         throws SQLException
Deprecated. Use getBigDecimal(int) instead.

Returns the value of a column as a BigDecimal object.

Specified by:
getBigDecimal in interface ResultSet
Parameters:
column - The column index (1-based).
scale - The number of digits after the decimal.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the scale is not valid, or the requested conversion is not valid.
See Also:
getBigDecimal(int)

getBigDecimal

public BigDecimal getBigDecimal(String columnName,
                                int scale)
                         throws SQLException
Deprecated. Use getBigDecimal(int) instead.

Returns the value of a column as a BigDecimal object.

Specified by:
getBigDecimal in interface ResultSet
Parameters:
columnName - The column name.
scale - The number of digits after the decimal.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the scale is not valid, or the requested conversion is not valid.
See Also:
getBigDecimal(int)

getDate

public Date getDate(int column)
             throws SQLException
Returns the value of a column as a java.sql.Date object using the default calendar.

Specified by:
getDate in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getDate

public Date getDate(String columnName)
             throws SQLException
Returns the value of a column as a java.sql.Date object using the default calendar.

Specified by:
getDate in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getTime

public Time getTime(int column)
             throws SQLException
Returns the value of a column as a java.sql.Time object using the default calendar.

Specified by:
getTime in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getTime

public Time getTime(String columnName)
             throws SQLException
Returns the value of a column as a java.sql.Time object using the default calendar.

Specified by:
getTime in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getTimestamp

public Timestamp getTimestamp(int column)
                       throws SQLException
Returns the value of a column as a java.sql.Timestamp object using the default calendar.

Specified by:
getTimestamp in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getTimestamp

public Timestamp getTimestamp(String columnName)
                       throws SQLException
Returns the value of a column as a java.sql.Timestamp object using the default calendar.

Specified by:
getTimestamp in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getDate

public Date getDate(int column,
                    Calendar calendar)
             throws SQLException
Returns the value of a column as a java.sql.Date object using a calendar other than the default.

Specified by:
getDate in interface ResultSet
Parameters:
column - The column index (1-based).
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the calendar is null, or the requested conversion is not valid.

getDate

public Date getDate(String columnName,
                    Calendar calendar)
             throws SQLException
Returns the value of a column as a java.sql.Date object using a calendar other than the default.

Specified by:
getDate in interface ResultSet
Parameters:
columnName - The column name.
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the calendar is null, or the requested conversion is not valid.

getTime

public Time getTime(int column,
                    Calendar calendar)
             throws SQLException
Returns the value of a column as a java.sql.Time object using the default calendar.

Specified by:
getTime in interface ResultSet
Parameters:
column - The column index (1-based).
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getTime

public Time getTime(String columnName,
                    Calendar calendar)
             throws SQLException
Returns the value of a column as a java.sql.Time object using the default calendar.

Specified by:
getTime in interface ResultSet
Parameters:
columnName - The column name.
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getTimestamp

public Timestamp getTimestamp(int column,
                              Calendar calendar)
                       throws SQLException
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default.

Specified by:
getTimestamp in interface ResultSet
Parameters:
column - The column index (1-based).
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the calendar is null, or the requested conversion is not valid.

getTimestamp

public Timestamp getTimestamp(String columnName,
                              Calendar calendar)
                       throws SQLException
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default.

Specified by:
getTimestamp in interface ResultSet
Parameters:
columnName - The column name.
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the calendar is null, or the requested conversion is not valid.

getBytes

public byte[] getBytes(int column)
                throws SQLException
Returns the value of a column as a Java byte array.

This can also be used to get values from columns with other types. The values are returned in their native IBM i format. This is not supported for result sets returned by a DatabaseMetaData object.

Specified by:
getBytes in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getBytes

public byte[] getBytes(String columnName)
                throws SQLException
Returns the value of a column as a Java byte array.

This can also be used to get values from columns with other types. The values are returned in their native IBM i format. This is not supported for result sets returned by a DatabaseMetaData object.

Specified by:
getBytes in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getString

public String getString(int column)
                 throws SQLException
Returns the value of a column as a String object.

Specified by:
getString in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getString

public String getString(String columnName)
                 throws SQLException
Returns the value of a column as a String object.

Specified by:
getString in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getBinaryStream

public InputStream getBinaryStream(int column)
                            throws SQLException
Returns the value of a column as a stream of uninterpreted bytes.

Specified by:
getBinaryStream in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getBinaryStream

public InputStream getBinaryStream(String columnName)
                            throws SQLException
Returns the value of a column as a stream of uninterpreted bytes.

Specified by:
getBinaryStream in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getAsciiStream

public InputStream getAsciiStream(int column)
                           throws SQLException
Returns the value of a column as a stream of ASCII characters.

Specified by:
getAsciiStream in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getAsciiStream

public InputStream getAsciiStream(String columnName)
                           throws SQLException
Returns the value of a column as a stream of ASCII characters.

Specified by:
getAsciiStream in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getUnicodeStream

public InputStream getUnicodeStream(int column)
                             throws SQLException
Deprecated. Use getCharacterStream(int) instead.

Returns the value of a column as a stream of Unicode characters.

Specified by:
getUnicodeStream in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
See Also:
getCharacterStream(int)

getUnicodeStream

public InputStream getUnicodeStream(String columnName)
                             throws SQLException
Deprecated. Use getCharacterStream(String) instead.

Returns the value of a column as a stream of Unicode characters.

Specified by:
getUnicodeStream in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.
See Also:
getCharacterStream(String)

getCharacterStream

public Reader getCharacterStream(int column)
                          throws SQLException
Returns the value of a column as a character stream.

Specified by:
getCharacterStream in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getCharacterStream

public Reader getCharacterStream(String columnName)
                          throws SQLException
Returns the value of a column as a character stream.

Specified by:
getCharacterStream in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getBlob

public Blob getBlob(int column)
             throws SQLException
Returns the value of a column as a Blob object.

Specified by:
getBlob in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getBlob

public Blob getBlob(String columnName)
             throws SQLException
Returns the value of a column as a Blob object.

Specified by:
getBlob in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getClob

public Clob getClob(int column)
             throws SQLException
Returns the value of a column as a Clob object.

Specified by:
getClob in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getClob

public Clob getClob(String columnName)
             throws SQLException
Returns the value of a column as a Clob object.

Specified by:
getClob in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getArray

public Array getArray(int column)
               throws SQLException
Returns the value of a column as an Array object.

Specified by:
getArray in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException

getArray

public Array getArray(String columnName)
               throws SQLException
Returns the value of a column as an Array object.

Specified by:
getArray in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException

getRef

public Ref getRef(int column)
           throws SQLException
Returns the value of a column as a Ref object. DB2 for IBM i does not support structured types.

Specified by:
getRef in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - Always thrown because DB2 for IBM i does not support structured types.

getRef

public Ref getRef(String columnName)
           throws SQLException
Returns the value of a column as a Ref object. DB2 for IBM i does not support structured types.

Specified by:
getRef in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - Always thrown because DB2 for IBM i does not support structured types.

getURL

public URL getURL(int column)
           throws SQLException
Returns the value of an SQL DATALINK output parameter as a java.net.URL object.

Specified by:
getURL in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The parameter value or null if the value is SQL NULL.
Throws:
SQLException - If the statement is not open, the index is not valid, the parameter name is not registered as an output parameter, the statement was not executed or the requested conversion is not valid.

getURL

public URL getURL(String columnName)
           throws SQLException
Returns the value of an SQL DATALINK output parameter as a java.net.URL object.

Specified by:
getURL in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The parameter value or null if the value is SQL NULL.
Throws:
SQLException - If the statement is not open, the index is not valid, the parameter name is not registered as an output parameter, the statement was not executed or the requested conversion is not valid.

getObject

public Object getObject(int column)
                 throws SQLException
Returns the value of a column as a Java Object. This can be used to get values from columns with all SQL types.

Specified by:
getObject in interface ResultSet
Parameters:
column - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getObject

public Object getObject(String columnName)
                 throws SQLException
Returns the value of a column as a Java Object. This can be used to get values from columns with all SQL types.

Specified by:
getObject in interface ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

getObject

public Object getObject(int column,
                        Map map)
                 throws SQLException
Returns the value of a column as a Java Object.

Specified by:
getObject in interface ResultSet
Parameters:
column - The column index (1-based).
map - The type map. This is not used.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the type map is null, or the requested conversion is not valid.

getObject

public Object getObject(String columnName,
                        Map map)
                 throws SQLException
Returns the value of a column as a Java Object.

Specified by:
getObject in interface ResultSet
Parameters:
columnName - The column name.
map - The type map. This is not used.
Returns:
The column value or null if the value is SQL NULL.
Throws:
SQLException - If the result set is not open, the cursor is not positioned on a row, the column index is not valid, the type map is null, or the requested conversion is not valid.

updateNull

public void updateNull(int column)
                throws SQLException
Updates a column in the current row using SQL NULL.

Specified by:
updateNull in interface ResultSet
Parameters:
column - The column index (1-based).
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateNull

public void updateNull(String columnName)
                throws SQLException
Updates a column in the current row using SQL NULL.

Specified by:
updateNull in interface ResultSet
Parameters:
columnName - The column name.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateByte

public void updateByte(int column,
                       byte x)
                throws SQLException
Updates a column in the current row using a Java byte value. The driver converts this to an SQL SMALLINT value.

Specified by:
updateByte in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateByte

public void updateByte(String columnName,
                       byte x)
                throws SQLException
Updates a column in the current row using a Java byte value. The driver converts this to an SQL SMALLINT value.

Specified by:
updateByte in interface ResultSet
Parameters:
columnName - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateBoolean

public void updateBoolean(int column,
                          boolean x)
                   throws SQLException
Updates a column in the current row using a Java boolean value.

Specified by:
updateBoolean in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateBoolean

public void updateBoolean(String columnName,
                          boolean x)
                   throws SQLException
Updates a column in the current row using a Java boolean value.

Specified by:
updateBoolean in interface ResultSet
Parameters:
columnName - The column name.
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateShort

public void updateShort(int column,
                        short x)
                 throws SQLException
Updates a column in the current row using a Java short value.

Specified by:
updateShort in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateShort

public void updateShort(String columnName,
                        short x)
                 throws SQLException
Updates a column in the current row using a Java short value.

Specified by:
updateShort in interface ResultSet
Parameters:
columnName - The column name.
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateInt

public void updateInt(int column,
                      int x)
               throws SQLException
Updates a column in the current row using a Java int value. The driver converts this to an SQL INTEGER value.

Specified by:
updateInt in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateInt

public void updateInt(String columnName,
                      int x)
               throws SQLException
Updates a column in the current row using a Java int value. The driver converts this to an SQL INTEGER value.

Specified by:
updateInt in interface ResultSet
Parameters:
columnName - The column name.
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateLong

public void updateLong(int column,
                       long x)
                throws SQLException
Updates a column in the current row using a Java long value.

Specified by:
updateLong in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateLong

public void updateLong(String columnName,
                       long x)
                throws SQLException
Updates a column in the current row using a Java long value.

Specified by:
updateLong in interface ResultSet
Parameters:
columnName - The column name.
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateFloat

public void updateFloat(int column,
                        float x)
                 throws SQLException
Updates a column in the current row using a Java float value. The driver converts this to an SQL REAL value.

Specified by:
updateFloat in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateFloat

public void updateFloat(String columnName,
                        float x)
                 throws SQLException
Updates a column in the current row using a Java float value. The driver converts this to an SQL REAL value.

Specified by:
updateFloat in interface ResultSet
Parameters:
columnName - The column name.
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateDouble

public void updateDouble(int column,
                         double x)
                  throws SQLException
Updates a column in the current row using a Java double value. The driver converts this to an SQL DOUBLE value.

Specified by:
updateDouble in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateDouble

public void updateDouble(String columnName,
                         double x)
                  throws SQLException
Updates a column in the current row using a Java double value. The driver converts this to an SQL DOUBLE value.

Specified by:
updateDouble in interface ResultSet
Parameters:
columnName - The column name.
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateBigDecimal

public void updateBigDecimal(int column,
                             BigDecimal x)
                      throws SQLException
Updates a column in the current row using a BigDecimal value. The driver converts this to an SQL NUMERIC value.

Specified by:
updateBigDecimal in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateBigDecimal

public void updateBigDecimal(String columnName,
                             BigDecimal x)
                      throws SQLException
Updates a column in the current row using a BigDecimal value. The driver converts this to an SQL NUMERIC value.

Specified by:
updateBigDecimal in interface ResultSet
Parameters:
columnName - The column name.
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateDate

public void updateDate(int column,
                       Date x)
                throws SQLException
Updates a column in the current row using a java.sql.Date value. The driver converts this to an SQL DATE value.

Specified by:
updateDate in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateDate

public void updateDate(String columnName,
                       Date x)
                throws SQLException
Updates a column in the current row using a java.sql.Date value. The driver converts this to an SQL DATE value.

Specified by:
updateDate in interface ResultSet
Parameters:
columnName - The column name.
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateTime

public void updateTime(int column,
                       Time x)
                throws SQLException
Updates a column in the current row using a java.sql.Time value. The driver converts this to an SQL TIME value.

Specified by:
updateTime in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateTime

public void updateTime(String columnName,
                       Time x)
                throws SQLException
Updates a column in the current row using a java.sql.Time value. The driver converts this to an SQL TIME value.

Specified by:
updateTime in interface ResultSet
Parameters:
columnName - The column name.
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateTimestamp

public void updateTimestamp(int column,
                            Timestamp x)
                     throws SQLException
Updates a column in the current row using a java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value.

Specified by:
updateTimestamp in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateTimestamp

public void updateTimestamp(String columnName,
                            Timestamp x)
                     throws SQLException
Updates a column in the current row using a java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value.

Specified by:
updateTimestamp in interface ResultSet
Parameters:
columnName - The column name.
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateBytes

public void updateBytes(int column,
                        byte[] x)
                 throws SQLException
Updates a column in the current row using a Java byte array value.

Specified by:
updateBytes in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateBytes

public void updateBytes(String columnName,
                        byte[] x)
                 throws SQLException
Updates a column in the current row using a Java byte array value.

Specified by:
updateBytes in interface ResultSet
Parameters:
columnName - The column name.
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateString

public void updateString(int column,
                         String x)
                  throws SQLException
Updates a column in the current row using a String value. The driver converts this to an SQL VARCHAR value.

Specified by:
updateString in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateString

public void updateString(String columnName,
                         String x)
                  throws SQLException
Updates a column in the current row using a String value. The driver converts this to an SQL VARCHAR value.

Specified by:
updateString in interface ResultSet
Parameters:
columnName - The column name.
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateBinaryStream

public void updateBinaryStream(int column,
                               InputStream x,
                               int length)
                        throws SQLException
Updates the designated column with a binary stream value, which will have the specified number of bytes.

Specified by:
updateBinaryStream in interface ResultSet
Parameters:
column - column index
x - the new column value
length - the length of the stream
Throws:
SQLException - if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream x,
                               int length)
                        throws SQLException
Updates the designated column with a binary stream value, which will have the specified number of bytes.

Specified by:
updateBinaryStream in interface ResultSet
Parameters:
columnName - column index
x - the new column value
length - the length of the stream
Throws:
SQLException - if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateAsciiStream

public void updateAsciiStream(int column,
                              InputStream x,
                              int length)
                       throws SQLException
Updates the designated column with an ascii stream value, which will have the specified number of bytes.

Specified by:
updateAsciiStream in interface ResultSet
Parameters:
column -
x - the new column value
length - the length of the stream
Throws:
SQLException - if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream x,
                              int length)
                       throws SQLException
Updates the designated column with an ascii stream value, which will have the specified number of bytes.

Specified by:
updateAsciiStream in interface ResultSet
Parameters:
columnName -
x - the new column value
length - the length of the stream
Throws:
SQLException - if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateCharacterStream

public void updateCharacterStream(int column,
                                  Reader x,
                                  int length)
                           throws SQLException
Updates a column in the current row using a Reader value. The driver reads the data from the Reader as needed until no more characters are available. The driver converts this to an SQL VARCHAR value.

Specified by:
updateCharacterStream in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value or null to update the value to SQL NULL.
length - The length.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid, the length is not valid, or an error happens while reading the input stream.

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader x,
                                  int length)
                           throws SQLException
Updates a column in the current row using a Reader value. The driver reads the data from the Reader as needed until no more characters are available. The driver converts this to an SQL VARCHAR value.

Specified by:
updateCharacterStream in interface ResultSet
Parameters:
columnName - The column name.
x - The column value or null to update the value to SQL NULL.
length - The length.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid, the length is not valid, or an error happens while reading the input stream.

updateBlob

public void updateBlob(int column,
                       Blob x)
                throws SQLException
Updates a column in the current row using a Java Blob value. The driver converts this to an SQL BLOB value.

Specified by:
updateBlob in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateBlob

public void updateBlob(String columnName,
                       Blob x)
                throws SQLException
Updates a column in the current row using a Java Blob value. The driver converts this to an SQL BLOB value.

Specified by:
updateBlob in interface ResultSet
Parameters:
columnName - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateClob

public void updateClob(int column,
                       Clob x)
                throws SQLException
Updates a column in the current row using a Java Clob value. The driver converts this to an SQL CLOB value.

Specified by:
updateClob in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateClob

public void updateClob(String columnName,
                       Clob x)
                throws SQLException
Updates a column in the current row using a Java Clob value. The driver converts this to an SQL CLOB value.

Specified by:
updateClob in interface ResultSet
Parameters:
columnName - The column name.
x - The column value.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateArray

public void updateArray(int column,
                        Array x)
                 throws SQLException
Updates the value of a column as an Array object.

Specified by:
updateArray in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value or null if the value is SQL NULL.
Throws:
SQLException

updateArray

public void updateArray(String columnName,
                        Array x)
                 throws SQLException
Updates the value of a column as an Array object.

Specified by:
updateArray in interface ResultSet
Parameters:
columnName - The column index (1-based).
x - The column value or null if the value is SQL NULL.
Throws:
SQLException

updateRef

public void updateRef(int column,
                      Ref x)
               throws SQLException
Updates the value of an SQL REF output parameter as a Ref value.

Specified by:
updateRef in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException

updateRef

public void updateRef(String columnName,
                      Ref x)
               throws SQLException
Updates the value of an SQL REF output parameter as a Ref value.

Specified by:
updateRef in interface ResultSet
Parameters:
columnName - The column index (1-based).
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException

updateObject

public void updateObject(int column,
                         Object x)
                  throws SQLException
Updates a column in the current row using an Object value. The driver converts this to a value of an SQL type, depending on the type of the specified value. The JDBC specification defines a standard mapping from Java types to SQL types.

Specified by:
updateObject in interface ResultSet
Parameters:
column - The column index (1-based).
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateObject

public void updateObject(String columnName,
                         Object x)
                  throws SQLException
Updates a column in the current row using an Object value. The driver converts this to a value of an SQL type, depending on the type of the specified value. The JDBC specification defines a standard mapping from Java types to SQL types.

Specified by:
updateObject in interface ResultSet
Parameters:
columnName - The column name.
x - The column value or null to update the value to SQL NULL.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateObject

public void updateObject(int column,
                         Object x,
                         int scale)
                  throws SQLException
Updates a column in the current row using an Object value. The driver converts this to a value of an SQL type, depending on the type of the specified value. The JDBC specification defines a standard mapping from Java types to SQL types.

Specified by:
updateObject in interface ResultSet
Parameters:
column - The column index.
x - The column value or null to update the value to SQL NULL.
scale - The scale.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

updateObject

public void updateObject(String columnName,
                         Object x,
                         int scale)
                  throws SQLException
Updates a column in the current row using an Object value. The driver converts this to a value of an SQL type, depending on the type of the specified value. The JDBC specification defines a standard mapping from Java types to SQL types.

Specified by:
updateObject in interface ResultSet
Parameters:
columnName - The column name.
x - The column value or null to update the value to SQL NULL.
scale - The scale.
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column index is not valid, or the requested conversion is not valid.

rowUpdated

public boolean rowUpdated()
                   throws SQLException
Indicates if the current row has been updated. This driver does not support this method.

Specified by:
rowUpdated in interface ResultSet
Returns:
Always false.
Throws:
SQLException - If an error occurs.

rowInserted

public boolean rowInserted()
                    throws SQLException
Indicates if the current row has been inserted. This driver does not support this method.

Specified by:
rowInserted in interface ResultSet
Returns:
Always false.
Throws:
SQLException - If an error occurs.

rowDeleted

public boolean rowDeleted()
                   throws SQLException
Indicates if the current row has been deleted. A result set of type TYPE_SCROLL_INSENSITIVE may contain rows that have been deleted.

Specified by:
rowDeleted in interface ResultSet
Returns:
true if current row has been deleted; false otherwise.
Throws:
SQLException - If an error occurs.

insertRow

public void insertRow()
               throws SQLException
Inserts the contents of the insert row into the result set and the database.

Specified by:
insertRow in interface ResultSet
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on the insert row, a column that is not nullable was not specified, or an error occurs.

updateRow

public void updateRow()
               throws SQLException
Cancels all pending updates that have been made since the last call to updateRow().

Specified by:
updateRow in interface ResultSet
Throws:
SQLException - If the result set is not open or the result set is not updatable.

deleteRow

public void deleteRow()
               throws SQLException
Deletes the current row from the result set and the database. After deleting a row, the cursor position is no longer valid, so it must be explicitly repositioned.

Specified by:
deleteRow in interface ResultSet
Throws:
SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the cursor is positioned on the insert row, or an error occurs.

refreshRow

public void refreshRow()
                throws SQLException
Refreshes the current row from the database.

Specified by:
refreshRow in interface ResultSet
Throws:
SQLException - If the result set is not open, the result set is not scrollable, the cursor is not positioned on a row, the cursor is positioned on the insert row or an error occurs.

cancelRowUpdates

public void cancelRowUpdates()
                      throws SQLException
Cancels all pending updates that have been made since the last call to updateRow().

Specified by:
cancelRowUpdates in interface ResultSet
Throws:
SQLException - If the result set is not open or the result set is not updatable.

moveToInsertRow

public void moveToInsertRow()
                     throws SQLException
Positions the cursor to the insert row.

Specified by:
moveToInsertRow in interface ResultSet
Throws:
SQLException - If the result set is not open, the result set is not scrollable, the result set is not updatable, or an error occurs.

moveToCurrentRow

public void moveToCurrentRow()
                      throws SQLException
Positions the cursor to the current row.

Specified by:
moveToCurrentRow in interface ResultSet
Throws:
SQLException - If the result set is not open, the result set is not scrollable, or an error occurs.

isClosed

public boolean isClosed()
                 throws SQLException
Indicates if the result set is closed.

Specified by:
isClosed in interface ResultSet
Returns:
true if this result set is closed; false otherwise.
Throws:
SQLException

getHoldability

public int getHoldability()
                   throws SQLException
Retrieves the holdability.

Specified by:
getHoldability in interface ResultSet
Throws:
SQLException - if a database error occurs

getNCharacterStream

public Reader getNCharacterStream(int column)
                           throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

Specified by:
getNCharacterStream in interface ResultSet
Parameters:
column -
Returns:
a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language.
Throws:
SQLException - if a database access error occurs

getNCharacterStream

public Reader getNCharacterStream(String columnName)
                           throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

Specified by:
getNCharacterStream in interface ResultSet
Parameters:
columnName -
Returns:
a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language.
Throws:
SQLException - if a database access error occurs

getNClob

public NClob getNClob(int column)
               throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.

Specified by:
getNClob in interface ResultSet
Parameters:
column -
Returns:
a NClob object representing the SQL NCLOB value in the specified column
Throws:
SQLException - if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurss

getNClob

public NClob getNClob(String columnName)
               throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.

Specified by:
getNClob in interface ResultSet
Parameters:
columnName -
Returns:
a NClob object representing the SQL NCLOB value in the specified column
Throws:
SQLException - if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurss

getNString

public String getNString(int column)
                  throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. It is intended for use when accessing NCHAR,NVARCHAR and LONGNVARCHAR columns.

Specified by:
getNString in interface ResultSet
Parameters:
column -
Returns:
the column value; if the value is SQL NULL, the value returned is null
Throws:
SQLException - if a database access error occurs

getNString

public String getNString(String columnName)
                  throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. It is intended for use when accessing NCHAR,NVARCHAR and LONGNVARCHAR columns.

Specified by:
getNString in interface ResultSet
Parameters:
columnName -
Returns:
the column value; if the value is SQL NULL, the value returned is null
Throws:
SQLException - if a database access error occurs

getRowId

public RowId getRowId(int column)
               throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.

Specified by:
getRowId in interface ResultSet
Parameters:
column - The column number
Returns:
the column value ; if the value is a SQL NULL the value returned is null
Throws:
SQLException - if a database access error occurs

getRowId

public RowId getRowId(String columnName)
               throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.

Specified by:
getRowId in interface ResultSet
Parameters:
columnName - The column name
Returns:
the column value ; if the value is a SQL NULL the value returned is null
Throws:
SQLException - if a database access error occurs

getSQLXML

public SQLXML getSQLXML(int column)
                 throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.

Specified by:
getSQLXML in interface ResultSet
Parameters:
column -
Returns:
a SQLXML object that maps an SQL XML value
Throws:
SQLException - if a database access error occurs

getSQLXML

public SQLXML getSQLXML(String columnName)
                 throws SQLException
Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.

Specified by:
getSQLXML in interface ResultSet
Parameters:
columnName -
Returns:
a SQLXML object that maps an SQL XML value
Throws:
SQLException - if a database access error occurs

updateAsciiStream

public void updateAsciiStream(int column,
                              InputStream x)
                       throws SQLException
Updates the designated column with an ascii stream value, which will have the specified number of bytes.

Specified by:
updateAsciiStream in interface ResultSet
Parameters:
column -
x - the new column value
Throws:
SQLException - if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream x)
                       throws SQLException
Updates the designated column with an ascii stream value, which will have the specified number of bytes.

Specified by:
updateAsciiStream in interface ResultSet
Parameters:
columnName -
x - the new column value
Throws:
SQLException - if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateAsciiStream

public void updateAsciiStream(int column,
                              InputStream x,
                              long length)
                       throws SQLException
Updates the designated column with an ascii stream value, which will have the specified number of bytes.

Specified by:
updateAsciiStream in interface ResultSet
Parameters:
column -
x - the new column value
length -
Throws:
SQLException - if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream x,
                              long length)
                       throws SQLException
Updates the designated column with an ascii stream value, which will have the specified number of bytes.

Specified by:
updateAsciiStream in interface ResultSet
Parameters:
columnName -
x - the new column value
length -
Throws:
SQLException - if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateBinaryStream

public void updateBinaryStream(int column,
                               InputStream x)
                        throws SQLException
Updates the designated column with a binary stream value.

Specified by:
updateBinaryStream in interface ResultSet
Parameters:
column -
x - the new column value
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream x)
                        throws SQLException
Updates the designated column with a binary stream value.

Specified by:
updateBinaryStream in interface ResultSet
Parameters:
columnName -
x - the new column value
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateBinaryStream

public void updateBinaryStream(int column,
                               InputStream x,
                               long length)
                        throws SQLException
Updates the designated column with a binary stream value.

Specified by:
updateBinaryStream in interface ResultSet
Parameters:
column -
x - the new column value
length -
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream x,
                               long length)
                        throws SQLException
Updates the designated column with a binary stream value.

Specified by:
updateBinaryStream in interface ResultSet
Parameters:
columnName -
x - the new column value
length -
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateBlob

public void updateBlob(int column,
                       InputStream x)
                throws SQLException
Updates the designated column using the given input stream. The data will be read from the stream as needed until end-of-stream is reached.

Specified by:
updateBlob in interface ResultSet
Parameters:
column -
x - An object that contains the data to set the parameter value to.
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateBlob

public void updateBlob(String columnName,
                       InputStream x)
                throws SQLException
Updates the designated column using the given input stream. The data will be read from the stream as needed until end-of-stream is reached.

Specified by:
updateBlob in interface ResultSet
Parameters:
columnName -
x - An object that contains the data to set the parameter value to.
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateBlob

public void updateBlob(int column,
                       InputStream x,
                       long length)
                throws SQLException
Updates the designated column using the given input stream. The data will be read from the stream as needed until end-of-stream is reached.

Specified by:
updateBlob in interface ResultSet
Parameters:
column -
x - An object that contains the data to set the parameter value to.
length -
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateBlob

public void updateBlob(String columnName,
                       InputStream x,
                       long length)
                throws SQLException
Updates the designated column using the given input stream. The data will be read from the stream as needed until end-of-stream is reached.

Specified by:
updateBlob in interface ResultSet
Parameters:
columnName -
x - An object that contains the data to set the parameter value to.
length -
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateCharacterStream

public void updateCharacterStream(int column,
                                  Reader x)
                           throws SQLException
Updates the designated column with a character stream value.

Specified by:
updateCharacterStream in interface ResultSet
Parameters:
column -
x - the new column value
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader x)
                           throws SQLException
Updates the designated column with a character stream value.

Specified by:
updateCharacterStream in interface ResultSet
Parameters:
columnName -
x - the new column value
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateCharacterStream

public void updateCharacterStream(int column,
                                  Reader x,
                                  long length)
                           throws SQLException
Updates the designated column with a character stream value.

Specified by:
updateCharacterStream in interface ResultSet
Parameters:
column -
x - the new column value
length -
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader x,
                                  long length)
                           throws SQLException
Updates the designated column with a character stream value.

Specified by:
updateCharacterStream in interface ResultSet
Parameters:
columnName -
x - the new column value
length -
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateClob

public void updateClob(int column,
                       Reader x)
                throws SQLException
Updates the designated column using the given Reader object.

Specified by:
updateClob in interface ResultSet
Parameters:
column -
x - An object that contains the data to set the parameter value to.
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateClob

public void updateClob(String columnName,
                       Reader x)
                throws SQLException
Updates the designated column using the given Reader object.

Specified by:
updateClob in interface ResultSet
Parameters:
columnName -
x - An object that contains the data to set the parameter value to.
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateClob

public void updateClob(int column,
                       Reader x,
                       long length)
                throws SQLException
Updates the designated column using the given Reader object.

Specified by:
updateClob in interface ResultSet
Parameters:
column -
x - An object that contains the data to set the parameter value to.
length -
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateClob

public void updateClob(String columnName,
                       Reader x,
                       long length)
                throws SQLException
Updates the designated column using the given Reader object.

Specified by:
updateClob in interface ResultSet
Parameters:
columnName -
x - An object that contains the data to set the parameter value to.
length -
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

updateNCharacterStream

public void updateNCharacterStream(int column,
                                   Reader x)
                            throws SQLException
Updates the designated column with a character stream value.

Specified by:
updateNCharacterStream in interface ResultSet
Parameters:
column -
x - the new column value
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateNCharacterStream

public void updateNCharacterStream(String columnName,
                                   Reader x)
                            throws SQLException
Updates the designated column with a character stream value.

Specified by:
updateNCharacterStream in interface ResultSet
Parameters:
columnName -
x - the new column value
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateNCharacterStream

public void updateNCharacterStream(int column,
                                   Reader x,
                                   long length)
                            throws SQLException
Updates the designated column with a character stream value.

Specified by:
updateNCharacterStream in interface ResultSet
Parameters:
column -
x - the new column value
length -
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateNCharacterStream

public void updateNCharacterStream(String columnName,
                                   Reader x,
                                   long length)
                            throws SQLException
Updates the designated column with a character stream value.

Specified by:
updateNCharacterStream in interface ResultSet
Parameters:
columnName -
x - the new column value
length -
Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateNClob

public void updateNClob(int column,
                        NClob x)
                 throws SQLException
Updates the designated column using the given Reader

Specified by:
updateNClob in interface ResultSet
Parameters:
column -
x - An object that contains the data to set the parameter value to.
Throws:
SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateNClob

public void updateNClob(String columnName,
                        NClob x)
                 throws SQLException
Updates the designated column using the given Reader

Specified by:
updateNClob in interface ResultSet
Parameters:
columnName -
x - An object that contains the data to set the parameter value to.
Throws:
SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateNClob

public void updateNClob(int column,
                        Reader x)
                 throws SQLException
Updates the designated column using the given Reader

Specified by:
updateNClob in interface ResultSet
Parameters:
column -
x - An object that contains the data to set the parameter value to.
Throws:
SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateNClob

public void updateNClob(String columnName,
                        Reader x)
                 throws SQLException
Updates the designated column using the given Reader

Specified by:
updateNClob in interface ResultSet
Parameters:
columnName -
x - An object that contains the data to set the parameter value to.
Throws:
SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateNClob

public void updateNClob(int column,
                        Reader x,
                        long length)
                 throws SQLException
Updates the designated column using the given Reader

Specified by:
updateNClob in interface ResultSet
Parameters:
column -
x - An object that contains the data to set the parameter value to.
length -
Throws:
SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateNClob

public void updateNClob(String columnName,
                        Reader x,
                        long length)
                 throws SQLException
Updates the designated column using the given Reader

Specified by:
updateNClob in interface ResultSet
Parameters:
columnName -
x - An object that contains the data to set the parameter value to.
length -
Throws:
SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateNString

public void updateNString(int column,
                          String x)
                   throws SQLException
Updates the designated column with a String value. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns.

Specified by:
updateNString in interface ResultSet
Parameters:
column -
x - The value for the column to be updated
Throws:
SQLException - if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs

updateNString

public void updateNString(String columnName,
                          String x)
                   throws SQLException
Updates the designated column with a String value. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns.

Specified by:
updateNString in interface ResultSet
Parameters:
columnName -
x - The value for the column to be updated
Throws:
SQLException - if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs

updateRowId

public void updateRowId(int column,
                        RowId x)
                 throws SQLException
Updates the designated column with a RowId value.

Specified by:
updateRowId in interface ResultSet
Parameters:
column -
x - the column value
Throws:
SQLException - if a database access occurs

updateRowId

public void updateRowId(String columnName,
                        RowId x)
                 throws SQLException
Updates the designated column with a RowId value.

Specified by:
updateRowId in interface ResultSet
Parameters:
columnName -
x - the column value
Throws:
SQLException - if a database access occurs

updateSQLXML

public void updateSQLXML(int column,
                         SQLXML x)
                  throws SQLException
Updates the designated column with a java.sql.SQLXML value.

Specified by:
updateSQLXML in interface ResultSet
Parameters:
column -
x - The value for the column to be updated
Throws:
SQLException - if a database access error occurs

updateSQLXML

public void updateSQLXML(String columnName,
                         SQLXML x)
                  throws SQLException
Updates the designated column with a java.sql.SQLXML value.

Specified by:
updateSQLXML in interface ResultSet
Parameters:
columnName -
x - The value for the column to be updated
Throws:
SQLException - if a database access error occurs

getValidWrappedList

protected String[] getValidWrappedList()

isWrapperFor

public boolean isWrapperFor(Class<?> iface)
                     throws SQLException
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. Returns false otherwise. If this implements the interface then return true, else if this is a wrapper then return the result of recursively calling isWrapperFor on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method should be implemented as a low-cost operation compared to unwrap so that callers can use this method to avoid expensive unwrap calls that may fail. If this method returns true then calling unwrap with the same argument should succeed.

Specified by:
isWrapperFor in interface Wrapper
Parameters:
iface - a Class defining an interface.
Returns:
true if this implements the interface or directly or indirectly wraps an object that does.
Throws:
SQLException - if an error occurs while determining whether this is a wrapper for an object with the given interface.

unwrap

public <T> T unwrap(Class<T> iface)
         throws SQLException
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. If the receiver implements the interface then the result is the receiver or a proxy for the receiver. If the receiver is a wrapper and the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object. Otherwise return the the result of calling unwrap recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does not implement the interface, then an SQLException is thrown.

Specified by:
unwrap in interface Wrapper
Parameters:
iface - A Class defining an interface that the result must implement.
Returns:
an object that implements the interface. May be a proxy for the actual implementing object.
Throws:
SQLException - If no object found that implements the interface