JDBCResultSet (HSQLDB 2.2.9 API)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.hsqldb.jdbc
Class JDBCResultSet

java.lang.Object
  org.hsqldb.jdbc.JDBCResultSet

All Implemented Interfaces:: ResultSet, Wrapper

public class JDBCResultSet
extends Object
implements ResultSet
extends Object
implements ResultSet

A table of data representing a database result set, which is usually generated by executing a statement that queries the database.

A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.

A default ResultSet object is not updatable and has a cursor that moves forward only. Thus, you can iterate through it only once and only from the first row to the last row. It is possible to produce ResultSet objects that are scrollable and/or updatable. The following code fragment, in which con is a valid Connection object, illustrates how to make a result set that is scrollable and insensitive to updates by others, and that is updatable. See ResultSet fields for other options.


       Statement stmt = con.createStatement(
                                      ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
       ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2");
       // rs will be scrollable, will not show changes made by others,
       // and will be updatable

The ResultSet interface provides getter methods (getBoolean, getLong, and so on) for retrieving column values from the current row. Values can be retrieved using either the index number of the column or the name of the column. In general, using the column index will be more efficient. Columns are numbered from 1. For maximum portability, result set columns within each row should be read in left-to-right order, and each column should be read only once.

For the getter methods, a JDBC driver attempts to convert the underlying data to the Java type specified in the getter method and returns a suitable Java value. The JDBC specification has a table showing the allowable mappings from SQL types to Java types that can be used by the ResultSet getter methods.

Column names used as input to getter methods are case insensitive. When a getter method is called with a column name and several columns have the same name, the value of the first matching column will be returned. The column name option is designed to be used when column names are used in the SQL query that generated the result set. For columns that are NOT explicitly named in the query, it is best to use column numbers. (JDBC4 clarification:) If column names are used, the programmer should take care to guarantee that they uniquely refer to the intended columns, which can be assured with the SQL AS clause.

A set of updater methods were added to this interface in the JDBC 2.0 API (Java^TM 2 SDK, Standard Edition, version 1.2). The comments regarding parameters to the getter methods also apply to parameters to the updater methods.

The updater methods may be used in two ways:

to update a column value in the current row. In a scrollable ResultSet object, the cursor can be moved backwards and forwards, to an absolute position, or to a position relative to the current row. The following code fragment updates the NAME column in the fifth row of the ResultSet object rs and then uses the method updateRow to update the data source table from which rs was derived.
```
       rs.absolute(5); // moves the cursor to the fifth row of rs
       rs.updateString("NAME", "AINSWORTH"); // updates the
          // NAME column of row 5 to be AINSWORTH
       rs.updateRow(); // updates the row in the data source

 
```

to insert column values into the insert row. An updatable ResultSet object has a special row associated with it that serves as a staging area for building a row to be inserted. The following code fragment moves the cursor to the insert row, builds a three-column row, and inserts it into rs and into the data source table using the method insertRow.


       rs.moveToInsertRow(); // moves cursor to the insert row
       rs.updateString(1, "AINSWORTH"); // updates the
          // first column of the insert row to be AINSWORTH
       rs.updateInt(2,35); // updates the second column to be 35
       rs.updateBoolean(3, true); // updates the third column to true
       rs.insertRow();
       rs.moveToCurrentRow();

A ResultSet object is automatically closed when the Statement object that generated it is closed, re-executed, or used to retrieve the next result from a sequence of multiple results.

The number, types and properties of a ResultSet object's columns are provided by the ResulSetMetaData object returned by the ResultSet.getMetaData method.

HSQLDB-Specific Information:

A ResultSet object generated by HSQLDB is by default of ResultSet.TYPE_FORWARD_ONLY (as is standard JDBC behavior) and does not allow the use of absolute and relative positioning methods. If a statement is created with:

 Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

then the ResultSet objects it produces support using all of the absolute and relative positioning methods of JDBC2 to set the position of the current row, for example:

 rs.absolute(5);
 String fifthRowValue = rs.getString(1);
 rs.relative(4);
 String ninthRowValue = rs.getString(1);

Note: An HSQLDB ResultSet object persists, even after its connection is closed. This is regardless of the operational mode of the Database from which it came. That is, they persist whether originating from a Server, WebServer or in-process mode Database.

From HSQLDB 2.0, there is full support for updatable result sets. Supported methods include all updateXXX methods for the supported types, as well as the insertRow(), updateRow(), deleteRow(), moveToInsertRow() methods.

The Statement must be created with ResultSet.CONCUR_UPDATABLE instead of CONCUR_READ_ONLY.

Updatability of a result set follows the SQL standards. Some or all columns of an updatable result set can be updated. The current row in such result sets can be deleted using the deleteRow() method. Some updatable result set can also be inserted into and support moveToInsertRow().

A result set is updatable if the SELECT statement is updatable. This includes SELECT from TABLE and updatable VIEW objects. An updatable SELECT statement has a single uderlying table or view. HSQLDB supports both scrollable and forward-only result sets for updatability.

 -- In the SELECT below, columns A and B are updatable, any row can be
 -- deleted, but it is not insertable-into as column C is not directly from
 -- the table.
 SELECT A, B, A + B AS C FROM T WHERE ...

 -- The SELECT below can be insertable-into so long as other columns of the
 -- table that do not appear in the SELECT list have a default value.
 SELECT A, B FROM T WHERE ...

JRE 1.1.x Notes:

In general, JDBC 2 support requires Java 1.2 and above, and JDBC 3 requires Java 1.4 and above. In HSQLDB, support for methods introduced in different versions of JDBC depends on the JDK version used for compiling and building HSQLDB.

Since 1.7.0, it is possible to build the product so that all JDBC 2 methods can be called while executing under the version 1.1.x Java Runtime Environment^TM. However, some of these method calls require int values that are defined only in the JDBC 2 or greater version of the ResultSet interface. For this reason, when the product is compiled under JDK 1.1.x, these values are defined here, in this class.

In a JRE 1.1.x environment, calling JDBC 2 methods that take or return the JDBC2-only ResultSet values can be achieved by referring to them in parameter specifications and return value comparisons, respectively, as follows:

 JDBCResultSet.FETCH_FORWARD
 JDBCResultSet.TYPE_FORWARD_ONLY
 JDBCResultSet.TYPE_SCROLL_INSENSITIVE
 JDBCResultSet.CONCUR_READ_ONLY
 // etc.

However, please note that code written in such a manner will not be compatible for use with other JDBC 2 drivers, since they expect and use ResultSet, rather than JDBCResultSet. Also note, this feature is offered solely as a convenience to developers who must work under JDK 1.1.x due to operating constraints, yet wish to use some of the more advanced features available under the JDBC 2 specification.

(fredt@users)
(boucherb@users)

Since:: HSQLDB 1.9.0
Author:: Campbell Boucher-Burnet (boucherb@users dot sourceforge.net), Fred Toussi (fredt@users dot sourceforge.net)
See Also:: JDBCStatement.executeQuery(java.lang.String), JDBCStatement.getResultSet(), ResultSetMetaData

Field Summary
`static int`	`CLOSE_CURSORS_AT_COMMIT` Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
`static int`	`CONCUR_READ_ONLY` Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
`static int`	`CONCUR_UPDATABLE` Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
`static int`	`FETCH_FORWARD` Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
`static int`	`FETCH_REVERSE` Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
`static int`	`FETCH_UNKNOWN` Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
`static int`	`HOLD_CURSORS_OVER_COMMIT` Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
`org.hsqldb.result.Result`	`result` The underlying result.
`static int`	`TYPE_FORWARD_ONLY` Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
`static int`	`TYPE_SCROLL_INSENSITIVE` Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
`static int`	`TYPE_SCROLL_SENSITIVE` Copy of java.sql.ResultSet constant, for JDK 1.1 clients.

Constructor Summary
`JDBCResultSet(JDBCConnection conn, org.hsqldb.jdbc.JDBCStatementBase s, org.hsqldb.result.Result r, org.hsqldb.result.ResultMetaData metaData)` Constructs a new `JDBCResultSet` object using the specified navigator and `org.hsqldb.result.ResultMetaData`.
`JDBCResultSet(JDBCConnection conn, org.hsqldb.result.Result r, org.hsqldb.result.ResultMetaData metaData)`

Method Summary

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

void afterLast()
Moves the cursor to the end of this ResultSet object, just after the last row.

void beforeFirst()
Moves the cursor to the front of this ResultSet object, just before the first row.

void cancelRowUpdates()
Cancels the updates made to the current row in this ResultSet object.

void clearWarnings()
Clears all warnings reported on this ResultSet object.

void close()
Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

void deleteRow()
Deletes the current row from this ResultSet object and from the underlying database.

int findColumn(String columnLabel)
Maps the given ResultSet column label to its ResultSet column index.

boolean first()
Moves the cursor to the first row in this ResultSet object.

Array getArray(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.

Array getArray(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.

InputStream getAsciiStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

InputStream getAsciiStream(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

BigDecimal getBigDecimal(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

BigDecimal getBigDecimal(int columnIndex, int scale)
Deprecated. by java.sun.com as of JDK 1.2

BigDecimal getBigDecimal(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

BigDecimal getBigDecimal(String columnLabel, int scale)
Deprecated. by java.sun.com as of JDK 1.2

InputStream getBinaryStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.

InputStream getBinaryStream(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.

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

Blob getBlob(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

boolean getBoolean(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

boolean getBoolean(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

byte getByte(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

byte getByte(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

byte[] getBytes(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

byte[] getBytes(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

Reader getCharacterStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

Reader getCharacterStream(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

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

Clob getClob(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.

int getConcurrency()
Retrieves the concurrency mode of this ResultSet object.

String getCursorName()
Retrieves the name of the SQL cursor used by this ResultSet object.

Date getDate(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

Date getDate(int columnIndex, Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

Date getDate(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

Date getDate(String columnLabel, Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

double getDouble(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

double getDouble(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

int getFetchDirection()
Retrieves the fetch direction for this ResultSet object.

int getFetchSize()
Retrieves the fetch size for this ResultSet object.

float getFloat(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

float getFloat(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

int getHoldability()
Retrieves the holdability of this ResultSet object

int getInt(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

int getInt(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

long getLong(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

long getLong(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

ResultSetMetaData getMetaData()
Retrieves the number, types and properties of this ResultSet object's columns.

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

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

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

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

String getNString(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

String getNString(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Object getObject(int columnIndex)





<T> T

getObject(int columnIndex,
          Class<T> type)

Object getObject(int columnIndex, Map map)
Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

Object getObject(String columnLabel)





<T> T

getObject(String columnLabel,
          Class<T> type)

Object getObject(String columnLabel, Map map)
Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

Ref getRef(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.

Ref getRef(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.

int getRow()
Retrieves the current row number.

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

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

short getShort(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

short getShort(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

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

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

Statement getStatement()
Retrieves the Statement object that produced this ResultSet object.

String getString(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

String getString(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Time getTime(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Time getTime(int columnIndex, Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Time getTime(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Time getTime(String columnLabel, Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Timestamp getTimestamp(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

Timestamp getTimestamp(int columnIndex, Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

Timestamp getTimestamp(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

Timestamp getTimestamp(String columnLabel, Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

int getType()
Retrieves the type of this ResultSet object.

InputStream getUnicodeStream(int columnIndex)
Deprecated. use getCharacterStream in place of getUnicodeStream

InputStream getUnicodeStream(String columnLabel)
Deprecated. use getCharacterStream instead

URL getURL(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.

URL getURL(String columnLabel)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.

SQLWarning getWarnings()
Retrieves the first warning reported by calls on this ResultSet object.

void insertRow()
Inserts the contents of the insert row into this ResultSet object and into the database.

boolean isAfterLast()
Retrieves whether the cursor is after the last row in this ResultSet object.

boolean isBeforeFirst()
Retrieves whether the cursor is before the first row in this ResultSet object.

boolean isClosed()
Retrieves whether this ResultSet object has been closed.

boolean isFirst()
Retrieves whether the cursor is on the first row of this ResultSet object.

boolean isLast()
Retrieves whether the cursor is on the last row of this ResultSet object.

boolean isWrapperFor(Class<?> iface)
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.

boolean last()
Moves the cursor to the last row in this ResultSet object.

void moveToCurrentRow()
Moves the cursor to the remembered cursor position, usually the current row.

void moveToInsertRow()
Moves the cursor to the insert row.

static JDBCResultSet newJDBCResultSet(org.hsqldb.result.Result r, org.hsqldb.result.ResultMetaData metaData)
Factory method returns a new JDBCResultSet object for use with user defined functions that retrun a ResultSet object.

boolean next()
Moves the cursor froward one row from its current position.

boolean previous()
Moves the cursor to the previous row in this ResultSet object.

void refreshRow()
Refreshes the current row with its most recent value in the database.

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

boolean rowDeleted()
Retrieves whether a row has been deleted.

boolean rowInserted()
Retrieves whether the current row has had an insertion.

boolean rowUpdated()
Retrieves whether the current row has been updated.

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

void setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object.





<T> T

unwrap(Class<T> iface)
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

void updateArray(int columnIndex, Array x)
Updates the designated column with a java.sql.Array value.

void updateArray(String columnLabel, Array x)
Updates the designated column with a java.sql.Array value.

void updateAsciiStream(int columnIndex, InputStream x)
Updates the designated column with an ascii stream value.

void updateAsciiStream(int columnIndex, InputStream x, int length)
(JDBC4 clarification:) Updates the designated column with an ascii stream value, which will have the specified number of bytes.

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

void updateAsciiStream(String columnLabel, InputStream x)
Updates the designated column with an ascii stream value.

void updateAsciiStream(String columnLabel, InputStream x, int length)
(JDBC4 clarification:) Updates the designated column with an ascii stream value, which will have the specified number of bytes.

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

void updateBigDecimal(int columnIndex, BigDecimal x)
Updates the designated column with a java.math.BigDecimal value.

void updateBigDecimal(String columnLabel, BigDecimal x)
Updates the designated column with a java.sql.BigDecimal value.

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

void updateBinaryStream(int columnIndex, InputStream x, int length)
(JDBC4 clarification:) Updates the designated column with a binary stream value, which will have the specified number of bytes.

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

void updateBinaryStream(String columnLabel, InputStream x)
Updates the designated column with a binary stream value.

void updateBinaryStream(String columnLabel, InputStream x, int length)
(JDBC4 clarification:) Updates the designated column with a binary stream value, which will have the specified number of bytes.

void updateBinaryStream(String columnLabel, InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.

void updateBlob(int columnIndex, Blob x)
Updates the designated column with a java.sql.Blob value.

void updateBlob(int columnIndex, InputStream inputStream)
Updates the designated column using the given input stream.

void updateBlob(int columnIndex, InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.

void updateBlob(String columnLabel, Blob x)
Updates the designated column with a java.sql.Blob value.

void updateBlob(String columnLabel, InputStream inputStream)
Updates the designated column using the given input stream.

void updateBlob(String columnLabel, InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.

void updateBoolean(int columnIndex, boolean x)
Updates the designated column with a boolean value.

void updateBoolean(String columnLabel, boolean x)
Updates the designated column with a boolean value.

void updateByte(int columnIndex, byte x)
Updates the designated column with a byte value.

void updateByte(String columnLabel, byte x)
Updates the designated column with a byte value.

void updateBytes(int columnIndex, byte[] x)
Updates the designated column with a byte array value.

void updateBytes(String columnLabel, byte[] x)
Updates the designated column with a byte array value.

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

void updateCharacterStream(int columnIndex, Reader x, int length)
(JDBC4 clarification:) Updates the designated column with a character stream value, which will have the specified number of (CHECKME: characters?) bytes.

void updateCharacterStream(int columnIndex, Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.

void updateCharacterStream(String columnLabel, Reader reader)
Updates the designated column with a character stream value.

void updateCharacterStream(String columnLabel, Reader reader, int length)
(JDBC4 clarification) Updates the designated column with a character stream value, which will have the specified number of (CHECKME: characters?) bytes.

void updateCharacterStream(String columnLabel, Reader reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.

void updateClob(int columnIndex, Clob x)
Updates the designated column with a java.sql.Clob value.

void updateClob(int columnIndex, Reader reader)
Updates the designated column using the given Reader object.

void updateClob(int columnIndex, Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long.

void updateClob(String columnLabel, Clob x)
Updates the designated column with a java.sql.Clob value.

void updateClob(String columnLabel, Reader reader)
Updates the designated column using the given Reader object.

void updateClob(String columnLabel, Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long.

void updateDate(int columnIndex, Date x)
Updates the designated column with a java.sql.Date value.

void updateDate(String columnLabel, Date x)
Updates the designated column with a java.sql.Date value.

void updateDouble(int columnIndex, double x)
Updates the designated column with a double value.

void updateDouble(String columnLabel, double x)
Updates the designated column with a double value.

void updateFloat(int columnIndex, float x)
Updates the designated column with a float value.

void updateFloat(String columnLabel, float x)
Updates the designated column with a float value.

void updateInt(int columnIndex, int x)
Updates the designated column with an int value.

void updateInt(String columnLabel, int x)
Updates the designated column with an int value.

void updateLong(int columnIndex, long x)
Updates the designated column with a long value.

void updateLong(String columnLabel, long x)
Updates the designated column with a long value.

void updateNCharacterStream(int columnIndex, Reader reader)
Updates the designated column with a character stream value.

void updateNCharacterStream(int columnIndex, Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.

void updateNCharacterStream(String columnLabel, Reader reader)
Updates the designated column with a character stream value.

void updateNCharacterStream(String columnLabel, Reader reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.

void updateNClob(int columnIndex, NClob nClob)
Updates the designated column with a java.sql.NClob value.

void updateNClob(int columnIndex, Reader reader)
Updates the designated column using the given Reader The data will be read from the stream as needed until end-of-stream is reached.

void updateNClob(int columnIndex, Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long.

void updateNClob(String columnLabel, NClob nClob)
Updates the designated column with a java.sql.NClob value.

void updateNClob(String columnLabel, Reader reader)
Updates the designated column using the given Reader object.

void updateNClob(String columnLabel, Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long.

void updateNString(int columnIndex, String nString)
Updates the designated column with a String value.

void updateNString(String columnLabel, String nString)
Updates the designated column with a String value.

void updateNull(int columnIndex)
(JDBC4 clarification:) Updates the designated column with a null value.

void updateNull(String columnLabel)
Updates the designated column with a null value.

void updateObject(int columnIndex, Object x)
Updates the designated column with an Object value.

void updateObject(int columnIndex, Object x, int scaleOrLength)
Updates the designated column with an Object value.

void updateObject(String columnLabel, Object x)
Updates the designated column with an Object value.

void updateObject(String columnLabel, Object x, int scaleOrLength)
Updates the designated column with an Object value.

void updateRef(int columnIndex, Ref x)
Updates the designated column with a java.sql.Ref value.

void updateRef(String columnLabel, Ref x)
Updates the designated column with a java.sql.Ref value.

void updateRow()
Updates the underlying database with the new contents of the current row of this ResultSet object.

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

void updateRowId(String columnLabel, RowId x)
Updates the designated column with a RowId value.

void updateShort(int columnIndex, short x)
Updates the designated column with a short value.

void updateShort(String columnLabel, short x)
Updates the designated column with a short value.

void updateSQLXML(int columnIndex, SQLXML xmlObject)
Updates the designated column with a java.sql.SQLXML value.

void updateSQLXML(String columnLabel, SQLXML xmlObject)
Updates the designated column with a java.sql.SQLXML value.

void updateString(int columnIndex, String x)
Updates the designated column with a String value.

void updateString(String columnLabel, String x)
Updates the designated column with a String value.

void updateTime(int columnIndex, Time x)
Updates the designated column with a java.sql.Time value.

void updateTime(String columnLabel, Time x)
Updates the designated column with a java.sql.Time value.

void updateTimestamp(int columnIndex, Timestamp x)
Updates the designated column with a java.sql.Timestamp value.

void updateTimestamp(String columnLabel, Timestamp x)
Updates the designated column with a java.sql.Timestamp value.

boolean wasNull()
Reports whether the last column read had a value of SQL NULL.

Methods inherited from class java.lang.Object
`equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Field Detail

result

public org.hsqldb.result.Result result

The underlying result.