java.sql
Interface ResultSet

All Known Subinterfaces:
RowSet

public interface ResultSet

This interface provides access to the data set returned by a SQL statement. An instance of this interface is returned by the various execution methods in the Statement.

This class models a cursor, which can be stepped through one row at a time. Methods are provided for accessing columns by column name or by index.

Note that a result set is invalidated if the statement that returned it is closed.


Field Summary
static int CLOSE_CURSORS_AT_COMMIT
           
static int CONCUR_READ_ONLY
          The concurrency mode of for the result set may not be modified.
static int CONCUR_UPDATABLE
          The concurrency mode of for the result set may be modified.
static int FETCH_FORWARD
          The rows will be processed in order from first to last.
static int FETCH_REVERSE
          The rows will be processed in order from last to first.
static int FETCH_UNKNOWN
          The rows will be processed in an unknown order
static int HOLD_CURSORS_OVER_COMMIT
           
static int TYPE_FORWARD_ONLY
          This type of result set may only step forward through the rows returned.
static int TYPE_SCROLL_INSENSITIVE
          This type of result set is scrollable and is not sensitive to changes made by other statements.
static int TYPE_SCROLL_SENSITIVE
          This type of result set is scrollable and is also sensitive to changes made by other statements.
 
Method Summary
 boolean absolute(int row)
          This method positions the result set to the specified absolute row.
 void afterLast()
          This method repositions the cursor to after the last row in the result set.
 void beforeFirst()
          This method repositions the cursor to before the first row in the result set.
 void cancelRowUpdates()
          This method cancels any changes that have been made to a row.
 void clearWarnings()
          This method clears all warnings associated with this result set.
 void close()
          This method closes the result set and frees any associated resources.
 void deleteRow()
          This method deletes the current row in the database.
 int findColumn(String columnName)
          This method returns the column index of the specified named column.
 boolean first()
          This method repositions the cursor on the first row in the result set.
 Array getArray(int columnIndex)
          This method returns the specified column value as an Array.
 Array getArray(String columnName)
          This method returns the specified column value as an Array.
 InputStream getAsciiStream(int columnIndex)
          This method returns the value of the specified column as an ASCII stream.
 InputStream getAsciiStream(String columnName)
          This method returns the value of the specified column as an ASCII stream.
 BigDecimal getBigDecimal(int columnIndex)
          This method returns the value of the specified column as a Java BigDecimal.
 BigDecimal getBigDecimal(int columnIndex, int scale)
          Deprecated.  
 BigDecimal getBigDecimal(String columnName)
          This method returns the value of the specified column as a Java BigDecimal.
 BigDecimal getBigDecimal(String columnName, int scale)
          Deprecated.  
 InputStream getBinaryStream(int columnIndex)
          This method returns the value of the specified column as a raw byte stream.
 InputStream getBinaryStream(String columnName)
          This method returns the value of the specified column as a raw byte stream.
 Blob getBlob(int columnIndex)
          This method returns the specified column value as a BLOB.
 Blob getBlob(String columnName)
          This method returns the specified column value as a BLOB.
 boolean getBoolean(int columnIndex)
          This method returns the value of the specified column as a Java boolean.
 boolean getBoolean(String columnName)
          This method returns the value of the specified column as a Java boolean.
 byte getByte(int columnIndex)
          This method returns the value of the specified column as a Java byte.
 byte getByte(String columnName)
          This method returns the value of the specified column as a Java byte.
 byte[] getBytes(int columnIndex)
          This method returns the value of the specified column as a Java byte array.
 byte[] getBytes(String columnName)
          This method returns the value of the specified column as a Java byte array.
 Reader getCharacterStream(int columnIndex)
          This method returns the value of the specified column as a character stream.
 Reader getCharacterStream(String columnName)
          This method returns the value of the specified column as a character stream.
 Clob getClob(int columnIndex)
          This method returns the specified column value as a CLOB.
 Clob getClob(String columnName)
          This method returns the specified column value as a CLOB.
 int getConcurrency()
          This method returns the concurrency type of this result set.
 String getCursorName()
          This method returns the name of the database cursor used by this result set.
 Date getDate(int columnIndex)
          This method returns the value of the specified column as a Java java.sql.Date.
 Date getDate(int columnIndex, Calendar cal)
          This method returns the specified column value as a java.sql.Date.
 Date getDate(String columnName)
          This method returns the value of the specified column as a Java java.sql.Date.
 Date getDate(String columnName, Calendar cal)
          This method returns the specified column value as a java.sql.Date.
 double getDouble(int columnIndex)
          This method returns the value of the specified column as a Java double.
 double getDouble(String columnName)
          This method returns the value of the specified column as a Java double.
 int getFetchDirection()
          This method returns the current fetch direction for this result set.
 int getFetchSize()
          This method returns the current number of rows that will be fetched from the database at a time.
 float getFloat(int columnIndex)
          This method returns the value of the specified column as a Java float.
 float getFloat(String columnName)
          This method returns the value of the specified column as a Java float.
 int getInt(int columnIndex)
          This method returns the value of the specified column as a Java int.
 int getInt(String columnName)
          This method returns the value of the specified column as a Java int.
 long getLong(int columnIndex)
          This method returns the value of the specified column as a Java long.
 long getLong(String columnName)
          This method returns the value of the specified column as a Java long.
 ResultSetMetaData getMetaData()
          This method returns data about the columns returned as part of the result set as a ResultSetMetaData instance.
 Object getObject(int columnIndex)
          This method returns the value of the specified column as a Java Object.
 Object getObject(int columnIndex, Map<String,Class<?>> map)
          This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.
 Object getObject(String columnName)
          This method returns the value of the specified column as a Java Object.
 Object getObject(String columnName, Map<String,Class<?>> map)
          This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.
 Ref getRef(int columnIndex)
          This method returns a Ref for the specified column which represents the structured type for the column.
 Ref getRef(String columnName)
          This method returns a Ref for the specified column which represents the structured type for the column.
 int getRow()
          This method returns the current row number in the cursor.
 short getShort(int columnIndex)
          This method returns the value of the specified column as a Java short.
 short getShort(String columnName)
          This method returns the value of the specified column as a Java short.
 Statement getStatement()
          This method returns a the Statement that was used to produce this result set.
 String getString(int columnIndex)
          This method returns the value of the specified column as a Java String.
 String getString(String columnName)
          This method returns the value of the specified column as a Java String.
 Time getTime(int columnIndex)
          This method returns the value of the specified column as a Java java.sql.Time.
 Time getTime(int columnIndex, Calendar cal)
          This method returns the specified column value as a java.sql.Time.
 Time getTime(String columnName)
          This method returns the value of the specified column as a Java java.sql.Time.
 Time getTime(String columnName, Calendar cal)
          This method returns the specified column value as a java.sql.Time.
 Timestamp getTimestamp(int columnIndex)
          This method returns the value of the specified column as a Java java.sql.Timestamp.
 Timestamp getTimestamp(int columnIndex, Calendar cal)
          This method returns the specified column value as a java.sql.Timestamp.
 Timestamp getTimestamp(String columnName)
          This method returns the value of the specified column as a Java java.sql.Timestamp.
 Timestamp getTimestamp(String columnName, Calendar cal)
          This method returns the specified column value as a java.sql.Timestamp.
 int getType()
          This method returns the result set type of this result set.
 InputStream getUnicodeStream(int columnIndex)
          Deprecated. Use getCharacterStream instead.
 InputStream getUnicodeStream(String columnName)
          Deprecated. Use getCharacterStream instead.
 URL getURL(int columnIndex)
          This method returns the specified column value as a java.net.URL.
 URL getURL(String columnName)
          This method returns the specified column value as a java.net.URL.
 SQLWarning getWarnings()
          This method returns the first SQL warning associated with this result set.
 void insertRow()
          This method inserts the current row into the database.
 boolean isAfterLast()
          This method tests whether or not the cursor is after the last row in the result set.
 boolean isBeforeFirst()
          This method tests whether or not the cursor is before the first row in the result set.
 boolean isFirst()
          This method tests whether or not the cursor is positioned on the first row in the result set.
 boolean isLast()
          This method tests whether or not the cursor is on the last row in the result set.
 boolean last()
          This method repositions the cursor on the last row in the result set.
 void moveToCurrentRow()
          This method moves the result set position from the insert row back to the current row that was selected prior to moving to the insert row.
 void moveToInsertRow()
          This method positions the result set to the "insert row", which allows a new row to be inserted into the database from the result set.
 boolean next()
          This method advances to the next row in the result set.
 boolean previous()
          This method moves the current position to the previous row in the result set.
 void refreshRow()
          This method refreshes the contents of the current row from the database.
 boolean relative(int rows)
          This method moves the result set position relative to the current row.
 boolean rowDeleted()
          This method tests whether or not the current row in the result set has been deleted.
 boolean rowInserted()
          This method tests whether or not the current row in the result set has been inserted.
 boolean rowUpdated()
          This method tests whether or not the current row in the result set has been updated.
 void setFetchDirection(int direction)
          This method provides a hint to the driver about which direction the result set will be processed in.
 void setFetchSize(int rows)
          This method provides a hint to the driver about how many rows at a time it should fetch from the database.
 void updateArray(int columnIndex, Array value)
          This method updates the specified column to have a java.sqlArray value.
 void updateArray(String columnName, Array value)
          This method updates the specified column to have a java.sqlArray value.
 void updateAsciiStream(int columnIndex, InputStream stream, int count)
          This method updates the specified column from an ASCII text stream.
 void updateAsciiStream(String columnName, InputStream stream, int count)
          This method updates the specified column from an ASCII text stream.
 void updateBigDecimal(int columnIndex, BigDecimal value)
          This method updates the specified column to have a BigDecimal value.
 void updateBigDecimal(String columnName, BigDecimal value)
          This method updates the specified column to have a BigDecimal value.
 void updateBinaryStream(int columnIndex, InputStream stream, int count)
          This method updates the specified column from a binary stream.
 void updateBinaryStream(String columnName, InputStream stream, int count)
          This method updates the specified column from a binary stream.
 void updateBlob(int columnIndex, Blob value)
          This method updates the specified column to have a java.sql.Blob value.
 void updateBlob(String columnName, Blob value)
          This method updates the specified column to have a java.sql.Blob value.
 void updateBoolean(int columnIndex, boolean value)
          This method updates the specified column to have a boolean value.
 void updateBoolean(String columnName, boolean value)
          This method updates the specified column to have a boolean value.
 void updateByte(int columnIndex, byte value)
          This method updates the specified column to have a byte value.
 void updateByte(String columnName, byte value)
          This method updates the specified column to have a byte value.
 void updateBytes(int columnIndex, byte[] value)
          This method updates the specified column to have a byte array value.
 void updateBytes(String columnName, byte[] value)
          This method updates the specified column to have a byte array value.
 void updateCharacterStream(int columnIndex, Reader reader, int count)
          This method updates the specified column from a character stream.
 void updateCharacterStream(String columnName, Reader reader, int count)
          This method updates the specified column from a character stream.
 void updateClob(int columnIndex, Clob value)
          This method updates the specified column to have a java.sql.Clob value.
 void updateClob(String columnName, Clob value)
          This method updates the specified column to have a java.sql.Clob value.
 void updateDate(int columnIndex, Date value)
          This method updates the specified column to have a java.sql.Date value.
 void updateDate(String columnName, Date value)
          This method updates the specified column to have a java.sql.Date value.
 void updateDouble(int columnIndex, double value)
          This method updates the specified column to have a double value.
 void updateDouble(String columnName, double value)
          This method updates the specified column to have a double value.
 void updateFloat(int columnIndex, float value)
          This method updates the specified column to have a float value.
 void updateFloat(String columnName, float value)
          This method updates the specified column to have a float value.
 void updateInt(int columnIndex, int value)
          This method updates the specified column to have an int value.
 void updateInt(String columnName, int value)
          This method updates the specified column to have an int value.
 void updateLong(int columnIndex, long value)
          This method updates the specified column to have a long value.
 void updateLong(String columnName, long value)
          This method updates the specified column to have a long value.
 void updateNull(int columnIndex)
          This method updates the specified column to have a NULL value.
 void updateNull(String columnName)
          This method updates the specified column to have a NULL value.
 void updateObject(int columnIndex, Object value)
          This method updates the specified column to have an Object value.
 void updateObject(int columnIndex, Object value, int scale)
          This method updates the specified column to have an Object value.
 void updateObject(String columnName, Object value)
          This method updates the specified column to have an Object value.
 void updateObject(String columnName, Object value, int scale)
          This method updates the specified column to have an Object value.
 void updateRef(int columnIndex, Ref value)
          This method updates the specified column to have a java.sql.Ref value.
 void updateRef(String columnName, Ref value)
          This method updates the specified column to have a java.sql.Ref value.
 void updateRow()
          This method updates the current row in the database.
 void updateShort(int columnIndex, short value)
          This method updates the specified column to have a short value.
 void updateShort(String columnName, short value)
          This method updates the specified column to have a short value.
 void updateString(int columnIndex, String value)
          This method updates the specified column to have a String value.
 void updateString(String columnName, String value)
          This method updates the specified column to have a String value.
 void updateTime(int columnIndex, Time value)
          This method updates the specified column to have a java.sql.Time value.
 void updateTime(String columnName, Time value)
          This method updates the specified column to have a java.sql.Time value.
 void updateTimestamp(int columnIndex, Timestamp value)
          This method updates the specified column to have a java.sql.Timestamp value.
 void updateTimestamp(String columnName, Timestamp value)
          This method updates the specified column to have a java.sql.Timestamp value.
 boolean wasNull()
          This method tests whether the value of the last column that was fetched was actually a SQL NULL value.
 

