Oracle10g JDBC

oracle.jdbc.driver
Class OracleResultSet

java.lang.Object
  extended byoracle.jdbc.driver.OracleResultSet
All Implemented Interfaces:
oracle.jdbc.internal.OracleResultSet, OracleResultSet, java.sql.ResultSet

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

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

1. Oracle specific methods.

For example, getter and update methods for Datum types.

2. JDBC 1.2 methods.

3. JDBC 2.0 methods.


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

Field Detail

FETCH_FORWARD

public static final int FETCH_FORWARD
See Also:
Constant Field Values

FETCH_REVERSE

public static final int FETCH_REVERSE
See Also:
Constant Field Values

FETCH_UNKNOWN

public static final int FETCH_UNKNOWN
See Also:
Constant Field Values

TYPE_FORWARD_ONLY

public static final int TYPE_FORWARD_ONLY
See Also:
Constant Field Values

TYPE_SCROLL_INSENSITIVE

public static final int TYPE_SCROLL_INSENSITIVE
See Also:
Constant Field Values

TYPE_SCROLL_SENSITIVE

public static final int TYPE_SCROLL_SENSITIVE
See Also:
Constant Field Values

CONCUR_READ_ONLY

public static final int CONCUR_READ_ONLY
See Also:
Constant Field Values

CONCUR_UPDATABLE

public static final int CONCUR_UPDATABLE
See Also:
Constant Field Values

TRACE

public static final boolean TRACE
See Also:
Constant Field Values

PRIVATE_TRACE

public static final boolean PRIVATE_TRACE
See Also:
Constant Field Values

BUILD_DATE

public static final java.lang.String BUILD_DATE
See Also:
Constant Field Values
Constructor Detail

OracleResultSet

public OracleResultSet()
Method Detail

getCursor

public abstract java.sql.ResultSet getCursor(int columnIndex)
                                      throws java.sql.SQLException
Oracle extension. Get the REFCURSOR value of the column as a ResultSet.

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

getOracleObject

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

Specified by:
getOracleObject in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value as the appropriate oracle.sql. type; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database access error occurs.

getROWID

public abstract ROWID getROWID(int columnIndex)
                        throws java.sql.SQLException
Oracle extension. Get the ROWID column value as ROWID.

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

getNUMBER

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

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

getDATE

public abstract DATE getDATE(int columnIndex)
                      throws java.sql.SQLException
Oracle extension. Get the column value as a DATE.

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

getARRAY

public abstract ARRAY getARRAY(int columnIndex)
                        throws java.sql.SQLException
Oracle extension. Get the column value as a ARRAY. An ARRAY instance maps to a Nested Table or VARRAY value in database.

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

getSTRUCT

public abstract STRUCT getSTRUCT(int columnIndex)
                          throws java.sql.SQLException
Oracle extension. Get the column value as a STRUCT. A STRUCT instance maps to a structured data type instance in database.

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

getOPAQUE

public abstract OPAQUE getOPAQUE(int columnIndex)
                          throws java.sql.SQLException
Oracle extension. Get the column value as a OPAQUE. A OPAQUE instance maps to a opaque data type instance in database.

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

getREF

public abstract REF getREF(int columnIndex)
                    throws java.sql.SQLException
Oracle extension. Get the column value as a REF. A REF instance maps to a REF (to a row or concreated object) value in database.

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

getCHAR

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

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

getRAW

public abstract RAW getRAW(int columnIndex)
                    throws java.sql.SQLException
Oracle extension. Get the column value as a RAW. A RAW instance maps to a RAW or LONG RAW value in database.

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

getBLOB

public abstract BLOB getBLOB(int columnIndex)
                      throws java.sql.SQLException
Oracle extension. Get the column value as a BLOB (unstructured binary data). BLOB data is accessed and referenced by using a locator which is stored in the database table and points to the BLOB data.

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

getCLOB

public abstract CLOB getCLOB(int columnIndex)
                      throws java.sql.SQLException
Oracle extension. Get the column value as a CLOB (single-byte character data). CLOB data is accessed and referenced by using a locator which is stored in the database table and points to the CLOB data.

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

getBFILE

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

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

getBfile

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

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

getCustomDatum

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

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

Specified by:
getCustomDatum in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
factory - CustomDatumFactory used to materialize the column value
Returns:
the column value as a CustomDatum; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database access error occurs.

