com.ibm.as400.access
Class AS400JDBCRowSet

java.lang.Object
  |
  +--com.ibm.as400.access.AS400JDBCRowSet
All Implemented Interfaces:
java.sql.ResultSet, javax.sql.RowSet, java.io.Serializable

public class AS400JDBCRowSet
extends java.lang.Object
implements javax.sql.RowSet, java.io.Serializable

The AS400JDBCRowSet class represents a connected rowset that encapsulates an JDBC result set. The database connection is maintained while in use.

Either the url or dataSourceName property must be set to specify how the database connection is established. The command property must be set to specify how to create the PreparedStatement.

This example creates an AS400JDBCRowSet object, populates it, and then updates its contents.

DriverManager.registerDriver(new AS400JDBCDriver()); AS400JDBCRowSet rowset = new AS400JDBCRowSet("jdbc:as400://mySystem","myUser", "myPassword"); // Set the command used to populate the list. rowset.setCommand("SELECT * FROM MYLIB.DATABASE"); // Populate the rowset. rowset.execute(); // Update the customer balances. while (rowset.next()) { double newBalance = rowset.getDouble("BALANCE") + july_statements.getPurchases(rowset.getString("CUSTNUM")); rowset.updateDouble("BALANCE", newBalance); rowset.updateRow(); }

This example creates an AS400JDBCRowSet object, sets the data source and command parameters and then populates it.

// Get the data source that is registered in JNDI (assumes JNDI environment is set). Context context = new InitialContext(); AS400JDBCDataSource dataSource = (AS400JDBCDataSource) context.lookup("jdbc/customer"); AS400JDBCRowSet rowset = new AS400JDBCRowSet(); rowset.setDataSourceName("jdbc/customer"); rowset.setUsername("myuser"); rowset.setPassword("myPasswd"); // Set the prepared statement and initialize the parameters. rowset.setCommand("SELECT * FROM MYLIBRARY.MYTABLE WHERE STATE = ? AND BALANCE > ?"); rowset.setString(1, "MINNESOTA"); rowset.setDouble(2, MAXIMUM_LIMIT); // Populate the rowset. rowset.execute();

AS400JDBCRowSet objects generate the following events:

See Also:
Serialized Form

Fields inherited from interface java.sql.ResultSet
CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE
 
Constructor Summary
AS400JDBCRowSet()
          Constructs a default AS400JDBCRowSet object.
AS400JDBCRowSet(java.lang.String dataSourceName)
          Constructs an AS400JDBCRowset with the specified dataSourceName.
AS400JDBCRowSet(java.lang.String url, java.lang.String username, java.lang.String password)
          Constructs an AS400JDBCRowSet with the specified parameters.
 
Method Summary
 boolean absolute(int rowNumber)
          Positions the cursor to an absolute row number.
 void addPropertyChangeListener(java.beans.PropertyChangeListener listener)
          Adds a PropertyChangeListener.
 void addRowSetListener(javax.sql.RowSetListener listener)
          Adds a RowSetListener to the list.
 void afterLast()
          Positions the cursor after the last row.
 void beforeFirst()
          Positions the cursor before the first row.
 void cancelRowUpdates()
          Cancels all pending updates that have been made since the last call to updateRow().
 void clearParameters()
          Clears the columns for the current row and releases all associated resources.
 void clearWarnings()
          Clears all warnings that have been reported for the result set.
 void close()
          Releases the rowset resources immediately instead of waiting for them to be automatically released.
 void deleteRow()
          Deletes the current row from the result set and the database.
 void execute()
          Executes the command and fills the rowset with data.