Field Detail

FETCH_FORWARD

static final int FETCH_FORWARD
The rows will be processed in order from first to last.

See Also:
Constant Field Values

FETCH_REVERSE

static final int FETCH_REVERSE
The rows will be processed in order from last to first.

See Also:
Constant Field Values

FETCH_UNKNOWN

static final int FETCH_UNKNOWN
The rows will be processed in an unknown order

See Also:
Constant Field Values

TYPE_FORWARD_ONLY

static final int TYPE_FORWARD_ONLY
This type of result set may only step forward through the rows returned.

See Also:
Constant Field Values

TYPE_SCROLL_INSENSITIVE

static final int TYPE_SCROLL_INSENSITIVE
This type of result set is scrollable and is not sensitive to changes made by other statements.

See Also:
Constant Field Values

TYPE_SCROLL_SENSITIVE

static final int TYPE_SCROLL_SENSITIVE
This type of result set is scrollable and is also sensitive to changes made by other statements.

See Also:
Constant Field Values

CONCUR_READ_ONLY

static final int CONCUR_READ_ONLY
The concurrency mode of for the result set may not be modified.

See Also:
Constant Field Values

CONCUR_UPDATABLE

static final int CONCUR_UPDATABLE
The concurrency mode of for the result set may be modified.

See Also:
Constant Field Values