getORAData

public abstract ORAData getORAData(int columnIndex,
                                   ORADataFactory factory)
                            throws java.sql.SQLException
Oracle extension. Get the column value as an instance of a subclass of ORAData. Which subclass is determined by the factory parameter.

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

getCursor

public java.sql.ResultSet getCursor(java.lang.String columnName)
                             throws java.sql.SQLException
Oracle extension. Get the REFCURSOR value of the column as a ResultSet.

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

getROWID

public ROWID getROWID(java.lang.String columnName)
               throws java.sql.SQLException
Oracle extension. Get the ROWID column value as ROWID.

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

getNUMBER

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

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

getDATE

public DATE getDATE(java.lang.String columnName)
             throws java.sql.SQLException
Oracle extension. Get the column value as a DATE.

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

getOracleObject

public Datum getOracleObject(java.lang.String columnName)
                      throws java.sql.SQLException
Oracle extension. Get the column value as the appropriate oracle.sql. type. This differs from getObject in that getObject returns the appropriate jdbc.sql. type. The Oracle specific types in oracle.sql more closely model the underlying Oracle database types possible loss of information due to conversion and slightly greater efficiency.

Specified by:
getOracleObject in interface OracleResultSet
Parameters:
columnName - the name of the column
Returns:
the column value as the appropriate oracle.sql. type; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database access error occurs.

getARRAY

public ARRAY getARRAY(java.lang.String columnName)
               throws java.sql.SQLException
Oracle extension. Get the column value as a ARRAY. An ARRAY instance maps to a Nested Table or VARRAY value in database.

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

getSTRUCT

public STRUCT getSTRUCT(java.lang.String columnName)
                 throws java.sql.SQLException
Oracle extension. Get the column value as a STRUCT. A STRUCT instance maps to a structured data type instance in database.

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

getOPAQUE

public OPAQUE getOPAQUE(java.lang.String columnName)
                 throws java.sql.SQLException
Oracle extension. Get the column value as a OPAQUE. A OPAQUE instance maps to a opaque data type instance in database.

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

getREF

public REF getREF(java.lang.String columnName)
           throws java.sql.SQLException
/ Oracle extension. Get the column value as a REF. A REF instance maps to a REF (to a row or concreated object) value in database.

Specified by:
getREF in interface OracleResultSet
Parameters:
columnName - the name of the column
Returns:
the column value as an oracle.sql.REF
Throws:
java.sql.SQLException - if a database acc

getCHAR

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

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

getRAW

public RAW getRAW(java.lang.String columnName)
           throws java.sql.SQLException
Oracle extension. Get the column value as a RAW. A RAW instance maps to a RAW or LONG RAW value in database.

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

getBLOB

public BLOB getBLOB(java.lang.String columnName)
             throws java.sql.SQLException
Oracle extension. Get the column value as a BLOB (unstructured binary data). BLOB data is accessed and referenced by using a locator which is stored in the database table and points to the BLOB data.

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

getCLOB

public CLOB getCLOB(java.lang.String columnName)
             throws java.sql.SQLException
Oracle extension. Get the column value as a CLOB (single-byte character data). CLOB data is accessed and referenced by using a locator which is stored in the database table and points to the CLOB data.

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

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

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

getCustomDatum

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

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

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

Specified by:
getCustomDatum in interface OracleResultSet
Parameters:
columnName - the name of the column
factory - CustomDatumFactory used to materialize the column value
Returns:
the column value as a CustomDatum; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database access error occurs.

getORAData

public ORAData getORAData(java.lang.String columnName,
                          ORADataFactory factory)
                   throws java.sql.SQLException
Oracle extension. Get the column value as an instance of a subclass of ORAData. Which subclass is determined by the factory parameter.

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

updateOracleObject

public abstract void updateOracleObject(int columnIndex,
                                        Datum x)
                                 throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.xxx value.

Specified by:
updateOracleObject in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateROWID

public abstract void updateROWID(int columnIndex,
                                 ROWID x)
                          throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.ROWID value.

Specified by:
updateROWID in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateNUMBER

public abstract void updateNUMBER(int columnIndex,
                                  NUMBER x)
                           throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.NUMBER value.

Specified by:
updateNUMBER in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateDATE

public abstract void updateDATE(int columnIndex,
                                DATE x)
                         throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.DATE value.

