All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class oracle.jdbc.driver.OracleResultSet

java.lang.Object
   |
   +----oracle.jdbc.driver.OracleResultSet

public abstract class OracleResultSet

extends Object

implements ResultSet

CONCUR_READ_ONLY

CONCUR_UPDATABLE

FETCH_FORWARD

FETCH_REVERSE

FETCH_UNKNOWN

TYPE_FORWARD_ONLY

TYPE_SCROLL_INSENSITIVE

TYPE_SCROLL_SENSITIVE

OracleResultSet()

absolute(int)

Implements JDBC 2.0 ResultSet.absolute.

afterLast()

Implements JDBC 2.0 ResultSet.afterLast.

beforeFirst()

Implements JDBC 2.0 ResultSet.beforeFirst.

cancelRowUpdates()

Implements JDBC 2.0 ResultSet.cancelRowUpdates.

clearWarnings()

Implements JDBC 1.0 ResultSet.clearWarnings.

close()

Implements JDBC 1.0 ResultSet.close.

deleteRow()

Implements JDBC 2.0 ResultSet.deleteRow.

findColumn(String)

Implements JDBC 1.0 ResultSet.findColumn.

first()

Implements JDBC 2.0 ResultSet.first.

getArray(int)

Implements JDBC 2.0 ResultSet.getArray.

getARRAY(int)

Oracle extension.

getARRAY(String)

Oracle extension.

getArray(String)

Implements JDBC 2.0 ResultSet.getArray.

getAsciiStream(int)

Implements JDBC 1.0 ResultSet.getAsciiStream.

getAsciiStream(String)

Implements JDBC 1.0 ResultSet.getAsciiStream.

getBFILE(int)

Oracle extension.

getBfile(int)

Oracle extension.

getBfile(String)

Oracle extension.

getBFILE(String)

Oracle extension.

getBigDecimal(int)

Implements JDBC 2.0 ResultSet.getBigDecimal.

getBigDecimal(int, int)

Implements JDBC 1.0 ResultSet.getBigDecimal.

getBigDecimal(String)

Implements JDBC 2.0 ResultSet.getBigDecimal.

getBigDecimal(String, int)

Implements JDBC 1.0 ResultSet.getBigDecimal.

getBinaryStream(int)

Implements JDBC 1.0 ResultSet.getBinaryStream.

getBinaryStream(String)

Implements JDBC 1.0 ResultSet.getBinaryStream.

getBlob(int)

Implements JDBC 2.0 ResultSet.getBlob.

getBLOB(int)

Oracle extension.

getBlob(String)

Implements JDBC 2.0 ResultSet.getBlob.

getBLOB(String)

Oracle extension.

getBoolean(int)

Implements JDBC 1.0 ResultSet.getBoolean.

getBoolean(String)

Implements JDBC 1.0 ResultSet.getBoolean.

getByte(int)

Implements JDBC 1.0 ResultSet.getByte.

getByte(String)

Implements JDBC 1.0 ResultSet.getByte.

getBytes(int)

Implements JDBC 1.0 ResultSet.getBytes.

getBytes(String)

Implements JDBC 1.0 ResultSet.getBytes.

getCHAR(int)

Oracle extension.

getCHAR(String)

Oracle extension.

getCharacterStream(int)

Implements JDBC 2.0 ResultSet.getCharacterStream.

getCharacterStream(String)

Implements JDBC 2.0 ResultSet.getCharacterStream.

getClob(int)

Implements JDBC 2.0 ResultSet.

getCLOB(int)

Oracle extension.

getClob(String)

Implements JDBC 2.0 ResultSet.

getCLOB(String)

Oracle extension.

getConcurrency()

Implements JDBC 2.0 ResultSet.getConcurrency.

getCursor(int)

Oracle extension.

getCURSOR(String)

Oracle extension.

getCursorName()

Implements JDBC 1.0 ResultSet.getCursorName.

getCustomDatum(int, CustomDatumFactory)

Oracle extension.

getCustomDatum(String, CustomDatumFactory)

Oracle extension.

getDATE(int)

Oracle extension.

getDate(int)

Implements JDBC 1.0 ResultSet.getDate.

getDate(int, Calendar)

Implements JDBC 2.0 ResultSet.getDate (idx, calendar).

getDATE(String)

Oracle extension.

getDate(String)

Implements JDBC 1.0 ResultSet.getDate.

getDate(String, Calendar)

Implements JDBC 2.0 ResultSet.getDate (idx, calendar).

getDouble(int)

Implements JDBC 1.0 ResultSet.getDouble.

getDouble(String)

Implements JDBC 1.0 ResultSet.getDouble.

getFetchDirection()

Implements JDBC 2.0 ResultSet.getFetchDirection.

getFetchSize()

Implements JDBC 2.0 ResultSet.getFetchSize.

getFloat(int)

Implements JDBC 1.0 ResultSet.getFloat.

getFloat(String)

Implements JDBC 1.0 ResultSet.getFloat.

getInt(int)

Implements JDBC 1.0 ResultSet.getInt.

getInt(String)

Implements JDBC 1.0 ResultSet.getInt.

getLong(int)

Implements JDBC 1.0 ResultSet.getLong.

getLong(String)

Implements JDBC 1.0 ResultSet.getLong.

getMetaData()

Implements JDBC 1.0 ResultSet.getMetaData.

getNUMBER(int)

Oracle extension.

getNUMBER(String)

Oracle extension.

getObject(int)

Implements JDBC 1.0 ResultSet.getObject.

getObject(int, Dictionary)

Implements JDBC 2.0 ResultSet.getObject (idx, map).

getObject(String)

Implements JDBC 1.0 ResultSet.getObject.

getObject(String, Dictionary)

Implements JDBC 2.0 ResultSet.getObject (idx, map).

getOracleObject(int)

Oracle extension.

getOracleObject(String)

Oracle extension.

getRAW(int)

Oracle extension.

getRAW(String)

Oracle extension.

getREF(int)

Oracle extension.

getRef(int)

Implements JDBC 2.0 ResultSet.getRef.

getRef(String)