protected  void finalize()
          Closes the Statement and Connection.
 int findColumn(java.lang.String columnName)
          Returns the column index for the specified column name.
 boolean first()
          Positions the cursor to the first row.
 java.sql.Array getArray(int columnIndex)
          Returns the value of a column as an Array object.
 java.sql.Array getArray(java.lang.String columnName)
          Returns the value of a column as an Array object.
 java.io.InputStream getAsciiStream(int columnIndex)
          Returns the value of a column as a stream of ASCII characters.
 java.io.InputStream getAsciiStream(java.lang.String columnName)
          Returns the value of a column as a stream of ASCII characters.
 java.math.BigDecimal getBigDecimal(int columnIndex)
          Returns the value of a column as a BigDecimal object.
 java.math.BigDecimal getBigDecimal(int columnIndex, int scale)
          Deprecated. Use getBigDecimal(int) instead.
 java.math.BigDecimal getBigDecimal(java.lang.String columnName)
          Returns the value of a column as a BigDecimal object.
 java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale)
          Deprecated. Use getBigDecimal(String) instead.
 java.io.InputStream getBinaryStream(int columnIndex)
          Returns the value of a column as a stream of uninterpreted bytes.
 java.io.InputStream getBinaryStream(java.lang.String columnName)
          Returns the value of a column as a stream of uninterpreted bytes.
 java.sql.Blob getBlob(int columnIndex)
          Returns the value of a column as a Blob object.
 java.sql.Blob getBlob(java.lang.String columnName)
          Returns the value of a column as a Blob object.
 boolean getBoolean(int columnIndex)
          Returns the value of a column as a Java boolean value.
 boolean getBoolean(java.lang.String columnName)
          Returns the value of a column as a Java boolean value.
 byte getByte(int columnIndex)
          Returns the value of a column as a Java byte value.
 byte getByte(java.lang.String columnName)
          Returns the value of a column as a Java byte value.
 byte[] getBytes(int columnIndex)
          Returns the value of a column as a Java byte array.
 byte[] getBytes(java.lang.String columnName)
          Returns the value of a column as a Java byte array.
 java.io.Reader getCharacterStream(int columnIndex)
          Returns the value of a column as a character stream.
 java.io.Reader getCharacterStream(java.lang.String columnName)
          Returns the value of a column as a character stream.
 java.sql.Clob getClob(int columnIndex)
          Returns the value of a column as a Clob object.
 java.sql.Clob getClob(java.lang.String columnName)
          Returns the value of a column as a Clob object.
 java.lang.String getCommand()
          Returns the command used by the statement the generate the rowset.
 int getConcurrency()
          Returns the result set concurrency.
 javax.naming.Context getContext()
          Returns the JNDI naming context which provides name-to-object bindings and methods for retrieving and updating naming and directory services.
 java.lang.String getCursorName()
          Returns the name of the SQL cursor in use by the result set.
 java.lang.String getDataSourceName()
          Returns the name of the iSeries data source as identified in JNDI.
 java.sql.Date getDate(int columnIndex)
          Returns the value of a column as a java.sql.Date object using the default calendar.
 java.sql.Date getDate(int columnIndex, java.util.Calendar calendar)
          Returns the value of a column as a java.sql.Date object using a calendar other than the default.
 java.sql.Date getDate(java.lang.String columnName)
          Returns the value of a column as a java.sql.Date object using the default calendar.
 java.sql.Date getDate(java.lang.String columnName, java.util.Calendar calendar)
          Returns the value of a column as a java.sql.Date object using a calendar other than the default.
 double getDouble(int columnIndex)
          Returns the value of a column as a Java double value.
 double getDouble(java.lang.String columnName)
          Returns the value of a column as a Java double value.
 java.util.Hashtable getEnvironment()
          Returns a hashtable of standard JNDI environment properties.
 boolean getEscapeProcessing()
          Indicates if escape processing is enabled (default).
 int getFetchDirection()
          Returns the fetch direction.
 int getFetchSize()
          Returns the number of rows to be fetched from the database when more rows are needed.
 float getFloat(int columnIndex)
          Returns the value of a column as a Java float value.
 float getFloat(java.lang.String columnName)
          Returns the value of a column as a Java float value.
 int getInt(int columnIndex)
          Returns the value of a column as a Java int value.
 int getInt(java.lang.String columnName)
          Returns the value of a column as a Java int value.
 long getLong(int columnIndex)
          Returns the value of a column as a Java long value.
 long getLong(java.lang.String columnName)
          Returns the value of a column as a Java long value.
 int getMaxFieldSize()
          Returns the maximum column size.
 int getMaxRows()
          Returns the maximum number of rows for the rowset.
 java.sql.ResultSetMetaData getMetaData()
          Returns the ResultSetMetaData object that describes the result set's columns.
 java.lang.Object getObject(int columnIndex)
          Returns the value of a column as a Java Object.
 java.lang.Object getObject(int columnIndex, java.util.Map typeMap)
          Returns the value of a column as a Java Object.
 java.lang.Object getObject(java.lang.String columnName)
          Returns the value of a column as a Java Object.
 java.lang.Object getObject(java.lang.String columnName, java.util.Map typeMap)
          Returns the value of a column as a Java Object.
 java.lang.String getPassword()
          Returns the password used to create the connection.
 int getQueryTimeout()
          Returns the maximum wait time in seconds for a statement to execute.
 java.sql.Ref getRef(int columnIndex)
          Returns the value of a column as a Ref object.
 java.sql.Ref getRef(java.lang.String columnName)
          Returns the value of a column as a Ref object.
 int getRow()
          Returns the current row number.
 short getShort(int columnIndex)
          Returns the value of a column as a Java short value.
 short getShort(java.lang.String columnName)
          Returns the value of a column as a Java short value.
 java.sql.Statement getStatement()
          Returns the statement for this result set.
 java.lang.String getString(int columnIndex)
          Returns the value of a column as a String object.
 java.lang.String getString(java.lang.String columnName)
          Returns the value of a column as a String object.
 java.sql.Time getTime(int columnIndex)
          Returns the value of a column as a java.sql.Time object using the default calendar.
 java.sql.Time getTime(int columnIndex, java.util.Calendar calendar)
          Returns the value of a column as a java.sql.Time object using a calendar other than the default.
 java.sql.Time getTime(java.lang.String columnName)
          Returns the value of a column as a java.sql.Time object using the default calendar.
 java.sql.Time getTime(java.lang.String columnName, java.util.Calendar calendar)
          Returns the value of a column as a java.sql.Time object using a calendar other than the default.
 java.sql.Timestamp getTimestamp(int columnIndex)
          Returns the value of a column as a java.sql.Timestamp object using the default calendar.
 java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar calendar)
          Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default.
 java.sql.Timestamp getTimestamp(java.lang.String columnName)
          Returns the value of a column as a java.sql.Timestamp object using the default calendar.
 java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar calendar)
          Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default.
 int getTransactionIsolation()
          Returns the transaction isolation level.
 int getType()
          Returns the result set type.
 java.util.Map getTypeMap()
          Returns the type map.
 java.io.InputStream getUnicodeStream(int columnIndex)
          Deprecated. Use getCharacterStream(int) instead.
 java.io.InputStream getUnicodeStream(java.lang.String columnName)
          Deprecated. Use getCharacterStream(String) instead.
 java.lang.String getUrl()
          Returns the url used in getting a connection.
 java.net.URL getURL(int columnIndex)
          Returns the value of an SQL DATALINK output parameter as a java.net.URL object.
 java.net.URL getURL(java.lang.String columnName)
          Returns the value of an SQL DATALINK output parameter as a java.net.URL object.
 java.lang.String getUsername()
          Returns the user used to create the connection.
 java.sql.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 isFirst()
          Indicates if the cursor is positioned on the first row.
 boolean isLast()
          Indicates if the cursor is positioned on the last row.
 boolean isReadOnly()
          Indicates if the rowset is read-only.
 boolean isUseDataSource()
          Indicates if the data source is used to make a connection to the database.
 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 and cancels all pending updates that have been made since the last call to updateRow().
 boolean relative(int rowNumber)
          Positions the cursor to a relative row number.
 void removePropertyChangeListener(java.beans.PropertyChangeListener listener)
          Removes a PropertyChangeListener.
 void removeRowSetListener(javax.sql.RowSetListener listener)
          Removes the RowSetListener from the list.
 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 setArray(int parameterIndex, java.sql.Array value)
          Sets the array value at the specified parameterIndex.
 void setAsciiStream(int parameterIndex, java.io.InputStream inputStream, int length)
          Sets the inputStream at the specified parameterIndex.
 void setBigDecimal(int parameterIndex, java.math.BigDecimal value)
          Sets the BigDecimal value at the specified parameterIndex.
 void setBinaryStream(int parameterIndex, java.io.InputStream inputStream, int length)
          Sets the binary stream value using a inputStream at the specified parameterIndex.
 void setBlob(int parameterIndex, java.sql.Blob value)
          Sets the Blob value at the specified parameterIndex.
 void setBoolean(int parameterIndex, boolean value)
          Sets the boolean value at the specified parameterIndex.
 void setByte(int parameterIndex, byte value)
          Sets the byte value at the specified parameterIndex.
 void setBytes(int parameterIndex, byte[] value)
          Sets the byte array value at the specified parameterIndex.
 void setCharacterStream(int parameterIndex, java.io.Reader reader, int length)
          Sets a column in the current row using a Reader value.
 void setClob(int parameterIndex, java.sql.Clob value)
          Sets the Clob value at the specified parameterIndex.
 void setCommand(java.lang.String command)
          Sets the command used by the execute statement to populate the rowset.
 void setConcurrency(int concurrency)
          Sets the concurrency type for the result set.
 void setContext(javax.naming.Context context)
          Sets the JNDI naming context which provides name-to-object bindings and methods for retrieving and updating naming and directory services.
 void setDataSourceName(java.lang.String dataSourceName)
          Sets the name of the iSeries data source.
 void setDate(int parameterIndex, java.sql.Date value)
          Sets the Date value at the specified parameterIndex.
 void setDate(int parameterIndex, java.sql.Date value, java.util.Calendar calendar)
          Sets the Date value at the specified parameterIndex.
 void setDouble(int parameterIndex, double value)
          Sets the double value at the specified parameterIndex.
 void setEnvironment(java.util.Hashtable environment)
          Sets the standard JNDI environment properties.
 void setEscapeProcessing(boolean enable)
          Sets whether the escape scanning is enabled for escape substitution processing.
 void setFetchDirection(int fetchDirection)
          Sets the direction in which the rows in a result set are processed.
 void setFetchSize(int fetchSize)
          Sets the number of rows to be fetched from the database when more rows are needed.
 void setFloat(int parameterIndex, float value)
          Sets the float value at the specified parameterIndex.
 void setInt(int parameterIndex, int value)
          Sets the integer value at the specified parameterIndex.
 void setLong(int parameterIndex, long value)
          Sets the long value at the specified parameterIndex.
 void setMaxFieldSize(int maxFieldSize)
          Sets the maximum column size.
 void setMaxRows(int maxRows)
          Sets the maximum row limit for the rowset.
 void setNull(int parameterIndex, int sqlType)
          Sets the type at the specified parameterIndex to SQL NULL.
 void setNull(int parameterIndex, int sqlType, java.lang.String typeName)
          Sets the user-named type or REF type at the specified parameterIndex to SQL NULL.
 void setObject(int parameterIndex, java.lang.Object value)
          Sets the object value at the specified parameterIndex.
 void setObject(int parameterIndex, java.lang.Object value, int targetSqlType)
          Sets the object value at the specified parameterIndex.
 void setObject(int parameterIndex, java.lang.Object value, int targetSqlType, int scale)
          Sets the object value at the specified parameterIndex.
 void setPassword(java.lang.String password)
          Sets the password used to make the connection.
 void setQueryTimeout(int timeout)
          Sets the maximum wait time in seconds for a statement to execute.
 void setReadOnly(boolean readOnly)
          Sets whether the rowset is read-only.
 void setRef(int parameterIndex, java.sql.Ref value)
          Sets Ref value at the specified parameterIndex.
 void setShort(int parameterIndex, short value)
          Sets the short value at the specified parameterIndex.
 void setString(int parameterIndex, java.lang.String value)
          Sets the string value at the specified parameterIndex.
 void setTime(int parameterIndex, java.sql.Time value)
          Sets the time value at the specified parameterIndex.
 void setTime(int parameterIndex, java.sql.Time value, java.util.Calendar calendar)
          Sets the time value at the specified parameterIndex.
 void setTimestamp(int parameterIndex, java.sql.Timestamp value)
          Sets the timestamp value at the specified parameterIndex.
 void setTimestamp(int parameterIndex, java.sql.Timestamp value, java.util.Calendar calendar)
          Sets the timestamp value at the specified parameterIndex.
 void setTransactionIsolation(int level)
          Sets the transaction isolation level.
 void setType(int type)
          Sets the result set type.
 void setTypeMap(java.util.Map map)
          Sets the type map to be used for distinct and structured types.
 void setUrl(java.lang.String url)
          Sets the URL used for getting a connection.
 void setUseDataSource(boolean useDataSource)
          Sets whether the data source is used to make a connection to the database.
 void setUsername(java.lang.String username)
          Sets the user name used to make the connection.
 java.lang.String toString()
          Returns the name of the SQL cursor in use by the result set.
 void updateArray(int columnIndex, java.sql.Array columnValue)
          Updates a column in the current row using an Array value.
 void updateArray(java.lang.String columnName, java.sql.Array columnValue)
          Updates a column in the current row using an Array value.
 void updateAsciiStream(int columnIndex, java.io.InputStream columnValue, int length)
          Updates a column in the current row using an ASCII stream value.
 void updateAsciiStream(java.lang.String columnName, java.io.InputStream columnValue, int length)
          Updates a column in the current row using an ASCII stream value.
 void updateBigDecimal(int columnIndex, java.math.BigDecimal columnValue)
          Updates a column in the current row using a BigDecimal value.
 void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal columnValue)
          Updates a column in the current row using a BigDecimal value.
 void updateBinaryStream(int columnIndex, java.io.InputStream columnValue, int length)
          Updates a column in the current row using a binary stream value.
 void updateBinaryStream(java.lang.String columnName, java.io.InputStream columnValue, int length)
          Updates a column in the current row using a binary stream value.
 void updateBlob(int columnIndex, java.sql.Blob columnValue)
          Updates a column in the current row using a Java Blob value.
 void updateBlob(java.lang.String columnName, java.sql.Blob columnValue)
          Updates a column in the current row using a Java Blob value.
 void updateBoolean(int columnIndex, boolean columnValue)
          Updates a column in the current row using a Java boolean value.
 void updateBoolean(java.lang.String columnName, boolean columnValue)
          Updates a column in the current row using a Java boolean value.
 void updateByte(int columnIndex, byte columnValue)
          Updates a column in the current row using a Java byte value.
 void updateByte(java.lang.String columnName, byte columnValue)
          Updates a column in the current row using a Java byte value.
 void updateBytes(int columnIndex, byte[] columnValue)
          Updates a column in the current row using a Java byte array value.
 void updateBytes(java.lang.String columnName, byte[] columnValue)
          Updates a column in the current row using a Java byte array value.
 void updateCharacterStream(int columnIndex, java.io.Reader columnValue, int length)
          Updates a column in the current row using a Reader value.
 void updateCharacterStream(java.lang.String columnName, java.io.Reader columnValue, int length)
          Updates a column in the current row using a Reader value.
 void updateClob(int columnIndex, java.sql.Clob columnValue)
          Updates a column in the current row using a Java Clob value.
 void updateClob(java.lang.String columnName, java.sql.Clob columnValue)
          Updates a column in the current row using a Java Clob value.
 void updateDate(int columnIndex, java.sql.Date columnValue)
          Updates a column in the current row using a java.sql.Date value.
 void updateDate(java.lang.String columnName, java.sql.Date columnValue)
          Updates a column in the current row using a java.sql.Date value.
 void updateDouble(int columnIndex, double columnValue)
          Updates a column in the current row using a Java double value.
 void updateDouble(java.lang.String columnName, double columnValue)
          Updates a column in the current row using a Java double value.
 void updateFloat(int columnIndex, float columnValue)
          Updates a column in the current row using a Java float value.
 void updateFloat(java.lang.String columnName, float columnValue)
          Updates a column in the current row using a Java float value.
 void updateInt(int columnIndex, int columnValue)
          Updates a column in the current row using a Java int value.
 void updateInt(java.lang.String columnName, int columnValue)
          Updates a column in the current row using a Java int value.
 void updateLong(int columnIndex, long columnValue)
          Updates a column in the current row using a Java long value.
 void updateLong(java.lang.String columnName, long columnValue)
          Updates a column in the current row using a Java long value.
 void updateNull(int columnIndex)
          Updates a column in the current row using SQL NULL.
 void updateNull(java.lang.String columnName)
          Updates a column in the current row using SQL NULL.
 void updateObject(int columnIndex, java.lang.Object columnValue)
          Updates a column in the current row using an Object value.
 void updateObject(int columnIndex, java.lang.Object columnValue, int scale)
          Updates a column in the current row using an Object value.
 void updateObject(java.lang.String columnName, java.lang.Object columnValue)
          Updates a column in the current row using an Object value.
 void updateObject(java.lang.String columnName, java.lang.Object columnValue, int scale)
          Updates a column in the current row using an Object value.
 void updateRef(int columnIndex, java.sql.Ref columnValue)
          Updates a column in the current row using an Ref value.
 void updateRef(java.lang.String columnName, java.sql.Ref columnValue)
          Updates a column in the current row using an Ref value.
 void updateRow()
          Updates the database with the new contents of the current row.
 void updateShort(int columnIndex, short columnValue)
          Updates a column in the current row using a Java short value.
 void updateShort(java.lang.String columnName, short columnValue)
          Updates a column in the current row using a Java short value.
 void updateString(int columnIndex, java.lang.String columnValue)
          Updates a column in the current row using a String value.
 void updateString(java.lang.String columnName, java.lang.String columnValue)
          Updates a column in the current row using a String value.
 void updateTime(int columnIndex, java.sql.Time columnValue)
          Updates a column in the current row using a java.sql.Time value.
 void updateTime(java.lang.String columnName, java.sql.Time columnValue)
          Updates a column in the current row using a java.sql.Time value.
 void updateTimestamp(int columnIndex, java.sql.Timestamp columnValue)
          Updates a column in the current row using a java.sql.Timestamp value.
 void updateTimestamp(java.lang.String columnName, java.sql.Timestamp columnValue)
          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, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