Specified by:
updateDATE in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateINTERVALYM

public abstract void updateINTERVALYM(int columnIndex,
                                      INTERVALYM x)
                               throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.INTERVALYM value.

Specified by:
updateINTERVALYM in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateINTERVALDS

public abstract void updateINTERVALDS(int columnIndex,
                                      INTERVALDS x)
                               throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.INTERVALDS value.

Specified by:
updateINTERVALDS in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateTIMESTAMP

public abstract void updateTIMESTAMP(int columnIndex,
                                     TIMESTAMP x)
                              throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.TIMESTAMP value.

Specified by:
updateTIMESTAMP in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateTIMESTAMPTZ

public abstract void updateTIMESTAMPTZ(int columnIndex,
                                       TIMESTAMPTZ x)
                                throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.TIMESTAMPTZ value.

Specified by:
updateTIMESTAMPTZ in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateTIMESTAMPLTZ

public abstract void updateTIMESTAMPLTZ(int columnIndex,
                                        TIMESTAMPLTZ x)
                                 throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.TIMESTAMPLTZ value.

Specified by:
updateTIMESTAMPLTZ in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateARRAY

public abstract void updateARRAY(int columnIndex,
                                 ARRAY x)
                          throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.ARRAY value.

Specified by:
updateARRAY in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateSTRUCT

public abstract void updateSTRUCT(int columnIndex,
                                  STRUCT x)
                           throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.STRUCT value.

Specified by:
updateSTRUCT in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateOPAQUE

public abstract void updateOPAQUE(int columnIndex,
                                  OPAQUE x)
                           throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.OPAQUE value.

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

updateREF

public abstract void updateREF(int columnIndex,
                               REF x)
                        throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.REF value.

Specified by:
updateREF in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateCHAR

public abstract void updateCHAR(int columnIndex,
                                CHAR x)
                         throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.CHAR value.

Specified by:
updateCHAR in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateRAW

public abstract void updateRAW(int columnIndex,
                               RAW x)
                        throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.RAW value.

Specified by:
updateRAW in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateBLOB

public abstract void updateBLOB(int columnIndex,
                                BLOB x)
                         throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.BLOB value.

Specified by:
updateBLOB in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateCLOB

public abstract void updateCLOB(int columnIndex,
                                CLOB x)
                         throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.CLOB value.

Specified by:
updateCLOB in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateBFILE

public abstract void updateBFILE(int columnIndex,
                                 BFILE x)
                          throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.BFILE value.

Specified by:
updateBFILE in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateBfile

public abstract void updateBfile(int columnIndex,
                                 BFILE X)
                          throws java.sql.SQLException
Oracle extension. Updates a column with an Bfile value.

Specified by:
updateBfile in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Throws:
java.sql.SQLException - if a database access error occurs

updateCustomDatum

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

Oracle extension. Updates a column with an CustomDatum value.

Specified by:
updateCustomDatum in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateORAData

public abstract void updateORAData(int columnIndex,
                                   ORAData x)
                            throws java.sql.SQLException
Oracle extension. Updates a column with an ORAData value.

Specified by:
updateORAData in interface OracleResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateRef

public abstract void updateRef(int columnIndex,
                               java.sql.Ref x)
                        throws java.sql.SQLException
Oracle extension. Updates a column with an Ref value.

Specified by:
updateRef in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateBlob

public abstract void updateBlob(int columnIndex,
                                java.sql.Blob x)
                         throws java.sql.SQLException
Oracle extension. Updates a column with an Blob value.

Specified by:
updateBlob in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateClob

public abstract void updateClob(int columnIndex,
                                java.sql.Clob x)
                         throws java.sql.SQLException
Oracle extension. Updates a column with an Clob value.

Specified by:
updateClob in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateArray

public abstract void updateArray(int columnIndex,
                                 java.sql.Array x)
                          throws java.sql.SQLException
Oracle extension. Updates a column with an Array value.

Specified by:
updateArray in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateROWID

public void updateROWID(java.lang.String columnName,
                        ROWID x)
                 throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.ROWID value.

Specified by:
updateROWID in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateNUMBER

public void updateNUMBER(java.lang.String columnName,
                         NUMBER x)
                  throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.NUMBER value.

Specified by:
updateNUMBER in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateDATE

public void updateDATE(java.lang.String columnName,
                       DATE x)
                throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.DATE value.

Specified by:
updateDATE in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateOracleObject

public void updateOracleObject(java.lang.String columnName,
                               Datum x)
                        throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.xxx value.

Specified by:
updateOracleObject in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateARRAY

public void updateARRAY(java.lang.String columnName,
                        ARRAY x)
                 throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.ARRAY value.

Specified by:
updateARRAY in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateSTRUCT

public void updateSTRUCT(java.lang.String columnName,
                         STRUCT x)
                  throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.STRUCT value.

Specified by:
updateSTRUCT in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateOPAQUE

public void updateOPAQUE(java.lang.String columnName,
                         OPAQUE x)
                  throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.OPAQUE value.

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

updateREF

public void updateREF(java.lang.String columnName,
                      REF x)
               throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.REF value.

Specified by:
updateREF in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateCHAR

public void updateCHAR(java.lang.String columnName,
                       CHAR x)
                throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.CHAR value.

Specified by:
updateCHAR in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateRAW

public void updateRAW(java.lang.String columnName,
                      RAW x)
               throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.RAW value.

Specified by:
updateRAW in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateBLOB

public void updateBLOB(java.lang.String columnName,
                       BLOB x)
                throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.BLOB value.

Specified by:
updateBLOB in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateCLOB

public void updateCLOB(java.lang.String columnName,
                       CLOB x)
                throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.CLOB value.

Specified by:
updateCLOB in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateBFILE

public void updateBFILE(java.lang.String columnName,
                        BFILE x)
                 throws java.sql.SQLException
Oracle extension. Updates a column with an oracle.sql.BFILE value.

Specified by:
updateBFILE in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateBfile

public void updateBfile(java.lang.String columnName,
                        BFILE x)
                 throws java.sql.SQLException
Oracle extension. Updates a column with an BFILE value.

Specified by:
updateBfile in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateCustomDatum

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

Oracle extension. Updates a column with an CustomDatum value.

Specified by:
updateCustomDatum in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateORAData

public void updateORAData(java.lang.String columnName,
                          ORAData x)
                   throws java.sql.SQLException
Oracle extension. Updates a column with an ORAData value.

Specified by:
updateORAData in interface OracleResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateRef

public void updateRef(java.lang.String columnName,
                      java.sql.Ref x)
               throws java.sql.SQLException
Oracle extension. Updates a column with an Ref value.

Specified by:
updateRef in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateBlob

public void updateBlob(java.lang.String columnName,
                       java.sql.Blob x)
                throws java.sql.SQLException
Oracle extension. Updates a column with an Blob value.

Specified by:
updateBlob in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateClob

public void updateClob(java.lang.String columnName,
                       java.sql.Clob x)
                throws java.sql.SQLException
Oracle extension. Updates a column with an Clob value.

Specified by:
updateClob in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateArray

public void updateArray(java.lang.String columnName,
                        java.sql.Array x)
                 throws java.sql.SQLException
Oracle extension. Updates a column with an Array value.

Specified by:
updateArray in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

setAutoRefetch

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

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

getAutoRefetch

public abstract boolean getAutoRefetch()
                                throws java.sql.SQLException
Oracle extension. Gets the current auto-refetch state.

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

getWarnings

public abstract java.sql.SQLWarning getWarnings()
                                         throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getWarnings. Oracle does not have any warnings, so always returns null.

Specified by:
getWarnings in interface java.sql.ResultSet
Returns:
null
Throws:
java.sql.SQLException - if a database-access error occurs.

clearWarnings

public abstract void clearWarnings()
                            throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.clearWarnings. After this call getWarnings returns null until a new warning is reported for this ResultSet.

Specified by:
clearWarnings in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if a database-access error occurs.

getCursorName

public abstract java.lang.String getCursorName()
                                        throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getCursorName. Oracle does not support cursor names, so this always throws an exception.

Specified by:
getCursorName in interface java.sql.ResultSet
Returns:
never returns
Throws:
java.sql.SQLException - always

getMetaData

public abstract java.sql.ResultSetMetaData getMetaData()
                                                throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getMetaData. This feature is not supported for ResultSet instance returned from oracle.sql.ARRAY#getResultSet.

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

findColumn