Implements JDBC 2.0 ResultSet.getRef.

getREF(String)

Oracle extension.

getRow()

Implements JDBC 2.0 ResultSet.getRow.

getROWID(int)

Oracle extension.

getROWID(String)

Oracle extension.

getShort(int)

Implements JDBC 1.0 ResultSet.getShort.

getShort(String)

Implements JDBC 1.0 ResultSet.getShort.

getStatement()

Implements JDBC 2.0 ResultSet.getStatement.

getString(int)

Implements JDBC 1.0 ResultSet.getString.

getString(String)

Implements JDBC 1.0 ResultSet.getString.

getSTRUCT(int)

Oracle extension.

getSTRUCT(String)

Oracle extension.

getTime(int)

Implements JDBC 1.0 ResultSet.getTime.

getTime(int, Calendar)

Implements JDBC 2.0 ResultSet.getTime (idx, calendar).

getTime(String)

Implements JDBC 1.0 ResultSet.getTime.

getTime(String, Calendar)

Implements JDBC 2.0 ResultSet.getTime (idx, calendar).

getTimestamp(int)

Implements JDBC 1.0 ResultSet.getTimestamp.

getTimestamp(int, Calendar)

Implements JDBC 2.0 ResultSet.getTimestamp (idx, calendar).

getTimestamp(String)

Implements JDBC 1.0 ResultSet.getTimestamp.

getTimestamp(String, Calendar)

Implements JDBC 2.0 ResultSet.getTimestamp (idx, calendar).

getType()

Implements JDBC 2.0 ResultSet.getType.

getUnicodeStream(int)

Implements JDBC 1.0 ResultSet.getUnicodeStream.

getUnicodeStream(String)

Implements JDBC 1.0 ResultSet.getUnicodeStream.

getWarnings()

Implements JDBC 1.0 ResultSet.getWarnings.

insertRow()

Implements JDBC 2.0 ResultSet.insertRow.

isAfterLast()

Implements JDBC 2.0 ResultSet.isAfterLast.

isBeforeFirst()

Implements JDBC 2.0 ResultSet.isBeforeFirst.

isFirst()

Implements JDBC 2.0 ResultSet.isFirst.

isLast()

Implements JDBC 2.0 ResultSet.isLast.

last()

Implements JDBC 2.0 ResultSet.last.

moveToCurrentRow()

Implements JDBC 2.0 ResultSet.moveToCurrentRow.

moveToInsertRow()

Implements JDBC 2.0 ResultSet.moveToInsertRow.

next()

Implements JDBC 1.0 ResultSet.next.

previous()

Implements JDBC 2.0 ResultSet.previous.

refreshRow()

Implements JDBC 2.0 ResultSet.refreshRow.

relative(int)

Implements JDBC 2.0 ResultSet.relative.

rowDeleted()

Implements JDBC 2.0 ResultSet.rowDeleted.

rowInserted()

Implements JDBC 2.0 ResultSet.rowInserted.

rowUpdated()

Implements JDBC 2.0 ResultSet.rowUpdated.

setFetchDirection(int)

Implements JDBC 2.0 ResultSet.setFetchDirection.

setFetchSize(int)

Implements JDBC 2.0 ResultSet.setFetchSize.

updateARRAY(int, ARRAY)

Oracle extension.

updateArray(int, Array)

Oracle extension.

updateArray(String, Array)

Oracle extension.

updateARRAY(String, ARRAY)

Oracle extension.

updateAsciiStream(int, InputStream, int)

Implements JDBC 2.0 ResultSet.updateAsciiStream.

updateAsciiStream(String, InputStream, int)

Implements JDBC 2.0 ResultSet.updateAsciiStream.

updateBFILE(int, BFILE)

Oracle extension.

updateBfile(int, BFILE)

Oracle extension.

updateBfile(String, BFILE)

Oracle extension.

updateBFILE(String, BFILE)

Oracle extension.

updateBigDecimal(int, BigDecimal)

Implements JDBC 2.0 ResultSet.updateBigDecimal.

updateBigDecimal(String, BigDecimal)

Implements JDBC 2.0 ResultSet.updateBigDecimal.

updateBinaryStream(int, InputStream, int)

Implements JDBC 2.0 ResultSet.updateBinaryStream.

updateBinaryStream(String, InputStream, int)

Implements JDBC 2.0 ResultSet.updateBinaryStream.

updateBLOB(int, BLOB)

Oracle extension.

updateBlob(int, Blob)

Oracle extension.

updateBlob(String, Blob)

Oracle extension.

updateBLOB(String, BLOB)

Oracle extension.

updateBoolean(int, boolean)

Implements JDBC 2.0 ResultSet.updateBoolean.

updateBoolean(String, boolean)

Implements JDBC 2.0 ResultSet.updateBoolean.

updateByte(int, byte)

Implements JDBC 2.0 ResultSet.updateByte.

updateByte(String, byte)

Implements JDBC 2.0 ResultSet.updateByte.

updateBytes(int, byte[])

Implements JDBC 2.0 ResultSet.updateBytes.

updateBytes(String, byte[])

Implements JDBC 2.0 ResultSet.updateBytes.

updateCHAR(int, CHAR)

Oracle extension.

updateCHAR(String, CHAR)

Oracle extension.

updateCharacterStream(int, Reader, int)

Implements JDBC 2.0 ResultSet.updateCharacterStream.

updateCharacterStream(String, Reader, int)

Implements JDBC 2.0 ResultSet.updateCharacterStream.

updateClob(int, Clob)

Oracle extension.

updateCLOB(int, CLOB)

Oracle extension.

updateClob(String, Clob)

Oracle extension.

updateCLOB(String, CLOB)

Oracle extension.

updateCustomDatum(int, CustomDatum)

Oracle extension.

updateCustomDatum(String, CustomDatum)

Oracle extension.

updateDate(int, Date)

Implements JDBC 2.0 ResultSet.updateDate.

updateDATE(int, DATE)

Oracle extension.

updateDATE(String, DATE)

Oracle extension.

updateDate(String, Date)

Implements JDBC 2.0 ResultSet.updateDate.