AS400JDBCRowSet

public AS400JDBCRowSet()
Constructs a default AS400JDBCRowSet object.

AS400JDBCRowSet

public AS400JDBCRowSet(java.lang.String dataSourceName)
Constructs an AS400JDBCRowset with the specified dataSourceName.
Parameters:
dataSourceName - The name of the data source used to make the connection.

AS400JDBCRowSet

public AS400JDBCRowSet(java.lang.String url,
                       java.lang.String username,
                       java.lang.String password)
Constructs an AS400JDBCRowSet with the specified parameters.
Parameters:
url - The url used to make the connection.
username - The user name.
password - The password.
Method Detail

absolute

public boolean absolute(int rowNumber)
                 throws java.sql.SQLException
Positions the cursor to an absolute 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.

If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.

Specified by:
absolute in interface java.sql.ResultSet
Parameters:
rowNumber - The absolute row number (1-based). 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:
java.sql.SQLException - If the result set is not open, the result set is not scrollable, the row number is 0, or an error occurs.

addPropertyChangeListener

public void addPropertyChangeListener(java.beans.PropertyChangeListener listener)
Adds a PropertyChangeListener.
Parameters:
listener - The PropertyChangeListener.
See Also:
removePropertyChangeListener(java.beans.PropertyChangeListener)

addRowSetListener

public void addRowSetListener(javax.sql.RowSetListener listener)
Adds a RowSetListener to the list.
Specified by:
addRowSetListener in interface javax.sql.RowSet
Parameters:
listener - The RowSetListener object.

afterLast

public void afterLast()
               throws java.sql.SQLException
Positions the cursor after the last row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
Specified by:
afterLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException - If the result set is not open, the result set is not scrollable, or an error occurs.

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException
Positions the cursor before the first row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
Specified by:
beforeFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException - If the result set is not open, the result set is not scrollable, or an error occurs.

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException
Cancels all pending updates that have been made since the last call to updateRow(). If no updates have been made or updateRow() has already been called, then this method has no effect.
Specified by:
cancelRowUpdates in interface java.sql.ResultSet
Throws:
java.sql.SQLException - If the result set is not open or the result set is not updatable.

clearParameters

public void clearParameters()
                     throws java.sql.SQLException
Clears the columns for the current row and releases all associated resources.
Specified by:
clearParameters in interface javax.sql.RowSet
Throws:
java.sql.SQLException - If a database error occurs.

clearWarnings

public void clearWarnings()
                   throws java.sql.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 java.sql.ResultSet
Throws:
java.sql.SQLException - If an error occurs.

close

public void close()
           throws java.sql.SQLException
Releases the rowset resources immediately instead of waiting for them to be automatically released. This closes the connection to the database.
Specified by:
close in interface java.sql.ResultSet
Throws:
java.sql.SQLException - If an error occurs.

deleteRow

public void deleteRow()
               throws java.sql.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 java.sql.ResultSet
Throws:
java.sql.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.

execute

public void execute()
             throws java.sql.SQLException
Executes the command and fills the rowset with data. Any previous contents are erased. The following properties may be used to create a connection for reading data: The following properties may be used to create a statement to execute a command:
Specified by:
execute in interface javax.sql.RowSet
Throws:
java.sql.SQLException - If a database error occurs.

finalize

protected void finalize()
                 throws java.sql.SQLException
Closes the Statement and Connection.
Overrides:
finalize in class java.lang.Object
Throws:
java.sql.SQLException - If a database error occurs.

findColumn

public int findColumn(java.lang.String columnName)
               throws java.sql.SQLException
Returns the column index for the specified column name.
Specified by:
findColumn in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column index (1-based).
Throws:
java.sql.SQLException - If the result set is not open or the column name is not found.

first

public boolean first()
              throws java.sql.SQLException
Positions the cursor to the first row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
Specified by:
first in interface java.sql.ResultSet
Returns:
true if the requested cursor position is valid; false otherwise.
Throws:
java.sql.SQLException - If the result set is not open, the result set is not scrollable, or an error occurs.

getArray

public java.sql.Array getArray(int columnIndex)
                        throws java.sql.SQLException
Returns the value of a column as an Array object. DB2 UDB for iSeries does not support arrays.
Specified by:
getArray in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - Always thrown because DB2 UDB for iSeries does not support arrays.

getArray

public java.sql.Array getArray(java.lang.String columnName)
                        throws java.sql.SQLException
Returns the value of a column as an Array object. DB2 UDB for iSeries does not support arrays.
Specified by:
getArray in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - Always thrown because DB2 UDB for iSeries does not support arrays.

getAsciiStream

public java.io.InputStream getAsciiStream(int columnIndex)
                                   throws java.sql.SQLException
Returns the value of a column as a stream of ASCII characters. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.io.InputStream getAsciiStream(java.lang.String columnName)
                                   throws java.sql.SQLException