public abstract int findColumn(java.lang.String columnName)
                        throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.findColumn.

Specified by:
findColumn in interface java.sql.ResultSet
Parameters:
columnName - the name of the column
Returns:
the column index
Throws:
java.sql.SQLException - if a database-access error occurs.

next

public abstract boolean next()
                      throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.next.

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

close

public abstract void close()
                    throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.close.

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

Specified by:
close in interface java.sql.ResultSet
Throws:
java.sql.SQLException - if a database-access error occurs.

wasNull

public abstract boolean wasNull()
                         throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.wasNull.

Specified by:
wasNull in interface java.sql.ResultSet
Returns:
true if last column read was SQL NULL
Throws:
java.sql.SQLException - if a database-access error occurs.

getObject

public abstract java.lang.Object getObject(int columnIndex)
                                    throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getObject.

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

getString

public abstract java.lang.String getString(int columnIndex)
                                    throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getString.

Specified by:
getString in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getBoolean

public abstract boolean getBoolean(int columnIndex)
                            throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getBoolean.

Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is false
Throws:
java.sql.SQLException - if a database-access error occurs.

getByte

public abstract byte getByte(int columnIndex)
                      throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getByte.

Specified by:
getByte in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if a database-access error occurs.

getShort

public abstract short getShort(int columnIndex)
                        throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getShort.

Specified by:
getShort in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if a database-access error occurs.

getInt

public abstract int getInt(int columnIndex)
                    throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getInt.

Specified by:
getInt in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if a database-access error occurs.

getLong

public abstract long getLong(int columnIndex)
                      throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getLong.

Specified by:
getLong in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if a database-access error occurs.

getFloat

public abstract float getFloat(int columnIndex)
                        throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getFloat.

Specified by:
getFloat in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if a database-access error occurs.

getDouble

public abstract double getDouble(int columnIndex)
                          throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getDouble.

Specified by:
getDouble in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getBigDecimal

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

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
scale - the number of digits to the right of the decimal
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getBytes

public abstract byte[] getBytes(int columnIndex)
                         throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getBytes.

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getDate

public abstract java.sql.Date getDate(int columnIndex)
                               throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getDate.

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getTime

public abstract java.sql.Time getTime(int columnIndex)
                               throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getTime.

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getTimestamp

public abstract java.sql.Timestamp getTimestamp(int columnIndex)
                                         throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getTimestamp.

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getAsciiStream

public abstract java.io.InputStream getAsciiStream(int columnIndex)
                                            throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getAsciiStream.

Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getUnicodeStream

public abstract java.io.InputStream getUnicodeStream(int columnIndex)
                                              throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getUnicodeStream.

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getBinaryStream

public abstract java.io.InputStream getBinaryStream(int columnIndex)
                                             throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getBinaryStream.

Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getObject

public java.lang.Object getObject(java.lang.String columnName)
                           throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getObject.

Specified by:
getObject in interface java.sql.ResultSet
Returns:
A java.lang.Object holding the column value.
Throws:
java.sql.SQLException - if a database-access error occurs.

getString

public java.lang.String getString(java.lang.String columnName)
                           throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getString.

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

getBoolean

public boolean getBoolean(java.lang.String columnName)
                   throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getBoolean.

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

getByte

public byte getByte(java.lang.String columnName)
             throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getByte.

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

getShort

public short getShort(java.lang.String columnName)
               throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getShort.

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

getInt

public int getInt(java.lang.String columnName)
           throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getInt.

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

getLong

public long getLong(java.lang.String columnName)
             throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getLong.

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

getFloat

public float getFloat(java.lang.String columnName)
               throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getFloat.

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

getDouble

public double getDouble(java.lang.String columnName)
                 throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getDouble.

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

getBigDecimal

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

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
scale - the number of digits to the right of the decimal
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database-access error occurs.

getBytes

public byte[] getBytes(java.lang.String columnName)
                throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getBytes.

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

getDate

public java.sql.Date getDate(java.lang.String columnName)
                      throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getDate.

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

getTime

public java.sql.Time getTime(java.lang.String columnName)
                      throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getTime.

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

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName)
                                throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getTimestamp.

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

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String columnName)
                                   throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getAsciiStream.

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

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String columnName)
                                     throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getUnicodeStream.

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

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String columnName)
                                    throws java.sql.SQLException