HOLD_CURSORS_OVER_COMMIT

static final int HOLD_CURSORS_OVER_COMMIT
See Also:
Constant Field Values

CLOSE_CURSORS_AT_COMMIT

static final int CLOSE_CURSORS_AT_COMMIT
See Also:
Constant Field Values
Method Detail

next

boolean next()
             throws SQLException
This method advances to the next row in the result set. Any streams open on the current row are closed automatically.

Returns:
true if the next row exists, false otherwise.
Throws:
SQLException - If an error occurs.

close

void close()
           throws SQLException
This method closes the result set and frees any associated resources.

Throws:
SQLException - If an error occurs.

wasNull

boolean wasNull()
                throws SQLException
This method tests whether the value of the last column that was fetched was actually a SQL NULL value.

Returns:
true if the last column fetched was a NULL, false otherwise.
Throws:
SQLException - If an error occurs.

getString

String getString(int columnIndex)
                 throws SQLException
This method returns the value of the specified column as a Java String.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a String.
Throws:
SQLException - If an error occurs.

getBoolean

boolean getBoolean(int columnIndex)
                   throws SQLException
This method returns the value of the specified column as a Java boolean.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a boolean.
Throws:
SQLException - If an error occurs.

getByte

byte getByte(int columnIndex)
             throws SQLException