Returns the value of a column as a stream of ASCII characters. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.math.BigDecimal getBigDecimal(int columnIndex)
                                   throws java.sql.SQLException
Returns the value of a column as a BigDecimal object. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.math.BigDecimal getBigDecimal(java.lang.String columnName)
                                   throws java.sql.SQLException
Returns the value of a column as a BigDecimal object. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.math.BigDecimal getBigDecimal(int columnIndex,
                                          int scale)
                                   throws java.sql.SQLException
Deprecated. Use getBigDecimal(int) instead.

Returns the value of a column as a BigDecimal object. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnIndex - 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:
java.sql.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 java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                          int scale)
                                   throws java.sql.SQLException
Deprecated. Use getBigDecimal(String) instead.

Returns the value of a column as a BigDecimal object. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getBigDecimal in interface java.sql.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:
java.sql.SQLException - If the result set is not open, the cursor is not positioned on a row, the column name is not found, the scale is not valid, or the requested conversion is not valid.
See Also:
getBigDecimal(String)

getBinaryStream

public java.io.InputStream getBinaryStream(int columnIndex)
                                    throws java.sql.SQLException
Returns the value of a column as a stream of uninterpreted bytes. This can be used to get values from columns with SQL types BINARY, VARBINARY, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.io.InputStream getBinaryStream(java.lang.String columnName)
                                    throws java.sql.SQLException
Returns the value of a column as a stream of uninterpreted bytes. This can be used to get values from columns with SQL types BINARY, VARBINARY, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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.

getBlob

public java.sql.Blob getBlob(int columnIndex)
                      throws java.sql.SQLException
Returns the value of a column as a Blob object. This can be used to get values from columns with SQL types BINARY, VARBINARY, and BLOB.
Specified by:
getBlob in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.sql.Blob getBlob(java.lang.String columnName)
                      throws java.sql.SQLException
Returns the value of a column as a Blob object. This can be used to get values from columns with SQL types BINARY, VARBINARY, and BLOB.
Specified by:
getBlob in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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.

getBoolean

public boolean getBoolean(int columnIndex)
                   throws java.sql.SQLException
Returns the value of a column as a Java boolean value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or false if the value is SQL NULL.
Throws:
java.sql.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(java.lang.String columnName)
                   throws java.sql.SQLException
Returns the value of a column as a Java boolean value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or false if the value is SQL NULL.
Throws:
java.sql.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.

getByte

public byte getByte(int columnIndex)
             throws java.sql.SQLException
Returns the value of a column as a Java byte value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getByte in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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(java.lang.String columnName)
             throws java.sql.SQLException
Returns the value of a column as a Java byte value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getByte in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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.

getBytes

public byte[] getBytes(int columnIndex)
                throws java.sql.SQLException
Returns the value of a column as a Java byte array. This can be used to get values from columns with SQL types BINARY and VARBINARY.

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

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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(java.lang.String columnName)
                throws java.sql.SQLException
Returns the value of a column as a Java byte array. This can be used to get values from columns with SQL types BINARY and VARBINARY.

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

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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.

getCharacterStream

public java.io.Reader getCharacterStream(int columnIndex)
                                  throws java.sql.SQLException
Returns the value of a column as a character stream. This can be used to to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
Specified by:
getCharacterStream in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.io.Reader getCharacterStream(java.lang.String columnName)
                                  throws java.sql.SQLException
Returns the value of a column as a character stream. This can be used to to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
Specified by:
getCharacterStream in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - If the result set is not open, the cursor is not positioned on a row, the column name is not valid, or the requested conversion is not valid.

getClob

public java.sql.Clob getClob(int columnIndex)
                      throws java.sql.SQLException
Returns the value of a column as a Clob object. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, BLOB, and CLOB.
Specified by:
getClob in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.sql.Clob getClob(java.lang.String columnName)
                      throws java.sql.SQLException
Returns the value of a column as a Clob object. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, BLOB, and CLOB.
Specified by:
getClob in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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.

getCommand

public java.lang.String getCommand()
Returns the command used by the statement the generate the rowset. This should be set before calling the execute method.
Specified by:
getCommand in interface javax.sql.RowSet
Returns:
The command. The default value is null.

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException
Returns the result set concurrency.
Specified by:
getConcurrency in interface java.sql.ResultSet
Returns:
The result set concurrency. Valid values are:
  • ResultSet.CONCUR_READ_ONLY
  • ResultSet.CONCUR_UPDATABLE
Throws:
java.sql.SQLException - If the result set is not open.

getContext

public javax.naming.Context getContext()
Returns the JNDI naming context which provides name-to-object bindings and methods for retrieving and updating naming and directory services.
Returns:
The context or null if the value has not been set.

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException
Returns the name of the SQL cursor in use by the result set. In SQL, results are retrieved through a named cursor. The current row of a result can be updated or deleted using a positioned UPDATE or DELETE statement that references a cursor name.
Specified by:
getCursorName in interface java.sql.ResultSet
Returns:
The cursor name.
Throws:
java.sql.SQLException - If the result is not open.

getDataSourceName

public java.lang.String getDataSourceName()
Returns the name of the iSeries data source as identified in JNDI.
Specified by:
getDataSourceName in interface javax.sql.RowSet
Returns:
The data source name. The default value is null.

getDate

public java.sql.Date getDate(int columnIndex)
                      throws java.sql.SQLException
Returns the value of a column as a java.sql.Date object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.
Specified by:
getDate in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.sql.Date getDate(java.lang.String columnName)
                      throws java.sql.SQLException
Returns the value of a column as a java.sql.Date object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.
Specified by:
getDate in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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.

getDate