updateDouble(int, double)

Implements JDBC 2.0 ResultSet.updateDouble.

updateDouble(String, double)

Implements JDBC 2.0 ResultSet.updateDouble.

updateFloat(int, float)

Implements JDBC 2.0 ResultSet.updateFloat.

updateFloat(String, float)

Implements JDBC 2.0 ResultSet.updateFloat.

updateInt(int, int)

Implements JDBC 2.0 ResultSet..

updateInt(String, int)

Implements JDBC 2.0 ResultSet..

updateLong(int, long)

Implements JDBC 2.0 ResultSet.updateLong.

updateLong(String, long)

Implements JDBC 2.0 ResultSet.updateLong.

updateNull(int)

Implements JDBC 2.0 ResultSet.updateNull.

updateNull(String)

Implements JDBC 2.0 ResultSet.updateNull.

updateNUMBER(int, NUMBER)

Oracle extension.

updateNUMBER(String, NUMBER)

Oracle extension.

updateObject(int, Object)

Implements JDBC 2.0 ResultSet.updateObject.

updateObject(int, Object, int)

Implements JDBC 2.0 ResultSet.updateObject.

updateObject(String, Object)

Implements JDBC 2.0 ResultSet.updateObject.

updateObject(String, Object, int)

Implements JDBC 2.0 ResultSet.updateObject.

updateOracleObject(int, Datum)

Oracle extension.

updateOracleObject(String, Datum)

Oracle extension.

updateRAW(int, RAW)

Oracle extension.

updateRAW(String, RAW)

Oracle extension.

updateRef(int, Ref)

Oracle extension.

updateREF(int, REF)

Oracle extension.

updateREF(String, REF)

Oracle extension.

updateRef(String, Ref)

Oracle extension.

updateRow()

Implements JDBC 2.0 ResultSet.updateRow.

updateROWID(int, ROWID)

Oracle extension.

updateROWID(String, ROWID)

Oracle extension.

updateShort(int, short)

Implements JDBC 2.0 ResultSet.updateShort.

updateShort(String, short)

Implements JDBC 2.0 ResultSet.updateShort.

updateString(int, String)

Implements JDBC 2.0 ResultSet.updateString.

updateString(String, String)

Implements JDBC 2.0 ResultSet.updateString.

updateSTRUCT(int, STRUCT)

Oracle extension.

updateSTRUCT(String, STRUCT)

Oracle extension.

updateTime(int, Time)

Implements JDBC 2.0 ResultSet.updateTime.

updateTime(String, Time)

Implements JDBC 2.0 ResultSet.updateTime.

updateTimestamp(int, Timestamp)

Implements JDBC 2.0 ResultSet.updateTimestamp.

updateTimestamp(String, Timestamp)

Implements JDBC 2.0 ResultSet.updateTimestamp.

wasNull()

Implements JDBC 1.0 ResultSet.wasNull.

 public static final int FETCH_FORWARD

 public static final int FETCH_REVERSE

 public static final int FETCH_UNKNOWN

 public static final int TYPE_FORWARD_ONLY

 public static final int TYPE_SCROLL_INSENSITIVE

 public static final int TYPE_SCROLL_SENSITIVE

 public static final int CONCUR_READ_ONLY

 public static final int CONCUR_UPDATABLE

 public OracleResultSet()

 public abstract ResultSet getCursor(int columnIndex) throws SQLException

Oracle extension. Get the REFCURSOR value of the column as a ResultSet.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the REFCURSOR column value as a ResultSet

Throws: SQLException

if a database access error occurs

 public abstract Datum getOracleObject(int columnIndex) throws SQLException

Oracle extension. Get the column value as the appropriate oracle.sql. type. This differs from getObject in that getObject returns the appropriate jdbc.sql. type. The Oracle specific types in oracle.sql more closely model the underlying Oracle database types, so there is no possible loss of information due to conversion and slightly greater efficiency.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as the appropriate oracle.sql. type; if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs.

 public abstract ROWID getROWID(int columnIndex) throws SQLException

Oracle extension. Get the ROWID column value as ROWID.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the ROWID column value as an oracle.sql.ROWID

Throws: SQLException

if a database access error occurs.

 public abstract NUMBER getNUMBER(int columnIndex) throws SQLException

Oracle extension. Get the column value as a NUMBER. NUMBER values have the same representation as Oracle numbers in the database, thus they have exactly the same value. Getting numeric values as other types can result in very slightly different values due to the difference in representation. Additionally, JDBC does not have to do any conversion when using getNUMBER and so is more efficient.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.NUMBER

Throws: SQLException

if a database access error occurs.

 public abstract DATE getDATE(int columnIndex) throws SQLException

Oracle extension. Get the column value as a DATE.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.DATE

Throws: SQLException

if a database access error occurs.

 public abstract ARRAY getARRAY(int columnIndex) throws SQLException

Oracle extension. Get the column value as a ARRAY. An ARRAY instance maps to a Nested Table or VARRAY value in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.ARRAY

Throws: SQLException

if a database access error occurs.

 public abstract STRUCT getSTRUCT(int columnIndex) throws SQLException

Oracle extension. Get the column value as a STRUCT. A STRUCT instance maps to a structured data type instance in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.STRUCT

Throws: SQLException

if a database access error occurs.

See Also:

getCustomDatum

 public abstract REF getREF(int columnIndex) throws SQLException

Oracle extension. Get the column value as a REF. A REF instance maps to a REF (to a row or concreated object) value in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.REF

Throws: SQLException

if a database access error occurs.

 public abstract CHAR getCHAR(int columnIndex) throws SQLException

Oracle extension. Get the column as a CHAR value. CHAR values retain the same same representation as they have in the database, so there can be no loss of information through conversion. While the vast majority of characters in the various Oracle NLS character sets are represented in the Unicode character set used by Java there are a very small number that are not. Additionally, JDBC does not have to perform any conversion when getting character data as CHAR, so getCHAR is slightly efficient than getString.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.CHAR

Throws: SQLException

if a database access error occurs.

 public abstract RAW getRAW(int columnIndex) throws SQLException