Implements JDBC 1.0 ResultSet.getBinaryStream.

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

getObject

public abstract java.lang.Object getObject(int columnIndex,
                                           java.util.Map map)
                                    throws java.sql.SQLException
Implements JDBC 2.0 ResultSet.getObject (idx, map). Returns the value of a column in the current row as a Java object. This method uses the given Map object for the custom mapping of the SQL structured or distinct type that is being retrieved.

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
map - the mapping from SQL type names to Java classes
Returns:
an object representing the SQL value
Throws:
java.sql.SQLException - if a database-access error occurs.

getRef

public abstract java.sql.Ref getRef(int columnIndex)
                             throws java.sql.SQLException
Implements JDBC 2.0 ResultSet.getRef. Gets a REF(<structured-type>) column value from the current row.

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

getBlob

public abstract java.sql.Blob getBlob(int columnIndex)
                               throws java.sql.SQLException
Implements JDBC 2.0 ResultSet.getBlob. Gets a BLOB value in the current row of this ResultSet object.

Specified by:
getBlob in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
a Blob object representing the SQL BLOB value in the specified column
Throws:
java.sql.SQLException - if a database-access error occurs.

getClob

public abstract java.sql.Clob getClob(int columnIndex)
                               throws java.sql.SQLException
Implements JDBC 2.0 ResultSet. Gets a CLOB value in the current row of this ResultSet object.

Specified by:
getClob in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
a Clob object representing the SQL CLOB value in the specified column
Throws:
java.sql.SQLException - if a database-access error occurs.

getArray

public abstract java.sql.Array getArray(int columnIndex)
                                 throws java.sql.SQLException
Implements JDBC 2.0 ResultSet.getArray. Gets an SQL ARRAY value from the current row of this ResultSet object.

Specified by:
getArray in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
an Array object representing the SQL ARRAY value in the specified column
Throws:
java.sql.SQLException - if a database-access error occurs.

getCharacterStream

public abstract java.io.Reader getCharacterStream(int columnIndex)
                                           throws java.sql.SQLException
Implements JDBC 2.0 ResultSet.getCharacterStream.

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

Specified by:
getCharacterStream in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Throws:
java.sql.SQLException - if a database-access error occurs.

getBigDecimal

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

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value (full precision); if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database access error occurs

getDate

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

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
cal - the calendar to use in constructing the date
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database access error occurs

getTime

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

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
cal - the calendar to use in constructing the time
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database access error occurs

getTimestamp

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

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
cal - the calendar to use in constructing the time
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if a database access error occurs

getTIMESTAMP

public TIMESTAMP getTIMESTAMP(int columnIndex)
                       throws java.sql.SQLException
Description copied from interface: OracleResultSet
Obtain an oralce.sql.TIMESTAMP value from the ResultSet.

Specified by:
getTIMESTAMP in interface OracleResultSet
Parameters:
columnIndex - parameter number.
Returns:
the obtained value.
Throws:
java.sql.SQLException - if an error occurred.

getTIMESTAMP

public TIMESTAMP getTIMESTAMP(java.lang.String columnName)
                       throws java.sql.SQLException
Description copied from interface: OracleResultSet
Obtain an oralce.sql.TIMESTAMP value from the ResultSet.

Specified by:
getTIMESTAMP in interface OracleResultSet
Parameters:
columnName - column name.
Returns:
the obtained value.
Throws:
java.sql.SQLException - if an error occurred.

getTIMESTAMPTZ

public TIMESTAMPTZ getTIMESTAMPTZ(int columnIndex)
                           throws java.sql.SQLException
Description copied from interface: OracleResultSet
Obtain an oralce.sql.TIMESTAMPTZ value from the ResultSet.

Specified by:
getTIMESTAMPTZ in interface OracleResultSet
Parameters:
columnIndex - parameter number.
Returns:
the obtained value.
Throws:
java.sql.SQLException - if an error occurred.

getTIMESTAMPTZ

public TIMESTAMPTZ getTIMESTAMPTZ(java.lang.String columnName)
                           throws java.sql.SQLException
Description copied from interface: OracleResultSet
Obtain an oralce.sql.TIMESTAMPTZ value from the ResultSet.

Specified by:
getTIMESTAMPTZ in interface OracleResultSet
Parameters:
columnName - column name.
Returns:
the obtained value.
Throws:
java.sql.SQLException - if an error occurred.