public java.sql.Date getDate(int columnIndex,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
Returns the value of a column as a java.sql.Date object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.
Specified by:
getDate in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.sql.Date getDate(java.lang.String columnName,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
Returns the value of a column as a java.sql.Date object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.
Specified by:
getDate in interface java.sql.ResultSet
Parameters:
columnName - The column name.
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - If the result set is not open, the cursor is not positioned on a row, the column name is not found, the calendar is null, or the requested conversion is not valid.

getDouble

public double getDouble(int columnIndex)
                 throws java.sql.SQLException
Returns the value of a column as a Java double value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getDouble in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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(java.lang.String columnName)
                 throws java.sql.SQLException
Returns the value of a column as a Java double value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getDouble in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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.

getEnvironment

public java.util.Hashtable getEnvironment()
Returns a hashtable of standard JNDI environment properties.
Returns:
The environment properties or null if the value has not been set.

getEscapeProcessing

public boolean getEscapeProcessing()
Indicates if escape processing is enabled (default). If enabled, escape substitution is done before committing the data.
Specified by:
getEscapeProcessing in interface javax.sql.RowSet
Returns:
true if enabled; false otherwise.

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException
Returns the fetch direction.
Specified by:
getFetchDirection in interface java.sql.ResultSet
Returns:
The fetch direction. Valid values are:
  • ResultSet.FETCH_FORWARD (default)
  • ResultSet.FETCH_REVERSE
  • ResultSet.FETCH_UNKNOWN
Throws:
java.sql.SQLException - If the result is not open.

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException
Returns the number of rows to be fetched from the database when more rows are needed. The number of rows specified only affects result sets created using this statement. If the value specified is zero, then the driver will choose an appropriate fetch size. This setting only affects statements that meet the criteria specified in the "block criteria" property. The fetch size is only used if the "block size" property is set to "0".
Specified by:
getFetchSize in interface java.sql.ResultSet
Returns:
The fetch size.
Throws:
java.sql.SQLException - If the result is not open.

getFloat

public float getFloat(int columnIndex)
               throws java.sql.SQLException
Returns the value of a column as a Java float value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getFloat in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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(java.lang.String columnName)
               throws java.sql.SQLException
Returns the value of a column as a Java float value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getFloat in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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(int columnIndex)
           throws java.sql.SQLException
Returns the value of a column as a Java int value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getInt in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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(java.lang.String columnName)
           throws java.sql.SQLException
Returns the value of a column as a Java int value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getInt in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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 columnIndex)
             throws java.sql.SQLException
Returns the value of a column as a Java long value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getLong in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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(java.lang.String columnName)
             throws java.sql.SQLException
Returns the value of a column as a Java long value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getLong in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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.

getMaxFieldSize

public int getMaxFieldSize()
                    throws java.sql.SQLException
Returns the maximum column size. This property is only used with column types:
Specified by:
getMaxFieldSize in interface javax.sql.RowSet
Returns:
The maximum size. The default zero of zero indicates no maximum.
Throws:
java.sql.SQLException - If a database error occurs.

getMaxRows

public int getMaxRows()
               throws java.sql.SQLException
Returns the maximum number of rows for the rowset.
Specified by:
getMaxRows in interface javax.sql.RowSet
Returns:
The maximum. The default value of zero indicates no maximum.
Throws:
java.sql.SQLException - If a database error occurs.

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException
Returns the ResultSetMetaData object that describes the result set's columns.
Specified by:
getMetaData in interface java.sql.ResultSet
Returns:
The metadata object.
Throws:
java.sql.SQLException - If an error occurs.

getObject

public java.lang.Object getObject(int columnIndex)
                           throws java.sql.SQLException
Returns the value of a column as a Java Object. This can be used to get values from columns with all SQL types. If the column is a user-defined type, then the connection's type map is used to created the object.
Specified by:
getObject in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.lang.Object getObject(java.lang.String columnName)
                           throws java.sql.SQLException
Returns the value of a column as a Java Object. This can be used to get values from columns with all SQL types. If the column is a user-defined type, then the connection's type map is used to created the object.
Specified by:
getObject in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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.

getObject

public java.lang.Object getObject(int columnIndex,
                                  java.util.Map typeMap)
                           throws java.sql.SQLException
Returns the value of a column as a Java Object.
Specified by:
getObject in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
typeMap - The type map. This is not used.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.lang.Object getObject(java.lang.String columnName,
                                  java.util.Map typeMap)
                           throws java.sql.SQLException
Returns the value of a column as a Java Object.
Specified by:
getObject in interface java.sql.ResultSet
Parameters:
columnName - The column name.
typeMap - The type map. This is not used.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - If the result set is not open, the cursor is not positioned on a row, the column name is not found, the type map is null, or the requested conversion is not valid.

getPassword

public java.lang.String getPassword()
Returns the password used to create the connection.
Specified by:
getPassword in interface javax.sql.RowSet
Returns:
An empty String. For security the password information cannot be accessed.

getQueryTimeout

public int getQueryTimeout()
                    throws java.sql.SQLException
Returns the maximum wait time in seconds for a statement to execute.
Specified by:
getQueryTimeout in interface javax.sql.RowSet
Returns:
The timeout value in seconds. The default value of zero indicates no maximum.
Throws:
java.sql.SQLException - If a database error occurs.

getRef

public java.sql.Ref getRef(int columnIndex)
                    throws java.sql.SQLException
Returns the value of a column as a Ref object. DB2 UDB for iSeries does not support structured types.
Specified by:
getRef in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - Always thrown because DB2 UDB for iSeries does not support structured types.

getRef

public java.sql.Ref getRef(java.lang.String columnName)
                    throws java.sql.SQLException
Returns the value of a column as a Ref object. DB2 UDB for iSeries does not support structured types.
Specified by:
getRef in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - Always thrown because DB2 UDB for iSeries does not support structured types.

getRow

public int getRow()
           throws java.sql.SQLException
Returns the current row number.
Specified by:
getRow in interface java.sql.ResultSet
Returns:
The current row number (1-based). If there is no current row or if the cursor is positioned on the insert row, 0 is returned.
Throws:
java.sql.SQLException - If the result set is not open.

getShort

public short getShort(int columnIndex)
               throws java.sql.SQLException
Returns the value of a column as a Java short value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getShort in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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(java.lang.String columnName)
               throws java.sql.SQLException
Returns the value of a column as a Java short value. This can be used to get values from columns with SQL types SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, CHAR, and VARCHAR.
Specified by:
getShort in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or 0 if the value is SQL NULL.
Throws:
java.sql.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.

getStatement

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

getString

public java.lang.String getString(int columnIndex)
                           throws java.sql.SQLException
Returns the value of a column as a String object. This can be used to get values from columns with any SQL type.
Specified by:
getString in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.lang.String getString(java.lang.String columnName)
                           throws java.sql.SQLException
Returns the value of a column as a String object. This can be used to get values from columns with any SQL type.
Specified by:
getString in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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.

getTime

public java.sql.Time getTime(int columnIndex)
                      throws java.sql.SQLException
Returns the value of a column as a java.sql.Time object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, TIME, and TIMESTAMP.
Specified by:
getTime in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.sql.Time getTime(java.lang.String columnName)
                      throws java.sql.SQLException
Returns the value of a column as a java.sql.Time object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, TIME, and TIMESTAMP.
Specified by:
getTime in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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.

getTime

public java.sql.Time getTime(int columnIndex,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
Returns the value of a column as a java.sql.Time object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, TIME, and TIMESTAMP.
Specified by:
getTime in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.sql.Time getTime(java.lang.String columnName,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException
Returns the value of a column as a java.sql.Time object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, TIME, and TIMESTAMP.
Specified by:
getTime in interface java.sql.ResultSet
Parameters:
columnName - The column name.
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - If the result set is not open, the cursor is not positioned on a row, the column name is not found, the calendar is null, or the requested conversion is not valid.

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex)
                                throws java.sql.SQLException
Returns the value of a column as a java.sql.Timestamp object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.
Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.sql.Timestamp getTimestamp(java.lang.String columnName)
                                throws java.sql.SQLException
Returns the value of a column as a java.sql.Timestamp object using the default calendar. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.
Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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.

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex,
                                       java.util.Calendar calendar)
                                throws java.sql.SQLException
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.
Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.sql.Timestamp getTimestamp(java.lang.String columnName,
                                       java.util.Calendar calendar)
                                throws java.sql.SQLException
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default. This can be used to get values from columns with SQL types CHAR, VARCHAR, DATE, and TIMESTAMP.
Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
columnName - The column name.
calendar - The calendar.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - If the result set is not open, the cursor is not positioned on a row, the column name is not found, the calendar is null, or the requested conversion is not valid.

getTransactionIsolation

public int getTransactionIsolation()
Returns the transaction isolation level. Possible values are:
Specified by:
getTransactionIsolation in interface javax.sql.RowSet
Returns:
The transaction isolation level.

getType

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

getTypeMap

public java.util.Map getTypeMap()
                         throws java.sql.SQLException
Returns the type map.
Specified by:
getTypeMap in interface javax.sql.RowSet
Returns:
The type map. The default value is null.
Throws:
java.sql.SQLException - If a database error occurs.

getUnicodeStream

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

Returns the value of a column as a stream of Unicode characters. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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 java.io.InputStream getUnicodeStream(java.lang.String columnName)
                                     throws java.sql.SQLException
Deprecated. Use getCharacterStream(String) instead.

Returns the value of a column as a stream of Unicode characters. This can be used to get values from columns with SQL types CHAR, VARCHAR, BINARY, VARBINARY, CLOB, and BLOB. All of the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
columnName - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.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.
See Also:
getCharacterStream(String)

getUrl

public java.lang.String getUrl()
Returns the url used in getting a connection. Either this property or the dataSource property must be set before calling the execute command.
Specified by:
getUrl in interface javax.sql.RowSet
Returns:
The url. The default value is null.

getURL

public java.net.URL getURL(int columnIndex)
                    throws java.sql.SQLException
Returns the value of an SQL DATALINK output parameter as a java.net.URL object.
Parameters:
columnIndex - The column index (1-based).
Returns:
The parameter value or null if the value is SQL NULL.
Throws:
java.sql.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.
Since:
Modification 5

getURL

public java.net.URL getURL(java.lang.String columnName)
                    throws java.sql.SQLException
Returns the value of an SQL DATALINK output parameter as a java.net.URL object.
Parameters:
columnName - The column name.
Returns:
The parameter value or null if the value is SQL NULL.
Throws:
java.sql.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.

getUsername

public java.lang.String getUsername()
Returns the user used to create the connection.
Specified by:
getUsername in interface javax.sql.RowSet
Returns:
The user. The default is null.

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException
Returns the first warning reported for the result set. Subsequent warnings may be chained to this warning.
Specified by:
getWarnings in interface java.sql.ResultSet
Returns:
The first warning or null if no warnings have been reported.
Throws:
java.sql.SQLException - If an error occurs.

insertRow

public void insertRow()
               throws java.sql.SQLException
Inserts the contents of the insert row into the result set and the database.
Specified by:
insertRow in interface java.sql.ResultSet
Throws:
java.sql.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.

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException
Indicates if the cursor is positioned after the last row.
Specified by:
isAfterLast in interface java.sql.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:
java.sql.SQLException - If the result set is not open.

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException
Indicates if the cursor is positioned before the first row.
Specified by:
isBeforeFirst in interface java.sql.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:
java.sql.SQLException - If the result set is not open.

isFirst

public boolean isFirst()
                throws java.sql.SQLException
Indicates if the cursor is positioned on the first row.
Specified by:
isFirst in interface java.sql.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:
java.sql.SQLException - If the result set is not open.

isLast

public boolean isLast()
               throws java.sql.SQLException
Indicates if the cursor is positioned on the last row.
Specified by:
isLast in interface java.sql.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:
java.sql.SQLException - If the result set is not open.

isReadOnly

public boolean isReadOnly()
Indicates if the rowset is read-only.
Specified by:
isReadOnly in interface javax.sql.RowSet
Returns:
true if read-only; false otherwise. The default value is false, allowing updates.

isUseDataSource

public boolean isUseDataSource()
Indicates if the data source is used to make a connection to the database.
Returns:
true if the data source is used; false if the url is used. The default value is true.

last

public boolean last()
             throws java.sql.SQLException
Positions the cursor to the last row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
Specified by:
last in interface java.sql.ResultSet
Returns:
true if the requested cursor position is valid; false otherwise.
Throws:
java.sql.SQLException - If the result set is not open, the result set is not scrollable, or an error occurs.

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException
Positions the cursor to the current row. This is the row where the cursor was positioned before moving it to the insert row. If the cursor is not on the insert row, then this has no effect.

If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.

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

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException
Positions the cursor to the insert row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
Specified by:
moveToInsertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - If the result set is not open, the result set is not scrollable, the result set is not updatable, or an error occurs.

next

public boolean next()
             throws java.sql.SQLException
Positions the cursor to the next row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
Specified by:
next in interface java.sql.ResultSet
Returns:
true if the requested cursor position is valid; false if there are no more rows.
Throws:
java.sql.SQLException - If the result set is not open, or an error occurs.

previous

public boolean previous()
                 throws java.sql.SQLException
Positions the cursor to the previous row. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
Specified by:
previous in interface java.sql.ResultSet
Returns:
true if the requested cursor position is valid; false otherwise.
Throws:
java.sql.SQLException - If the result set is not open, the result set is not scrollable, or an error occurs.

refreshRow

public void refreshRow()
                throws java.sql.SQLException
Refreshes the current row from the database and cancels all pending updates that have been made since the last call to updateRow(). This method provides a way for an application to explicitly refetch a row from the database. If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
Specified by:
refreshRow in interface java.sql.ResultSet
Throws:
java.sql.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.

relative

public boolean relative(int rowNumber)
                 throws java.sql.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.

If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.

Specified by:
relative in interface java.sql.ResultSet
Parameters:
rowNumber - 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:
java.sql.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.

removePropertyChangeListener

public void removePropertyChangeListener(java.beans.PropertyChangeListener listener)
Removes a PropertyChangeListener.
Parameters:
listener - The PropertyChangeListener.
See Also:
addPropertyChangeListener(java.beans.PropertyChangeListener)

removeRowSetListener

public void removeRowSetListener(javax.sql.RowSetListener listener)
Removes the RowSetListener from the list.
Specified by:
removeRowSetListener in interface javax.sql.RowSet
Parameters:
listener - The RowSetListener object.

rowDeleted

public boolean rowDeleted()
                   throws java.sql.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 java.sql.ResultSet
Returns:
true if current row has been deleted; false otherwise.
Throws:
java.sql.SQLException - If an error occurs.

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException
Indicates if the current row has been inserted. This driver does not support this method.
Specified by:
rowInserted in interface java.sql.ResultSet
Returns:
Always false.
Throws:
java.sql.SQLException - If an error occurs.

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException
Indicates if the current row has been updated. This driver does not support this method.
Specified by:
rowUpdated in interface java.sql.ResultSet
Returns:
Always false.
Throws:
java.sql.SQLException - If an error occurs.

setArray

public void setArray(int parameterIndex,
                     java.sql.Array value)
              throws java.sql.SQLException
Sets the array value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setArray in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Array object.
Throws:
java.sql.SQLException - If a database error occurs.

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           java.io.InputStream inputStream,
                           int length)
                    throws java.sql.SQLException