This method returns the value of the specified column as a Java byte.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a byte.
Throws:
SQLException - If an error occurs.

getShort

short getShort(int columnIndex)
               throws SQLException
This method returns the value of the specified column as a Java short.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a short.
Throws:
SQLException - If an error occurs.

getInt

int getInt(int columnIndex)
           throws SQLException
This method returns the value of the specified column as a Java int.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a int.
Throws:
SQLException - If an error occurs.

getLong

long getLong(int columnIndex)
             throws SQLException
This method returns the value of the specified column as a Java long.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a long.
Throws:
SQLException - If an error occurs.

getFloat

float getFloat(int columnIndex)
               throws SQLException
This method returns the value of the specified column as a Java float.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a float.
Throws:
SQLException - If an error occurs.

getDouble

double getDouble(int columnIndex)
                 throws SQLException
This method returns the value of the specified column as a Java double.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a double.
Throws:
SQLException - If an error occurs.

getBigDecimal

BigDecimal getBigDecimal(int columnIndex,
                         int scale)
                         throws SQLException
Deprecated. 

This method returns the value of the specified column as a Java BigDecimal.

Parameters:
columnIndex - The index of the column to return.
scale - The number of digits to the right of the decimal to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBytes

byte[] getBytes(int columnIndex)
                throws SQLException
This method returns the value of the specified column as a Java byte array.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a byte array
Throws:
SQLException - If an error occurs.

getDate

Date getDate(int columnIndex)
             throws SQLException
This method returns the value of the specified column as a Java java.sql.Date.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getTime

Time getTime(int columnIndex)
             throws SQLException
This method returns the value of the specified column as a Java java.sql.Time.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTimestamp

Timestamp getTimestamp(int columnIndex)
                       throws SQLException
This method returns the value of the specified column as a Java java.sql.Timestamp.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getAsciiStream

InputStream getAsciiStream(int columnIndex)
                           throws SQLException
This method returns the value of the specified column as an ASCII stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as an ASCII InputStream.
Throws:
SQLException - If an error occurs.

getUnicodeStream

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

This method returns the value of the specified column as a Unicode UTF-8 stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a Unicode UTF-8 InputStream.
Throws:
SQLException - If an error occurs.

getBinaryStream

InputStream getBinaryStream(int columnIndex)
                            throws SQLException
This method returns the value of the specified column as a raw byte stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a raw byte InputStream.
Throws:
SQLException - If an error occurs.

getString

String getString(String columnName)
                 throws SQLException
This method returns the value of the specified column as a Java String.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a String.
Throws:
SQLException - If an error occurs.

getBoolean

boolean getBoolean(String columnName)
                   throws SQLException
This method returns the value of the specified column as a Java boolean.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a boolean.
Throws:
SQLException - If an error occurs.

getByte

byte getByte(String columnName)
             throws SQLException
This method returns the value of the specified column as a Java byte.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a byte.
Throws:
SQLException - If an error occurs.

getShort

short getShort(String columnName)
               throws SQLException
This method returns the value of the specified column as a Java short.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a short.
Throws:
SQLException - If an error occurs.

getInt

int getInt(String columnName)
           throws SQLException
This method returns the value of the specified column as a Java int.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a int.
Throws:
SQLException - If an error occurs.

getLong

long getLong(String columnName)
             throws SQLException
This method returns the value of the specified column as a Java long.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a long.
Throws:
SQLException - If an error occurs.

getFloat

float getFloat(String columnName)
               throws SQLException
This method returns the value of the specified column as a Java float.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a float.
Throws:
SQLException - If an error occurs.

getDouble

double getDouble(String columnName)
                 throws SQLException
This method returns the value of the specified column as a Java double.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a double.
Throws:
SQLException - If an error occurs.

getBigDecimal

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

This method returns the value of the specified column as a Java BigDecimal.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBytes

byte[] getBytes(String columnName)
                throws SQLException
This method returns the value of the specified column as a Java byte array.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a byte array
Throws:
SQLException - If an error occurs.

getDate

Date getDate(String columnName)
             throws SQLException
This method returns the value of the specified column as a Java java.sql.Date.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getTime

Time getTime(String columnName)
             throws SQLException
This method returns the value of the specified column as a Java java.sql.Time.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTimestamp

Timestamp getTimestamp(String columnName)
                       throws SQLException
This method returns the value of the specified column as a Java java.sql.Timestamp.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getAsciiStream

InputStream getAsciiStream(String columnName)
                           throws SQLException
This method returns the value of the specified column as an ASCII stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as an ASCII InputStream.
Throws:
SQLException - If an error occurs.

getUnicodeStream

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

This method returns the value of the specified column as a Unicode UTF-8 stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a Unicode UTF-8 InputStream.
Throws:
SQLException - If an error occurs.

getBinaryStream

InputStream getBinaryStream(String columnName)
                            throws SQLException