Oracle extension. Get the column value as a RAW. A RAW instance maps to a RAW or LONG RAW value in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.RAW

Throws: SQLException

if a database access error occurs.

 public abstract BLOB getBLOB(int columnIndex) throws SQLException

Oracle extension. Get the column value as a BLOB (unstructured binary data). BLOB data is accessed and referenced by using a locator which is stored in the database table and points to the BLOB data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.BLOB

Throws: SQLException

if a database access error occurs.

 public abstract CLOB getCLOB(int columnIndex) throws SQLException

Oracle extension. Get the column value as a CLOB (single-byte character data). CLOB data is accessed and referenced by using a locator which is stored in the database table and points to the CLOB data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.CLOB

Throws: SQLException

if a database access error occurs.

 public abstract BFILE getBFILE(int columnIndex) throws SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.BFILE

Throws: SQLException

if a database access error occurs.

 public abstract BFILE getBfile(int columnIndex) throws SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.BFILE

Throws: SQLException

if a database access error occurs.

 public abstract CustomDatum getCustomDatum(int columnIndex,
                                            CustomDatumFactory factory) throws SQLException

Oracle extension. Get the column value as an instance of a subclass of CustomDatum. Which subclass is determined by the factory parameter.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

factory - CustomDatumFactory used to materialize the column value

Returns:

the column value as a CustomDatum; if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs.

 public ResultSet getCURSOR(String columnName) throws SQLException

Oracle extension. Get the REFCURSOR value of the column as a ResultSet.

Parameters:

columnName - the name of the column

Returns:

the REFCURSOR column value as a ResultSet

Throws: SQLException

if a database access error occurs

 public ROWID getROWID(String columnName) throws SQLException

Oracle extension. Get the ROWID column value as ROWID.

Parameters:

columnName - the name of the column

Returns:

the ROWID column value as an oracle.sql.ROWID

Throws: SQLException

if a database access error occurs.

 public NUMBER getNUMBER(String columnName) throws SQLException

Oracle extension. Get the column value as a NUMBER. NUMBER values have the same representation as Oracle numbers in the database, thus they have exactly the same value. Getting numeric values as other types can result in very slightly different values due to the difference in representation. Additionally, JDBC does not have to do any conversion when using getNUMBER and so is more efficient.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.NUMBER

Throws: SQLException

if a database access error occurs.

 public DATE getDATE(String columnName) throws SQLException

Oracle extension. Get the column value as a DATE.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.DATE

Throws: SQLException

if a database access error occurs.

 public Datum getOracleObject(String columnName) throws SQLException

Oracle extension. Get the column value as the appropriate oracle.sql. type. This differs from getObject in that getObject returns the appropriate jdbc.sql. type. The Oracle specific types in oracle.sql more closely model the underlying Oracle database types possible loss of information due to conversion and slightly greater efficiency.

Parameters:

columnName - the name of the column

Returns:

the column value as the appropriate oracle.sql. type; if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs.

 public ARRAY getARRAY(String columnName) throws SQLException

Oracle extension. Get the column value as a ARRAY. An ARRAY instance maps to a Nested Table or VARRAY value in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.ARRAY

Throws: SQLException

if a database access error occurs.

 public STRUCT getSTRUCT(String columnName) throws SQLException

Oracle extension. Get the column value as a STRUCT. A STRUCT instance maps to a structured data type instance in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.STRUCT

Throws: SQLException

if a database access error occurs.

See Also:

getCustomDatum

 public REF getREF(String columnName) throws SQLException

Oracle extension. Get the column value as a REF. A REF instance maps to a REF (to a row or concreated object) value in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.REF

Throws: SQLException

if a database acc

 public CHAR getCHAR(String columnName) throws SQLException

Oracle extension. Get the column as a CHAR value. CHAR values retain the same same representation as they have in the database, so there can be no loss of information through conversion. While the vast majority of characters in the various Oracle NLS character sets are represented in the Unicode character set used by Java there are a very small number that are not. Additionally, JDBC does not have to perform any conversion when getting character data as CHAR, so getCHAR is slightly efficient than getString.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.CHAR

Throws: SQLException

if a database access error occurs.

 public RAW getRAW(String columnName) throws SQLException

Oracle extension. Get the column value as a RAW. A RAW instance maps to a RAW or LONG RAW value in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.RAW

Throws: SQLException

if a database access error occurs.

 public BLOB getBLOB(String columnName) throws SQLException

Oracle extension. Get the column value as a BLOB (unstructured binary data). BLOB data is accessed and referenced by using a locator which is stored in the database table and points to the BLOB data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.BLOB

Throws: SQLException

if a database access error occurs.

 public CLOB getCLOB(String columnName) throws SQLException

Oracle extension. Get the column value as a CLOB (single-byte character data). CLOB data is accessed and referenced by using a locator which is stored in the database table and points to the CLOB data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.CLOB

Throws: SQLException

if a database access error occurs.

 public BFILE getBFILE(String columnName) throws SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.BFILE

Throws: SQLException

if a database access error occurs.

 public BFILE getBfile(String columnName) throws SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.BFILE

Throws: SQLException

if a database access error occurs.

 public CustomDatum getCustomDatum(String columnName,
                                   CustomDatumFactory factory) throws SQLException

Oracle extension. Get the column value as an instance of a subclass of CustomDatum. Which subclass is determined by the factory parameter.

Parameters:

columnName - the name of the column

factory - CustomDatumFactory used to materialize the column value

Returns:

the column value as a CustomDatum; if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs.

 public abstract void updateOracleObject(int columnIndex,
                                         Datum x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.xxx value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateROWID(int columnIndex,
                                  ROWID x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.ROWID value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateNUMBER(int columnIndex,
                                   NUMBER x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.NUMBER value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateDATE(int columnIndex,
                                 DATE x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.DATE value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateARRAY(int columnIndex,
                                  ARRAY x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.ARRAY value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateSTRUCT(int columnIndex,
                                   STRUCT x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.STRUCT value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateREF(int columnIndex,
                                REF x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.REF value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateCHAR(int columnIndex,
                                 CHAR x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.CHAR value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateRAW(int columnIndex,
                                RAW x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.RAW value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateBLOB(int columnIndex,
                                 BLOB x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.BLOB value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateCLOB(int columnIndex,
                                 CLOB x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.CLOB value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateBFILE(int columnIndex,
                                  BFILE x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.BFILE value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateBfile(int columnIndex,
                                  BFILE X) throws SQLException

Oracle extension. Updates a column with an Bfile value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract void updateCustomDatum(int columnIndex,
                                        CustomDatum x) throws SQLException

Oracle extension. Updates a column with an CustomDatum value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Oracle extension. Updates a column with an Ref value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Oracle extension. Updates a column with an Blob value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Oracle extension. Updates a column with an Clob value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Oracle extension. Updates a column with an Array value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateROWID(String columnName,
                         ROWID x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.ROWID value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateNUMBER(String columnName,
                          NUMBER x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.NUMBER value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateDATE(String columnName,
                        DATE x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.DATE value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateOracleObject(String columnName,
                                Datum x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.xxx value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateARRAY(String columnName,
                         ARRAY x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.ARRAY value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateSTRUCT(String columnName,
                          STRUCT x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.STRUCT value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateREF(String columnName,
                       REF x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.REF value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateCHAR(String columnName,
                        CHAR x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.CHAR value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateRAW(String columnName,
                       RAW x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.RAW value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateBLOB(String columnName,
                        BLOB x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.BLOB value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateCLOB(String columnName,
                        CLOB x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.CLOB value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateBFILE(String columnName,
                         BFILE x) throws SQLException

Oracle extension. Updates a column with an oracle.sql.BFILE value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateBfile(String columnName,
                         BFILE x) throws SQLException

Oracle extension. Updates a column with an Bfile value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateCustomDatum(String columnName,
                               CustomDatum x) throws SQLException

Oracle extension. Updates a column with an CustomDatum value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Oracle extension. Updates a column with an Ref value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Oracle extension. Updates a column with an Blob value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Oracle extension. Updates a column with an Clob value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Oracle extension. Updates a column with an Array value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

 public abstract SQLWarning getWarnings() throws SQLException

Implements JDBC 1.0 ResultSet.getWarnings. Oracle does not have any warnings, so always returns null.

Returns:

null

Throws: SQLException

if a database-access error occurs.

 public abstract void clearWarnings() throws SQLException

Implements JDBC 1.0 ResultSet.clearWarnings. After this call getWarnings returns null until a new warning is reported for this ResultSet.

Throws: SQLException

if a database-access error occurs.

 public abstract String getCursorName() throws SQLException

Implements JDBC 1.0 ResultSet.getCursorName. Oracle does not support cursor names, so this always throws an exception.

Returns:

never returns

Throws: SQLException

always

 public abstract ResultSetMetaData getMetaData() throws SQLException

Implements JDBC 1.0 ResultSet.getMetaData. This feature is not supported for ResultSet instance returned from oracle.sql.ARRAY#getResultSet.

Returns:

the description of a ResultSet's columns

Throws: SQLException

if a database-access error occurs.

 public abstract int findColumn(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.findColumn.

Parameters:

columnName - the name of the column

Returns:

the column index

Throws: SQLException

if a database-access error occurs.

 public abstract boolean next() throws SQLException

Implements JDBC 1.0 ResultSet.next.

Returns:

true if the new current row is valid; false if there are no more rows

Throws: SQLException

if a database-access error occurs.

 public abstract void close() throws SQLException

Implements JDBC 1.0 ResultSet.close.

Note: Because finalization is problematic for many Java VMs, Oracle JDBC does not have finalizer methods on OracleConnection, OracleStatement and its subclasses, nor OracleResultSet and its subclasses. User code must explicitly close these by sending the close method.

Throws: SQLException

if a database-access error occurs.

 public abstract boolean wasNull() throws SQLException

Implements JDBC 1.0 ResultSet.wasNull.

Returns:

true if last column read was SQL NULL

Throws: SQLException

if a database-access error occurs.

 public abstract Object getObject(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getObject.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

A java.lang.Object holding the column value.

Throws: SQLException

if a database-access error occurs.

 public abstract String getString(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getString.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public abstract boolean getBoolean(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getBoolean.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is false

Throws: SQLException

if a database-access error occurs.

 public abstract byte getByte(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getByte.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is 0

Throws: SQLException

if a database-access error occurs.

 public abstract short getShort(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getShort.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is 0

Throws: SQLException

if a database-access error occurs.

 public abstract int getInt(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getInt.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is 0

Throws: SQLException

if a database-access error occurs.

 public abstract long getLong(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getLong.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is 0

Throws: SQLException

if a database-access error occurs.

 public abstract float getFloat(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getFloat.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is 0

Throws: SQLException

if a database-access error occurs.

 public abstract double getDouble(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getDouble.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

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

Implements JDBC 1.0 ResultSet.getBigDecimal.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

scale - the number of digits to the right of the decimal

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public abstract byte[] getBytes(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getBytes.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public abstract Date getDate(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getDate.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public abstract Time getTime(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getTime.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public abstract Timestamp getTimestamp(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getTimestamp.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public abstract InputStream getAsciiStream(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getAsciiStream.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public abstract InputStream getUnicodeStream(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getUnicodeStream.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public abstract InputStream getBinaryStream(int columnIndex) throws SQLException

Implements JDBC 1.0 ResultSet.getBinaryStream.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public Object getObject(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getObject.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

A java.lang.Object holding the column value.

Throws: SQLException

if a database-access error occurs.

 public String getString(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getString.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public boolean getBoolean(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getBoolean.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is false

Throws: SQLException

if a database-access error occurs.

 public byte getByte(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getByte.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is 0

Throws: SQLException

if a databas

 public short getShort(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getShort.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is 0

Throws: SQLException

if a database-access error occurs.

 public int getInt(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getInt.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is 0

Throws: SQLException

if a database-access error occurs.

 public long getLong(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getLong.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is 0

Throws: SQLException

if a database-access error occurs.

 public float getFloat(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getFloat.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is 0

Throws: SQLException

if a database-access error occurs.

 public double getDouble(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getDouble.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQ

Throws: SQLException

if a database-access error occurs.

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

Implements JDBC 1.0 ResultSet.getBigDecimal.

Parameters:

columnName - is the SQL name of the column

scale - the number of digits to the right of the decimal

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public byte[] getBytes(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getBytes.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public Date getDate(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getDate.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public Time getTime(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getTime.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public Timestamp getTimestamp(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getTimestamp.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public InputStream getAsciiStream(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getAsciiStream.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public InputStream getUnicodeStream(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getUnicodeStream.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public InputStream getBinaryStream(String columnName) throws SQLException

Implements JDBC 1.0 ResultSet.getBinaryStream.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database-access error occurs.

 public abstract Object getObject(int columnIndex,
                                  Dictionary map) throws SQLException

Implements JDBC 2.0 ResultSet.getObject (idx, map). Returns the value of a column in the current row as a Java object. This method uses the given Map object for the custom mapping of the SQL structured or distinct type that is being retrieved.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

map - the mapping from SQL type names to Java classes

Returns:

an object representing the SQL value

Throws: SQLException

if a database-access error occurs.

 public abstract Ref getRef(int columnIndex) throws SQLException

Implements JDBC 2.0 ResultSet.getRef. Gets a REF(<structured-type>) column value from the current row.

Parameters:

columnIndex - 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.

 public abstract Blob getBlob(int columnIndex) throws SQLException

Implements JDBC 2.0 ResultSet.getBlob. Gets a BLOB value in the current row of this ResultSet object.

Parameters:

columnIndex - 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.

 public abstract Clob getClob(int columnIndex) throws SQLException

Implements JDBC 2.0 ResultSet. Gets a CLOB value in the current row of this ResultSet object.

Parameters:

columnIndex - 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.

 public abstract Array getArray(int columnIndex) throws SQLException

Implements JDBC 2.0 ResultSet.getArray. Gets an SQL ARRAY value from the current row of this ResultSet object.

Parameters:

columnIndex - 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.

 public abstract Reader getCharacterStream(int columnIndex) throws SQLException

Implements JDBC 2.0 ResultSet.getCharacterStream.

Gets the value of a column in the current row as a java.io.Reader.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Throws: SQLException

if a database-access error occurs.

 public abstract BigDecimal getBigDecimal(int columnIndex) throws SQLException

Implements JDBC 2.0 ResultSet.getBigDecimal. Gets the value of a column in the current row as a java.math.BigDecimal object with full precision. The methods behaves the same as getBigDecimal (idx, scale) since Oracle handles numeric values with full precision.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value (full precision); if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.getDate (idx, calendar). Gets the value of a column in the current row as a java.sql.Date object. This methods behaves the same as getDate (idx) since Oracle database doesn't support timezone information with Date.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

cal - the calendar to use in constructing the date

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.getTime (idx, calendar). Gets the value of a column in the current row as a java.sql.Time object. This methods behaves the same as getTime (idx) since Oracle database doesn't support timezone information with Date.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

cal - the calendar to use in constructing the time

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.getTimestamp (idx, calendar). Gets the value of a column in the current row as a java.sql.Timestamp object. This methods behaves the same as getTimestamp (idx) since Oracle database doesn't support timezone information with Date.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

cal - the calendar to use in constructing the time

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs

 public Object getObject(String columnName,
                         Dictionary map) throws SQLException

Implements JDBC 2.0 ResultSet.getObject (idx, map). Returns the value of a column in the current row as a Java object. This method uses the given Map object for the custom mapping of the SQL structured or distinct type that is being retrieved.

Parameters:

columnName - is the SQL name of the column

map - the mapping from SQL type names to Java classes

Returns:

an object representing the SQL value

Throws: SQLException

if a database-access error occurs.

 public Ref getRef(String columnName) throws SQLException

Implements JDBC 2.0 ResultSet.getRef. Gets a REF(<structured-type>) column value from the current row.

Parameters:

columnName - is the SQL name of the column

Returns:

a Ref object representing an SQL REF value

Throws: SQLException

if a database-access error occurs.

 public Blob getBlob(String columnName) throws SQLException

Implements JDBC 2.0 ResultSet.getBlob. Gets a BLOB value in the current row of this ResultSet object.

Parameters:

columnName - is the SQL name of the column

Returns:

a Blob object representing the SQL BLOB value in the specified column

Throws: SQLException

if a database-access error occurs.

 public Clob getClob(String columnName) throws SQLException

Implements JDBC 2.0 ResultSet. Gets a CLOB value in the current row of this ResultSet object.

Parameters:

columnName - is the SQL name of the column

Returns:

a Clob object representing the SQL CLOB value in the specified column

Throws: SQLException

if a database-access error occurs.

 public Reader getCharacterStream(String columnName) throws SQLException

Implements JDBC 2.0 ResultSet.getCharacterStream.

Gets the value of a column in the current row as a java.io.Reader.

Parameters:

columnName - is the SQL name of the column

Throws: SQLException

if a database-access error occurs.

 public Array getArray(String columnName) throws SQLException

Implements JDBC 2.0 ResultSet.getArray. Gets an SQL ARRAY value from the current row of this ResultSet object .

Parameters:

columnName - is the SQL name of the column

Returns:

an Array object representing the SQL ARRAY value in the specified column

Throws: SQLException

if a database-access error occurs.

 public BigDecimal getBigDecimal(String columnName) throws SQLException

Implements JDBC 2.0 ResultSet.getBigDecimal. Gets the value of a column in the current row as a java.math.BigDecimal object with full precision. The methods behaves the same as getBigDecimal (idx, scale) since Oracle handles numeric values with full precision.

Parameters:

columnName - is the SQL name of the column

Returns:

the column value (full precision); if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.getDate (idx, calendar). Gets the value of a column in the current row as a java.sql.Date object. This methods behaves the same as getDate (idx) since Oracle database doesn't support timezone information with Date.

Parameters:

columnName - is the SQL name of the column

cal - the calendar to use in constructing the date

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.getTime (idx, calendar). Gets the value of a column in the current row as a java.sql.Time object. This methods behaves the same as getTime (idx) since Oracle database doesn't support timezone information with Date.

Parameters:

columnName - is the SQL name of the column

cal - the calendar to use in constructing the time

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.getTimestamp (idx, calendar). Gets the value of a column in the current row as a java.sql.Timestamp object. This methods behaves the same as getTimestamp (idx) since Oracle database doesn't support timezone information with Date.

Parameters:

columnName - is the SQL name of the column

cal - the calendar to use in constructing the time

Returns:

the column value; if the value is SQL NULL, the result is null

Throws: SQLException

if a database access error occurs

 public abstract boolean isBeforeFirst() throws SQLException

Implements JDBC 2.0 ResultSet.isBeforeFirst.

Indicates whether the cursor is before the first row in the result set.

Returns:

true if the cursor is before the first row, false otherwise. Returns false when the result set contains no rows.

Throws: SQLException

if a database access error occurs

 public abstract boolean isAfterLast() throws SQLException

Implements JDBC 2.0 ResultSet.isAfterLast.

Indicates whether the cursor is after the last row in the result set.

Returns:

true if the cursor is after the last row, false otherwise. Returns false when the result set contains no rows.

Throws: SQLException

if a database access error occurs

 public abstract boolean isFirst() throws SQLException

Implements JDBC 2.0 ResultSet.isFirst.

Indicates whether the cursor is on the first row of the result set.

Returns:

true if the cursor is on the first row, false otherwise.

Throws: SQLException

if a database access error occurs

 public abstract boolean isLast() throws SQLException

Implements JDBC 2.0 ResultSet.isLast.

Indicates whether the cursor is on the last row of the result set.

Returns:

true if the cursor is on the last row, false otherwise.

Throws: SQLException

if a database access error occurs or the result set type is TYPE_FORWARD_ONLY

 public abstract void beforeFirst() throws SQLException

Implements JDBC 2.0 ResultSet.beforeFirst.

Moves the cursor to the front of the result set, just before the first row. Has no effect if the result set contains no rows.

Throws: SQLException

if a database access error occurs or the result set type is TYPE_FORWARD_ONLY

 public abstract void afterLast() throws SQLException

Implements JDBC 2.0 ResultSet.afterLast.

Moves the cursor to the end of the result set, just after the last row. Has no effect if the result set contains no rows.

Throws: SQLException

if a database access error occurs or the result set type is TYPE_FORWARD_ONLY

 public abstract boolean first() throws SQLException

Implements JDBC 2.0 ResultSet.first.

Moves the cursor to 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 a database access error occurs or the result set type is TYPE_FORWARD_ONLY

 public abstract boolean last() throws SQLException

Implements JDBC 2.0 ResultSet.last.

Moves the cursor to 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 a database access error occurs or the result set type is TYPE_FORWARD_ONLY.

 public abstract int getRow() throws SQLException

Implements JDBC 2.0 ResultSet.getRow.

Retrieves the current row number. The first row is number 1, the second number 2, and so on.

Returns:

the current row number; 0 if there is no current row

Throws: SQLException

if a database access error occurs

 public abstract boolean absolute(int row) throws SQLException

Implements JDBC 2.0 ResultSet.absolute.

Moves the cursor to the given row number in the result set.

If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set.

If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set.

An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before/after the first/last row, respectively.

Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().

Returns:

true if the cursor is on the result set; false otherwise

Throws: SQLException

if a database access error occurs or row is 0, or result set type is TYPE_FORWARD_ONLY.

 public abstract boolean relative(int rows) throws SQLException

Implements JDBC 2.0 ResultSet.relative.

Moves the cursor a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.

Note: Calling relative(1) is different from calling next() because is makes sense to call next() when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set.

Returns:

true if the cursor is on a row; false otherwise

Throws: SQLException

if a database access error occurs, there is no current row, or the result set type is TYPE_FORWARD_ONLY

 public abstract boolean previous() throws SQLException

Implements JDBC 2.0 ResultSet.previous.

Moves the cursor to the previous row in the result set.

Note: previous() is not the same as relative(-1) because it makes sense to callprevious() when there is no current row.

Returns:

true if the cursor is on a valid row; false if it is off the result set

Throws: SQLException

if a database access error occurs or the result set type is TYPE_FORWARD_ONLY

 public abstract void setFetchDirection(int direction) throws SQLException

Implements JDBC 2.0 ResultSet.setFetchDirection. Oracle processes result set in forward direction only. Chagning fetch direction to FETCH_REVERSE or FETCH_UNKNOWN is ignored.

Throws: SQLException

if a database access error occurs

 public abstract int getFetchDirection() throws SQLException

Implements JDBC 2.0 ResultSet.getFetchDirection. Returns the fetch direction for this result set which is always FORWARD_ONLY.

Returns:

the current fetch direction for this result set

Throws: SQLException

if a database access error occurs

 public abstract void setFetchSize(int rows) throws SQLException

Implements JDBC 2.0 ResultSet.setFetchSize. 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 result set. If the fetch size specified is zero, the JDBC driver set the fetch size to the connection's default row prefetch value (value retruned from OracleConnection::getDefaultRowPrefetch).

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.

 public abstract int getFetchSize() throws SQLException

Implements JDBC 2.0 ResultSet.getFetchSize. Returns the fetch size for this result set.

Returns:

the current fetch size for this result set

Throws: SQLException

if a database access error occurs

 public abstract int getType() throws SQLException

Implements JDBC 2.0 ResultSet.getType. Returns the type of this result set. The type is determined by the statement that created the result set.

Returns:

TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, or TYPE_SCROLL_SENSITIVE

Throws: SQLException

if a database access error occurs

 public abstract int getConcurrency() throws SQLException

Implements JDBC 2.0 ResultSet.getConcurrency. Returns the concurrency mode of this result set. The concurrency used is determined by the statement that created the result set.

Returns:

the concurrency type, CONCUR_READ_ONLY or CONCUR_UPDATABLE

Throws: SQLException

if a database access error occurs

 public abstract void insertRow() throws SQLException

Implements JDBC 2.0 ResultSet.insertRow. Inserts the contents of the insert row into the result set and the database. Must be on the insert row when this method is called.

Throws: SQLException

if a database access error occurs, if called when not on the insert row, or if not all of non-nullable columns in the insert row have been given a value

 public abstract void updateRow() throws SQLException

Implements JDBC 2.0 ResultSet.updateRow. Updates the underlying database with the new contents of the current row. Cannot be called when on the insert row.

Throws: SQLException

if a database access error occurs or if called when on the insert row

 public abstract void deleteRow() throws SQLException

Implements JDBC 2.0 ResultSet.deleteRow. Deletes the current row from the result set and the underlying database. Cannot be called when on the insert row.

Throws: SQLException

if a database access error occurs or if called when on the insert row.

 public abstract void refreshRow() throws SQLException

Implements JDBC 2.0 ResultSet.refreshRow. refreshRow() is supported for scroll-sensitive result sets and scroll-sensitive/updatable result set. Refreshes the current row with its most recent value in the database. Cannot be called when on the insert row. The JDBC driver 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 updateXXX, but before calling updateRow, then the updates made to the row are lost. Calling the method refreshRow frequently will likely slow performance.

Throws: SQLException

if a database access error occurs, or if called when on the insert row, or the result set type is forward-only, or the result set type is scroll-insensitive and concurrency type is read only.

 public abstract void moveToInsertRow() throws SQLException

Implements JDBC 2.0 ResultSet.moveToInsertRow. Moves the cursor to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row.

Throws: SQLException

if a database access error occurs or the result set is not updatable

 public abstract void cancelRowUpdates() throws SQLException

Implements JDBC 2.0 ResultSet.cancelRowUpdates. Cancels the updates made to a row. This method may be called after calling an updateXXX method(s) and before calling updateRow to rollback the updates made to a row. If no updates have been made or updateRow has already been called, then this method has no effect.

Throws: SQLException

if a database access error occurs or if called when on the insert row

 public abstract void moveToCurrentRow() throws SQLException

Implements JDBC 2.0 ResultSet.moveToCurrentRow. Moves the cursor to the remembered cursor position. This method has no effect if the cursor is not on the insert row.

Throws: SQLException

if a database access error occurs or the result set is not updatable

 public abstract Statement getStatement() throws SQLException

Implements JDBC 2.0 ResultSet.getStatement. Returns the Statement that produced this ResultSet object. If the result set was generated some other way, such as by a DatabaseMetaData method, this method returns null.

Returns:

the Statment that produced the result set or null if the result set was produced some other way

Throws: SQLException

if a database access error occurs

 public abstract boolean rowUpdated() throws SQLException

Implements JDBC 2.0 ResultSet.rowUpdated. Always return false since Oracle JDBC driver doesn't detect row updated.

Returns:

false always

 public abstract boolean rowInserted() throws SQLException

Implements JDBC 2.0 ResultSet.rowInserted. Always return false since Oracle JDBC driver doesn't detect row inserted.

Returns:

false always

 public abstract boolean rowDeleted() throws SQLException

Implements JDBC 2.0 ResultSet.rowDeleted. Always return false since Oracle JDBC driver doesn't detect row deleted.

Returns:

false always

 public abstract void updateNull(int columnIndex) throws SQLException

Implements JDBC 2.0 ResultSet.updateNull. Give a nullable column a null value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateBoolean. Updates a column with a boolean value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateByte. Updates a column with a byte value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateShort. Updates a column with a short value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.. Updates a column with an integer value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateLong. Updates a column with a long value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateFloat. Updates a column with a float value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateDouble. Updates a column with a Double value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateBigDecimal. Updates a column with a BigDecimal value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateString. Updates a column with a String value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateBytes. Updates a column with a byte array value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateDate. Updates a column with a Date value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateTime. Updates a column with a Time value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateTimestamp. Updates a column with a Timestamp value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateAsciiStream. Updates a column with an ascii stream value.

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

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

Implements JDBC 2.0 ResultSet.updateBinaryStream. Updates a column with a binary stream value.

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

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

Implements JDBC 2.0 ResultSet.updateCharacterStream. Updates a column with a character stream value.

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

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

Implements JDBC 2.0 ResultSet.updateObject. Updates a column with an Object value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

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. For all other types this value will be ignored.

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateObject. Updates a column with an Object value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws: SQLException

if a database access error occurs

 public void updateNull(String columnName) throws SQLException

Implements JDBC 2.0 ResultSet.updateNull. Give a nullable column a null value. The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName - is the SQL name of the column

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateBoolean. Updates a column with a boolean value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateByte. Updates a column with a byte value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateShort. Updates a column with a short value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.. Updates a column with an integer value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateLong. Updates a column with a long value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateFloat. Updates a column with a float value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateDouble. Updates a column with a Double value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateBigDecimal. Updates a column with a BigDecimal value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateString. Updates a column with a String value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateBytes. Updates a column with a byte array value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateDate. Updates a column with a Date value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateTime. Updates a column with a Time value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateTimestamp. Updates a column with a Timestamp value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateAsciiStream. Updates a column with an ascii stream value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

length - the length of the stream

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateBinaryStream. Updates a column with a binary stream value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

length - the length of the stream

Throws: SQLException

if a database access error occurs

 public void updateCharacterStream(String columnName,
                                   Reader reader,
                                   int length) throws SQLException

Implements JDBC 2.0 ResultSet.updateCharacterStream. Updates a column with a character stream value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

length - the length of the stream

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateObject. Updates a column with an Object value.

Parameters:

columnName - is the SQL 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. For all other types this value will be ignored.

Throws: SQLException

if a database access error occurs

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

Implements JDBC 2.0 ResultSet.updateObject. Updates a column with an Object value.

Parameters:

columnName - is the SQL name of the column

x - the new column value

Throws: SQLException

if a database access error occurs

All Packages  Class Hierarchy  This Package  Previous  Next  Index