OracleResultSet

Overview

Package

Class

Tree

Deprecated

Index

Help

Oracle10g JDBC

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

oracle.jdbc.driver
Class OracleResultSet

java.lang.Object
  oracle.jdbc.driver.OracleResultSet

All Implemented Interfaces:: oracle.jdbc.internal.OracleResultSet, OracleResultSet, java.sql.ResultSet

public abstract class OracleResultSet
extends java.lang.Object
implements oracle.jdbc.internal.OracleResultSet

This abstract class contains all the results set public methods Oracle JDBC drivers expose to the outside world. All ResultSet implementation should extend this class. This class contains --

1. Oracle specific methods.

For example, getter and update methods for Datum types.

2. JDBC 1.2 methods.

3. JDBC 2.0 methods.

Field Summary
`static java.lang.String`	`BUILD_DATE`
`static int`	`CONCUR_READ_ONLY`
`static int`	`CONCUR_UPDATABLE`
`static int`	`FETCH_FORWARD`
`static int`	`FETCH_REVERSE`
`static int`	`FETCH_UNKNOWN`
`static boolean`	`PRIVATE_TRACE`
`static boolean`	`TRACE`
`static int`	`TYPE_FORWARD_ONLY`
`static int`	`TYPE_SCROLL_INSENSITIVE`
`static int`	`TYPE_SCROLL_SENSITIVE`

Fields inherited from interface java.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, HOLD_CURSORS_OVER_COMMIT

Constructor Summary
`OracleResultSet()`