This method returns the value of the specified column as a raw byte stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a raw byte InputStream.
Throws:
SQLException - If an error occurs.

getWarnings

SQLWarning getWarnings()
                       throws SQLException
This method returns the first SQL warning associated with this result set. Any additional warnings will be chained to this one.

Returns:
The first SQLWarning for this result set, or null if there are no warnings.
Throws:
SQLException - If an error occurs.

clearWarnings

void clearWarnings()
                   throws SQLException
This method clears all warnings associated with this result set.

Throws:
SQLException - If an error occurs.

getCursorName

String getCursorName()
                     throws SQLException
This method returns the name of the database cursor used by this result set.

Returns:
The name of the database cursor used by this result set.
Throws:
SQLException - If an error occurs.

getMetaData

ResultSetMetaData getMetaData()
                              throws SQLException
This method returns data about the columns returned as part of the result set as a ResultSetMetaData instance.

Returns:
The ResultSetMetaData instance for this result set.
Throws:
SQLException - If an error occurs.

getObject

Object getObject(int columnIndex)
                 throws SQLException
This method returns the value of the specified column as a Java Object.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as an Object.
Throws:
SQLException - If an error occurs.

getObject

Object getObject(String columnName)
                 throws SQLException
This method returns the value of the specified column as a Java Object.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as an Object.
Throws:
SQLException - If an error occurs.

findColumn

int findColumn(String columnName)
               throws SQLException
This method returns the column index of the specified named column.

Parameters:
columnName - The name of the column.
Returns:
The index of the column.
Throws:
SQLException - If an error occurs.

getCharacterStream

Reader getCharacterStream(int columnIndex)
                          throws SQLException
This method returns the value of the specified column as a character stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as an character Reader.
Throws:
SQLException - If an error occurs.

getCharacterStream

Reader getCharacterStream(String columnName)
                          throws SQLException
This method returns the value of the specified column as a character stream. Note that all the data from this stream must be read before fetching the value of any other column. Please also be aware that calling next() or close() on this result set will close this stream as well.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as an character Reader.
Throws:
SQLException - If an error occurs.

getBigDecimal

BigDecimal getBigDecimal(int columnIndex)
                         throws SQLException
This method returns the value of the specified column as a Java BigDecimal.

Parameters:
columnIndex - The index of the column to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

getBigDecimal

BigDecimal getBigDecimal(String columnName)
                         throws SQLException
This method returns the value of the specified column as a Java BigDecimal.

Parameters:
columnName - The name of the column to return.
Returns:
The column value as a BigDecimal.
Throws:
SQLException - If an error occurs.

isBeforeFirst

boolean isBeforeFirst()
                      throws SQLException
This method tests whether or not the cursor is before the first row in the result set.

Returns:
true if the cursor is positioned before the first row, false otherwise.
Throws:
SQLException - If an error occurs.

isAfterLast

boolean isAfterLast()
                    throws SQLException
This method tests whether or not the cursor is after the last row in the result set.

Returns:
true if the cursor is positioned after the last row, false otherwise.
Throws:
SQLException - If an error occurs.

isFirst

boolean isFirst()
                throws SQLException
This method tests whether or not the cursor is positioned on the first row in the result set.

Returns:
true if the cursor is positioned on the first row, false otherwise.
Throws:
SQLException - If an error occurs.

isLast

boolean isLast()
               throws SQLException
This method tests whether or not the cursor is on the last row in the result set.

Returns:
true if the cursor is positioned on the last row, false otherwise.
Throws:
SQLException - If an error occurs.

beforeFirst

void beforeFirst()
                 throws SQLException
This method repositions the cursor to before the first row in the result set.

Throws:
SQLException - If an error occurs.

afterLast

void afterLast()
               throws SQLException
This method repositions the cursor to after the last row in the result set.

Throws:
SQLException - If an error occurs.

first

boolean first()
              throws SQLException
This method repositions the cursor on the first row in the result set.

Returns:
true if the cursor is on a valid row; false if there are no rows in the result set.
Throws:
SQLException - If an error occurs.

last

boolean last()
             throws SQLException
This method repositions the cursor on the last row in the result set.

Returns:
true if the cursor is on a valid row; false if there are no rows in the result set.
Throws:
SQLException - If an error occurs.

getRow

int getRow()
           throws SQLException
This method returns the current row number in the cursor. Numbering begins at index 1.

Returns:
The current row number, or 0 if there is not current row.
Throws:
SQLException - If an error occurs.

absolute

boolean absolute(int row)
                 throws SQLException
This method positions the result set to the specified absolute row. Positive numbers are row offsets from the beginning of the result set (numbering starts from row 1) and negative numbers are row offsets from the end of the result set (numbering starts from -1).

Parameters:
row - The row to position the result set to.
Returns:
true if the current position was changed, false otherwise.
Throws:
SQLException - If an error occurs.

relative

boolean relative(int rows)
                 throws SQLException
This method moves the result set position relative to the current row. The offset can be positive or negative.

Parameters:
rows - The number of row positions to move.
Returns:
true if the current position was changed, false otherwise.
Throws:
SQLException - If an error occurs.

previous

boolean previous()
                 throws SQLException
This method moves the current position to the previous row in the result set.

Returns:
true if the previous row exists, false otherwise.
Throws:
SQLException - If an error occurs.

setFetchDirection

void setFetchDirection(int direction)
                       throws SQLException
This method provides a hint to the driver about which direction the result set will be processed in.

