: Class OracleResultSet

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: INNER | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

oracle.jdbc.driver
Class OracleResultSet

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

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

Field Summary
`static int`	`CONCUR_READ_ONLY`
`static int`	`CONCUR_UPDATABLE`
`static int`	`FETCH_FORWARD`
`static int`	`FETCH_REVERSE`
`static int`	`FETCH_UNKNOWN`
`static int`	`TYPE_FORWARD_ONLY`
`static int`	`TYPE_SCROLL_INSENSITIVE`
`static int`	`TYPE_SCROLL_SENSITIVE`

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 oracle.jdbc2.Array`	`getArray(int columnIndex)` Implements JDBC 2.0 ResultSet.getArray.
`abstract ARRAY`	`getARRAY(int columnIndex)` Oracle extension.
`oracle.jdbc2.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 oracle.jdbc2.Blob`	`getBlob(int columnIndex)` Implements JDBC 2.0 ResultSet.getBlob.
`abstract BLOB`	`getBLOB(int columnIndex)` Oracle extension.
`oracle.jdbc2.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 oracle.jdbc2.Clob`	`getClob(int columnIndex)` Implements JDBC 2.0 ResultSet.
`abstract CLOB`	`getCLOB(int columnIndex)` Oracle extension.
`oracle.jdbc2.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)` Oracle extension.
`CustomDatum`	`getCustomDatum(java.lang.String columnName, CustomDatumFactory factory)` Oracle extension.
`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.
`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.Dictionary 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.Dictionary map)` Implements JDBC 2.0 ResultSet.getObject (idx, map).
`abstract Datum`	`getOracleObject(int columnIndex)` Oracle extension.
`Datum`	`getOracleObject(java.lang.String columnName)` Oracle extension.
`abstract RAW`	`getRAW(int columnIndex)` Oracle extension.
`RAW`	`getRAW(java.lang.String columnName)` Oracle extension.
`abstract oracle.jdbc2.Ref`	`getRef(int columnIndex)` Implements JDBC 2.0 ResultSet.getRef.
`abstract REF`	`getREF(int columnIndex)` Oracle extension.
`oracle.jdbc2.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.
`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.
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName, java.util.Calendar cal)` Implements JDBC 2.0 ResultSet.getTimestamp (idx, calendar).
`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.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, oracle.jdbc2.Array x)` Oracle extension.
`abstract void`	`updateARRAY(int columnIndex, ARRAY x)` Oracle extension.
`void`	`updateArray(java.lang.String columnName, oracle.jdbc2.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, oracle.jdbc2.Blob x)` Oracle extension.
`abstract void`	`updateBLOB(int columnIndex, BLOB x)` Oracle extension.
`void`	`updateBlob(java.lang.String columnName, oracle.jdbc2.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, oracle.jdbc2.Clob x)` Oracle extension.
`abstract void`	`updateCLOB(int columnIndex, CLOB x)` Oracle extension.
`void`	`updateClob(java.lang.String columnName, oracle.jdbc2.Clob x)` Oracle extension.
`void`	`updateCLOB(java.lang.String columnName, CLOB x)` Oracle extension.
`abstract void`	`updateCustomDatum(int columnIndex, CustomDatum x)` Oracle extension.
`void`	`updateCustomDatum(java.lang.String columnName, CustomDatum x)` Oracle extension.
`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`	`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`	`updateOracleObject(int columnIndex, Datum x)` Oracle extension.
`void`	`updateOracleObject(java.lang.String columnName, Datum 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, oracle.jdbc2.Ref x)` Oracle extension.
`abstract void`	`updateREF(int columnIndex, REF x)` Oracle extension.
`void`	`updateRef(java.lang.String columnName, oracle.jdbc2.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.
`void`	`updateTimestamp(java.lang.String columnName, java.sql.Timestamp x)` Implements JDBC 2.0 ResultSet.updateTimestamp.
`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

FETCH_REVERSE

public static final int FETCH_REVERSE

FETCH_UNKNOWN

public static final int FETCH_UNKNOWN

TYPE_FORWARD_ONLY

public static final int TYPE_FORWARD_ONLY

TYPE_SCROLL_INSENSITIVE

public static final int TYPE_SCROLL_INSENSITIVE

TYPE_SCROLL_SENSITIVE

public static final int TYPE_SCROLL_SENSITIVE

CONCUR_READ_ONLY

public static final int CONCUR_READ_ONLY

CONCUR_UPDATABLE

public static final int CONCUR_UPDATABLE

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.

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.

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.

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.

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.

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.

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.

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:: getCustomDatum

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.

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.

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.

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.

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.

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.

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

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

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

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.

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

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.

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.

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.

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.

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:: getCustomDatum

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.

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

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.

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.

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

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

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

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

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

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.

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.

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.

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.

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.

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,
                               REF x)
                        throws java.sql.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:: 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.

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.

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.

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.

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.

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.

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

updateCustomDatum

public abstract void updateCustomDatum(int columnIndex,
                                       CustomDatum x)
                                throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateRef

public abstract void updateRef(int columnIndex,
                               oracle.jdbc2.Ref x)
                        throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateBlob

public abstract void updateBlob(int columnIndex,
                                oracle.jdbc2.Blob x)
                         throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateClob

public abstract void updateClob(int columnIndex,
                                oracle.jdbc2.Clob x)
                         throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateArray

public abstract void updateArray(int columnIndex,
                                 oracle.jdbc2.Array x)
                          throws java.sql.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:: 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.

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.

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.

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.

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.

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.

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,
                      REF x)
               throws java.sql.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:: 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.

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.

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.

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.

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.

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.

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

Oracle extension. Updates a column with an CustomDatum 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

updateRef

public void updateRef(java.lang.String columnName,
                      oracle.jdbc2.Ref x)
               throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateBlob

public void updateBlob(java.lang.String columnName,
                       oracle.jdbc2.Blob x)
                throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateClob

public void updateClob(java.lang.String columnName,
                       oracle.jdbc2.Clob x)
                throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateArray

public void updateArray(java.lang.String columnName,
                        oracle.jdbc2.Array x)
                 throws java.sql.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:: 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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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 java.lang.String getString(java.lang.String columnName)
                           throws java.sql.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:: 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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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 oracle.jdbc2.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.

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 oracle.jdbc2.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.

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 oracle.jdbc2.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.

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 oracle.jdbc2.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.

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.

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.

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.

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.

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.

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

getObject

public java.lang.Object getObject(java.lang.String columnName,
                                  java.util.Dictionary map)
                           throws java.sql.SQLException

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

getRef

public oracle.jdbc2.Ref getRef(java.lang.String columnName)
                        throws java.sql.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:: java.sql.SQLException - if a database-access error occurs.

getBlob

public oracle.jdbc2.Blob getBlob(java.lang.String columnName)
                          throws java.sql.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:: java.sql.SQLException - if a database-access error occurs.

getClob

public oracle.jdbc2.Clob getClob(java.lang.String columnName)
                          throws java.sql.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:: java.sql.SQLException - if a database-access error occurs.

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String columnName)
                                  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.

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

getArray

public oracle.jdbc2.Array getArray(java.lang.String columnName)
                            throws java.sql.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:: java.sql.SQLException - if a database-access error occurs.

getBigDecimal

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

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

getDate

public java.sql.Date getDate(java.lang.String columnName,
                             java.util.Calendar cal)
                      throws java.sql.SQLException

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

getTime

public java.sql.Time getTime(java.lang.String columnName,
                             java.util.Calendar cal)
                      throws java.sql.SQLException

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

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException

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

isBeforeFirst

public abstract boolean isBeforeFirst()
                               throws java.sql.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:: java.sql.SQLException - if a database access error occurs

isAfterLast

public abstract boolean isAfterLast()
                             throws java.sql.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:: java.sql.SQLException - if a database access error occurs

isFirst

public abstract boolean isFirst()
                         throws java.sql.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:: java.sql.SQLException - if a database access error occurs

isLast

public abstract boolean isLast()
                        throws java.sql.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:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY

beforeFirst

public abstract void beforeFirst()
                          throws java.sql.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:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY

afterLast

public abstract void afterLast()
                        throws java.sql.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:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY

first

public abstract boolean first()
                       throws java.sql.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:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY

last

public abstract boolean last()
                      throws java.sql.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:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY.

getRow

public abstract int getRow()
                    throws java.sql.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:: java.sql.SQLException - if a database access error occurs

absolute

public abstract boolean absolute(int row)
                          throws java.sql.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:: java.sql.SQLException - if a database access error occurs or row is 0, or result set type is TYPE_FORWARD_ONLY.

relative

public abstract boolean relative(int rows)
                          throws java.sql.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:: java.sql.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 java.sql.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:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY

setFetchDirection

public abstract void setFetchDirection(int direction)
                                throws java.sql.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:: java.sql.SQLException - if a database access error occurs

getFetchDirection

public abstract int getFetchDirection()
                               throws java.sql.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:: java.sql.SQLException - if a database access error occurs

setFetchSize

public abstract void setFetchSize(int rows)
                           throws java.sql.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:: java.sql.SQLException - if a database access error occurs or the condition 0 <= rows <= this.getMaxRows() is not satisfied.

getFetchSize

public abstract int getFetchSize()
                          throws java.sql.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:: java.sql.SQLException - if a database access error occurs

getType

public abstract int getType()
                     throws java.sql.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:: java.sql.SQLException - if a database access error occurs

getConcurrency

public abstract int getConcurrency()
                            throws java.sql.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:: java.sql.SQLException - if a database access error occurs

insertRow

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

updateRow

public abstract void updateRow()
                        throws java.sql.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:: java.sql.SQLException - if a database access error occurs or if called when on the insert row

deleteRow

public abstract void deleteRow()
                        throws java.sql.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:: java.sql.SQLException - if a database access error occurs or if called when on the insert row.

refreshRow

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

moveToInsertRow

public abstract void moveToInsertRow()
                              throws java.sql.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:: java.sql.SQLException - if a database access error occurs or the result set is not updatable

cancelRowUpdates

public abstract void cancelRowUpdates()
                               throws java.sql.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:: java.sql.SQLException - if a database access error occurs or if called when on the insert row

moveToCurrentRow

public abstract void moveToCurrentRow()
                               throws java.sql.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:: java.sql.SQLException - if a database access error occurs or the result set is not updatable

getStatement

public abstract java.sql.Statement getStatement()
                                         throws java.sql.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:: java.sql.SQLException - if a database access error occurs

rowUpdated

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

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

Returns:: false always

rowInserted

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

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

Returns:: false always

rowDeleted

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

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

Returns:: false always

updateNull

public abstract void updateNull(int columnIndex)
                         throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateBoolean

public abstract void updateBoolean(int columnIndex,
                                   boolean x)
                            throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateByte

public abstract void updateByte(int columnIndex,
                                byte x)
                         throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateShort

public abstract void updateShort(int columnIndex,
                                 short x)
                          throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateInt

public abstract void updateInt(int columnIndex,
                               int x)
                        throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateLong

public abstract void updateLong(int columnIndex,
                                long x)
                         throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateFloat

public abstract void updateFloat(int columnIndex,
                                 float x)
                          throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateDouble

public abstract void updateDouble(int columnIndex,
                                  double x)
                           throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateBigDecimal

public abstract void updateBigDecimal(int columnIndex,
                                      java.math.BigDecimal x)
                               throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateString

public abstract void updateString(int columnIndex,
                                  java.lang.String x)
                           throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateBytes

public abstract void updateBytes(int columnIndex,
                                 byte[] x)
                          throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateDate

public abstract void updateDate(int columnIndex,
                                java.sql.Date x)
                         throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateTime

public abstract void updateTime(int columnIndex,
                                java.sql.Time x)
                         throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateTimestamp

public abstract void updateTimestamp(int columnIndex,
                                     java.sql.Timestamp x)
                              throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateAsciiStream

public abstract void updateAsciiStream(int columnIndex,
                                       java.io.InputStream x,
                                       int length)
                                throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateBinaryStream

public abstract void updateBinaryStream(int columnIndex,
                                        java.io.InputStream x,
                                        int length)
                                 throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateCharacterStream

public abstract void updateCharacterStream(int columnIndex,
                                           java.io.Reader x,
                                           int length)
                                    throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateObject

public abstract void updateObject(int columnIndex,
                                  java.lang.Object x,
                                  int scale)
                           throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateObject

public abstract void updateObject(int columnIndex,
                                  java.lang.Object x)
                           throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateNull

public void updateNull(java.lang.String columnName)
                throws java.sql.SQLException

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

updateBoolean

public void updateBoolean(java.lang.String columnName,
                          boolean x)
                   throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateByte

public void updateByte(java.lang.String columnName,
                       byte x)
                throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateShort

public void updateShort(java.lang.String columnName,
                        short x)
                 throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateInt

public void updateInt(java.lang.String columnName,
                      int x)
               throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateLong

public void updateLong(java.lang.String columnName,
                       long x)
                throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateFloat

public void updateFloat(java.lang.String columnName,
                        float x)
                 throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateDouble

public void updateDouble(java.lang.String columnName,
                         double x)
                  throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateBigDecimal

public void updateBigDecimal(java.lang.String columnName,
                             java.math.BigDecimal x)
                      throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateString

public void updateString(java.lang.String columnName,
                         java.lang.String x)
                  throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateBytes

public void updateBytes(java.lang.String columnName,
                        byte[] x)
                 throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateDate

public void updateDate(java.lang.String columnName,
                       java.sql.Date x)
                throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateTime

public void updateTime(java.lang.String columnName,
                       java.sql.Time x)
                throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateTimestamp

public void updateTimestamp(java.lang.String columnName,
                            java.sql.Timestamp x)
                     throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateAsciiStream

public void updateAsciiStream(java.lang.String columnName,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateBinaryStream

public void updateBinaryStream(java.lang.String columnName,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateCharacterStream

public void updateCharacterStream(java.lang.String columnName,
                                  java.io.Reader reader,
                                  int length)
                           throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object x,
                         int scale)
                  throws java.sql.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:: java.sql.SQLException - if a database access error occurs

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object x)
                  throws java.sql.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:: java.sql.SQLException - if a database access error occurs

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: INNER | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

oracle.jdbc.driver Class OracleResultSet

FETCH_FORWARD

FETCH_REVERSE

FETCH_UNKNOWN

TYPE_FORWARD_ONLY

TYPE_SCROLL_INSENSITIVE

TYPE_SCROLL_SENSITIVE

CONCUR_READ_ONLY

CONCUR_UPDATABLE

OracleResultSet

getCursor

getOracleObject

getROWID

getNUMBER

getDATE

getARRAY

getSTRUCT

getREF

getCHAR

getRAW

getBLOB

getCLOB

getBFILE

getBfile

getCustomDatum

getCURSOR

getROWID

getNUMBER

getDATE

getOracleObject

getARRAY

getSTRUCT

getREF

getCHAR

getRAW

getBLOB

getCLOB

getBFILE

getBfile

getCustomDatum

updateOracleObject

updateROWID

updateNUMBER

updateDATE

updateARRAY

updateSTRUCT

updateREF

updateCHAR

updateRAW

updateBLOB

updateCLOB

updateBFILE

updateBfile

updateCustomDatum

updateRef

updateBlob

updateClob

updateArray

updateROWID

updateNUMBER

updateDATE

updateOracleObject

updateARRAY

updateSTRUCT

updateREF

updateCHAR

updateRAW

updateBLOB

updateCLOB

updateBFILE

updateBfile

updateCustomDatum

updateRef

updateBlob

updateClob

updateArray

setAutoRefetch

getAutoRefetch

getWarnings

clearWarnings

oracle.jdbc.driver
Class OracleResultSet