Sets the inputStream at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method. The driver reads the data from the stream as needed until no more bytes are available. The converts this to an SQL VARCHAR value.
Specified by:
setAsciiStream in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
inputStream - The input stream or null to update the value to SQL NULL.
length - The number of bytes in the stream.
Throws:
java.sql.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.

setBigDecimal

public void setBigDecimal(int parameterIndex,
                          java.math.BigDecimal value)
                   throws java.sql.SQLException
Sets the BigDecimal value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setBigDecimal in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The BigDecimal object.
Throws:
java.sql.SQLException - If a database error occurs.

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            java.io.InputStream inputStream,
                            int length)
                     throws java.sql.SQLException
Sets the binary stream value using a inputStream at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARBINARY value.
Specified by:
setBinaryStream in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
inputStream - The input stream or null to update the value to SQL NULL.
length - The number of bytes in the stream.
Throws:
java.sql.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.

setBlob

public void setBlob(int parameterIndex,
                    java.sql.Blob value)
             throws java.sql.SQLException
Sets the Blob value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setBlob in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Blob object.
Throws:
java.sql.SQLException - If a database error occurs.

setBoolean

public void setBoolean(int parameterIndex,
                       boolean value)
                throws java.sql.SQLException
Sets the boolean value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setBoolean in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The boolean value.
Throws:
java.sql.SQLException - If a database error occurs.

setByte

public void setByte(int parameterIndex,
                    byte value)
             throws java.sql.SQLException
Sets the byte value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setByte in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The byte value.
Throws:
java.sql.SQLException - If a database error occurs.

setBytes

public void setBytes(int parameterIndex,
                     byte[] value)
              throws java.sql.SQLException
Sets the byte array value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setBytes in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The byte array.
Throws:
java.sql.SQLException - If a database error occurs.

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               java.io.Reader reader,
                               int length)
                        throws java.sql.SQLException
Sets a column in the current row using a Reader value. This parameter is used by the internal statement to populate the rowset via the execute method. 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:
setCharacterStream in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
reader - The reader or null to update the value to SQL NULL.
length - The number of characters in the stream.
Throws:
java.sql.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.

setClob

public void setClob(int parameterIndex,
                    java.sql.Clob value)
             throws java.sql.SQLException
Sets the Clob value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setClob in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Clob object.
Throws:
java.sql.SQLException - If a database error occurs.

setCommand

public void setCommand(java.lang.String command)
                throws java.sql.SQLException
Sets the command used by the execute statement to populate the rowset. This property is required to create the PreparedStatement. Resetting the command creates a new PreparedStatement and clears all existing input parameters.
Specified by:
setCommand in interface javax.sql.RowSet
Parameters:
command - The command.
Throws:
java.sql.SQLException - If a database error occurs.

setConcurrency

public void setConcurrency(int concurrency)
Sets the concurrency type for the result set. Valid values include:
Specified by:
setConcurrency in interface javax.sql.RowSet
Parameters:
concurrency - The concurrency type.

setContext

public void setContext(javax.naming.Context context)
Sets the JNDI naming context which provides name-to-object bindings and methods for retrieving and updating naming and directory services. If this is not set, a default InitialContext will be created.
Parameters:
context - A JNDI naming context.

setDataSourceName

public void setDataSourceName(java.lang.String dataSourceName)
Sets the name of the iSeries data source. Note: This property is not supported. The setDataSource method should be used for setting the data source.
Specified by:
setDataSourceName in interface javax.sql.RowSet
Parameters:
dataSourceName - The iSeries data source name.

setDate

public void setDate(int parameterIndex,
                    java.sql.Date value)
             throws java.sql.SQLException
Sets the Date value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setDate in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Date object.
Throws:
java.sql.SQLException - If a database error occurs.

setDate

public void setDate(int parameterIndex,
                    java.sql.Date value,
                    java.util.Calendar calendar)
             throws java.sql.SQLException
Sets the Date value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setDate in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Date object.
calendar - The Calendar object.
Throws:
java.sql.SQLException - If a database error occurs.

setDouble

public void setDouble(int parameterIndex,
                      double value)
               throws java.sql.SQLException
Sets the double value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setDouble in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The double value.
Throws:
java.sql.SQLException - If a database error occurs.

setEnvironment

public void setEnvironment(java.util.Hashtable environment)
Sets the standard JNDI environment properties. If this is not set, a default set of properties will be used.
Parameters:
environment - A Hashtable of JNDI environment properties.

setEscapeProcessing

public void setEscapeProcessing(boolean enable)
                         throws java.sql.SQLException
Sets whether the escape scanning is enabled for escape substitution processing.
Specified by:
setEscapeProcessing in interface javax.sql.RowSet
Parameters:
enable - true if enabled; false otherwise. The default value is true.
Throws:
java.sql.SQLException - If a database error occurs.

setFetchDirection

public void setFetchDirection(int fetchDirection)
                       throws java.sql.SQLException
Sets the direction in which the rows in a result set are processed.
Specified by:
setFetchDirection in interface java.sql.ResultSet
Parameters:
fetchDirection - The fetch direction for processing rows. Valid values are:
  • ResultSet.FETCH_FORWARD
  • ResultSet.FETCH_REVERSE
  • ResultSet.FETCH_UNKNOWN
The default is the statement's fetch direction.
Throws:
java.sql.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.

setFetchSize

public void setFetchSize(int fetchSize)
                  throws java.sql.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.

This setting only affects statements that meet the criteria specified in the "block criteria" property. The fetch size is only used if the "block size" property is set to "0".

Specified by:
setFetchSize in interface java.sql.ResultSet
Parameters:
fetchSize - 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:
java.sql.SQLException - If the result set is not open or the input value is not valid.

setFloat

public void setFloat(int parameterIndex,
                     float value)
              throws java.sql.SQLException
Sets the float value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setFloat in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The float value.
Throws:
java.sql.SQLException - If a database error occurs.

setInt

public void setInt(int parameterIndex,
                   int value)
            throws java.sql.SQLException