Method Summary
`abstract boolean`	`absolute(int row)` Implements JDBC 2.0 ResultSet.absolute.
`abstract void`	`afterLast()` Implements JDBC 2.0 ResultSet.afterLast.
`abstract void`	`beforeFirst()` Implements JDBC 2.0 ResultSet.beforeFirst.
`abstract void`	`cancelRowUpdates()` Implements JDBC 2.0 ResultSet.cancelRowUpdates.
`abstract void`	`clearWarnings()` Implements JDBC 1.0 ResultSet.clearWarnings.
`abstract void`	`close()` Implements JDBC 1.0 ResultSet.close.
`abstract void`	`deleteRow()` Implements JDBC 2.0 ResultSet.deleteRow.
`abstract int`	`findColumn(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.findColumn.
`abstract boolean`	`first()` Implements JDBC 2.0 ResultSet.first.
`abstract java.sql.Array`	`getArray(int columnIndex)` Implements JDBC 2.0 ResultSet.getArray.
`abstract ARRAY`	`getARRAY(int columnIndex)` Oracle extension.
`java.sql.Array`	`getArray(java.lang.String columnName)` Implements JDBC 2.0 ResultSet.getArray.
`ARRAY`	`getARRAY(java.lang.String columnName)` Oracle extension.
`abstract java.io.InputStream`	`getAsciiStream(int columnIndex)` Implements JDBC 1.0 ResultSet.getAsciiStream.
`java.io.InputStream`	`getAsciiStream(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getAsciiStream.
`abstract boolean`	`getAutoRefetch()` Oracle extension.
`abstract BFILE`	`getBfile(int columnIndex)` Oracle extension.
`abstract BFILE`	`getBFILE(int columnIndex)` Oracle extension.
`BFILE`	`getBfile(java.lang.String columnName)` Oracle extension.
`BFILE`	`getBFILE(java.lang.String columnName)` Oracle extension.
`abstract java.math.BigDecimal`	`getBigDecimal(int columnIndex)` Implements JDBC 2.0 ResultSet.getBigDecimal.
`abstract java.math.BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Implements JDBC 1.0 ResultSet.getBigDecimal.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String columnName)` Implements JDBC 2.0 ResultSet.getBigDecimal.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String columnName, int scale)` Implements JDBC 1.0 ResultSet.getBigDecimal.
`abstract java.io.InputStream`	`getBinaryStream(int columnIndex)` Implements JDBC 1.0 ResultSet.getBinaryStream.
`java.io.InputStream`	`getBinaryStream(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getBinaryStream.
`abstract java.sql.Blob`	`getBlob(int columnIndex)` Implements JDBC 2.0 ResultSet.getBlob.
`abstract BLOB`	`getBLOB(int columnIndex)` Oracle extension.
`java.sql.Blob`	`getBlob(java.lang.String columnName)` Implements JDBC 2.0 ResultSet.getBlob.
`BLOB`	`getBLOB(java.lang.String columnName)` Oracle extension.
`abstract boolean`	`getBoolean(int columnIndex)` Implements JDBC 1.0 ResultSet.getBoolean.
`boolean`	`getBoolean(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getBoolean.
`abstract byte`	`getByte(int columnIndex)` Implements JDBC 1.0 ResultSet.getByte.
`byte`	`getByte(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getByte.
`abstract byte[]`	`getBytes(int columnIndex)` Implements JDBC 1.0 ResultSet.getBytes.
`byte[]`	`getBytes(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getBytes.
`abstract CHAR`	`getCHAR(int columnIndex)` Oracle extension.
`CHAR`	`getCHAR(java.lang.String columnName)` Oracle extension.
`abstract java.io.Reader`	`getCharacterStream(int columnIndex)` Implements JDBC 2.0 ResultSet.getCharacterStream.
`java.io.Reader`	`getCharacterStream(java.lang.String columnName)` Implements JDBC 2.0 ResultSet.getCharacterStream.
`abstract java.sql.Clob`	`getClob(int columnIndex)` Implements JDBC 2.0 ResultSet.
`abstract CLOB`	`getCLOB(int columnIndex)` Oracle extension.
`java.sql.Clob`	`getClob(java.lang.String columnName)` Implements JDBC 2.0 ResultSet.
`CLOB`	`getCLOB(java.lang.String columnName)` Oracle extension.
`abstract int`	`getConcurrency()` Implements JDBC 2.0 ResultSet.getConcurrency.
`abstract java.sql.ResultSet`	`getCursor(int columnIndex)` Oracle extension.
`java.sql.ResultSet`	`getCursor(java.lang.String columnName)` Oracle extension.
`abstract java.lang.String`	`getCursorName()` Implements JDBC 1.0 ResultSet.getCursorName.
`abstract CustomDatum`	`getCustomDatum(int columnIndex, CustomDatumFactory factory)` Deprecated.
`CustomDatum`	`getCustomDatum(java.lang.String columnName, CustomDatumFactory factory)` Deprecated.
`abstract java.sql.Date`	`getDate(int columnIndex)` Implements JDBC 1.0 ResultSet.getDate.
`abstract DATE`	`getDATE(int columnIndex)` Oracle extension.
`abstract java.sql.Date`	`getDate(int columnIndex, java.util.Calendar cal)` Implements JDBC 2.0 ResultSet.getDate (idx, calendar).
`java.sql.Date`	`getDate(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getDate.
`DATE`	`getDATE(java.lang.String columnName)` Oracle extension.
`java.sql.Date`	`getDate(java.lang.String columnName, java.util.Calendar cal)` Implements JDBC 2.0 ResultSet.getDate (idx, calendar).
`abstract double`	`getDouble(int columnIndex)` Implements JDBC 1.0 ResultSet.getDouble.
`double`	`getDouble(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getDouble.
`abstract int`	`getFetchDirection()` Implements JDBC 2.0 ResultSet.getFetchDirection.
`abstract int`	`getFetchSize()` Implements JDBC 2.0 ResultSet.getFetchSize.
`abstract float`	`getFloat(int columnIndex)` Implements JDBC 1.0 ResultSet.getFloat.
`float`	`getFloat(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getFloat.
`abstract int`	`getInt(int columnIndex)` Implements JDBC 1.0 ResultSet.getInt.
`int`	`getInt(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getInt.
`INTERVALDS`	`getINTERVALDS(int columnIndex)` Obtain an oralce.sql.INTERVALDS value from the ResultSet.
`INTERVALDS`	`getINTERVALDS(java.lang.String columnName)` Obtain an oralce.sql.INTERVALDS value from the ResultSet.
`INTERVALYM`	`getINTERVALYM(int columnIndex)` Obtain an oralce.sql.INTERVALYM value from the ResultSet.
`INTERVALYM`	`getINTERVALYM(java.lang.String columnName)` Obtain an oralce.sql.INTERVALYM value from the ResultSet.
`abstract long`	`getLong(int columnIndex)` Implements JDBC 1.0 ResultSet.getLong.
`long`	`getLong(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getLong.
`abstract java.sql.ResultSetMetaData`	`getMetaData()` Implements JDBC 1.0 ResultSet.getMetaData.
`abstract NUMBER`	`getNUMBER(int columnIndex)` Oracle extension.
`NUMBER`	`getNUMBER(java.lang.String columnName)` Oracle extension.
`abstract java.lang.Object`	`getObject(int columnIndex)` Implements JDBC 1.0 ResultSet.getObject.
`abstract java.lang.Object`	`getObject(int columnIndex, java.util.Map map)` Implements JDBC 2.0 ResultSet.getObject (idx, map).
`java.lang.Object`	`getObject(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getObject.
`java.lang.Object`	`getObject(java.lang.String columnName, java.util.Map map)` Implements JDBC 2.0 ResultSet.getObject (idx, map).
`abstract OPAQUE`	`getOPAQUE(int columnIndex)` Oracle extension.
`OPAQUE`	`getOPAQUE(java.lang.String columnName)` Oracle extension.
`abstract Datum`	`getOracleObject(int columnIndex)` Oracle extension.
`Datum`	`getOracleObject(java.lang.String columnName)` Oracle extension.
`abstract ORAData`	`getORAData(int columnIndex, ORADataFactory factory)` Oracle extension.
`ORAData`	`getORAData(java.lang.String columnName, ORADataFactory factory)` Oracle extension.
`abstract RAW`	`getRAW(int columnIndex)` Oracle extension.
`RAW`	`getRAW(java.lang.String columnName)` Oracle extension.
`abstract java.sql.Ref`	`getRef(int columnIndex)` Implements JDBC 2.0 ResultSet.getRef.
`abstract REF`	`getREF(int columnIndex)` Oracle extension.
`java.sql.Ref`	`getRef(java.lang.String columnName)` Implements JDBC 2.0 ResultSet.getRef.
`REF`	`getREF(java.lang.String columnName)` / Oracle extension.
`abstract int`	`getRow()` Implements JDBC 2.0 ResultSet.getRow.
`abstract ROWID`	`getROWID(int columnIndex)` Oracle extension.
`ROWID`	`getROWID(java.lang.String columnName)` Oracle extension.
`abstract short`	`getShort(int columnIndex)` Implements JDBC 1.0 ResultSet.getShort.
`short`	`getShort(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getShort.
`abstract java.sql.Statement`	`getStatement()` Implements JDBC 2.0 ResultSet.getStatement.
`abstract java.lang.String`	`getString(int columnIndex)` Implements JDBC 1.0 ResultSet.getString.
`java.lang.String`	`getString(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getString.
`abstract STRUCT`	`getSTRUCT(int columnIndex)` Oracle extension.
`STRUCT`	`getSTRUCT(java.lang.String columnName)` Oracle extension.
`abstract java.sql.Time`	`getTime(int columnIndex)` Implements JDBC 1.0 ResultSet.getTime.
`abstract java.sql.Time`	`getTime(int columnIndex, java.util.Calendar cal)` Implements JDBC 2.0 ResultSet.getTime (idx, calendar).
`java.sql.Time`	`getTime(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getTime.
`java.sql.Time`	`getTime(java.lang.String columnName, java.util.Calendar cal)` Implements JDBC 2.0 ResultSet.getTime (idx, calendar).
`abstract java.sql.Timestamp`	`getTimestamp(int columnIndex)` Implements JDBC 1.0 ResultSet.getTimestamp.
`TIMESTAMP`	`getTIMESTAMP(int columnIndex)` Obtain an oralce.sql.TIMESTAMP value from the ResultSet.
`abstract java.sql.Timestamp`	`getTimestamp(int columnIndex, java.util.Calendar cal)` Implements JDBC 2.0 ResultSet.getTimestamp (idx, calendar).
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getTimestamp.
`TIMESTAMP`	`getTIMESTAMP(java.lang.String columnName)` Obtain an oralce.sql.TIMESTAMP value from the ResultSet.
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName, java.util.Calendar cal)` Implements JDBC 2.0 ResultSet.getTimestamp (idx, calendar).
`TIMESTAMPLTZ`	`getTIMESTAMPLTZ(int columnIndex)` Obtain an oralce.sql.TIMESTAMPLTZ value from the ResultSet.
`TIMESTAMPLTZ`	`getTIMESTAMPLTZ(java.lang.String columnName)` Obtain an oralce.sql.TIMESTAMPLTZ value from the ResultSet.
`TIMESTAMPTZ`	`getTIMESTAMPTZ(int columnIndex)` Obtain an oralce.sql.TIMESTAMPTZ value from the ResultSet.
`TIMESTAMPTZ`	`getTIMESTAMPTZ(java.lang.String columnName)` Obtain an oralce.sql.TIMESTAMPTZ value from the ResultSet.
`abstract int`	`getType()` Implements JDBC 2.0 ResultSet.getType.
`abstract java.io.InputStream`	`getUnicodeStream(int columnIndex)` Implements JDBC 1.0 ResultSet.getUnicodeStream.
`java.io.InputStream`	`getUnicodeStream(java.lang.String columnName)` Implements JDBC 1.0 ResultSet.getUnicodeStream.
`abstract java.net.URL`	`getURL(int columnIndex)` JDBC 3.0 Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.net.URL` object in the Java programming language.
`java.net.URL`	`getURL(java.lang.String columnName)` JDBC 3.0 Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.net.URL` object in the Java programming language.
`abstract java.sql.SQLWarning`	`getWarnings()` Implements JDBC 1.0 ResultSet.getWarnings.
`abstract void`	`insertRow()` Implements JDBC 2.0 ResultSet.insertRow.
`abstract boolean`	`isAfterLast()` Implements JDBC 2.0 ResultSet.isAfterLast.
`abstract boolean`	`isBeforeFirst()` Implements JDBC 2.0 ResultSet.isBeforeFirst.
`abstract boolean`	`isFirst()` Implements JDBC 2.0 ResultSet.isFirst.
`abstract boolean`	`isLast()` Implements JDBC 2.0 ResultSet.isLast.
`abstract boolean`	`last()` Implements JDBC 2.0 ResultSet.last.
`abstract void`	`moveToCurrentRow()` Implements JDBC 2.0 ResultSet.moveToCurrentRow.
`abstract void`	`moveToInsertRow()` Implements JDBC 2.0 ResultSet.moveToInsertRow.
`abstract boolean`	`next()` Implements JDBC 1.0 ResultSet.next.
`abstract boolean`	`previous()` Implements JDBC 2.0 ResultSet.previous.
`abstract void`	`refreshRow()` Implements JDBC 2.0 ResultSet.refreshRow.
`abstract boolean`	`relative(int rows)` Implements JDBC 2.0 ResultSet.relative.
`abstract boolean`	`rowDeleted()` Implements JDBC 2.0 ResultSet.rowDeleted.
`abstract boolean`	`rowInserted()` Implements JDBC 2.0 ResultSet.rowInserted.
`abstract boolean`	`rowUpdated()` Implements JDBC 2.0 ResultSet.rowUpdated.
`abstract void`	`setAutoRefetch(boolean autoRefetch)` Oracle extension.
`abstract void`	`setFetchDirection(int direction)` Implements JDBC 2.0 ResultSet.setFetchDirection.
`abstract void`	`setFetchSize(int rows)` Implements JDBC 2.0 ResultSet.setFetchSize.
`abstract void`	`updateArray(int columnIndex, java.sql.Array x)` Oracle extension.
`abstract void`	`updateARRAY(int columnIndex, ARRAY x)` Oracle extension.
`void`	`updateArray(java.lang.String columnName, java.sql.Array x)` Oracle extension.
`void`	`updateARRAY(java.lang.String columnName, ARRAY x)` Oracle extension.
`abstract void`	`updateAsciiStream(int columnIndex, java.io.InputStream x, int length)` Implements JDBC 2.0 ResultSet.updateAsciiStream.
`void`	`updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)` Implements JDBC 2.0 ResultSet.updateAsciiStream.
`abstract void`	`updateBfile(int columnIndex, BFILE X)` Oracle extension.
`abstract void`	`updateBFILE(int columnIndex, BFILE x)` Oracle extension.
`void`	`updateBfile(java.lang.String columnName, BFILE x)` Oracle extension.
`void`	`updateBFILE(java.lang.String columnName, BFILE x)` Oracle extension.
`abstract void`	`updateBigDecimal(int columnIndex, java.math.BigDecimal x)` Implements JDBC 2.0 ResultSet.updateBigDecimal.
`void`	`updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)` Implements JDBC 2.0 ResultSet.updateBigDecimal.
`abstract void`	`updateBinaryStream(int columnIndex, java.io.InputStream x, int length)` Implements JDBC 2.0 ResultSet.updateBinaryStream.
`void`	`updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)` Implements JDBC 2.0 ResultSet.updateBinaryStream.
`abstract void`	`updateBlob(int columnIndex, java.sql.Blob x)` Oracle extension.
`abstract void`	`updateBLOB(int columnIndex, BLOB x)` Oracle extension.
`void`	`updateBlob(java.lang.String columnName, java.sql.Blob x)` Oracle extension.
`void`	`updateBLOB(java.lang.String columnName, BLOB x)` Oracle extension.
`abstract void`	`updateBoolean(int columnIndex, boolean x)` Implements JDBC 2.0 ResultSet.updateBoolean.
`void`	`updateBoolean(java.lang.String columnName, boolean x)` Implements JDBC 2.0 ResultSet.updateBoolean.
`abstract void`	`updateByte(int columnIndex, byte x)` Implements JDBC 2.0 ResultSet.updateByte.
`void`	`updateByte(java.lang.String columnName, byte x)` Implements JDBC 2.0 ResultSet.updateByte.
`abstract void`	`updateBytes(int columnIndex, byte[] x)` Implements JDBC 2.0 ResultSet.updateBytes.
`void`	`updateBytes(java.lang.String columnName, byte[] x)` Implements JDBC 2.0 ResultSet.updateBytes.
`abstract void`	`updateCHAR(int columnIndex, CHAR x)` Oracle extension.
`void`	`updateCHAR(java.lang.String columnName, CHAR x)` Oracle extension.
`abstract void`	`updateCharacterStream(int columnIndex, java.io.Reader x, int length)` Implements JDBC 2.0 ResultSet.updateCharacterStream.
`void`	`updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length)` Implements JDBC 2.0 ResultSet.updateCharacterStream.
`abstract void`	`updateClob(int columnIndex, java.sql.Clob x)` Oracle extension.
`abstract void`	`updateCLOB(int columnIndex, CLOB x)` Oracle extension.
`void`	`updateClob(java.lang.String columnName, java.sql.Clob x)` Oracle extension.
`void`	`updateCLOB(java.lang.String columnName, CLOB x)` Oracle extension.
`abstract void`	`updateCustomDatum(int columnIndex, CustomDatum x)` Deprecated.
`void`	`updateCustomDatum(java.lang.String columnName, CustomDatum x)` Deprecated.
`abstract void`	`updateDate(int columnIndex, java.sql.Date x)` Implements JDBC 2.0 ResultSet.updateDate.
`abstract void`	`updateDATE(int columnIndex, DATE x)` Oracle extension.
`void`	`updateDate(java.lang.String columnName, java.sql.Date x)` Implements JDBC 2.0 ResultSet.updateDate.
`void`	`updateDATE(java.lang.String columnName, DATE x)` Oracle extension.
`abstract void`	`updateDouble(int columnIndex, double x)` Implements JDBC 2.0 ResultSet.updateDouble.
`void`	`updateDouble(java.lang.String columnName, double x)` Implements JDBC 2.0 ResultSet.updateDouble.
`abstract void`	`updateFloat(int columnIndex, float x)` Implements JDBC 2.0 ResultSet.updateFloat.
`void`	`updateFloat(java.lang.String columnName, float x)` Implements JDBC 2.0 ResultSet.updateFloat.
`abstract void`	`updateInt(int columnIndex, int x)` Implements JDBC 2.0 ResultSet..
`void`	`updateInt(java.lang.String columnName, int x)` Implements JDBC 2.0 ResultSet..
`abstract void`	`updateINTERVALDS(int columnIndex, INTERVALDS x)` Oracle extension.
`abstract void`	`updateINTERVALYM(int columnIndex, INTERVALYM x)` Oracle extension.
`abstract void`	`updateLong(int columnIndex, long x)` Implements JDBC 2.0 ResultSet.updateLong.
`void`	`updateLong(java.lang.String columnName, long x)` Implements JDBC 2.0 ResultSet.updateLong.
`abstract void`	`updateNull(int columnIndex)` Implements JDBC 2.0 ResultSet.updateNull.
`void`	`updateNull(java.lang.String columnName)` Implements JDBC 2.0 ResultSet.updateNull.
`abstract void`	`updateNUMBER(int columnIndex, NUMBER x)` Oracle extension.
`void`	`updateNUMBER(java.lang.String columnName, NUMBER x)` Oracle extension.
`abstract void`	`updateObject(int columnIndex, java.lang.Object x)` Implements JDBC 2.0 ResultSet.updateObject.
`abstract void`	`updateObject(int columnIndex, java.lang.Object x, int scale)` Implements JDBC 2.0 ResultSet.updateObject.
`void`	`updateObject(java.lang.String columnName, java.lang.Object x)` Implements JDBC 2.0 ResultSet.updateObject.
`void`	`updateObject(java.lang.String columnName, java.lang.Object x, int scale)` Implements JDBC 2.0 ResultSet.updateObject.
`abstract void`	`updateOPAQUE(int columnIndex, OPAQUE x)` Oracle extension.
`void`	`updateOPAQUE(java.lang.String columnName, OPAQUE x)` Oracle extension.
`abstract void`	`updateOracleObject(int columnIndex, Datum x)` Oracle extension.
`void`	`updateOracleObject(java.lang.String columnName, Datum x)` Oracle extension.
`abstract void`	`updateORAData(int columnIndex, ORAData x)` Oracle extension.
`void`	`updateORAData(java.lang.String columnName, ORAData x)` Oracle extension.
`abstract void`	`updateRAW(int columnIndex, RAW x)` Oracle extension.
`void`	`updateRAW(java.lang.String columnName, RAW x)` Oracle extension.
`abstract void`	`updateRef(int columnIndex, java.sql.Ref x)` Oracle extension.
`abstract void`	`updateREF(int columnIndex, REF x)` Oracle extension.
`void`	`updateRef(java.lang.String columnName, java.sql.Ref x)` Oracle extension.
`void`	`updateREF(java.lang.String columnName, REF x)` Oracle extension.
`abstract void`	`updateRow()` Implements JDBC 2.0 ResultSet.updateRow.
`abstract void`	`updateROWID(int columnIndex, ROWID x)` Oracle extension.
`void`	`updateROWID(java.lang.String columnName, ROWID x)` Oracle extension.
`abstract void`	`updateShort(int columnIndex, short x)` Implements JDBC 2.0 ResultSet.updateShort.
`void`	`updateShort(java.lang.String columnName, short x)` Implements JDBC 2.0 ResultSet.updateShort.
`abstract void`	`updateString(int columnIndex, java.lang.String x)` Implements JDBC 2.0 ResultSet.updateString.
`void`	`updateString(java.lang.String columnName, java.lang.String x)` Implements JDBC 2.0 ResultSet.updateString.
`abstract void`	`updateSTRUCT(int columnIndex, STRUCT x)` Oracle extension.
`void`	`updateSTRUCT(java.lang.String columnName, STRUCT x)` Oracle extension.
`abstract void`	`updateTime(int columnIndex, java.sql.Time x)` Implements JDBC 2.0 ResultSet.updateTime.
`void`	`updateTime(java.lang.String columnName, java.sql.Time x)` Implements JDBC 2.0 ResultSet.updateTime.
`abstract void`	`updateTimestamp(int columnIndex, java.sql.Timestamp x)` Implements JDBC 2.0 ResultSet.updateTimestamp.
`abstract void`	`updateTIMESTAMP(int columnIndex, TIMESTAMP x)` Oracle extension.
`void`	`updateTimestamp(java.lang.String columnName, java.sql.Timestamp x)` Implements JDBC 2.0 ResultSet.updateTimestamp.
`abstract void`	`updateTIMESTAMPLTZ(int columnIndex, TIMESTAMPLTZ x)` Oracle extension.
`abstract void`	`updateTIMESTAMPTZ(int columnIndex, TIMESTAMPTZ x)` Oracle extension.
`abstract boolean`	`wasNull()` Implements JDBC 1.0 ResultSet.wasNull.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

FETCH_FORWARD

public static final int FETCH_FORWARD

See Also:: Constant Field Values

FETCH_REVERSE

public static final int FETCH_REVERSE

See Also:: Constant Field Values

FETCH_UNKNOWN

public static final int FETCH_UNKNOWN

See Also:: Constant Field Values

TYPE_FORWARD_ONLY

public static final int TYPE_FORWARD_ONLY

See Also:: Constant Field Values

TYPE_SCROLL_INSENSITIVE

public static final int TYPE_SCROLL_INSENSITIVE

See Also:: Constant Field Values

TYPE_SCROLL_SENSITIVE

public static final int TYPE_SCROLL_SENSITIVE

See Also:: Constant Field Values

CONCUR_READ_ONLY

public static final int CONCUR_READ_ONLY

See Also:: Constant Field Values

CONCUR_UPDATABLE

public static final int CONCUR_UPDATABLE

See Also:: Constant Field Values

TRACE

public static final boolean TRACE

See Also:: Constant Field Values

PRIVATE_TRACE

public static final boolean PRIVATE_TRACE

See Also:: Constant Field Values

BUILD_DATE

public static final java.lang.String BUILD_DATE

See Also:: Constant Field Values

Constructor Detail

OracleResultSet

public OracleResultSet()

Method Detail

getCursor

public abstract java.sql.ResultSet getCursor(int columnIndex)
                                      throws java.sql.SQLException

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

Specified by:: getCursor in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the REFCURSOR column value as a ResultSet
Throws:: java.sql.SQLException - if a database access error occurs

getOracleObject

public abstract Datum getOracleObject(int columnIndex)
                               throws java.sql.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.

Specified by:: getOracleObject in interface OracleResultSet

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:: java.sql.SQLException - if a database access error occurs.

getROWID

public abstract ROWID getROWID(int columnIndex)
                        throws java.sql.SQLException

Oracle extension. Get the ROWID column value as ROWID.

Specified by:: getROWID in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the ROWID column value as an oracle.sql.ROWID
Throws:: java.sql.SQLException - if a database access error occurs.

getNUMBER

public abstract NUMBER getNUMBER(int columnIndex)
                          throws java.sql.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.

Specified by:: getNUMBER in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.NUMBER
Throws:: java.sql.SQLException - if a database access error occurs.

getDATE

public abstract DATE getDATE(int columnIndex)
                      throws java.sql.SQLException

Oracle extension. Get the column value as a DATE.

Specified by:: getDATE in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.DATE
Throws:: java.sql.SQLException - if a database access error occurs.

getARRAY

public abstract ARRAY getARRAY(int columnIndex)
                        throws java.sql.SQLException

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

Specified by:: getARRAY in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.ARRAY
Throws:: java.sql.SQLException - if a database access error occurs.

getSTRUCT

public abstract STRUCT getSTRUCT(int columnIndex)
                          throws java.sql.SQLException

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

Specified by:: getSTRUCT in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.STRUCT
Throws:: java.sql.SQLException - if a database access error occurs.
See Also:: getORAData

getOPAQUE

public abstract OPAQUE getOPAQUE(int columnIndex)
                          throws java.sql.SQLException

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

Specified by:: getOPAQUE in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.OPAQUE
Throws:: java.sql.SQLException - if a database access error occurs.
Since:: 8,2
See Also:: getORAData

getREF

public abstract REF getREF(int columnIndex)
                    throws java.sql.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.

Specified by:: getREF in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.REF
Throws:: java.sql.SQLException - if a database access error occurs.

getCHAR

public abstract CHAR getCHAR(int columnIndex)
                      throws java.sql.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.

Specified by:: getCHAR in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.CHAR
Throws:: java.sql.SQLException - if a database access error occurs.

getRAW

public abstract RAW getRAW(int columnIndex)
                    throws java.sql.SQLException

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

Specified by:: getRAW in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.RAW
Throws:: java.sql.SQLException - if a database access error occurs.

getBLOB

public abstract BLOB getBLOB(int columnIndex)
                      throws java.sql.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.

Specified by:: getBLOB in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.BLOB
Throws:: java.sql.SQLException - if a database access error occurs.

getCLOB

public abstract CLOB getCLOB(int columnIndex)
                      throws java.sql.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.

Specified by:: getCLOB in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.CLOB
Throws:: java.sql.SQLException - if a database access error occurs.

getBFILE

public abstract BFILE getBFILE(int columnIndex)
                        throws java.sql.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.

Specified by:: getBFILE in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.BFILE
Throws:: java.sql.SQLException - if a database access error occurs.

getBfile

public abstract BFILE getBfile(int columnIndex)
                        throws java.sql.SQLException

Specified by:: getBfile in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value as an oracle.sql.BFILE
Throws:: java.sql.SQLException - if a database access error occurs.

getCustomDatum

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

Deprecated.

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

Specified by:: getCustomDatum in interface OracleResultSet

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:: java.sql.SQLException - if a database access error occurs.

getORAData

public abstract ORAData getORAData(int columnIndex,
                                   ORADataFactory factory)
                            throws java.sql.SQLException

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

Specified by:: getORAData in interface OracleResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; factory - ORADataFactory used to materialize the column value
Returns:: the column value as an ORAData; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database access error occurs.

getCursor

public java.sql.ResultSet getCursor(java.lang.String columnName)
                             throws java.sql.SQLException

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

Specified by:: getCursor in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the REFCURSOR column value as a ResultSet
Throws:: java.sql.SQLException - if a database access error occurs

getROWID

public ROWID getROWID(java.lang.String columnName)
               throws java.sql.SQLException

Oracle extension. Get the ROWID column value as ROWID.

Specified by:: getROWID in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the ROWID column value as an oracle.sql.ROWID
Throws:: java.sql.SQLException - if a database access error occurs.

getNUMBER

public NUMBER getNUMBER(java.lang.String columnName)
                 throws java.sql.SQLException

Specified by:: getNUMBER in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.NUMBER
Throws:: java.sql.SQLException - if a database access error occurs.

getDATE

public DATE getDATE(java.lang.String columnName)
             throws java.sql.SQLException

Oracle extension. Get the column value as a DATE.

Specified by:: getDATE in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.DATE
Throws:: java.sql.SQLException - if a database access error occurs.

getOracleObject

public Datum getOracleObject(java.lang.String columnName)
                      throws java.sql.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.

Specified by:: getOracleObject in interface OracleResultSet

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:: java.sql.SQLException - if a database access error occurs.

getARRAY

public ARRAY getARRAY(java.lang.String columnName)
               throws java.sql.SQLException

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

Specified by:: getARRAY in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.ARRAY
Throws:: java.sql.SQLException - if a database access error occurs.

getSTRUCT

public STRUCT getSTRUCT(java.lang.String columnName)
                 throws java.sql.SQLException

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

Specified by:: getSTRUCT in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.STRUCT
Throws:: java.sql.SQLException - if a database access error occurs.
See Also:: getORAData

getOPAQUE

public OPAQUE getOPAQUE(java.lang.String columnName)
                 throws java.sql.SQLException

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

Specified by:: getOPAQUE in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.OPAQUE
Throws:: java.sql.SQLException - if a database access error occurs.
Since:: 8.2
See Also:: getORAData

getREF

public REF getREF(java.lang.String columnName)
           throws java.sql.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.

Specified by:: getREF in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.REF
Throws:: java.sql.SQLException - if a database acc

getCHAR

public CHAR getCHAR(java.lang.String columnName)
             throws java.sql.SQLException

Specified by:: getCHAR in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.CHAR
Throws:: java.sql.SQLException - if a database access error occurs.

getRAW

public RAW getRAW(java.lang.String columnName)
           throws java.sql.SQLException

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

Specified by:: getRAW in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.RAW
Throws:: java.sql.SQLException - if a database access error occurs.

getBLOB

public BLOB getBLOB(java.lang.String columnName)
             throws java.sql.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.

Specified by:: getBLOB in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.BLOB
Throws:: java.sql.SQLException - if a database access error occurs.

getCLOB

public CLOB getCLOB(java.lang.String columnName)
             throws java.sql.SQLException

Specified by:: getCLOB in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.CLOB
Throws:: java.sql.SQLException - if a database access error occurs.

getBFILE

public BFILE getBFILE(java.lang.String columnName)
               throws java.sql.SQLException

Specified by:: getBFILE in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.BFILE
Throws:: java.sql.SQLException - if a database access error occurs.

getBfile

public BFILE getBfile(java.lang.String columnName)
               throws java.sql.SQLException

Specified by:: getBfile in interface OracleResultSet

Parameters:: columnName - the name of the column
Returns:: the column value as an oracle.sql.BFILE
Throws:: java.sql.SQLException - if a database access error occurs.

getCustomDatum

public CustomDatum getCustomDatum(java.lang.String columnName,
                                  CustomDatumFactory factory)
                           throws java.sql.SQLException

Deprecated.

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

This method is deprecated. It is recommended to use getORAData().

Specified by:: getCustomDatum in interface OracleResultSet

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:: java.sql.SQLException - if a database access error occurs.

getORAData

public ORAData getORAData(java.lang.String columnName,
                          ORADataFactory factory)
                   throws java.sql.SQLException

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

Specified by:: getORAData in interface OracleResultSet

Parameters:: columnName - the name of the column; factory - ORADataFactory used to materialize the column value
Returns:: the column value as a ORAData; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database access error occurs.

updateOracleObject

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

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

Specified by:: updateOracleObject in interface OracleResultSet

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

updateROWID

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

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

Specified by:: updateROWID in interface OracleResultSet

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

updateNUMBER

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

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

Specified by:: updateNUMBER in interface OracleResultSet

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

updateDATE

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

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

Specified by:: updateDATE in interface OracleResultSet

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

updateINTERVALYM

public abstract void updateINTERVALYM(int columnIndex,
                                      INTERVALYM x)
                               throws java.sql.SQLException

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

Specified by:: updateINTERVALYM in interface OracleResultSet

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

updateINTERVALDS

public abstract void updateINTERVALDS(int columnIndex,
                                      INTERVALDS x)
                               throws java.sql.SQLException

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

Specified by:: updateINTERVALDS in interface OracleResultSet

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

updateTIMESTAMP

public abstract void updateTIMESTAMP(int columnIndex,
                                     TIMESTAMP x)
                              throws java.sql.SQLException

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

Specified by:: updateTIMESTAMP in interface OracleResultSet

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

updateTIMESTAMPTZ

public abstract void updateTIMESTAMPTZ(int columnIndex,
                                       TIMESTAMPTZ x)
                                throws java.sql.SQLException

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

Specified by:: updateTIMESTAMPTZ in interface OracleResultSet

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

updateTIMESTAMPLTZ

public abstract void updateTIMESTAMPLTZ(int columnIndex,
                                        TIMESTAMPLTZ x)
                                 throws java.sql.SQLException

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

Specified by:: updateTIMESTAMPLTZ in interface OracleResultSet

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

updateARRAY

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

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

Specified by:: updateARRAY in interface OracleResultSet

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

updateSTRUCT

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

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

Specified by:: updateSTRUCT in interface OracleResultSet

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

updateOPAQUE

public abstract void updateOPAQUE(int columnIndex,
                                  OPAQUE x)
                           throws java.sql.SQLException

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

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

updateREF

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

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

Specified by:: updateREF in interface OracleResultSet

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

updateCHAR

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

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

Specified by:: updateCHAR in interface OracleResultSet

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

updateRAW

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

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

Specified by:: updateRAW in interface OracleResultSet

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

updateBLOB

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

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

Specified by:: updateBLOB in interface OracleResultSet

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

updateCLOB

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

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

Specified by:: updateCLOB in interface OracleResultSet

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

updateBFILE

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

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

Specified by:: updateBFILE in interface OracleResultSet

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

updateBfile

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

Oracle extension. Updates a column with an Bfile value.

Specified by:: updateBfile in interface OracleResultSet

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

updateCustomDatum

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

Deprecated.

Oracle extension. Updates a column with an CustomDatum value.

Specified by:: updateCustomDatum in interface OracleResultSet

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

updateORAData

public abstract void updateORAData(int columnIndex,
                                   ORAData x)
                            throws java.sql.SQLException

Oracle extension. Updates a column with an ORAData value.

Specified by:: updateORAData in interface OracleResultSet

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

updateRef

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

Oracle extension. Updates a column with an Ref value.

Specified by:: updateRef in interface java.sql.ResultSet

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

updateBlob

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

Oracle extension. Updates a column with an Blob value.

Specified by:: updateBlob in interface java.sql.ResultSet

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

updateClob

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

Oracle extension. Updates a column with an Clob value.

Specified by:: updateClob in interface java.sql.ResultSet

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

updateArray

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

Oracle extension. Updates a column with an Array value.

Specified by:: updateArray in interface java.sql.ResultSet

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

updateROWID

public void updateROWID(java.lang.String columnName,
                        ROWID x)
                 throws java.sql.SQLException

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

Specified by:: updateROWID in interface OracleResultSet

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

updateNUMBER

public void updateNUMBER(java.lang.String columnName,
                         NUMBER x)
                  throws java.sql.SQLException

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

Specified by:: updateNUMBER in interface OracleResultSet

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

updateDATE

public void updateDATE(java.lang.String columnName,
                       DATE x)
                throws java.sql.SQLException

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

Specified by:: updateDATE in interface OracleResultSet

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

updateOracleObject

public void updateOracleObject(java.lang.String columnName,
                               Datum x)
                        throws java.sql.SQLException

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

Specified by:: updateOracleObject in interface OracleResultSet

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

updateARRAY

public void updateARRAY(java.lang.String columnName,
                        ARRAY x)
                 throws java.sql.SQLException

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

Specified by:: updateARRAY in interface OracleResultSet

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

updateSTRUCT

public void updateSTRUCT(java.lang.String columnName,
                         STRUCT x)
                  throws java.sql.SQLException

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

Specified by:: updateSTRUCT in interface OracleResultSet

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

updateOPAQUE

public void updateOPAQUE(java.lang.String columnName,
                         OPAQUE x)
                  throws java.sql.SQLException

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

Parameters:: columnName - is the SQL name of the column; x - the new column value
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 8.2

updateREF

public void updateREF(java.lang.String columnName,
                      REF x)
               throws java.sql.SQLException

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

Specified by:: updateREF in interface OracleResultSet

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

updateCHAR

public void updateCHAR(java.lang.String columnName,
                       CHAR x)
                throws java.sql.SQLException

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

Specified by:: updateCHAR in interface OracleResultSet

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

updateRAW

public void updateRAW(java.lang.String columnName,
                      RAW x)
               throws java.sql.SQLException

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

Specified by:: updateRAW in interface OracleResultSet

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

updateBLOB

public void updateBLOB(java.lang.String columnName,
                       BLOB x)
                throws java.sql.SQLException

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

Specified by:: updateBLOB in interface OracleResultSet

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

updateCLOB

public void updateCLOB(java.lang.String columnName,
                       CLOB x)
                throws java.sql.SQLException

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

Specified by:: updateCLOB in interface OracleResultSet

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

updateBFILE

public void updateBFILE(java.lang.String columnName,
                        BFILE x)
                 throws java.sql.SQLException

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

Specified by:: updateBFILE in interface OracleResultSet

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

updateBfile

public void updateBfile(java.lang.String columnName,
                        BFILE x)
                 throws java.sql.SQLException

Oracle extension. Updates a column with an BFILE value.

Specified by:: updateBfile in interface OracleResultSet

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

updateCustomDatum

public void updateCustomDatum(java.lang.String columnName,
                              CustomDatum x)
                       throws java.sql.SQLException

Deprecated.

Oracle extension. Updates a column with an CustomDatum value.

Specified by:: updateCustomDatum in interface OracleResultSet

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

updateORAData

public void updateORAData(java.lang.String columnName,
                          ORAData x)
                   throws java.sql.SQLException

Oracle extension. Updates a column with an ORAData value.

Specified by:: updateORAData in interface OracleResultSet

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

updateRef

public void updateRef(java.lang.String columnName,
                      java.sql.Ref x)
               throws java.sql.SQLException

Oracle extension. Updates a column with an Ref value.

Specified by:: updateRef in interface java.sql.ResultSet

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

updateBlob

public void updateBlob(java.lang.String columnName,
                       java.sql.Blob x)
                throws java.sql.SQLException

Oracle extension. Updates a column with an Blob value.

Specified by:: updateBlob in interface java.sql.ResultSet

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

updateClob

public void updateClob(java.lang.String columnName,
                       java.sql.Clob x)
                throws java.sql.SQLException

Oracle extension. Updates a column with an Clob value.

Specified by:: updateClob in interface java.sql.ResultSet

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

updateArray

public void updateArray(java.lang.String columnName,
                        java.sql.Array x)
                 throws java.sql.SQLException

Oracle extension. Updates a column with an Array value.

Specified by:: updateArray in interface java.sql.ResultSet

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

setAutoRefetch

public abstract void setAutoRefetch(boolean autoRefetch)
                             throws java.sql.SQLException

Oracle extension. Set this ResultSet's auto-refetch mode. If a ResultSet is in auto-refetch mode, then it automatically refetches the column values during updateRow(). Otherwise, the column values in the ResultSet are the same as the value from the updateXXX() calls which may not be in sync with the database column values if a database trigger is enabled to modify the column values. Disable auto-refetch improves performance by avoiding one database round-trip druing the updateRow() call. By default, new ResultSet are in auto-refetch mode.

Parameters:: autoRefetch - true enables auto-refetch; false disables auto-refetch.
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 8.1.7

getAutoRefetch

public abstract boolean getAutoRefetch()
                                throws java.sql.SQLException

Oracle extension. Gets the current auto-refetch state.

Returns:: the current state of auot-refetch mode
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 8.1.7
See Also:: setAutoRefetch(boolean)

getWarnings

public abstract java.sql.SQLWarning getWarnings()
                                         throws java.sql.SQLException

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

Specified by:: getWarnings in interface java.sql.ResultSet

Returns:: null
Throws:: java.sql.SQLException - if a database-access error occurs.

clearWarnings

public abstract void clearWarnings()
                            throws java.sql.SQLException

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

Specified by:: clearWarnings in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database-access error occurs.

getCursorName

public abstract java.lang.String getCursorName()
                                        throws java.sql.SQLException

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

Specified by:: getCursorName in interface java.sql.ResultSet

Returns:: never returns
Throws:: java.sql.SQLException - always

getMetaData

public abstract java.sql.ResultSetMetaData getMetaData()
                                                throws java.sql.SQLException

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

Specified by:: getMetaData in interface java.sql.ResultSet

Returns:: the description of a ResultSet's columns
Throws:: java.sql.SQLException - if a database-access error occurs.

findColumn

public abstract int findColumn(java.lang.String columnName)
                        throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.findColumn.

Specified by:: findColumn in interface java.sql.ResultSet

Parameters:: columnName - the name of the column
Returns:: the column index
Throws:: java.sql.SQLException - if a database-access error occurs.

public abstract boolean next()
                      throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.next.

Specified by:: next in interface java.sql.ResultSet

Returns:: true if the new current row is valid; false if there are no more rows
Throws:: java.sql.SQLException - if a database-access error occurs.

close

public abstract void close()
                    throws java.sql.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.

Specified by:: close in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database-access error occurs.

wasNull

public abstract boolean wasNull()
                         throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.wasNull.

Specified by:: wasNull in interface java.sql.ResultSet

Returns:: true if last column read was SQL NULL
Throws:: java.sql.SQLException - if a database-access error occurs.

getObject

public abstract java.lang.Object getObject(int columnIndex)
                                    throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getObject.

Specified by:: getObject in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: A java.lang.Object holding the column value.
Throws:: java.sql.SQLException - if a database-access error occurs.

getString

public abstract java.lang.String getString(int columnIndex)
                                    throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getString.

Specified by:: getString in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getBoolean

public abstract boolean getBoolean(int columnIndex)
                            throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getBoolean.

Specified by:: getBoolean in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getByte

public abstract byte getByte(int columnIndex)
                      throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getByte.

Specified by:: getByte in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getShort

public abstract short getShort(int columnIndex)
                        throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getShort.

Specified by:: getShort in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getInt

public abstract int getInt(int columnIndex)
                    throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getInt.

Specified by:: getInt in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getLong

public abstract long getLong(int columnIndex)
                      throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getLong.

Specified by:: getLong in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getFloat

public abstract float getFloat(int columnIndex)
                        throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getFloat.

Specified by:: getFloat in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getDouble

public abstract double getDouble(int columnIndex)
                          throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getDouble.

Specified by:: getDouble in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getBigDecimal

public abstract java.math.BigDecimal getBigDecimal(int columnIndex,
                                                   int scale)
                                            throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getBigDecimal.

Specified by:: getBigDecimal in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getBytes

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

Implements JDBC 1.0 ResultSet.getBytes.

Specified by:: getBytes in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getDate

public abstract java.sql.Date getDate(int columnIndex)
                               throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getDate.

Specified by:: getDate in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getTime

public abstract java.sql.Time getTime(int columnIndex)
                               throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getTime.

Specified by:: getTime in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getTimestamp

public abstract java.sql.Timestamp getTimestamp(int columnIndex)
                                         throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getTimestamp.

Specified by:: getTimestamp in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getAsciiStream

public abstract java.io.InputStream getAsciiStream(int columnIndex)
                                            throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getAsciiStream.

Specified by:: getAsciiStream in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getUnicodeStream

public abstract java.io.InputStream getUnicodeStream(int columnIndex)
                                              throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getUnicodeStream.

Specified by:: getUnicodeStream in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getBinaryStream

public abstract java.io.InputStream getBinaryStream(int columnIndex)
                                             throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getBinaryStream.

Specified by:: getBinaryStream in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getObject

public java.lang.Object getObject(java.lang.String columnName)
                           throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getObject.

Specified by:: getObject in interface java.sql.ResultSet

Returns:: A java.lang.Object holding the column value.
Throws:: java.sql.SQLException - if a database-access error occurs.

getString

public java.lang.String getString(java.lang.String columnName)
                           throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getString.

Specified by:: getString in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database-access error occurs.

getBoolean

public boolean getBoolean(java.lang.String columnName)
                   throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getBoolean.

Specified by:: getBoolean in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is false
Throws:: java.sql.SQLException - if a database-access error occurs.

getByte

public byte getByte(java.lang.String columnName)
             throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getByte.

Specified by:: getByte in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a databas

getShort

public short getShort(java.lang.String columnName)
               throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getShort.

Specified by:: getShort in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database-access error occurs.

getInt

public int getInt(java.lang.String columnName)
           throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getInt.

Specified by:: getInt in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database-access error occurs.

getLong

public long getLong(java.lang.String columnName)
             throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getLong.

Specified by:: getLong in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database-access error occurs.

getFloat

public float getFloat(java.lang.String columnName)
               throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getFloat.

Specified by:: getFloat in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database-access error occurs.

getDouble

public double getDouble(java.lang.String columnName)
                 throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getDouble.

Specified by:: getDouble in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQ
Throws:: java.sql.SQLException - if a database-access error occurs.

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                          int scale)
                                   throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getBigDecimal.

Specified by:: getBigDecimal in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getBytes

public byte[] getBytes(java.lang.String columnName)
                throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getBytes.

Specified by:: getBytes in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database-access error occurs.

getDate

public java.sql.Date getDate(java.lang.String columnName)
                      throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getDate.

Specified by:: getDate in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database-access error occurs.

getTime

public java.sql.Time getTime(java.lang.String columnName)
                      throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getTime.

Specified by:: getTime in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database-access error occurs.

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName)
                                throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getTimestamp.

Specified by:: getTimestamp in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database-access error occurs.

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String columnName)
                                   throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getAsciiStream.

Specified by:: getAsciiStream in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database-access error occurs.

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String columnName)
                                     throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getUnicodeStream.

Specified by:: getUnicodeStream in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database-access error occurs.

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String columnName)
                                    throws java.sql.SQLException

Implements JDBC 1.0 ResultSet.getBinaryStream.

Specified by:: getBinaryStream in interface java.sql.ResultSet

Parameters:: columnName - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database-access error occurs.

getObject

public abstract java.lang.Object getObject(int columnIndex,
                                           java.util.Map map)
                                    throws java.sql.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.

Specified by:: getObject in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getRef

public abstract java.sql.Ref getRef(int columnIndex)
                             throws java.sql.SQLException

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

Specified by:: getRef in interface java.sql.ResultSet

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

getBlob

public abstract java.sql.Blob getBlob(int columnIndex)
                               throws java.sql.SQLException

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

Specified by:: getBlob in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getClob

public abstract java.sql.Clob getClob(int columnIndex)
                               throws java.sql.SQLException

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

Specified by:: getClob in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getArray

public abstract java.sql.Array getArray(int columnIndex)
                                 throws java.sql.SQLException

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

Specified by:: getArray in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database-access error occurs.

getCharacterStream

public abstract java.io.Reader getCharacterStream(int columnIndex)
                                           throws java.sql.SQLException

Implements JDBC 2.0 ResultSet.getCharacterStream.

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

Specified by:: getCharacterStream in interface java.sql.ResultSet

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

getBigDecimal

public abstract java.math.BigDecimal getBigDecimal(int columnIndex)
                                            throws java.sql.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.

Specified by:: getBigDecimal in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database access error occurs

getDate

public abstract java.sql.Date getDate(int columnIndex,
                                      java.util.Calendar cal)
                               throws java.sql.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.

Specified by:: getDate in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database access error occurs

getTime

public abstract java.sql.Time getTime(int columnIndex,
                                      java.util.Calendar cal)
                               throws java.sql.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.

Specified by:: getTime in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database access error occurs

getTimestamp

public abstract java.sql.Timestamp getTimestamp(int columnIndex,
                                                java.util.Calendar cal)
                                         throws java.sql.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.

Specified by:: getTimestamp in interface java.sql.ResultSet

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:: java.sql.SQLException - if a database access error occurs