Parameters:
direction - The direction in which rows will be processed. The allowed values are the FETCH_* constants defined in this interface.
Throws:
SQLException - If an error occurs.

getFetchDirection

int getFetchDirection()
                      throws SQLException
This method returns the current fetch direction for this result set.

Returns:
The fetch direction for this result set.
Throws:
SQLException - If an error occurs.

setFetchSize

void setFetchSize(int rows)
                  throws SQLException
This method provides a hint to the driver about how many rows at a time it should fetch from the database.

Parameters:
rows - The number of rows the driver should fetch per call.
Throws:
SQLException - If an error occurs.

getFetchSize

int getFetchSize()
                 throws SQLException
This method returns the current number of rows that will be fetched from the database at a time.

Returns:
The current fetch size for this result set.
Throws:
SQLException - If an error occurs.

getType

int getType()
            throws SQLException
This method returns the result set type of this result set. This will be one of the TYPE_* constants defined in this interface.

Returns:
The result set type.
Throws:
SQLException - If an error occurs.

getConcurrency

int getConcurrency()
                   throws SQLException
This method returns the concurrency type of this result set. This will be one of the CONCUR_* constants defined in this interface.

Returns:
The result set concurrency type.
Throws:
SQLException - If an error occurs.

rowUpdated

boolean rowUpdated()
                   throws SQLException
This method tests whether or not the current row in the result set has been updated. Updates must be visible in order of this method to detect the update.

Returns:
true if the row has been updated, false otherwise.
Throws:
SQLException - If an error occurs.

rowInserted

boolean rowInserted()
                    throws SQLException
This method tests whether or not the current row in the result set has been inserted. Inserts must be visible in order of this method to detect the insert.

Returns:
true if the row has been inserted, false otherwise.
Throws:
SQLException - If an error occurs.

rowDeleted

boolean rowDeleted()
                   throws SQLException
This method tests whether or not the current row in the result set has been deleted. Deletes must be visible in order of this method to detect the deletion.

Returns:
true if the row has been deleted, false otherwise.
Throws:
SQLException - If an error occurs.

updateNull

void updateNull(int columnIndex)
                throws SQLException
This method updates the specified column to have a NULL value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
Throws:
SQLException - If an error occurs.

updateBoolean

void updateBoolean(int columnIndex,
                   boolean value)
                   throws SQLException
This method updates the specified column to have a boolean value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateByte

void updateByte(int columnIndex,
                byte value)
                throws SQLException
This method updates the specified column to have a byte value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateShort

void updateShort(int columnIndex,
                 short value)
                 throws SQLException
This method updates the specified column to have a short value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateInt

void updateInt(int columnIndex,
               int value)
               throws SQLException
This method updates the specified column to have an int value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateLong

void updateLong(int columnIndex,
                long value)
                throws SQLException
This method updates the specified column to have a long value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateFloat

void updateFloat(int columnIndex,
                 float value)
                 throws SQLException
This method updates the specified column to have a float value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateDouble

void updateDouble(int columnIndex,
                  double value)
                  throws SQLException
This method updates the specified column to have a double value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBigDecimal

void updateBigDecimal(int columnIndex,
                      BigDecimal value)
                      throws SQLException
This method updates the specified column to have a BigDecimal value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateString

void updateString(int columnIndex,
                  String value)
                  throws SQLException
This method updates the specified column to have a String value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBytes

void updateBytes(int columnIndex,
                 byte[] value)
                 throws SQLException
This method updates the specified column to have a byte array value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateDate

void updateDate(int columnIndex,
                Date value)
                throws SQLException
This method updates the specified column to have a java.sql.Date value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTime

void updateTime(int columnIndex,
                Time value)
                throws SQLException
This method updates the specified column to have a java.sql.Time value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTimestamp

void updateTimestamp(int columnIndex,
                     Timestamp value)
                     throws SQLException
This method updates the specified column to have a java.sql.Timestamp value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateAsciiStream

void updateAsciiStream(int columnIndex,
                       InputStream stream,
                       int count)
                       throws SQLException
This method updates the specified column from an ASCII text stream. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateBinaryStream

void updateBinaryStream(int columnIndex,
                        InputStream stream,
                        int count)
                        throws SQLException
This method updates the specified column from a binary stream. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateCharacterStream

void updateCharacterStream(int columnIndex,
                           Reader reader,
                           int count)
                           throws SQLException
This method updates the specified column from a character stream. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
reader - The reader from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateObject

void updateObject(int columnIndex,
                  Object value,
                  int scale)
                  throws SQLException
This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
scale - The scale of the object in question, which is used only for numeric type objects.
Throws:
SQLException - If an error occurs.

updateObject

void updateObject(int columnIndex,
                  Object value)
                  throws SQLException
This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnIndex - The index of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateNull

void updateNull(String columnName)
                throws SQLException
This method updates the specified column to have a NULL value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
Throws:
SQLException - If an error occurs.

updateBoolean

void updateBoolean(String columnName,
                   boolean value)
                   throws SQLException
This method updates the specified column to have a boolean value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateByte

void updateByte(String columnName,
                byte value)
                throws SQLException
This method updates the specified column to have a byte value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateShort

void updateShort(String columnName,
                 short value)
                 throws SQLException
This method updates the specified column to have a short value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateInt

void updateInt(String columnName,
               int value)
               throws SQLException
This method updates the specified column to have an int value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateLong

void updateLong(String columnName,
                long value)
                throws SQLException
This method updates the specified column to have a long value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateFloat

void updateFloat(String columnName,
                 float value)
                 throws SQLException
This method updates the specified column to have a float value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateDouble

void updateDouble(String columnName,
                  double value)
                  throws SQLException
This method updates the specified column to have a double value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBigDecimal

void updateBigDecimal(String columnName,
                      BigDecimal value)
                      throws SQLException
This method updates the specified column to have a BigDecimal value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateString

void updateString(String columnName,
                  String value)
                  throws SQLException
This method updates the specified column to have a String value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateBytes

void updateBytes(String columnName,
                 byte[] value)
                 throws SQLException
This method updates the specified column to have a byte array value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateDate

void updateDate(String columnName,
                Date value)
                throws SQLException
This method updates the specified column to have a java.sql.Date value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTime

void updateTime(String columnName,
                Time value)
                throws SQLException
This method updates the specified column to have a java.sql.Time value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateTimestamp

void updateTimestamp(String columnName,
                     Timestamp value)
                     throws SQLException
This method updates the specified column to have a java.sql.Timestamp value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

updateAsciiStream

void updateAsciiStream(String columnName,
                       InputStream stream,
                       int count)
                       throws SQLException
This method updates the specified column from an ASCII text stream. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateBinaryStream

void updateBinaryStream(String columnName,
                        InputStream stream,
                        int count)
                        throws SQLException
This method updates the specified column from a binary stream. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
stream - The stream from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateCharacterStream

void updateCharacterStream(String columnName,
                           Reader reader,
                           int count)
                           throws SQLException
This method updates the specified column from a character stream. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
reader - The reader from which the column value is updated.
count - The length of the stream.
Throws:
SQLException - If an error occurs.

updateObject

void updateObject(String columnName,
                  Object value,
                  int scale)
                  throws SQLException
This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
scale - The scale of the object in question, which is used only for numeric type objects.
Throws:
SQLException - If an error occurs.

updateObject

void updateObject(String columnName,
                  Object value)
                  throws SQLException
This method updates the specified column to have an Object value. This does not update the actual database. updateRow must be called in order to do that.

Parameters:
columnName - The name of the column to update.
value - The new value of the column.
Throws:
SQLException - If an error occurs.

insertRow

void insertRow()
               throws SQLException
This method inserts the current row into the database. The result set must be positioned on the insert row in order to call this method successfully.

Throws:
SQLException - If an error occurs.

updateRow

void updateRow()
               throws SQLException
This method updates the current row in the database.

Throws:
SQLException - If an error occurs.

deleteRow

void deleteRow()
               throws SQLException
This method deletes the current row in the database.

Throws:
SQLException - If an error occurs.

refreshRow

void refreshRow()
                throws SQLException
This method refreshes the contents of the current row from the database.

Throws:
SQLException - If an error occurs.

cancelRowUpdates

void cancelRowUpdates()
                      throws SQLException
This method cancels any changes that have been made to a row. If the rowUpdate method has been called, then the changes cannot be undone.

Throws:
SQLException - If an error occurs.

moveToInsertRow

void moveToInsertRow()
                     throws SQLException
This method positions the result set to the "insert row", which allows a new row to be inserted into the database from the result set.

Throws:
SQLException - If an error occurs.

moveToCurrentRow

void moveToCurrentRow()
                      throws SQLException
This method moves the result set position from the insert row back to the current row that was selected prior to moving to the insert row.

Throws:
SQLException - If an error occurs.

getStatement

Statement getStatement()
                       throws SQLException
This method returns a the Statement that was used to produce this result set.

Returns:
The Statement used to produce this result set.
Throws:
SQLException - If an error occurs.

getObject

Object getObject(int columnIndex,
                 Map<String,Class<?>> map)
                 throws SQLException
This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.

Parameters:
columnIndex - The index of the column to return.
map - The SQL type to Java type map to use.
Returns:
The value of the column as an Object.
Throws:
SQLException - If an error occurs.

getRef

Ref getRef(int columnIndex)
           throws SQLException
This method returns a Ref for the specified column which represents the structured type for the column.

Parameters:
columnIndex - The index of the column to return.
Returns:
A Ref object for the column
Throws:
SQLException - If an error occurs.

getBlob

Blob getBlob(int columnIndex)
             throws SQLException
This method returns the specified column value as a BLOB.

Parameters:
columnIndex - The index of the column value to return.
Returns:
The value of the column as a BLOB.
Throws:
SQLException - If an error occurs.

getClob

Clob getClob(int columnIndex)
             throws SQLException
This method returns the specified column value as a CLOB.

Parameters:
columnIndex - The index of the column value to return.
Returns:
The value of the column as a CLOB.
Throws:
SQLException - If an error occurs.

getArray

Array getArray(int columnIndex)
               throws SQLException
This method returns the specified column value as an Array.

Parameters:
columnIndex - The index of the column value to return.
Returns:
The value of the column as an Array.
Throws:
SQLException - If an error occurs.

getObject

Object getObject(String columnName,
                 Map<String,Class<?>> map)
                 throws SQLException
This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.

Parameters:
columnName - The name of the column to return.
map - The SQL type to Java type map to use.
Returns:
The value of the column as an Object.
Throws:
SQLException - If an error occurs.

