IntegrateResultSet (Integrate API)

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

br.ufg.integrate.wrapper.jdbc
Class IntegrateResultSet

java.lang.Object
  br.ufg.integrate.wrapper.jdbc.IntegrateResultSet

All Implemented Interfaces:: ResultSet, Wrapper

Direct Known Subclasses:: ResultSetImpl

public abstract class IntegrateResultSet
extends Object
implements ResultSet
extends Object
implements ResultSet

Version:: 0.1 Classe abstrata que implementa a classe java.sql.ResultSet. Os métodos a serem implementados são os mais básicos da interface implementada, permitindo a implementação de classes para um driver JDBC básico, sem todos os recursos da API. os métodos que não são abstratos não estão implementados, e apenas lançam uma exceção. Extensões desta classe podem sobrepor os métodos que acharem necessários.
Author:: Rogerio

Field Summary

Fields inherited from interface java.sql.ResultSet
`CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE`

Constructor Summary
`IntegrateResultSet()`

Method Summary
`boolean`	`absolute(int row)` /**
`void`	`afterLast()`
`void`	`beforeFirst()`
`void`	`cancelRowUpdates()` Cancels the updates made to the current row in this `ResultSet` object.
`void`	`clearWarnings()` Clears all warnings reported on this `ResultSet` object.
`abstract void`	`close()`
`void`	`deleteRow()` Deletes the current row from this `ResultSet` object and from the underlying database.
`abstract int`	`findColumn(String columnName)`
`abstract boolean`	`first()`
`Array`	`getArray(int i)` 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 colName)` 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)`
`InputStream`	`getAsciiStream(String columnName)`
`BigDecimal`	`getBigDecimal(int columnIndex)`
`BigDecimal`	`getBigDecimal(int columnIndex, int scale)`
`BigDecimal`	`getBigDecimal(String columnName)`
`BigDecimal`	`getBigDecimal(String columnName, int scale)`
`InputStream`	`getBinaryStream(int columnIndex)`
`InputStream`	`getBinaryStream(String columnName)`
`Blob`	`getBlob(int i)` 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 colName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
`abstract boolean`	`getBoolean(int columnIndex)`
`abstract boolean`	`getBoolean(String columnName)`
`byte`	`getByte(int columnIndex)`
`byte`	`getByte(String columnName)`
`byte[]`	`getBytes(int columnIndex)`
`byte[]`	`getBytes(String columnName)`
`Reader`	`getCharacterStream(int columnIndex)`
`Reader`	`getCharacterStream(String columnName)`
`Clob`	`getClob(int i)` 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 colName)` 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()`
`String`	`getCursorName()` Retrieves the name of the SQL cursor used by this `ResultSet` object.
`abstract Date`	`getDate(int columnIndex)`
`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.
`abstract Date`	`getDate(String columnName)`
`Date`	`getDate(String columnName, 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.
`abstract double`	`getDouble(int columnIndex)`
`abstract double`	`getDouble(String columnName)`
`int`	`getFetchDirection()`
`int`	`getFetchSize()` Retrieves the fetch size for this `ResultSet` object.
`abstract float`	`getFloat(int columnIndex)`
`abstract float`	`getFloat(String columnName)`
`int`	`getHoldability()`
`abstract int`	`getInt(int columnIndex)`
`abstract int`	`getInt(String columnName)`
`abstract long`	`getLong(int columnIndex)`
`abstract long`	`getLong(String columnName)`
`abstract ResultSetMetaData`	`getMetaData()` Retrieves the number, types and properties of this `ResultSet` object's columns.
`Reader`	`getNCharacterStream(int arg0)`
`Reader`	`getNCharacterStream(String arg0)`
`NClob`	`getNClob(int arg0)`
`NClob`	`getNClob(String arg0)`
`String`	`getNString(int arg0)`
`String`	`getNString(String arg0)`
`abstract Object`	`getObject(int columnIndex)`
`Object`	`getObject(int i, 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.
`abstract Object`	`getObject(String columnName)`
`Object`	`getObject(String colName, 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 i)` 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 colName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
`abstract int`	`getRow()`
`RowId`	`getRowId(int arg0)`
`RowId`	`getRowId(String arg0)`
`abstract short`	`getShort(int columnIndex)`
`abstract short`	`getShort(String columnName)`
`SQLXML`	`getSQLXML(int arg0)`
`SQLXML`	`getSQLXML(String arg0)`
`abstract Statement`	`getStatement()`
`abstract String`	`getString(int columnIndex)`
`abstract String`	`getString(String columnName)`
`abstract Time`	`getTime(int columnIndex)`
`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.
`abstract Time`	`getTime(String columnName)`
`Time`	`getTime(String columnName, 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)`
`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 columnName)`
`Timestamp`	`getTimestamp(String columnName, 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.
`abstract int`	`getType()`
`InputStream`	`getUnicodeStream(int columnIndex)`
`InputStream`	`getUnicodeStream(String columnName)`
`URL`	`getURL(int columnIndex)`
`URL`	`getURL(String columnName)`
`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()`
`boolean`	`isBeforeFirst()`
`abstract boolean`	`isClosed()`
`abstract boolean`	`isFirst()`
`abstract boolean`	`isLast()`
`boolean`	`isWrapperFor(Class arg0)`
`abstract boolean`	`last()`
`void`	`moveToCurrentRow()` Moves the cursor to the remembered cursor position, usually the current row.
`void`	`moveToInsertRow()` Moves the cursor to the insert row.
`abstract boolean`	`next()`
`abstract boolean`	`previous()`
`void`	`refreshRow()` Refreshes the current row with its most recent value in the database.
`boolean`	`relative(int rows)`
`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.
`Object`	`unwrap(Class arg0)`
`void`	`updateArray(int columnIndex, Array x)`
`void`	`updateArray(String columnName, Array x)`
`void`	`updateAsciiStream(int arg0, InputStream arg1)`
`void`	`updateAsciiStream(int columnIndex, InputStream x, int length)` Updates the designated column with an ascii stream value.
`void`	`updateAsciiStream(int arg0, InputStream arg1, long arg2)`
`void`	`updateAsciiStream(String arg0, InputStream arg1)`
`void`	`updateAsciiStream(String columnName, InputStream x, int length)` Updates the designated column with an ascii stream value.
`void`	`updateAsciiStream(String arg0, InputStream arg1, long arg2)`
`void`	`updateBigDecimal(int columnIndex, BigDecimal x)` Updates the designated column with a `java.math.BigDecimal` value.
`void`	`updateBigDecimal(String columnName, BigDecimal x)` Updates the designated column with a `java.sql.BigDecimal` value.
`void`	`updateBinaryStream(int arg0, InputStream arg1)`
`void`	`updateBinaryStream(int columnIndex, InputStream x, int length)` Updates the designated column with a binary stream value.
`void`	`updateBinaryStream(int arg0, InputStream arg1, long arg2)`
`void`	`updateBinaryStream(String arg0, InputStream arg1)`
`void`	`updateBinaryStream(String columnName, InputStream x, int length)` Updates the designated column with a binary stream value.
`void`	`updateBinaryStream(String arg0, InputStream arg1, long arg2)`
`void`	`updateBlob(int columnIndex, Blob x)`
`void`	`updateBlob(int arg0, InputStream arg1)`
`void`	`updateBlob(int arg0, InputStream arg1, long arg2)`
`void`	`updateBlob(String columnName, Blob x)`
`void`	`updateBlob(String arg0, InputStream arg1)`
`void`	`updateBlob(String arg0, InputStream arg1, long arg2)`
`void`	`updateBoolean(int columnIndex, boolean x)` Updates the designated column with a `boolean` value.
`void`	`updateBoolean(String columnName, 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 columnName, byte x)` Updates the designated column with a `byte` value.
`void`	`updateBytes(int columnIndex, byte[] x)`
`void`	`updateBytes(String columnName, byte[] x)` Updates the designated column with a byte array value.
`void`	`updateCharacterStream(int arg0, Reader arg1)`
`void`	`updateCharacterStream(int columnIndex, Reader x, int length)` Updates the designated column with a character stream value.
`void`	`updateCharacterStream(int arg0, Reader arg1, long arg2)`
`void`	`updateCharacterStream(String arg0, Reader arg1)`
`void`	`updateCharacterStream(String columnNameIndex, Reader x, int length)` Updates the designated column with a character stream value.
`void`	`updateCharacterStream(String arg0, Reader arg1, long arg2)`
`void`	`updateClob(int columnIndex, Clob x)`
`void`	`updateClob(int arg0, Reader arg1)`
`void`	`updateClob(int arg0, Reader arg1, long arg2)`
`void`	`updateClob(String columnName, Clob x)`
`void`	`updateClob(String arg0, Reader arg1)`
`void`	`updateClob(String arg0, Reader arg1, long arg2)`
`void`	`updateDate(int columnIndex, Date x)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDate(String columnName, 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 columnName, 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 columnName, 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 columnName, 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 columnName, long x)` Updates the designated column with a `long` value.
`void`	`updateNCharacterStream(int arg0, Reader arg1)`
`void`	`updateNCharacterStream(int arg0, Reader arg1, long arg2)`
`void`	`updateNCharacterStream(String arg0, Reader arg1)`
`void`	`updateNCharacterStream(String arg0, Reader arg1, long arg2)`
`void`	`updateNClob(int arg0, NClob arg1)`
`void`	`updateNClob(int arg0, Reader arg1)`
`void`	`updateNClob(int arg0, Reader arg1, long arg2)`
`void`	`updateNClob(String arg0, NClob arg1)`
`void`	`updateNClob(String arg0, Reader arg1)`
`void`	`updateNClob(String arg0, Reader arg1, long arg2)`
`void`	`updateNString(int arg0, String arg1)`
`void`	`updateNString(String arg0, String arg1)`
`void`	`updateNull(int columnIndex)` Gives a nullable column a null value.
`void`	`updateNull(String columnName)` 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 scale)`
`void`	`updateObject(String columnName, Object x)` Updates the designated column with an `Object` value.
`void`	`updateObject(String columnName, Object x, int scale)` Updates the designated column with an `Object` value.
`void`	`updateRef(int columnIndex, Ref x)`
`void`	`updateRef(String columnName, Ref x)`
`void`	`updateRow()` Updates the underlying database with the new contents of the current row of this `ResultSet` object.
`void`	`updateRowId(int arg0, RowId arg1)`
`void`	`updateRowId(String arg0, RowId arg1)`
`void`	`updateShort(int columnIndex, short x)`
`void`	`updateShort(String columnName, short x)` Updates the designated column with a `short` value.
`void`	`updateSQLXML(int arg0, SQLXML arg1)`
`void`	`updateSQLXML(String arg0, SQLXML arg1)`
`void`	`updateString(int columnIndex, String x)` Updates the designated column with a `String` value.
`void`	`updateString(String columnName, 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 columnName, 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 columnName, Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`boolean`	`wasNull()`

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

Constructor Detail

IntegrateResultSet

public IntegrateResultSet()

Method Detail

absolute

public boolean absolute(int row)
                 throws SQLException

/**

Specified by:: absolute in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.absolute(int)

afterLast

public void afterLast()
               throws SQLException

Specified by:: afterLast in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.afterLast()

beforeFirst

public void beforeFirst()
                 throws SQLException

Specified by:: beforeFirst in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.beforeFirst()

cancelRowUpdates

public void cancelRowUpdates()
                      throws SQLException

Cancels the updates made to the current row in this ResultSet object. This method may be called after calling an updater method(s) and before calling the method updateRow to roll back the updates made to a row. If no updates have been made or updateRow has already been called, this method has no effect.

Specified by:: cancelRowUpdates in interface ResultSet

Throws:: SQLException - if a database access error occurs or if this method is called when the cursor is on the insert row

clearWarnings

public void clearWarnings()
                   throws SQLException

Clears all warnings reported on this ResultSet object. After this method is called, the method getWarnings returns null until a new warning is reported for this ResultSet object.

Specified by:: clearWarnings in interface ResultSet

Throws:: SQLException - if a database access error occurs

close

public abstract void close()
                    throws SQLException

Specified by:: close in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.close()

deleteRow

public void deleteRow()
               throws SQLException

Deletes the current row from this ResultSet object and from the underlying database. This method cannot be called when the cursor is on the insert row.

Specified by:: deleteRow in interface ResultSet

Throws:: SQLException - if a database access error occurs or if this method is called when the cursor is on the insert row

findColumn

public abstract int findColumn(String columnName)
                        throws SQLException

Specified by:: findColumn in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.findColumn(java.lang.String)

first

public abstract boolean first()
                       throws SQLException

Specified by:: first in interface ResultSet

Throws:: SQLException

getArray

public Array getArray(int i)
               throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.

Specified by:: getArray in interface ResultSet

Parameters:: i - the first column is 1, the second is 2, ...
Returns:: an Array object representing the SQL ARRAY value in the specified column
Throws:: SQLException - if a database access error occurs

getArray

public Array getArray(String colName)
               throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.

Specified by:: getArray in interface ResultSet

Parameters:: colName - the name of the column from which to retrieve the value
Returns:: an Array object representing the SQL ARRAY value in the specified column
Throws:: SQLException - if a database access error occurs

getAsciiStream

public InputStream getAsciiStream(int columnIndex)
                           throws SQLException

Specified by:: getAsciiStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getAsciiStream(int)

getAsciiStream

public InputStream getAsciiStream(String columnName)
                           throws SQLException

Specified by:: getAsciiStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getAsciiStream(int)

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)
                         throws SQLException

Specified by:: getBigDecimal in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getBigDecimal(int, int)

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex,
                                int scale)
                         throws SQLException

Specified by:: getBigDecimal in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getBigDecimal(int, int)

getBigDecimal

public BigDecimal getBigDecimal(String columnName)
                         throws SQLException

Specified by:: getBigDecimal in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getBigDecimal(int, int)

getBigDecimal

public BigDecimal getBigDecimal(String columnName,
                                int scale)
                         throws SQLException

Specified by:: getBigDecimal in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getBigDecimal(int, int)

getBinaryStream

public InputStream getBinaryStream(int columnIndex)
                            throws SQLException

Specified by:: getBinaryStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getBinaryStream(int)

getBinaryStream

public InputStream getBinaryStream(String columnName)
                            throws SQLException

Specified by:: getBinaryStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getBinaryStream(int)

getBlob

public Blob getBlob(int i)
             throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

Specified by:: getBlob in interface ResultSet

Parameters:: i - the first column is 1, the second is 2, ...
Returns:: a Blob object representing the SQL BLOB value in the specified column
Throws:: SQLException - if a database access error occurs

getBlob

public Blob getBlob(String colName)
             throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

Specified by:: getBlob in interface ResultSet

Parameters:: colName - the name of the column from which to retrieve the value
Returns:: a Blob object representing the SQL BLOB value in the specified column
Throws:: SQLException - if a database access error occurs

getBoolean

public abstract boolean getBoolean(int columnIndex)
                            throws SQLException

Specified by:: getBoolean in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getBoolean(int)

getBoolean

public abstract boolean getBoolean(String columnName)
                            throws SQLException

Specified by:: getBoolean in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getBoolean(int)

getByte

public byte getByte(int columnIndex)
             throws SQLException

Specified by:: getByte in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getByte(int)

getByte

public byte getByte(String columnName)
             throws SQLException

Specified by:: getByte in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getByte(int)

getBytes

public byte[] getBytes(int columnIndex)
                throws SQLException

Specified by:: getBytes in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getBytes(int)

getBytes

public byte[] getBytes(String columnName)
                throws SQLException

Specified by:: getBytes in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getBytes(int)

getCharacterStream

public Reader getCharacterStream(int columnIndex)
                          throws SQLException

Specified by:: getCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getCharacterStream(int)

getCharacterStream

public Reader getCharacterStream(String columnName)
                          throws SQLException

Specified by:: getCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getCharacterStream(int)

getClob

public Clob getClob(int i)
             throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.

Specified by:: getClob in interface ResultSet

Parameters:: i - the first column is 1, the second is 2, ...
Returns:: a Clob object representing the SQL CLOB value in the specified column
Throws:: SQLException - if a database access error occurs

getClob

public Clob getClob(String colName)
             throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.

Specified by:: getClob in interface ResultSet

Parameters:: colName - the name of the column from which to retrieve the value
Returns:: a Clob object representing the SQL CLOB value in the specified column
Throws:: SQLException - if a database access error occurs

getConcurrency

public int getConcurrency()
                   throws SQLException

Specified by:: getConcurrency in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getConcurrency()

getCursorName

public String getCursorName()
                     throws SQLException

Retrieves the name of the SQL cursor used by this ResultSet object.

In SQL, a result table is retrieved through a cursor that is named. The current row of a result set can be updated or deleted using a positioned update/delete statement that references the cursor name. To insure that the cursor has the proper isolation level to support update, the cursor's SELECT statement should be of the form SELECT FOR UPDATE. If FOR UPDATE is omitted, the positioned updates may fail.

The JDBC API supports this SQL feature by providing the name of the SQL cursor used by a ResultSet object. The current row of a ResultSet object is also the current row of this SQL cursor.

Note: If positioned update is not supported, a SQLException is thrown.

Specified by:: getCursorName in interface ResultSet

Returns:: the SQL name for this ResultSet object's cursor
Throws:: SQLException - if a database access error occurs

getDate

public abstract Date getDate(int columnIndex)
                      throws SQLException

Specified by:: getDate in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getDate(int)

getDate

public Date getDate(int columnIndex,
                    Calendar cal)
             throws SQLException

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. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.

Specified by:: getDate in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; cal - the java.util.Calendar object to use in constructing the date
Returns:: the column value as a java.sql.Date object; if the value is SQL NULL, the value returned is null in the Java programming language
Throws:: SQLException - if a database access error occurs

getDate

public abstract Date getDate(String columnName)
                      throws SQLException

Specified by:: getDate in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getDate(int)

getDate

public Date getDate(String columnName,
                    Calendar cal)
             throws SQLException

Specified by:: getDate in interface ResultSet

Parameters:: columnName - the SQL name of the column from which to retrieve the value; cal - the java.util.Calendar object to use in constructing the date
Returns:: the column value as a java.sql.Date object; if the value is SQL NULL, the value returned is null in the Java programming language
Throws:: SQLException - if a database access error occurs

getDouble

public abstract double getDouble(int columnIndex)
                          throws SQLException

Specified by:: getDouble in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getDouble(int)

getDouble

public abstract double getDouble(String columnName)
                          throws SQLException

Specified by:: getDouble in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getDouble(int)

getFetchDirection

public int getFetchDirection()
                      throws SQLException

Specified by:: getFetchDirection in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getFetchDirection()

getFetchSize

public int getFetchSize()
                 throws SQLException

Retrieves the fetch size for this ResultSet object.

Specified by:: getFetchSize in interface ResultSet

Returns:: the current fetch size for this ResultSet object
Throws:: SQLException - if a database access error occurs
See Also:: setFetchSize(int)

getFloat

public abstract float getFloat(int columnIndex)
                        throws SQLException

Specified by:: getFloat in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getFloat(int)

getFloat

public abstract float getFloat(String columnName)
                        throws SQLException

Specified by:: getFloat in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getFloat(int)

getHoldability

public int getHoldability()
                   throws SQLException

Specified by:: getHoldability in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getHoldability()

getInt

public abstract int getInt(int columnIndex)
                    throws SQLException

Specified by:: getInt in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getInt(int)

getInt

public abstract int getInt(String columnName)
                    throws SQLException

Specified by:: getInt in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getInt(int)

getLong

public abstract long getLong(int columnIndex)
                      throws SQLException

Specified by:: getLong in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getLong(int)

getLong

public abstract long getLong(String columnName)
                      throws SQLException

Specified by:: getLong in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getLong(int)

getMetaData

public abstract ResultSetMetaData getMetaData()
                                       throws SQLException

Retrieves the number, types and properties of this ResultSet object's columns.

Specified by:: getMetaData in interface ResultSet

Returns:: the description of this ResultSet object's columns
Throws:: SQLException - if a database access error occurs

getNCharacterStream

public Reader getNCharacterStream(int arg0)
                           throws SQLException

Specified by:: getNCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getNCharacterStream(int)

getNCharacterStream

public Reader getNCharacterStream(String arg0)
                           throws SQLException

Specified by:: getNCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getNCharacterStream(int)

getNClob

public NClob getNClob(int arg0)
               throws SQLException

Specified by:: getNClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getNClob(int)

getNClob

public NClob getNClob(String arg0)
               throws SQLException

Specified by:: getNClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getNClob(int)

getNString

public String getNString(int arg0)
                  throws SQLException

Specified by:: getNString in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getNString(int)

getNString

public String getNString(String arg0)
                  throws SQLException

Specified by:: getNString in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getNString(int)

getObject

public abstract Object getObject(int columnIndex)
                          throws SQLException

Specified by:: getObject in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getObject(int)

getObject

public Object getObject(int i,
                        Map map)
                 throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. If the value is an SQL NULL, the driver returns a Java null. This method uses the given Map object for the custom mapping of the SQL structured or distinct type that is being retrieved.

Specified by:: getObject in interface ResultSet

Parameters:: i - the first column is 1, the second is 2, ...; map - a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
Returns:: an Object in the Java programming language representing the SQL value
Throws:: SQLException - if a database access error occurs

getObject

public abstract Object getObject(String columnName)
                          throws SQLException

Specified by:: getObject in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getObject(int)

getObject

public Object getObject(String colName,
                        Map map)
                 throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. If the value is an SQL NULL, the driver returns a Java null. This method uses the specified Map object for custom mapping if appropriate.

Specified by:: getObject in interface ResultSet

Parameters:: colName - the name of the column from which to retrieve the value; map - a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
Returns:: an Object representing the SQL value in the specified column
Throws:: SQLException - if a database access error occurs

getRef

public Ref getRef(int i)
           throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.

Specified by:: getRef in interface ResultSet

Parameters:: i - the first column is 1, the second is 2, ...
Returns:: a Ref object representing an SQL REF value
Throws:: SQLException - if a database access error occurs

getRef

public Ref getRef(String colName)
           throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.

Specified by:: getRef in interface ResultSet

Parameters:: colName - the column name
Returns:: a Ref object representing the SQL REF value in the specified column
Throws:: SQLException - if a database access error occurs

getRow

public abstract int getRow()
                    throws SQLException

Specified by:: getRow in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getRow()

getRowId

public RowId getRowId(int arg0)
               throws SQLException

Specified by:: getRowId in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getRowId(int)

getRowId

public RowId getRowId(String arg0)
               throws SQLException

Specified by:: getRowId in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getRowId(int)

getShort

public abstract short getShort(int columnIndex)
                        throws SQLException

Specified by:: getShort in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getShort(int)

getShort

public abstract short getShort(String columnName)
                        throws SQLException

Specified by:: getShort in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getShort(int)

getSQLXML

public SQLXML getSQLXML(int arg0)
                 throws SQLException

Specified by:: getSQLXML in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getSQLXML(int)

getSQLXML

public SQLXML getSQLXML(String arg0)
                 throws SQLException

Specified by:: getSQLXML in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getSQLXML(int)

getStatement

public abstract Statement getStatement()
                                throws SQLException

Specified by:: getStatement in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getStatement()

getString

public abstract String getString(int columnIndex)
                          throws SQLException

Specified by:: getString in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getString(int)

getString

public abstract String getString(String columnName)
                          throws SQLException

Specified by:: getString in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getString(int)

getTime

public abstract Time getTime(int columnIndex)
                      throws SQLException

Specified by:: getTime in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getTime(int)

getTime

public Time getTime(int columnIndex,
                    Calendar cal)
             throws SQLException

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. This method uses the given calendar to construct an appropriate millisecond value for the time if the underlying database does not store timezone information.

Specified by:: getTime in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; cal - the java.util.Calendar object to use in constructing the time
Returns:: the column value as a java.sql.Time object; if the value is SQL NULL, the value returned is null in the Java programming language
Throws:: SQLException - if a database access error occurs

getTime

public abstract Time getTime(String columnName)
                      throws SQLException

Specified by:: getTime in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getTime(int)

getTime

public Time getTime(String columnName,
                    Calendar cal)
             throws SQLException

Specified by:: getTime in interface ResultSet

Parameters:: columnName - the SQL name of the column; cal - the java.util.Calendar object to use in constructing the time
Returns:: the column value as a java.sql.Time object; if the value is SQL NULL, the value returned is null in the Java programming language
Throws:: SQLException - if a database access error occurs

getTimestamp

public Timestamp getTimestamp(int columnIndex)
                       throws SQLException

Specified by:: getTimestamp in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getTimestamp(int)

getTimestamp

public Timestamp getTimestamp(int columnIndex,
                              Calendar cal)
                       throws SQLException

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. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.

Specified by:: getTimestamp in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; cal - the java.util.Calendar object to use in constructing the timestamp
Returns:: the column value as a java.sql.Timestamp object; if the value is SQL NULL, the value returned is null in the Java programming language
Throws:: SQLException - if a database access error occurs

getTimestamp

public Timestamp getTimestamp(String columnName)
                       throws SQLException

Specified by:: getTimestamp in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getTimestamp(int)

getTimestamp

public Timestamp getTimestamp(String columnName,
                              Calendar cal)
                       throws SQLException

Specified by:: getTimestamp in interface ResultSet

Parameters:: columnName - the SQL name of the column; cal - the java.util.Calendar object to use in constructing the time
Returns:: the column value as a java.sql.Time object; if the value is SQL NULL, the value returned is null in the Java programming language
Throws:: SQLException - if a database access error occurs

getType

public abstract int getType()
                     throws SQLException

Specified by:: getType in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getType()

getUnicodeStream

public InputStream getUnicodeStream(int columnIndex)
                             throws SQLException

Specified by:: getUnicodeStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getUnicodeStream(int)

getUnicodeStream

public InputStream getUnicodeStream(String columnName)
                             throws SQLException

Specified by:: getUnicodeStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getUnicodeStream(int)

getURL

public URL getURL(int columnIndex)
           throws SQLException

Specified by:: getURL in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getURL(int)

getURL

public URL getURL(String columnName)
           throws SQLException

Specified by:: getURL in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.getURL(int)

getWarnings

public SQLWarning getWarnings()
                       throws SQLException

Retrieves the first warning reported by calls on this ResultSet object. Subsequent warnings on this ResultSet object will be chained to the SQLWarning object that this method returns.

The warning chain is automatically cleared each time a new row is read. This method may not be called on a ResultSet object that has been closed; doing so will cause an SQLException to be thrown.

Note: This warning chain only covers warnings caused by ResultSet methods. Any warning caused by Statement methods (such as reading OUT parameters) will be chained on the Statement object.

Specified by:: getWarnings in interface ResultSet

Returns:: the first SQLWarning object reported or null if there are none
Throws:: SQLException - if a database access error occurs or this method is called on a closed result set

insertRow

public void insertRow()
               throws SQLException

Inserts the contents of the insert row into this ResultSet object and into the database. The cursor must be on the insert row when this method is called.

Specified by:: insertRow in interface ResultSet

Throws:: SQLException - if a database access error occurs, if this method is called when the cursor is not on the insert row, or if not all of non-nullable columns in the insert row have been given a value

isAfterLast

public boolean isAfterLast()
                    throws SQLException

Specified by:: isAfterLast in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.isAfterLast()

isBeforeFirst

public boolean isBeforeFirst()
                      throws SQLException

Specified by:: isBeforeFirst in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.isBeforeFirst()

isClosed

public abstract boolean isClosed()
                          throws SQLException

Specified by:: isClosed in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.isClosed()

isFirst

public abstract boolean isFirst()
                         throws SQLException

Specified by:: isFirst in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.isFirst()

isLast

public abstract boolean isLast()
                        throws SQLException

Specified by:: isLast in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.isLast()

isWrapperFor

public boolean isWrapperFor(Class arg0)
                     throws SQLException

Specified by:: isWrapperFor in interface Wrapper

Throws:: SQLException
See Also:: Wrapper.isWrapperFor(java.lang.Class)

last

public abstract boolean last()
                      throws SQLException

Specified by:: last in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.last()

moveToCurrentRow

public void moveToCurrentRow()
                      throws SQLException

Moves the cursor to the remembered cursor position, usually the current row. This method has no effect if the cursor is not on the insert row.

Specified by:: moveToCurrentRow in interface ResultSet

Throws:: SQLException - if a database access error occurs or the result set is not updatable

moveToInsertRow

public void moveToInsertRow()
                     throws SQLException

Moves the cursor to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row. The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the updater methods prior to inserting the row into the result set. Only the updater, getter, and insertRow methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before calling insertRow. An updater method must be called before a getter method can be called on a column value.

Specified by:: moveToInsertRow in interface ResultSet

Throws:: SQLException - if a database access error occurs or the result set is not updatable

public abstract boolean next()
                      throws SQLException

Specified by:: next in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.next()

public abstract boolean previous()
                          throws SQLException

Specified by:: previous in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.previous()

refreshRow

public void refreshRow()
                throws SQLException

Refreshes the current row with its most recent value in the database. This method cannot be called when the cursor is on the insert row.

The refreshRow method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database. An application may want to call refreshRow when caching or prefetching is being done by the JDBC driver to fetch the latest value of a row from the database. The JDBC driver may actually refresh multiple rows at once if the fetch size is greater than one.

All values are refetched subject to the transaction isolation level and cursor sensitivity. If refreshRow is called after calling an updater method, but before calling the method updateRow, then the updates made to the row are lost. Calling the method refreshRow frequently will likely slow performance.

Specified by:: refreshRow in interface ResultSet

Throws:: SQLException - if a database access error occurs or if this method is called when the cursor is on the insert row

relative

public boolean relative(int rows)
                 throws SQLException

Specified by:: relative in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.relative(int)

rowDeleted

public boolean rowDeleted()
                   throws SQLException

Retrieves whether a row has been deleted. A deleted row may leave a visible "hole" in a result set. This method can be used to detect holes in a result set. The value returned depends on whether or not this ResultSet object can detect deletions.

Specified by:: rowDeleted in interface ResultSet

Returns:: true if a row was deleted and deletions are detected; false otherwise
Throws:: SQLException - if a database access error occurs
See Also:: DatabaseMetaData.deletesAreDetected(int)

rowInserted

public boolean rowInserted()
                    throws SQLException

Retrieves whether the current row has had an insertion. The value returned depends on whether or not this ResultSet object can detect visible inserts.

Specified by:: rowInserted in interface ResultSet

Returns:: true if a row has had an insertion and insertions are detected; false otherwise
Throws:: SQLException - if a database access error occurs
See Also:: DatabaseMetaData.insertsAreDetected(int)

rowUpdated

public boolean rowUpdated()
                   throws SQLException

Retrieves whether the current row has been updated. The value returned depends on whether or not the result set can detect updates.

Specified by:: rowUpdated in interface ResultSet

Returns:: true if both (1) the row has been visibly updated by the owner or another and (2) updates are detected
Throws:: SQLException - if a database access error occurs
See Also:: DatabaseMetaData.updatesAreDetected(int)

setFetchDirection

public void setFetchDirection(int direction)
                       throws SQLException

Gives a hint as to the direction in which the rows in this ResultSet object will be processed. The initial value is determined by the Statement object that produced this ResultSet object. The fetch direction may be changed at any time.

Specified by:: setFetchDirection in interface ResultSet

Parameters:: direction - an int specifying the suggested fetch direction; one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
Throws:: SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY and the fetch direction is not FETCH_FORWARD

setFetchSize

public void setFetchSize(int rows)
                  throws SQLException

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. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the Statement object that created the result set. The fetch size may be changed at any time.

Specified by:: setFetchSize in interface ResultSet

Parameters:: rows - the number of rows to fetch
Throws:: SQLException - if a database access error occurs or the condition 0 <= rows <= this.getMaxRows() is not satisfied

unwrap

public Object unwrap(Class arg0)
              throws SQLException

Specified by:: unwrap in interface Wrapper

Throws:: SQLException
See Also:: Wrapper.unwrap(java.lang.Class)

updateArray

public void updateArray(int columnIndex,
                        Array x)
                 throws SQLException

Specified by:: updateArray in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateArray(int, java.sql.Array)

updateArray

public void updateArray(String columnName,
                        Array x)
                 throws SQLException

Specified by:: updateArray in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateArray(int, java.sql.Array)

updateAsciiStream

public void updateAsciiStream(int arg0,
                              InputStream arg1)
                       throws SQLException

Specified by:: updateAsciiStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateAsciiStream(int, java.io.InputStream, int)

updateAsciiStream

public void updateAsciiStream(String arg0,
                              InputStream arg1)
                       throws SQLException

Specified by:: updateAsciiStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateAsciiStream(int, java.io.InputStream, int)

updateAsciiStream

public void updateAsciiStream(int arg0,
                              InputStream arg1,
                              long arg2)
                       throws SQLException

Specified by:: updateAsciiStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateAsciiStream(int, java.io.InputStream, int)

updateAsciiStream

public void updateAsciiStream(String arg0,
                              InputStream arg1,
                              long arg2)
                       throws SQLException

Specified by:: updateAsciiStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateAsciiStream(int, java.io.InputStream, int)

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream x,
                              int length)
                       throws SQLException

Updates the designated column with an ascii stream value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateAsciiStream in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream x,
                              int length)
                       throws SQLException

Specified by:: updateAsciiStream in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             BigDecimal x)
                      throws SQLException

Updates the designated column with a java.math.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateBigDecimal in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateBigDecimal

public void updateBigDecimal(String columnName,
                             BigDecimal x)
                      throws SQLException

Updates the designated column with a java.sql.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateBigDecimal in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateBinaryStream

public void updateBinaryStream(int arg0,
                               InputStream arg1)
                        throws SQLException

Specified by:: updateBinaryStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBinaryStream(int, java.io.InputStream, int)

updateBinaryStream

public void updateBinaryStream(String arg0,
                               InputStream arg1)
                        throws SQLException

Specified by:: updateBinaryStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBinaryStream(int, java.io.InputStream, int)

updateBinaryStream

public void updateBinaryStream(int arg0,
                               InputStream arg1,
                               long arg2)
                        throws SQLException

Specified by:: updateBinaryStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBinaryStream(int, java.io.InputStream, int)

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream x,
                               int length)
                        throws SQLException

Updates the designated column with a binary stream value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateBinaryStream in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream x,
                               int length)
                        throws SQLException

Specified by:: updateBinaryStream in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateBinaryStream

public void updateBinaryStream(String arg0,
                               InputStream arg1,
                               long arg2)
                        throws SQLException

Specified by:: updateBinaryStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBinaryStream(int, java.io.InputStream, int)

updateBlob

public void updateBlob(int columnIndex,
                       Blob x)
                throws SQLException

Specified by:: updateBlob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBlob(int, java.sql.Blob)

updateBlob

public void updateBlob(String columnName,
                       Blob x)
                throws SQLException

Specified by:: updateBlob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBlob(int, java.sql.Blob)

updateBlob

public void updateBlob(int arg0,
                       InputStream arg1)
                throws SQLException

Specified by:: updateBlob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBlob(int, java.sql.Blob)

updateBlob

public void updateBlob(String arg0,
                       InputStream arg1)
                throws SQLException

Specified by:: updateBlob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBlob(int, java.sql.Blob)

updateBlob

public void updateBlob(int arg0,
                       InputStream arg1,
                       long arg2)
                throws SQLException

Specified by:: updateBlob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBlob(int, java.sql.Blob)

updateBlob

public void updateBlob(String arg0,
                       InputStream arg1,
                       long arg2)
                throws SQLException

Specified by:: updateBlob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBlob(int, java.sql.Blob)

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean x)
                   throws SQLException

Updates the designated column with a boolean value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateBoolean in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateBoolean

public void updateBoolean(String columnName,
                          boolean x)
                   throws SQLException

Specified by:: updateBoolean in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateByte

public void updateByte(int columnIndex,
                       byte x)
                throws SQLException

Updates the designated column with a byte value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateByte in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateByte

public void updateByte(String columnName,
                       byte x)
                throws SQLException

Specified by:: updateByte in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateBytes

public void updateBytes(int columnIndex,
                        byte[] x)
                 throws SQLException

Specified by:: updateBytes in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateBytes(int, byte[])

updateBytes

public void updateBytes(String columnName,
                        byte[] x)
                 throws SQLException

Updates the designated column with a byte array value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateBytes in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader x,
                                  int length)
                           throws SQLException

Updates the designated column with a character stream value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateCharacterStream in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateCharacterStream

public void updateCharacterStream(String columnNameIndex,
                                  Reader x,
                                  int length)
                           throws SQLException

Specified by:: updateCharacterStream in interface ResultSet

Parameters:: columnNameIndex - index of the column; x - the java.io.Reader object containing the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateCharacterStream

public void updateCharacterStream(int arg0,
                                  Reader arg1)
                           throws SQLException

Specified by:: updateCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateCharacterStream(int, java.io.Reader, int)

updateCharacterStream

public void updateCharacterStream(String arg0,
                                  Reader arg1)
                           throws SQLException

Specified by:: updateCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateCharacterStream(int, java.io.Reader, int)

updateCharacterStream

public void updateCharacterStream(int arg0,
                                  Reader arg1,
                                  long arg2)
                           throws SQLException

Specified by:: updateCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateCharacterStream(int, java.io.Reader, int)

updateCharacterStream

public void updateCharacterStream(String arg0,
                                  Reader arg1,
                                  long arg2)
                           throws SQLException

Specified by:: updateCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateCharacterStream(int, java.io.Reader, int)

updateClob

public void updateClob(int columnIndex,
                       Clob x)
                throws SQLException

Specified by:: updateClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateClob(int, java.sql.Clob)

updateClob

public void updateClob(String columnName,
                       Clob x)
                throws SQLException

Specified by:: updateClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateClob(int, java.sql.Clob)

updateClob

public void updateClob(int arg0,
                       Reader arg1)
                throws SQLException

Specified by:: updateClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateClob(int, java.sql.Clob)

updateClob

public void updateClob(String arg0,
                       Reader arg1)
                throws SQLException

Specified by:: updateClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateClob(int, java.sql.Clob)

updateClob

public void updateClob(int arg0,
                       Reader arg1,
                       long arg2)
                throws SQLException

Specified by:: updateClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateClob(int, java.sql.Clob)

updateClob

public void updateClob(String arg0,
                       Reader arg1,
                       long arg2)
                throws SQLException

Specified by:: updateClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateClob(int, java.sql.Clob)

updateDate

public void updateDate(int columnIndex,
                       Date x)
                throws SQLException

Updates the designated column with a java.sql.Date value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateDate in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateDate

public void updateDate(String columnName,
                       Date x)
                throws SQLException

Specified by:: updateDate in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateDouble

public void updateDouble(int columnIndex,
                         double x)
                  throws SQLException

Updates the designated column with a double value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateDouble in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateDouble

public void updateDouble(String columnName,
                         double x)
                  throws SQLException

Specified by:: updateDouble in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateFloat

public void updateFloat(int columnIndex,
                        float x)
                 throws SQLException

Updates the designated column with a float value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateFloat in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateFloat

public void updateFloat(String columnName,
                        float x)
                 throws SQLException

Specified by:: updateFloat in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateInt

public void updateInt(int columnIndex,
                      int x)
               throws SQLException

Updates the designated column with an int value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateInt in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateInt

public void updateInt(String columnName,
                      int x)
               throws SQLException

Specified by:: updateInt in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateLong

public void updateLong(int columnIndex,
                       long x)
                throws SQLException

Updates the designated column with a long value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateLong in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateLong

public void updateLong(String columnName,
                       long x)
                throws SQLException

Specified by:: updateLong in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateNCharacterStream

public void updateNCharacterStream(int arg0,
                                   Reader arg1)
                            throws SQLException

Specified by:: updateNCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNCharacterStream(int, java.io.Reader, long)

updateNCharacterStream

public void updateNCharacterStream(String arg0,
                                   Reader arg1)
                            throws SQLException

Specified by:: updateNCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNCharacterStream(int, java.io.Reader, long)

updateNCharacterStream

public void updateNCharacterStream(int arg0,
                                   Reader arg1,
                                   long arg2)
                            throws SQLException

Specified by:: updateNCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNCharacterStream(int, java.io.Reader, long)

updateNCharacterStream

public void updateNCharacterStream(String arg0,
                                   Reader arg1,
                                   long arg2)
                            throws SQLException

Specified by:: updateNCharacterStream in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNCharacterStream(int, java.io.Reader, long)

updateNClob

public void updateNClob(int arg0,
                        NClob arg1)
                 throws SQLException

Specified by:: updateNClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNClob(int, java.sql.NClob)

updateNClob

public void updateNClob(String arg0,
                        NClob arg1)
                 throws SQLException

Specified by:: updateNClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNClob(int, java.sql.NClob)

updateNClob

public void updateNClob(int arg0,
                        Reader arg1)
                 throws SQLException

Specified by:: updateNClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNClob(int, java.sql.NClob)

updateNClob

public void updateNClob(String arg0,
                        Reader arg1)
                 throws SQLException

Specified by:: updateNClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNClob(int, java.sql.NClob)

updateNClob

public void updateNClob(int arg0,
                        Reader arg1,
                        long arg2)
                 throws SQLException

Specified by:: updateNClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNClob(int, java.sql.NClob)

updateNClob

public void updateNClob(String arg0,
                        Reader arg1,
                        long arg2)
                 throws SQLException

Specified by:: updateNClob in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNClob(int, java.sql.NClob)

updateNString

public void updateNString(int arg0,
                          String arg1)
                   throws SQLException

Specified by:: updateNString in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNString(int, java.lang.String)

updateNString

public void updateNString(String arg0,
                          String arg1)
                   throws SQLException

Specified by:: updateNString in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateNString(int, java.lang.String)

updateNull

public void updateNull(int columnIndex)
                throws SQLException

Gives a nullable column a null value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateNull in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Throws:: SQLException - if a database access error occurs

updateNull

public void updateNull(String columnName)
                throws SQLException

Updates the designated column with a null value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateNull in interface ResultSet

Parameters:: columnName - the name of the column
Throws:: SQLException - if a database access error occurs

updateObject

public void updateObject(int columnIndex,
                         Object x)
                  throws SQLException

Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateObject in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateObject

public void updateObject(int columnIndex,
                         Object x,
                         int scale)
                  throws SQLException

Specified by:: updateObject in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateObject(int, java.lang.Object, int)

updateObject

public void updateObject(String columnName,
                         Object x)
                  throws SQLException

Specified by:: updateObject in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateObject

public void updateObject(String columnName,
                         Object x,
                         int scale)
                  throws SQLException

Specified by:: updateObject in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value; scale - for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types this value will be ignored.
Throws:: SQLException - if a database access error occurs

updateRef

public void updateRef(int columnIndex,
                      Ref x)
               throws SQLException

Specified by:: updateRef in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateRef(int, java.sql.Ref)

updateRef

public void updateRef(String columnName,
                      Ref x)
               throws SQLException

Specified by:: updateRef in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateRef(int, java.sql.Ref)

updateRow

public void updateRow()
               throws SQLException

Updates the underlying database with the new contents of the current row of this ResultSet object. This method cannot be called when the cursor is on the insert row.

Specified by:: updateRow in interface ResultSet

Throws:: SQLException - if a database access error occurs or if this method is called when the cursor is on the insert row

updateRowId

public void updateRowId(int arg0,
                        RowId arg1)
                 throws SQLException

Specified by:: updateRowId in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateRowId(int, java.sql.RowId)

updateRowId

public void updateRowId(String arg0,
                        RowId arg1)
                 throws SQLException

Specified by:: updateRowId in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateRowId(int, java.sql.RowId)

updateShort

public void updateShort(int columnIndex,
                        short x)
                 throws SQLException

Specified by:: updateShort in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateShort(int, short)

updateSQLXML

public void updateSQLXML(int arg0,
                         SQLXML arg1)
                  throws SQLException

Specified by:: updateSQLXML in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateSQLXML(int, java.sql.SQLXML)

updateSQLXML

public void updateSQLXML(String arg0,
                         SQLXML arg1)
                  throws SQLException

Specified by:: updateSQLXML in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.updateSQLXML(int, java.sql.SQLXML)

updateShort

public void updateShort(String columnName,
                        short x)
                 throws SQLException

Updates the designated column with a short value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateShort in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateString

public void updateString(int columnIndex,
                         String x)
                  throws SQLException

Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateString in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateString

public void updateString(String columnName,
                         String x)
                  throws SQLException

Specified by:: updateString in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateTime

public void updateTime(String columnName,
                       Time x)
                throws SQLException

Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateTime in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateTime

public void updateTime(int columnIndex,
                       Time x)
                throws SQLException

Specified by:: updateTime in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateTimestamp

public void updateTimestamp(int columnIndex,
                            Timestamp x)
                     throws SQLException

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:: updateTimestamp in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateTimestamp

public void updateTimestamp(String columnName,
                            Timestamp x)
                     throws SQLException

Specified by:: updateTimestamp in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

wasNull

public boolean wasNull()
                throws SQLException

Specified by:: wasNull in interface ResultSet

Throws:: SQLException
See Also:: ResultSet.wasNull()

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

br.ufg.integrate.wrapper.jdbc Class IntegrateResultSet

IntegrateResultSet

absolute

afterLast

beforeFirst

cancelRowUpdates

clearWarnings

close

deleteRow

findColumn

first

getArray

getArray

getAsciiStream

getAsciiStream

getBigDecimal

getBigDecimal

getBigDecimal

getBigDecimal

getBinaryStream

getBinaryStream

getBlob

getBlob

getBoolean

getBoolean

getByte

getByte

getBytes

getBytes

getCharacterStream

getCharacterStream

getClob

getClob

getConcurrency

getCursorName

getDate

getDate

getDate

getDate

getDouble

getDouble

getFetchDirection

getFetchSize

getFloat

getFloat

getHoldability

getInt

getInt

getLong

getLong

getMetaData

getNCharacterStream

getNCharacterStream

getNClob

getNClob

getNString

getNString

getObject

getObject

getObject

getObject

getRef

getRef

getRow

getRowId

getRowId

getShort

getShort

getSQLXML

getSQLXML

getStatement

getString

getString

getTime

getTime

getTime

getTime

getTimestamp

getTimestamp

getTimestamp

br.ufg.integrate.wrapper.jdbc
Class IntegrateResultSet