getTIMESTAMPLTZ

public TIMESTAMPLTZ getTIMESTAMPLTZ(int columnIndex)
                             throws java.sql.SQLException
Description copied from interface: OracleResultSet
Obtain an oralce.sql.TIMESTAMPLTZ value from the ResultSet.

Specified by:
getTIMESTAMPLTZ in interface OracleResultSet
Parameters:
columnIndex - parameter number.
Returns:
the obtained value.
Throws:
java.sql.SQLException - if an error occurred.

getTIMESTAMPLTZ

public TIMESTAMPLTZ getTIMESTAMPLTZ(java.lang.String columnName)
                             throws java.sql.SQLException
Description copied from interface: OracleResultSet
Obtain an oralce.sql.TIMESTAMPLTZ value from the ResultSet.

Specified by:
getTIMESTAMPLTZ in interface OracleResultSet
Parameters:
columnName - column name.
Returns:
the obtained value.
Throws:
java.sql.SQLException - if an error occurred.

getINTERVALYM

public INTERVALYM getINTERVALYM(int columnIndex)
                         throws java.sql.SQLException
Description copied from interface: OracleResultSet
Obtain an oralce.sql.INTERVALYM value from the ResultSet.

Specified by:
getINTERVALYM in interface OracleResultSet
Parameters:
columnIndex - parameter number.
Returns:
the obtained value.
Throws:
java.sql.SQLException - if an error occurred.

getINTERVALYM

public INTERVALYM getINTERVALYM(java.lang.String columnName)
                         throws java.sql.SQLException
Description copied from interface: OracleResultSet
Obtain an oralce.sql.INTERVALYM value from the ResultSet.

Specified by:
getINTERVALYM in interface OracleResultSet
Returns:
the obtained value.
Throws:
java.sql.SQLException - if an error occurred.

getINTERVALDS

public INTERVALDS getINTERVALDS(int columnIndex)
                         throws java.sql.SQLException
Description copied from interface: OracleResultSet
Obtain an oralce.sql.INTERVALDS value from the ResultSet.

Specified by:
getINTERVALDS in interface OracleResultSet
Parameters:
columnIndex - parameter number.
Returns:
the obtained value.
Throws:
java.sql.SQLException - if an error occurred.

getINTERVALDS

public INTERVALDS getINTERVALDS(java.lang.String columnName)
                         throws java.sql.SQLException
Description copied from interface: OracleResultSet
Obtain an oralce.sql.INTERVALDS value from the ResultSet.

Specified by:
getINTERVALDS in interface OracleResultSet
Returns:
the obtained value.
Throws:
java.sql.SQLException - if an error occurred.

getObject

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

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
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 java.sql.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.

Specified by:
getRef in interface java.sql.ResultSet
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 java.sql.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.

Specified by:
getBlob in interface java.sql.ResultSet
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 java.sql.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.

Specified by:
getClob in interface java.sql.ResultSet
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.

Specified by:
getCharacterStream in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
Throws:
java.sql.SQLException - if a database-access error occurs.

getArray

public java.sql.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 .

Specified by:
getArray in interface java.sql.ResultSet
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
Implements JDBC 2.0 ResultSet.getBigDecimal. Gets the value of a column in the current row as a java.math.BigDecimal object with full precision. The methods behaves the same as getBigDecimal (idx, scale) since Oracle handles numeric values with full precision.

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
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
Implements JDBC 2.0 ResultSet.getDate (idx, calendar). Gets the value of a column in the current row as a java.sql.Date object. This methods behaves the same as getDate (idx) since Oracle database doesn't support timezone information with Date.

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
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
Implements JDBC 2.0 ResultSet.getTime (idx, calendar). Gets the value of a column in the current row as a java.sql.Time object. This methods behaves the same as getTime (idx) since Oracle database doesn't support timezone information with Date.

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
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
Implements JDBC 2.0 ResultSet.getTimestamp (idx, calendar). Gets the value of a column in the current row as a java.sql.Timestamp object. This methods behaves the same as getTimestamp (idx) since Oracle database doesn't support timezone information with Date.

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
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.

Specified by:
isBeforeFirst in interface java.sql.ResultSet
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.

Specified by:
isAfterLast in interface java.sql.ResultSet
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.