getRef

Ref getRef(String columnName)
           throws SQLException
This method returns a Ref for the specified column which represents the structured type for the column.

Parameters:
columnName - The name of the column to return.
Returns:
A Ref object for the column
Throws:
SQLException - If an error occurs.

getBlob

Blob getBlob(String columnName)
             throws SQLException
This method returns the specified column value as a BLOB.

Parameters:
columnName - The name of the column value to return.
Returns:
The value of the column as a BLOB.
Throws:
SQLException - If an error occurs.

getClob

Clob getClob(String columnName)
             throws SQLException
This method returns the specified column value as a CLOB.

Parameters:
columnName - The name of the column value to return.
Returns:
The value of the column as a CLOB.
Throws:
SQLException - If an error occurs.

getArray

Array getArray(String columnName)
               throws SQLException
This method returns the specified column value as an Array.

Parameters:
columnName - The name of the column value to return.
Returns:
The value of the column as an Array.
Throws:
SQLException - If an error occurs.

getDate

Date getDate(int columnIndex,
             Calendar cal)
             throws SQLException
This method returns the specified column value as a java.sql.Date. The specified Calendar is used to generate a value for the date if the database does not support timezones.

Parameters:
columnIndex - The index of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getDate

Date getDate(String columnName,
             Calendar cal)
             throws SQLException
This method returns the specified column value as a java.sql.Date. The specified Calendar is used to generate a value for the date if the database does not support timezones.

Parameters:
columnName - The name of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Date.
Throws:
SQLException - If an error occurs.

getTime

Time getTime(int columnIndex,
             Calendar cal)
             throws SQLException
This method returns the specified column value as a java.sql.Time. The specified Calendar is used to generate a value for the time if the database does not support timezones.

Parameters:
columnIndex - The index of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTime

Time getTime(String columnName,
             Calendar cal)
             throws SQLException
This method returns the specified column value as a java.sql.Time. The specified Calendar is used to generate a value for the time if the database does not support timezones.

Parameters:
columnName - The name of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Time.
Throws:
SQLException - If an error occurs.

getTimestamp

Timestamp getTimestamp(int columnIndex,
                       Calendar cal)
                       throws SQLException
This method returns the specified column value as a java.sql.Timestamp. The specified Calendar is used to generate a value for the timestamp if the database does not support timezones.

Parameters:
columnIndex - The index of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getTimestamp

Timestamp getTimestamp(String columnName,
                       Calendar cal)
                       throws SQLException
This method returns the specified column value as a java.sql.Timestamp. The specified Calendar is used to generate a value for the timestamp if the database does not support timezones.

Parameters:
columnName - The name of the column value to return.
cal - The Calendar to use for calculating timezones.
Returns:
The value of the column as a java.sql.Timestamp.
Throws:
SQLException - If an error occurs.

getURL

URL getURL(int columnIndex)
           throws SQLException
This method returns the specified column value as a java.net.URL.

Parameters:
columnIndex - The index of the column value to return.
Throws:
SQLException - If an error occurs.
Since:
1.4

getURL

URL getURL(String columnName)
           throws SQLException
This method returns the specified column value as a java.net.URL.

Parameters:
columnName - The name of the column value to return.
Throws:
SQLException - If an error occurs.
Since:
1.4

updateRef

void updateRef(int columnIndex,
               Ref value)
               throws SQLException
This method updates the specified column to have a java.sql.Ref value. This does not update the actual database. updateRow must be called in order to do that.

Throws:
SQLException - If an error occurs.
Since:
1.4

updateRef

void updateRef(String columnName,
               Ref value)
               throws SQLException
This method updates the specified column to have a java.sql.Ref value. This does not update the actual database. updateRow must be called in order to do that.

Throws:
SQLException - If an error occurs.
Since:
1.4

updateBlob

void updateBlob(int columnIndex,
                Blob value)
                throws SQLException
This method updates the specified column to have a java.sql.Blob value. This does not update the actual database. updateRow must be called in order to do that.

Throws:
SQLException - If an error occurs.
Since:
1.4

updateBlob

void updateBlob(String columnName,
                Blob value)
                throws SQLException
This method updates the specified column to have a java.sql.Blob value. This does not update the actual database. updateRow must be called in order to do that.

Throws:
SQLException - If an error occurs.
Since:
1.4

updateClob

void updateClob(int columnIndex,
                Clob value)
                throws SQLException
This method updates the specified column to have a java.sql.Clob value. This does not update the actual database. updateRow must be called in order to do that.

Throws:
SQLException - If an error occurs.
Since:
1.4

updateClob

void updateClob(String columnName,
                Clob value)
                throws SQLException
This method updates the specified column to have a java.sql.Clob value. This does not update the actual database. updateRow must be called in order to do that.

Throws:
SQLException - If an error occurs.
Since:
1.4

updateArray

void updateArray(int columnIndex,
                 Array value)
                 throws SQLException
This method updates the specified column to have a java.sqlArray value. This does not update the actual database. updateRow must be called in order to do that.

Throws:
SQLException - If an error occurs.
Since:
1.4

updateArray

void updateArray(String columnName,
                 Array value)
                 throws SQLException
This method updates the specified column to have a java.sqlArray value. This does not update the actual database. updateRow must be called in order to do that.

Throws:
SQLException - If an error occurs.
Since:
1.4