Sets the integer value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setInt in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The integer value.
Throws:
java.sql.SQLException - If a database error occurs.

setLong

public void setLong(int parameterIndex,
                    long value)
             throws java.sql.SQLException
Sets the long value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setLong in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The long value.
Throws:
java.sql.SQLException - If a database error occurs.

setMaxFieldSize

public void setMaxFieldSize(int maxFieldSize)
                     throws java.sql.SQLException
Sets the maximum column size. The default size is zero indicating no maximum value. This property is only used with column types:
Specified by:
setMaxFieldSize in interface javax.sql.RowSet
Parameters:
maxFieldSize - The maximum column size.
Throws:
java.sql.SQLException - If a database error occurs.

setMaxRows

public void setMaxRows(int maxRows)
                throws java.sql.SQLException
Sets the maximum row limit for the rowset. The default value is zero indicating no maximum value.
Specified by:
setMaxRows in interface javax.sql.RowSet
Parameters:
maxRows - The maximum number of rows.
Throws:
java.sql.SQLException - If a database error occurs.

setNull

public void setNull(int parameterIndex,
                    int sqlType)
             throws java.sql.SQLException
Sets the type at the specified parameterIndex to SQL NULL. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setNull in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
sqlType - The SQL type.
Throws:
java.sql.SQLException - If a database error occurs.

setNull

public void setNull(int parameterIndex,
                    int sqlType,
                    java.lang.String typeName)
             throws java.sql.SQLException
Sets the user-named type or REF type at the specified parameterIndex to SQL NULL. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setNull in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
sqlType - The SQL type.
typeName - The fully qualified name of an SQL user-named type. This parameter is not used if the type is REF.
Throws:
java.sql.SQLException - If a database error occurs.

setObject

public void setObject(int parameterIndex,
                      java.lang.Object value)
               throws java.sql.SQLException
Sets the object value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setObject in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Object value.
Throws:
java.sql.SQLException - If a database error occurs.

setObject

public void setObject(int parameterIndex,
                      java.lang.Object value,
                      int targetSqlType)
               throws java.sql.SQLException
Sets the object value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setObject in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Object value.
targetSqlType - The SQL type.
Throws:
java.sql.SQLException - If a database error occurs.

setObject

public void setObject(int parameterIndex,
                      java.lang.Object value,
                      int targetSqlType,
                      int scale)
               throws java.sql.SQLException
Sets the object value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setObject in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Object value.
targetSqlType - The SQL type.
scale - The number of digits after the decimal point. This parameter is used only for SQL types Decimal or Numeric.
Throws:
java.sql.SQLException - If a database error occurs.

setPassword

public void setPassword(java.lang.String password)
Sets the password used to make the connection. Note: This property has no effect unless the useDataSource property is set to false.
Specified by:
setPassword in interface javax.sql.RowSet
Parameters:
password - The password.

setQueryTimeout

public void setQueryTimeout(int timeout)
                     throws java.sql.SQLException
Sets the maximum wait time in seconds for a statement to execute.
Specified by:
setQueryTimeout in interface javax.sql.RowSet
Parameters:
timeout - The timeout value in seconds. The default value is zero indicating no maximum value.
Throws:
java.sql.SQLException - If a database error occurs.

setReadOnly

public void setReadOnly(boolean readOnly)
                 throws java.sql.SQLException
Sets whether the rowset is read-only. The default value is false indicating updates are allowed.
Specified by:
setReadOnly in interface javax.sql.RowSet
Parameters:
readOnly - true if read-only; false otherwise.
Throws:
java.sql.SQLException - If a database error occurs.

setRef

public void setRef(int parameterIndex,
                   java.sql.Ref value)
            throws java.sql.SQLException
Sets Ref value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setRef in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Ref object.
Throws:
java.sql.SQLException - If a database error occurs.

setShort

public void setShort(int parameterIndex,
                     short value)
              throws java.sql.SQLException
Sets the short value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setShort in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The short value.
Throws:
java.sql.SQLException - If a database error occurs.

setString

public void setString(int parameterIndex,
                      java.lang.String value)
               throws java.sql.SQLException
Sets the string value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setString in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The String object.
Throws:
java.sql.SQLException - If a database error occurs.

setTime

public void setTime(int parameterIndex,
                    java.sql.Time value)
             throws java.sql.SQLException
Sets the time value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setTime in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Time object.
Throws:
java.sql.SQLException - If a database error occurs.

setTime

public void setTime(int parameterIndex,
                    java.sql.Time value,
                    java.util.Calendar calendar)
             throws java.sql.SQLException
Sets the time value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setTime in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Time object.
calendar - The Calendar object.
Throws:
java.sql.SQLException - If a database error occurs.

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp value)
                  throws java.sql.SQLException
Sets the timestamp value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setTimestamp in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Timestamp object.
Throws:
java.sql.SQLException - If a database error occurs.

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp value,
                         java.util.Calendar calendar)
                  throws java.sql.SQLException
Sets the timestamp value at the specified parameterIndex. This parameter is used by the internal statement to populate the rowset via the execute method.
Specified by:
setTimestamp in interface javax.sql.RowSet
Parameters:
parameterIndex - The parameter index (1-based).
value - The Timestamp object.
calendar - The Calendar object.
Throws:
java.sql.SQLException - If a database error occurs.

setTransactionIsolation

public void setTransactionIsolation(int level)
                             throws java.sql.SQLException
Sets the transaction isolation level.
Specified by:
setTransactionIsolation in interface javax.sql.RowSet
Parameters:
level - The transaction isolation level. Possible values are:
  • Connection.TRANSACTION_READ_UNCOMMITTED
  • Connection.TRANSACTION_READ_COMMITTED
  • Connection.TRANSACTION_REPEATABLE_READ
  • Connection.TRANSACTION_SERIALIZABLE
Throws:
java.sql.SQLException - If a database error occurs.

setType

public void setType(int type)
             throws java.sql.SQLException
Sets the result set type. Valid values are:
Specified by:
setType in interface javax.sql.RowSet
Parameters:
type - The type.
Throws:
java.sql.SQLException - If a database error occurs.

setTypeMap

public void setTypeMap(java.util.Map map)
                throws java.sql.SQLException
Sets the type map to be used for distinct and structured types. Note: Distinct types are supported by DB2 UDB for iSeries, but are not externalized by the IBM Toolbox for Java JDBC driver. In other words, distinct types behave as if they are the underlying type. Structured types are not supported by DB2 UDB for iSeries. Consequently, this driver does not support the type map.
Specified by:
setTypeMap in interface javax.sql.RowSet
Parameters:
map - The type map.
Throws:
java.sql.SQLException - If a database error occurs.

setUrl

public void setUrl(java.lang.String url)
Sets the URL used for getting a connection. Either this property or the dataSource property must be set before a connection can be made. This sets setUseDataSource to false.
Specified by:
setUrl in interface javax.sql.RowSet
Parameters:
The - URL.
See Also:
setUseDataSource(boolean)

setUseDataSource

public void setUseDataSource(boolean useDataSource)
Sets whether the data source is used to make a connection to the database.
Parameters:
useDataSource - true if the data source is used; false if the URL is used. The default value is true.

setUsername

public void setUsername(java.lang.String username)
Sets the user name used to make the connection. Note: This property has no effect unless the useDataSource property is set to false.
Specified by:
setUsername in interface javax.sql.RowSet
Parameters:
username - The user name.

toString

public java.lang.String toString()
Returns the name of the SQL cursor in use by the result set.
Overrides:
toString in class java.lang.Object
Returns:
The cursor name.

updateArray

public void updateArray(int columnIndex,
                        java.sql.Array columnValue)
                 throws java.sql.SQLException
Updates a column in the current row using an Array value. DB2 UDB for iSeries does not support arrays.
Parameters:
columnIndex - The column index (1-based).
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - Always thrown because DB2 UDB for iSeries does not support arrays.
Since:
Modification 5

updateArray

public void updateArray(java.lang.String columnName,
                        java.sql.Array columnValue)
                 throws java.sql.SQLException
Updates a column in the current row using an Array value. DB2 UDB for iSeries does not support arrays.
Parameters:
columnIndex - The column name.
Returns:
The column value or null if the value is SQL NULL.
Throws:
java.sql.SQLException - Always thrown because DB2 UDB for iSeries does not support arrays.

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream columnValue,
                              int length)
                       throws java.sql.SQLException
Updates a column in the current row using an ASCII stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARCHAR value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateAsciiStream in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
length - The length.
Throws:
java.sql.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, the requested conversion is not valid, the length is not valid, the input stream does not contain ASCII characters, or an error happens while reading the input stream.

updateAsciiStream

public void updateAsciiStream(java.lang.String columnName,
                              java.io.InputStream columnValue,
                              int length)
                       throws java.sql.SQLException
Updates a column in the current row using an ASCII stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARCHAR value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateAsciiStream in interface java.sql.ResultSet
Parameters:
columnName - The column name.
columnValue - The column value or null to update the value to SQL NULL.
length - The length.
Throws:
java.sql.SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, the requested conversion is not valid, the length is not valid, the input stream does not contain ASCII characters, or an error happens while reading the input stream.