Specified by:
isFirst in interface java.sql.ResultSet
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.

Specified by:
isLast in interface java.sql.ResultSet
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.

Specified by:
beforeFirst in interface java.sql.ResultSet
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.

Specified by:
afterLast in interface java.sql.ResultSet
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.

Specified by:
first in interface java.sql.ResultSet
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.

Specified by:
last in interface java.sql.ResultSet
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.

Specified by:
getRow in interface java.sql.ResultSet
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().

Specified by:
absolute in interface java.sql.ResultSet
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.

Specified by:
relative in interface java.sql.ResultSet
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

previous

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.

Specified by:
previous in interface java.sql.ResultSet
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.

Specified by:
setFetchDirection in interface java.sql.ResultSet
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.

Specified by:
getFetchDirection in interface java.sql.ResultSet
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).

Specified by:
setFetchSize in interface java.sql.ResultSet
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.

Specified by:
getFetchSize in interface java.sql.ResultSet
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.

Specified by:
getType in interface java.sql.ResultSet
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.

Specified by:
getConcurrency in interface java.sql.ResultSet
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.

Specified by:
insertRow in interface java.sql.ResultSet
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.

Specified by:
updateRow in interface java.sql.ResultSet
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.

Specified by:
deleteRow in interface java.sql.ResultSet
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.

Specified by:
refreshRow in interface java.sql.ResultSet
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.

Specified by:
moveToInsertRow in interface java.sql.ResultSet
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.

Specified by:
cancelRowUpdates in interface java.sql.ResultSet
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.

Specified by:
moveToCurrentRow in interface java.sql.ResultSet
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.

Specified by:
getStatement in interface java.sql.ResultSet
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.

Specified by:
rowUpdated in interface java.sql.ResultSet
Returns:
false always
Throws:
java.sql.SQLException

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.

Specified by:
rowInserted in interface java.sql.ResultSet
Returns:
false always
Throws:
java.sql.SQLException

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.

Specified by:
rowDeleted in interface java.sql.ResultSet
Returns:
false always
Throws:
java.sql.SQLException

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.

Specified by:
updateNull in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateBoolean in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateByte in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateShort in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateInt in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateLong in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateFloat in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateDouble in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateString in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateBytes in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateDate in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateTime in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateTimestamp in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateAsciiStream in interface java.sql.ResultSet
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.

Specified by:
updateBinaryStream in interface java.sql.ResultSet
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.

Specified by:
updateCharacterStream in interface java.sql.ResultSet
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.

Specified by:
updateObject in interface java.sql.ResultSet
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.

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

updateNull

public void updateNull(java.lang.String columnName)
                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.

Specified by:
updateNull in interface java.sql.ResultSet
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.

Specified by:
updateBoolean in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateByte in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateShort in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateInt in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateLong in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateFloat in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateDouble in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateString in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateBytes in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateDate in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateTime in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateTimestamp in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
updateAsciiStream in interface java.sql.ResultSet
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.

Specified by:
updateBinaryStream in interface java.sql.ResultSet
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.

Specified by:
updateCharacterStream in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
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.

Specified by:
updateObject in interface java.sql.ResultSet
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.

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
columnName - is the SQL name of the column
x - the new column value
Throws:
java.sql.SQLException - if a database access error occurs

getURL

public abstract java.net.URL getURL(int columnIndex)
                             throws java.sql.SQLException
JDBC 3.0 Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.

Specified by:
getURL in interface java.sql.ResultSet
Parameters:
columnIndex - the index of the column 1 is the first, 2 is the second,...
Returns:
the column value as a java.net.URL object; if the value is SQL NULL, the value returned is null in the Java programming language
Throws:
java.sql.SQLException - if a database access error occurs, or if a URL is malformed
Since:
9.0.2

getURL

public java.net.URL getURL(java.lang.String columnName)
                    throws java.sql.SQLException
JDBC 3.0 Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.

Specified by:
getURL in interface java.sql.ResultSet
Parameters:
columnName - the SQL name of the column
Returns:
the column value as a java.net.URL object; if the value is SQL NULL, the value returned is null in the Java programming language
Throws:
java.sql.SQLException - if a database access error occurs or if a URL is malformed
Since:
9.0.2

Oracle10g JDBC

Copyright © 1998,2004, Oracle. All rights reserved