updateBigDecimal

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
Throws:
java.sql.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(java.lang.String columnName,
                             java.math.BigDecimal columnValue)
                      throws java.sql.SQLException
Updates a column in the current row using a BigDecimal value. The driver converts this to an SQL NUMERIC value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream columnValue,
                               int length)
                        throws java.sql.SQLException
Updates a column in the current row using a binary stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARBINARY value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateBinaryStream in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
length - The length.
Throws:
java.sql.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.

updateBinaryStream

public void updateBinaryStream(java.lang.String columnName,
                               java.io.InputStream columnValue,
                               int length)
                        throws java.sql.SQLException
Updates a column in the current row using a binary stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARBINARY value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateBinaryStream in interface java.sql.ResultSet
Parameters:
columnName - The column name.
columnValue - The column value or null to update the value to SQL NULL.
length - The length.
Throws:
java.sql.SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, 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 columnIndex,
                       java.sql.Blob columnValue)
                throws java.sql.SQLException
Updates a column in the current row using a Java Blob value. The driver converts this to an SQL BLOB value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Parameters:
columnIndex - The column index (1-based).
columnValue - The column value.
Throws:
java.sql.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.
Since:
Modification 5

updateBlob

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Parameters:
columnName - The column name.
columnValue - The column value.
Throws:
java.sql.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 columnIndex,
                          boolean columnValue)
                   throws java.sql.SQLException
Updates a column in the current row using a Java boolean value. The driver converts this to an SQL SMALLINT value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateBoolean in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value.
Throws:
java.sql.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(java.lang.String columnName,
                          boolean columnValue)
                   throws java.sql.SQLException
Updates a column in the current row using a Java boolean value. The driver converts this to an SQL SMALLINT value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateByte

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateByte in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value.
Throws:
java.sql.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(java.lang.String columnName,
                       byte columnValue)
                throws java.sql.SQLException
Updates a column in the current row using a Java byte value. The driver converts this to an SQL SMALLINT value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateByte in interface java.sql.ResultSet
Parameters:
columnName - The column name.
columnValue - The column value.
Throws:
java.sql.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 columnIndex,
                        byte[] columnValue)
                 throws java.sql.SQLException
Updates a column in the current row using a Java byte array value. The driver converts this to an SQL VARBINARY value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateBytes in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
Throws:
java.sql.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(java.lang.String columnName,
                        byte[] columnValue)
                 throws java.sql.SQLException
Updates a column in the current row using a Java byte array value. The driver converts this to an SQL VARBINARY value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader columnValue,
                                  int length)
                           throws java.sql.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.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateCharacterStream in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
length - The length.
Throws:
java.sql.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(java.lang.String columnName,
                                  java.io.Reader columnValue,
                                  int length)
                           throws java.sql.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.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateClob

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Parameters:
columnIndex - The column index (1-based).
columnValue - The column value.
Throws:
java.sql.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.
Since:
Modification 5

updateClob

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Parameters:
columnName - The column name.
columnValue - The column value.
Throws:
java.sql.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 columnIndex,
                       java.sql.Date columnValue)
                throws java.sql.SQLException
Updates a column in the current row using a java.sql.Date value. The driver converts this to an SQL DATE value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateDate in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
Throws:
java.sql.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(java.lang.String columnName,
                       java.sql.Date columnValue)
                throws java.sql.SQLException
Updates a column in the current row using a java.sql.Date value. The driver converts this to an SQL DATE value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateDouble

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateDouble in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value.
Throws:
java.sql.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(java.lang.String columnName,
                         double columnValue)
                  throws java.sql.SQLException
Updates a column in the current row using a Java double value. The driver converts this to an SQL DOUBLE value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateFloat

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateFloat in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value.
Throws:
java.sql.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(java.lang.String columnName,
                        float columnValue)
                 throws java.sql.SQLException
Updates a column in the current row using a Java float value. The driver converts this to an SQL REAL value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateInt

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateInt in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value.
Throws:
java.sql.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(java.lang.String columnName,
                      int columnValue)
               throws java.sql.SQLException
Updates a column in the current row using a Java int value. The driver converts this to an SQL INTEGER value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateLong

public void updateLong(int columnIndex,
                       long columnValue)
                throws java.sql.SQLException
Updates a column in the current row using a Java long value. If the connected AS/400 or iSeries server supports SQL BIGINT data, the driver converts this to an SQL BIGINT value. Otherwise, the driver converts this to an SQL INTEGER value. SQL BIGINT data is supported on V4R5 and later.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateLong in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value.
Throws:
java.sql.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(java.lang.String columnName,
                       long columnValue)
                throws java.sql.SQLException
Updates a column in the current row using a Java long value. If the connected AS/400 or iSeries server supports SQL BIGINT data, the driver converts this to an SQL BIGINT value. Otherwise, the driver converts this to an SQL INTEGER value. SQL BIGINT data is supported on V4R5 and later.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateNull

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateNull in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
Throws:
java.sql.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(java.lang.String columnName)
                throws java.sql.SQLException
Updates a column in the current row using SQL NULL.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object columnValue)
                  throws java.sql.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. In the cases where an SQL type is not supported by DB2 UDB for iSeries, the next closest matching type is used.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
Throws:
java.sql.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(java.lang.String columnName,
                         java.lang.Object columnValue)
                  throws java.sql.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. In the cases where an SQL type is not supported by DB2 UDB for iSeries, the next closest matching type is used.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object columnValue,
                         int scale)
                  throws java.sql.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. In the cases where an SQL type is not supported by DB2 UDB for iSeries, the next closest matching type is used.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
scale - The number of digits after the decimal if SQL type is DECIMAL or NUMERIC.
Throws:
java.sql.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, the scale is not valid, or the requested conversion is not valid.

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object columnValue,
                         int scale)
                  throws java.sql.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. In the cases where an SQL type is not supported by DB2 UDB for iSeries, the next closest matching type is used.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
columnName - The column name.
columnValue - The column value or null to update the value to SQL NULL.
scale - The number of digits after the decimal if SQL type is DECIMAL or NUMERIC.
Throws:
java.sql.SQLException - If the result set is not open, the result set is not updatable, the cursor is not positioned on a row, the column name is not found, the scale is not valid, or the requested conversion is not valid.

updateRow

public void updateRow()
               throws java.sql.SQLException
Updates the database with the new contents of the current row.
Specified by:
updateRow in interface java.sql.ResultSet
Throws:
java.sql.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.

updateRef

public void updateRef(int columnIndex,
                      java.sql.Ref columnValue)
               throws java.sql.SQLException
Updates a column in the current row using an Ref value. DB2 UDB for iSeries does not support structured types.
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
Returns:
The parameter value or 0 if the value is SQL NULL.
Throws:
java.sql.SQLException - Always thrown because DB2 UDB for iSeries does not support REFs.
Since:
Modification 5

updateRef

public void updateRef(java.lang.String columnName,
                      java.sql.Ref columnValue)
               throws java.sql.SQLException
Updates a column in the current row using an Ref value. DB2 UDB for iSeries does not support structured types.
Parameters:
columnIndex - The column name.
columnValue - The column value or null to update the value to SQL NULL.
Returns:
The parameter value or 0 if the value is SQL NULL.
Throws:
java.sql.SQLException - Always thrown because DB2 UDB for iSeries does not support REFs.

updateShort

public void updateShort(int columnIndex,
                        short columnValue)
                 throws java.sql.SQLException
Updates a column in the current row using a Java short value. The driver converts this to an SQL SMALLINT value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateShort in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value.
Throws:
java.sql.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(java.lang.String columnName,
                        short columnValue)
                 throws java.sql.SQLException
Updates a column in the current row using a Java short value. The driver converts this to an SQL SMALLINT value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateString

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateString in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
Throws:
java.sql.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(java.lang.String columnName,
                         java.lang.String columnValue)
                  throws java.sql.SQLException
Updates a column in the current row using a String value. The driver converts this to an SQL VARCHAR value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateTime

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateTime in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
Throws:
java.sql.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(java.lang.String columnName,
                       java.sql.Time columnValue)
                throws java.sql.SQLException
Updates a column in the current row using a java.sql.Time value. The driver converts this to an SQL TIME value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

updateTimestamp

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

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

Specified by:
updateTimestamp in interface java.sql.ResultSet
Parameters:
columnIndex - The column index (1-based).
columnValue - The column value or null to update the value to SQL NULL.
Throws:
java.sql.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(java.lang.String columnName,
                            java.sql.Timestamp columnValue)
                     throws java.sql.SQLException
Updates a column in the current row using a java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value.

This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.

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

wasNull

public boolean wasNull()
                throws java.sql.SQLException
Indicates if the last column read has the value of SQL NULL.
Specified by:
wasNull in interface java.sql.ResultSet
Returns:
true if the value is SQL NULL; false otherwise.
Throws:
java.sql.SQLException - If the result set is not open.