External Interfaces > Reality Java Interface > JavaDocs > JavaDocs for Reality SQL/JDBC Classes > RealSQLResultSet

Comment on this topic

Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

Reality V15.0 ()

: Class RealSQLResultSet (RealSQL-JDBC) (realsqlresultset.html)

To

Reality

Version

Topic

Submitted by

Company

Location

Email address

Comment

 

 

com.northgateis.reality.realsql
Class RealSQLResultSet

java.lang.Object
 |
 +--com.northgateis.reality.realsql.RealSQLResultSet
public class RealSQLResultSet
extends java.lang.Object
implements java.sql.ResultSet

The RealSQLResultSet class is an implementation of the JDBC 2.0 ResultSet interface.

On instantiation the previously prepared statement is executed by the database server. If this was an update statement, the total number of rows affected is retrieved and processing is complete. Alternatively if the statement generated a resultset, a new thread is spawned with the job of fetching all of the rows from the database and storing for later retrieval. The fetch thread will terminate when either all of the rows in the resultset have been retrieved, or if the statement is cancelled part way through its operation.

Because the fetch operation runs in a separate thread, the ResultSet object can be returned to the client prior to its completion. This allows the client to start processing those rows which have been returned. If the client processes the rows faster than the fetch thread, the client will hang during execution of the next() method until that row has been retrieved.

See Also:
ResultSet

Method Summary
 boolean absolute(int row)
          Not supported by the RealSQL-JDBC driver.
protected  void addWarning(java.sql.SQLWarning msg)
          Adds a new warning message to the SQLWarnings chain.
 void afterLast()
          Not supported by the RealSQL-JDBC driver.
 void beforeFirst()
          Not supported by the RealSQL-JDBC driver.
 void cancelRowUpdates()
          Not supported by the RealSQL-JDBC driver.
 void clearWarnings()
          After this call getWarnings returns null until a new warning is reported for this ResultSet.
 void close()
          Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
 void complete()
          Indicates that the retrieval of all rows in the ResultSet is complete.
 void deleteRow()
          Not supported by the RealSQL-JDBC driver.
protected  void finalize()
          Ensures that the statement resources at the server are released if this object is garbage collected without a prior call to the close method.
 int findColumn(java.lang.String cname)
          Finds the column index in ResultSet for a given column name.
 boolean first()
          Not supported by the RealSQL-JDBC driver.
 java.sql.Array getArray(int column)
          Not supported by the RealSQL-JDBC driver.
 java.sql.Array getArray(java.lang.String cname)
          Not supported by the RealSQL-JDBC driver.
 java.io.InputStream getAsciiStream(int column)
          Not supported by the RealSQL-JDBC driver.
 java.io.InputStream getAsciiStream(java.lang.String cname)
          Not supported by the RealSQL-JDBC driver.
 java.math.BigDecimal getBigDecimal(int column)
          JDBC 2.0 Get the value of a column in the current row as a java.math.BigDecimal object with full precision.
 java.math.BigDecimal getBigDecimal(int column, int scale)
          Deprecated.  
 java.math.BigDecimal getBigDecimal(java.lang.String cname)
          JDBC 2.0 Gets the value of a column in the current row as a java.math.BigDecimal object with full precision.
 java.math.BigDecimal getBigDecimal(java.lang.String cname, int scale)
          Deprecated.  
 java.io.InputStream getBinaryStream(int column)
          Not supported by the RealSQL-JDBC driver.
 java.io.InputStream getBinaryStream(java.lang.String cname)
          Not supported by the RealSQL-JDBC driver.
 java.sql.Blob getBlob(int column)
          Not supported by the RealSQL-JDBC driver.
 java.sql.Blob getBlob(java.lang.String cname)
          Not supported by the RealSQL-JDBC driver.
 boolean getBoolean(int column)
          Gets the value of a column in the current row as a Java boolean.
 boolean getBoolean(java.lang.String cname)
          Get the value of a column in the current row as a Java boolean.
 byte getByte(int column)
          Get the value of a column in the current row as a Java byte.
 byte getByte(java.lang.String cname)
          Gets the value of a column in the current row as a Java byte.
 byte[] getBytes(int column)
          Not supported by the RealSQL-JDBC driver.
 byte[] getBytes(java.lang.String cname)
          Not supported by the RealSQL-JDBC driver.
 java.io.Reader getCharacterStream(int column)
          Not supported by the RealSQL-JDBC driver.
 java.io.Reader getCharacterStream(java.lang.String cname)
          Not supported by the RealSQL-JDBC driver.
 java.sql.Clob getClob(int column)
          Not supported by the RealSQL-JDBC driver.
 java.sql.Clob getClob(java.lang.String cname)
          Not supported by the RealSQL-JDBC driver.
 int getConcurrency()
          Not supported by the RealSQL-JDBC driver.
 java.lang.String getCursorName()
          Not supported by the RealSQL-JDBC driver.
 java.sql.Date getDate(int column)
          Get the value of a column in the current row as a java.sql.Date object.
 java.sql.Date getDate(int column, java.util.Calendar cal)
          Get the value of a column in the current row as a java.sql.Date object.
 java.sql.Date getDate(java.lang.String cname)
          Gets the value of a column in the current row as a java.sql.Date object.
 java.sql.Date getDate(java.lang.String cname, java.util.Calendar cal)
          Gets the value of a column in the current row as a java.sql.Date object.
 double getDouble(int column)
          Get the value of a column in the current row as a Java double.
 double getDouble(java.lang.String cname)
          Gets the value of a column in the current row as a Java double.
 int getFetchDirection()
          JDBC 2.0 Returns the fetch direction for this result set.
 int getFetchSize()
          JDBC 2.0 Returns the fetch size for this result set.
 float getFloat(int column)
          Get the value of a column in the current row as a Java float.
 float getFloat(java.lang.String cname)
          Gets the value of a column in the current row as a Java float.
 int getInt(int column)
          Get the value of a column in the current row as a Java int.
 int getInt(java.lang.String cname)
          Gets the value of a column in the current row as a Java int.
 long getLong(int column)
          Get the value of a column in the current row as a Java long.
 long getLong(java.lang.String cname)
          Gets the value of a column in the current row as a Java long.
 java.sql.ResultSetMetaData getMetaData()
          Get the number, types and properties of a ResultSet's columns.
 java.lang.Object getObject(int column)
          Get the value of a column in the current row as a Java object.
 java.lang.Object getObject(int column, java.util.Map types)
          Not supported by the RealSQL-JDBC driver.
 java.lang.Object getObject(java.lang.String cname)
          Gets the value of a column in the current row as a Java object.
 java.lang.Object getObject(java.lang.String cname, java.util.Map types)
          Not supported by the RealSQL-JDBC driver.
 java.sql.Ref getRef(int column)
          Not supported by the RealSQL-JDBC driver.
 java.sql.Ref getRef(java.lang.String cname)
          Not supported by the RealSQL-JDBC driver.
 int getRow()
          JDBC 2.0 Get the current row number.
protected  int getRowCount()
          Get the update count, this is only valid if the last SQL statement executed caused an update to occur on the database.
 short getShort(int column)
          Get the value of a column in the current row as a Java short.
 short getShort(java.lang.String cname)
          Gets the value of a column in the current row as a Java short.
 java.sql.Statement getStatement()
          JDBC 2.0 Returns the Statement that produced this ResultSet object.
 java.lang.String getString(int column)
          Get the value of a column in the current row as a Java String.
 java.lang.String getString(java.lang.String cname)
          Gets the value of a column in the current row as a Java String.
 java.sql.Time getTime(int column)
          Gets the value of a column in the current row as a java.sql.Time object.
 java.sql.Time getTime(int column, java.util.Calendar cal)
          Gets the value of a column in the current row as a java.sql.Time object.
 java.sql.Time getTime(java.lang.String cname)
          Gets the value of a column in the current row as a java.sql.Time object.
 java.sql.Time getTime(java.lang.String cname, java.util.Calendar cal)
          Gets the value of a column in the current row as a java.sql.Time object.
 java.sql.Timestamp getTimestamp(int column)
          Gets the value of a column in the current row as a java.sql.Timestamp object.
 java.sql.Timestamp getTimestamp(int column, java.util.Calendar cal)
          Gets the value of a column in the current row as a java.sql.Timestamp object.
 java.sql.Timestamp getTimestamp(java.lang.String cname)
          Gets the value of a column in the current row as a java.sql.Timestamp object.
 java.sql.Timestamp getTimestamp(java.lang.String cname, java.util.Calendar cal)
          Gets the value of a column in the current row as a java.sql.Timestamp object.
 int getType()
          JDBC 2.0 Returns the type of this result set.
 java.io.InputStream getUnicodeStream(int column)
          Deprecated. use getCharacterStream()
 java.io.InputStream getUnicodeStream(java.lang.String cname)
          Deprecated. use the getCharacterStream()
 java.sql.SQLWarning getWarnings()
          The first warning reported by calls on this ResultSet is returned.
 void insertRow()
          Not supported by the RealSQL-JDBC driver.
 boolean isAfterLast()
          Not supported by the RealSQL-JDBC driver.
 boolean isBeforeFirst()
          Not supported by the RealSQL-JDBC driver.
protected  boolean isClosed()
           
 boolean isFirst()
          Not supported by the RealSQL-JDBC driver.
 boolean isLast()
          Not supported by the RealSQL-JDBC driver.
 boolean last()
          Not supported by the RealSQL-JDBC driver.
 void moveToCurrentRow()
          Not supported by the RealSQL-JDBC driver.
 void moveToInsertRow()
          Not supported by the RealSQL-JDBC driver.
 boolean next()
          Moves to the next row of data for processing.
 boolean previous()
          Not supported by the RealSQL-JDBC driver.
 void refreshRow()
          Not supported by the RealSQL-JDBC driver.
 boolean relative(int count)
          Not supported by the RealSQL-JDBC driver.
 boolean rowDeleted()
          Not supported by the RealSQL-JDBC driver.
 boolean rowInserted()
          Not supported by the RealSQL-JDBC driver.
 boolean rowUpdated()
          Not supported by the RealSQL-JDBC driver.
 void setFetchDirection(int dir)
          JDBC 2.0 Gives a hint as to the direction in which the rows in this result set will be processed.
 void setFetchSize(int unused)
          Not supported by the RealSQL-JDBC driver.
 void updateAsciiStream(int col, java.io.InputStream is, int len)
          Not supported by the RealSQL-JDBC driver.
 void updateAsciiStream(java.lang.String cname, java.io.InputStream is, int len)
          Not supported by the RealSQL-JDBC driver.
 void updateBigDecimal(int column, java.math.BigDecimal d)
          Not supported by the RealSQL-JDBC driver.
 void updateBigDecimal(java.lang.String cname, java.math.BigDecimal d)
          Not supported by the RealSQL-JDBC driver.
 void updateBinaryStream(int column, java.io.InputStream is, int len)
          Not supported by the RealSQL-JDBC driver.
 void updateBinaryStream(java.lang.String cname, java.io.InputStream is, int len)
          Not supported by the RealSQL-JDBC driver.
 void updateBlob(int column, java.sql.Blob b)
          Not supported by the RealSQL-JDBC driver.
 void updateBoolean(int column, boolean b)
          Not supported by the RealSQL-JDBC driver.
 void updateBoolean(java.lang.String cname, boolean b)
          Not supported by the RealSQL-JDBC driver.
 void updateByte(int column, byte b)
          Not supported by the RealSQL-JDBC driver.
 void updateByte(java.lang.String cname, byte b)
          Not supported by the RealSQL-JDBC driver.
 void updateBytes(int column, byte[] data)
          Not supported by the RealSQL-JDBC driver.
 void updateBytes(java.lang.String cname, byte[] b)
          Not supported by the RealSQL-JDBC driver.
 void updateCharacterStream(int column, java.io.Reader in, int len)
          Not supported by the RealSQL-JDBC driver.
 void updateCharacterStream(java.lang.String cname, java.io.Reader r, int len)
          Not supported by the RealSQL-JDBC driver.
 void updateDate(int column, java.sql.Date d)
          Not supported by the RealSQL-JDBC driver.
 void updateDate(java.lang.String cname, java.sql.Date d)
          Not supported by the RealSQL-JDBC driver.
 void updateDouble(int column, double d)
          Not supported by the RealSQL-JDBC driver.
 void updateDouble(java.lang.String cname, double d)
          Not supported by the RealSQL-JDBC driver.
 void updateFloat(int column, float f)
          Not supported by the RealSQL-JDBC driver.
 void updateFloat(java.lang.String cname, float f)
          Not supported by the RealSQL-JDBC driver.
 void updateInt(int column, int x)
          Not supported by the RealSQL-JDBC driver.
 void updateInt(java.lang.String cname, int x)
          Not supported by the RealSQL-JDBC driver.
 void updateLong(int column, long l)
          Not supported by the RealSQL-JDBC driver.
 void updateLong(java.lang.String cname, long l)
          Not supported by the RealSQL-JDBC driver.
 void updateNull(int column)
          Not supported by the RealSQL-JDBC driver.
 void updateNull(java.lang.String cname)
          Not supported by the RealSQL-JDBC driver.
 void updateObject(int column, java.lang.Object ob)
          Not supported by the RealSQL-JDBC driver.
 void updateObject(int column, java.lang.Object ob, int scale)
          Not supported by the RealSQL-JDBC driver.
 void updateObject(java.lang.String cname, java.lang.Object ob)
          Not supported by the RealSQL-JDBC driver.
 void updateObject(java.lang.String cname, java.lang.Object ob, int scale)
          Not supported by the RealSQL-JDBC driver.
 void updateRow()
          Not supported by the RealSQL-JDBC driver.
 void updateShort(int column, short s)
          Not supported by the RealSQL-JDBC driver.
 void updateShort(java.lang.String cname, short s)
          Not supported by the RealSQL-JDBC driver.
 void updateString(int column, java.lang.String str)
          Not supported by the RealSQL-JDBC driver.
 void updateString(java.lang.String cname, java.lang.String str)
          Not supported by the RealSQL-JDBC driver.
 void updateTime(int column, java.sql.Time t)
          Not supported by the RealSQL-JDBC driver.
 void updateTime(java.lang.String cname, java.sql.Time t)
          Not supported by the RealSQL-JDBC driver.
 void updateTimestamp(int column, java.sql.Timestamp ts)
          Not supported by the RealSQL-JDBC driver.
 void updateTimestamp(java.lang.String cname, java.sql.Timestamp ts)
          Not supported by the RealSQL-JDBC driver.
 boolean wasNull()
          Reports whether the last column read had a value of SQL NULL.
 
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

finalize

protected void finalize()
 throws java.sql.SQLException
Ensures that the statement resources at the server are released if this object is garbage collected without a prior call to the close method.
Throws:
java.sql.SQLException -  
Overrides:
finalize in class java.lang.Object

absolute

public boolean absolute(int row)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Positions the result set to an absolute position relative to either the beginning or end of the result set.

Specified by:
absolute in interface java.sql.ResultSet
Parameters:
row - positive indicates the absolute row number from the start, negative indicates the absolute row number from the end.
Returns:
true if the positioning points to a row
Throws:
java.sql.SQLException - IM001 - "Driver does not support this function".

afterLast

public void afterLast()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Moves the result set to after the last row.

Specified by:
afterLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException - IM001 - "Driver does not support this function".

beforeFirst

public void beforeFirst()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Moves the result set to before the first row.

Specified by:
beforeFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException - IM001 - "Driver does not support this function".

cancelRowUpdates

public void cancelRowUpdates()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Cancels the updates made to a row.

Specified by:
cancelRowUpdates in interface java.sql.ResultSet
Throws:
java.sql.SQLException - IM001 - "Driver does not support this function".

clearWarnings

public void clearWarnings()
 throws java.sql.SQLException
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 - never thrown.

close

public void close()
 throws java.sql.SQLException
Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

Specified by:
close in interface java.sql.ResultSet
Throws:
java.sql.SQLException - this is never thrown

deleteRow

public void deleteRow()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Deletes the current row from the result set and the underlying database.

Specified by:
deleteRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException - IM001 - "Driver does not support this function".

findColumn

public int findColumn(java.lang.String cname)
 throws java.sql.SQLException
Finds the column index in ResultSet for a given column name.

Specified by:
findColumn in interface java.sql.ResultSet
Parameters:
columnname - the name of the column.
Returns:
the column index
Throws:
java.sql.SQLException -  

first

public boolean first()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Moves the cursor to the first row in the result set.

Specified by:
first in interface java.sql.ResultSet
Throws:
java.sql.SQLException - IM001 - "Driver does not support this function".

getArray

public java.sql.Array getArray(java.lang.String cname)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

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

Specified by:
getArray in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as an Array
Throws:
java.sql.SQLException - IM001 - "Driver does not support this function".

getArray

public java.sql.Array getArray(int column)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

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

Specified by:
getArray in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as an Array
Throws:
java.sql.SQLException - IM001 - "Driver does not support this function".

getAsciiStream

public java.io.InputStream getAsciiStream(int column)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

Gets the value of a column in the current row as a stream of ASCII characters.

Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
column - the column number for the desired column
Returns:
an ASCII input stream for the desired column
Throws:
java.sql.SQLException -  

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String cname)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

Gets the value of a column in the current row as a stream of ASCII characters.

Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
an ASCII input stream for the column
Throws:
java.sql.SQLException -  

getBigDecimal

public java.math.BigDecimal getBigDecimal(int column)
 throws java.sql.SQLException
JDBC 2.0 Get the value of a column in the current row as a java.math.BigDecimal object with full precision.

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
column - the column number of the desired column.
Returns:
the specified column as a BigDecimal.
Throws:
java.sql.SQLException. -  

getBigDecimal

public java.math.BigDecimal getBigDecimal(int column,
 int scale)
 throws java.sql.SQLException
Deprecated.  
Gets the value of a column in the current row as a java.math.BigDecimal object.

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
column - the column number of the desired column
scale - the scale with which the BigDecimal should be constructed
Returns:
the specified column as a BigDecimal
Throws:
java.sql.SQLException -  

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String cname)
 throws java.sql.SQLException
JDBC 2.0 Gets the value of a column in the current row as a java.math.BigDecimal object with full precision.

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
cname - the name of the column being sought
Returns:
the specified column as a BigDecimal
Throws:
java.sql.SQLException. -  

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String cname,
 int scale)
 throws java.sql.SQLException
Deprecated.  
Gets the value of a column in the current row as a java.math.BigDecimal object.

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
cname - the name of the column being sought
scale - the scale with which the BigDecimal should be constructed
Returns:
the specified column as a BigDecimal
Throws:
java.sql.SQLException -  

getBinaryStream

public java.io.InputStream getBinaryStream(int column)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

Gets the value of a column in the current row as a stream of uninterpreted bytes.

Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as an InputStream
Throws:
java.sql.SQLException -  

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String cname)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

Gets the value of a column in the current row as a stream of uninterpreted bytes.

Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as an InputStream
Throws:
java.sql.SQLException -  

getBlob

public java.sql.Blob getBlob(java.lang.String cname)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

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

Specified by:
getBlob in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a Blob
Throws:
java.sql.SQLException -  

getBlob

public java.sql.Blob getBlob(int column)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

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

Specified by:
getBlob in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a Blob
Throws:
java.sql.SQLException -  

getBoolean

public boolean getBoolean(int column)
 throws java.sql.SQLException
Gets the value of a column in the current row as a Java boolean.

Reality does not support the boolean data type, but supports the operation by returning false for values=0 or values=null and true for values>0.

Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
true if value greater than zero; else false.
Throws:
java.sql.SQLException - if NON-INTEGER value.

getBoolean

public boolean getBoolean(java.lang.String cname)
 throws java.sql.SQLException
Get the value of a column in the current row as a Java Boolean.

Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a Boolean
Throws:
java.sql.SQLException

getByte

public byte getByte(int column)
 throws java.sql.SQLException
Get the value of a column in the current row as a Java byte.

Specified by:
getByte in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column as a byte
Throws:
java.sql.SQLException -  

getByte

public byte getByte(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a Java byte.

The driver does not currently support this operation, and will throw an SQLException.

Specified by:
getByte in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a byte
Throws:
java.sql.SQLException -  

getBytes

public byte[] getBytes(int column)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

Get the value of a column in the current row as a Java byte array.

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column as a byte
Throws:
java.sql.SQLException -  

getBytes

public byte[] getBytes(java.lang.String cname)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

Gets the value of a column in the current row as a Java byte array.

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a byte
Throws:
java.sql.SQLException -  

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String cname)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

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

Specified by:
getCharacterStream in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a Reader
Throws:
java.sql.SQLException -  

getCharacterStream

public java.io.Reader getCharacterStream(int column)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

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

Specified by:
getCharacterStream in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a Reader
Throws:
java.sql.SQLException -  

getClob

public java.sql.Clob getClob(java.lang.String cname)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

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

Specified by:
getClob in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a clob
Throws:
java.sql.SQLException -  

getClob

public java.sql.Clob getClob(int column)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

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

Specified by:
getClob in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a Clob
Throws:
java.sql.SQLException -  

getConcurrency

public int getConcurrency()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Returns the concurrency mode of this result set.

Specified by:
getConcurrency in interface java.sql.ResultSet
Returns:
the result set concurrency
Throws:
java.sql.SQLException -  

getCursorName

public java.lang.String getCursorName()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

Gets the name of the SQL cursor used by this ResultSet.

Specified by:
getCursorName in interface java.sql.ResultSet
Returns:
the cursor name
Throws:
java.sql.SQLException -  

getDate

public java.sql.Date getDate(int column)
 throws java.sql.SQLException
Get the value of a column in the current row as a java.sql.Date object.

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
column - the number of desired column
Returns:
a Date representation of the specified column
Throws:
java.sql.SQLException -  

getDate

public java.sql.Date getDate(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a java.sql.Date object.

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a Date
Throws:
java.sql.SQLException -  

getDate

public java.sql.Date getDate(int column,
 java.util.Calendar cal)
 throws java.sql.SQLException
Get the value of a column in the current row as a java.sql.Date object.

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
column - the number of desired column
cal - the Calendar to use in constructing the date
Returns:
a Date representation of the specified column
Throws:
java.sql.SQLException -  

getDate

public java.sql.Date getDate(java.lang.String cname,
 java.util.Calendar cal)
 throws java.sql.SQLException
Gets the value of a column in the current row as a java.sql.Date object.

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
cal - the Calendar to use in constructing the Date
Returns:
the column as a Date
Throws:
java.sql.SQLException -  

getDouble

public double getDouble(int column)
 throws java.sql.SQLException
Get the value of a column in the current row as a Java double.

Specified by:
getDouble in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a double
Throws:
java.sql.SQLException -  

getDouble

public double getDouble(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a Java double.

Specified by:
getDouble in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a double
Throws:
java.sql.SQLException -  

getFetchDirection

public int getFetchDirection()
 throws java.sql.SQLException
JDBC 2.0 Returns the fetch direction for this result set.

Specified by:
getFetchDirection in interface java.sql.ResultSet
Returns:
the direction in which results might be fetched
Throws:
java.sql.SQLException - this is never thrown.

getFetchSize

public int getFetchSize()
 throws java.sql.SQLException
JDBC 2.0 Returns the fetch size for this result set. The driver always fetches all rows.

Specified by:
getFetchSize in interface java.sql.ResultSet
Returns:
0
Throws:
java.sql.SQLException - this is never thrown.

getFloat

public float getFloat(int column)
 throws java.sql.SQLException
Get the value of a column in the current row as a Java float.

Specified by:
getFloat in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a float
Throws:
java.sql.SQLException -  

getFloat

public float getFloat(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a Java float.

Specified by:
getFloat in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a float
Throws:
java.sql.SQLException -  

getInt

public int getInt(int column)
 throws java.sql.SQLException
Get the value of a column in the current row as a Java int.

Specified by:
getInt in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as an int, null data is returned as 0.
Throws:
java.sql.SQLException - if unable to convert column data to type INTEGER.

getInt

public int getInt(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a Java int.

Specified by:
getInt in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as an int
Throws:
java.sql.SQLException - thrown in the event of an error reading the column

getLong

public long getLong(int column)
 throws java.sql.SQLException
Get the value of a column in the current row as a Java long.

Specified by:
getLong in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a long
Throws:
java.sql.SQLException - thrown in the event of an error reading the column

getLong

public long getLong(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a Java long.

Specified by:
getLong in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a long
Throws:
java.sql.SQLException - thrown in the event of an error reading the column

getMetaData

public java.sql.ResultSetMetaData getMetaData()
 throws java.sql.SQLException
Get the number, types and properties of a ResultSet's columns.

Specified by:
getMetaData in interface java.sql.ResultSet
Returns:
the ResultSetMetaData associated with this result set
Throws:
java.sql.SQLException -  

getObject

public java.lang.Object getObject(int column)
 throws java.sql.SQLException
Get the value of a column in the current row as a Java object.

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a Java object based on the standard SQL -> Java mapping unless the SQL type is a custom SQL type, in which case the getTypeMap() value in the RealSQLConnection will be used
Throws:
java.sql.SQLException. -  
See Also:
Connection.getTypeMap()

getObject

public java.lang.Object getObject(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a Java object.

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a Java object based on the standard SQL -> Java mapping unless the SQL type is a custom SQL type, in which case the getTypeMap() value in the RealSQLConnection will be used
Throws:
java.sql.SQLException. -  
See Also:
Connection.getTypeMap()

getObject

public java.lang.Object getObject(java.lang.String cname,
 java.util.Map types)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Returns the value of a column in the current row as a Java object.

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a Java object based on the standard SQL -> Java mapping unless the SQL type is a custom SQL type, in which case the getTypeMap() value in the RealSQLConnection will be used
Throws:
java.sql.SQLException. -  
See Also:
Connection.getTypeMap()

getObject

public java.lang.Object getObject(int column,
 java.util.Map types)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Returns the value of a column in the current row as a Java object.

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a Java object based on the standard SQL -> Java mapping unless the SQL type is a custom SQL type, in which case the getTypeMap() value in the RealSQLConnection will be used
Throws:
java.sql.SQLException. -  
See Also:
Connection.getTypeMap()

getRef

public java.sql.Ref getRef(java.lang.String cname)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Gets a REF() column value from the current row.

RealSQL-JDBC does not currently support references

Specified by:
getRef in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
a ref for the specified column
Throws:
java.sql.SQLException - this is always thrown

getRef

public java.sql.Ref getRef(int column)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Gets a REF() column value from the current row.

Specified by:
getRef in interface java.sql.ResultSet
Parameters:
column - the desired column number
Returns:
a ref for the specified column
Throws:
java.sql.SQLException - this is always thrown

getRow

public int getRow()
 throws java.sql.SQLException
JDBC 2.0 Get the current row number.

Specified by:
getRow in interface java.sql.ResultSet
Returns:
the current row number
Throws:
java.sql.SQLException -  

getShort

public short getShort(int column)
 throws java.sql.SQLException
Get the value of a column in the current row as a Java short.

Specified by:
getShort in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a short
Throws:
java.sql.SQLException. -  

getShort

public short getShort(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a Java short.

Specified by:
getShort in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a short
Throws:
java.sql.SQLException. -  

getStatement

public java.sql.Statement getStatement()
 throws java.sql.SQLException
JDBC 2.0 Returns the Statement that produced this ResultSet object.

Specified by:
getStatement in interface java.sql.ResultSet
Returns:
the Statement that generated this result set
Throws:
java.sql.SQLException - this is never thrown

getString

public java.lang.String getString(int column)
 throws java.sql.SQLException
Get the value of a column in the current row as a Java String.

Specified by:
getString in interface java.sql.ResultSet
Parameters:
col - the column number of the desired column
Returns:
the column as a Java String
Throws:
java.sql.SQLException -  

getString

public java.lang.String getString(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a Java String.

Specified by:
getString in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a Java String
Throws:
java.sql.SQLException -  

getTime

public java.sql.Time getTime(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a java.sql.Time object.

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a Time object
Throws:
java.sql.SQLException - thrown

getTime

public java.sql.Time getTime(int column)
 throws java.sql.SQLException
Gets the value of a column in the current row as a java.sql.Time object.

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a Java String
Throws:
java.sql.SQLException. -  

getTime

public java.sql.Time getTime(java.lang.String cname,
 java.util.Calendar cal)
 throws java.sql.SQLException
Gets the value of a column in the current row as a java.sql.Time object.

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
cal - the Calendar to use in creating the Time object
Returns:
the column as a Time object
Throws:
java.sql.SQLException. -  

getTime

public java.sql.Time getTime(int column,
 java.util.Calendar cal)
 throws java.sql.SQLException
Gets the value of a column in the current row as a java.sql.Time object.

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
cal - the Calendar to use in creating the Time object
Returns:
the column as a Java String
Throws:
java.sql.SQLException. -  

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String cname)
 throws java.sql.SQLException
Gets the value of a column in the current row as a java.sql.Timestamp object.

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as a Timestamp
Throws:
java.sql.SQLException -  

getTimestamp

public java.sql.Timestamp getTimestamp(int column)
 throws java.sql.SQLException
Gets the value of a column in the current row as a java.sql.Timestamp object.

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as a Timestamp
Throws:
java.sql.SQLException. -  

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String cname,
 java.util.Calendar cal)
 throws java.sql.SQLException
Gets the value of a column in the current row as a java.sql.Timestamp object.

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
cal - this is currently ignored
Returns:
the column as a Timestamp
Throws:
java.sql.SQLException. -  

getTimestamp

public java.sql.Timestamp getTimestamp(int column,
 java.util.Calendar cal)
 throws java.sql.SQLException
Gets the value of a column in the current row as a java.sql.Timestamp object.

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
c - this is currently ignored
Returns:
the column as a Timestamp
Throws:
java.sql.SQLException. -  

getType

public int getType()
 throws java.sql.SQLException
JDBC 2.0 Returns the type of this result set.

Specified by:
getType in interface java.sql.ResultSet
Returns:
the result set type
Throws:
java.sql.SQLException - this is never thrown

getUnicodeStream

public java.io.InputStream getUnicodeStream(int column)
 throws java.sql.SQLException
Deprecated. use getCharacterStream()
Not supported by the RealSQL-JDBC driver.

Gets the value of a column in the current row as a stream of Unicode characters.

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
column - the number of the desired column
Returns:
the column as an InputStream
Throws:
java.sql.SQLException. -  

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String cname)
 throws java.sql.SQLException
Deprecated. use the getCharacterStream()
Not supported by the RealSQL-JDBC driver.

Gets the value of a column in the current row as a stream of Unicode characters.

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
cname - the name of the desired column
Returns:
the column as an InputStream
Throws:
java.sql.SQLException. -  

getWarnings

public java.sql.SQLWarning getWarnings()
 throws java.sql.SQLException
The first warning reported by calls on this ResultSet is returned.

Specified by:
getWarnings in interface java.sql.ResultSet
Returns:
null
Throws:
java.sql.SQLException - this is never thrown

insertRow

public void insertRow()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Inserts the contents of the insert row into the result set and the database.

Specified by:
insertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException -  

isAfterLast

public boolean isAfterLast()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 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 result set is positioned after the last row
Throws:
java.sql.SQLException -  

isBeforeFirst

public boolean isBeforeFirst()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 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 result set is positioned before the first row
Throws:
java.sql.SQLException - this is never thrown

isFirst

public boolean isFirst()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 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 current row is the first row
Throws:
java.sql.SQLException - this is never thrown

isLast

public boolean isLast()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 JDBC 2.0 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 current row is the first row
Throws:
java.sql.SQLException - this is never thrown

last

public boolean last()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

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

Specified by:
last in interface java.sql.ResultSet
Throws:
java.sql.SQLException - a database error occurred or the result set TYPE_FORWARD_ONLY

moveToCurrentRow

public void moveToCurrentRow()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Moves the cursor to the remembered cursor position, usually the current row.

Specified by:
moveToCurrentRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException -  

moveToInsertRow

public void moveToInsertRow()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Moves the cursor to the insert row.

Specified by:
moveToInsertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException -  

next

public boolean next()
 throws java.sql.SQLException
Moves to the next row of data for processing. If there are no more rows to be processed, then it will return false.

Specified by:
next in interface java.sql.ResultSet
Returns:
true if there are results to be processed else false.
Throws:
java.sql.SQLException - thrown if a read error occurs

previous

public boolean previous()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

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

Specified by:
previous in interface java.sql.ResultSet
Returns:
true if there are results to be processed, false otherwise
Throws:
java.sql.SQLException -  

refreshRow

public void refreshRow()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Refreshes the current row with its most recent value in the database.

This method is a NO-OP. Implementing classes should extend this.

Specified by:
refreshRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException -  

relative

public boolean relative(int count)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Moves the cursor a relative number of rows, either positive or negative.

Specified by:
relative in interface java.sql.ResultSet
Parameters:
count - the number of rows to move forward
Returns:
true if the result set remains on a row, false otherwise
Throws:
java.sql.SQLException -  

rowDeleted

public boolean rowDeleted()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Indicates whether a row has been deleted.

Specified by:
rowDeleted in interface java.sql.ResultSet
Returns:
true if row has been deleted; else false.
Throws:
java.sql.SQLException -  

rowInserted

public boolean rowInserted()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Indicates whether the current row has had an insertion.

Specified by:
rowInserted in interface java.sql.ResultSet
Returns:
true if row inserted; else false.
Throws:
java.sql.SQLException -  

rowUpdated

public boolean rowUpdated()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Indicates whether the current row has been updated.

Specified by:
rowUpdated in interface java.sql.ResultSet
Returns:
true if row updated; else false.
Throws:
java.sql.SQLException -  

setFetchDirection

public void setFetchDirection(int dir)
 throws java.sql.SQLException
JDBC 2.0 Gives a hint as to the direction in which the rows in this result set will be processed.

If the direction is not FETCH_FORWARD the method throws an exception.

Specified by:
setFetchDirection in interface java.sql.ResultSet
Parameters:
dir - the direction
Throws:
java.sql.SQLException - thrown if invalid argument value passed.

setFetchSize

public void setFetchSize(int unused)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 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.

Specified by:
setFetchSize in interface java.sql.ResultSet
Parameters:
unused - the suggested fetch size
Throws:
java.sql.SQLException -  

updateAsciiStream

public void updateAsciiStream(int col,
 java.io.InputStream is,
 int len)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with an ascii stream value.

Specified by:
updateAsciiStream in interface java.sql.ResultSet
Parameters:
column - the column number for the update
is - the stream to update the column with
len - the length of the stream
Throws:
java.sql.SQLException -  

updateAsciiStream

public void updateAsciiStream(java.lang.String cname,
 java.io.InputStream is,
 int len)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with an ascii stream value.

Specified by:
updateAsciiStream in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
is - the stream to update the column with
len - the length of the stream
Throws:
java.sql.SQLException -  

updateBigDecimal

public void updateBigDecimal(int column,
 java.math.BigDecimal d)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a BigDecimal value.

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Parameters:
column - the column number for the update
d - the value to use in the update
Throws:
java.sql.SQLException -  

updateBigDecimal

public void updateBigDecimal(java.lang.String cname,
 java.math.BigDecimal d)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a BigDecimal value.

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
d - the value to use in the update
Throws:
java.sql.SQLException -  

updateBinaryStream

public void updateBinaryStream(int column,
 java.io.InputStream is,
 int len)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a binary stream value.

Specified by:
updateBinaryStream in interface java.sql.ResultSet
Parameters:
column - the column number for the update
is - the stream to update the column with
len - the length of the stream
Throws:
java.sql.SQLException - a database error occurred

updateBinaryStream

public void updateBinaryStream(java.lang.String cname,
 java.io.InputStream is,
 int len)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a binary stream value.

Specified by:
updateBinaryStream in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
is - the stream to update the column with
len - the length of the stream
Throws:
java.sql.SQLException - a database error occurred

updateBlob

public void updateBlob(int column,
 java.sql.Blob b)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Performs an in-place modification of a Blob column

.

Parameters:
column - the name of the column to update
b - the Blob value
Throws:
java.sql.SQLException -  

updateBoolean

public void updateBoolean(int column,
 boolean b)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a boolean value.

Specified by:
updateBoolean in interface java.sql.ResultSet
Parameters:
column - the column number for the update
b - the value to use in the update
Throws:
java.sql.SQLException -  

updateBoolean

public void updateBoolean(java.lang.String cname,
 boolean b)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a boolean value.

Specified by:
updateBoolean in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
b - the value to use in the update
Throws:
java.sql.SQLException -  

updateByte

public void updateByte(int column,
 byte b)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a byte value.

Specified by:
updateByte in interface java.sql.ResultSet
Parameters:
column - the column number for the update
b - the value to use in the update
Throws:
java.sql.SQLException -  

updateByte

public void updateByte(java.lang.String cname,
 byte b)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a byte value.

Specified by:
updateByte in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
b - the value to use in the update
Throws:
java.sql.SQLException -  

updateBytes

public void updateBytes(int column,
 byte[] data)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a byte array value.

Specified by:
updateBytes in interface java.sql.ResultSet
Parameters:
column - the column number for the update
data - the value to use in the update
Throws:
java.sql.SQLException -  

updateBytes

public void updateBytes(java.lang.String cname,
 byte[] b)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a byte array value.

Specified by:
updateBytes in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
b - the value to use in the update
Throws:
java.sql.SQLException -  

updateCharacterStream

public void updateCharacterStream(int column,
 java.io.Reader in,
 int len)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a character stream value.

Specified by:
updateCharacterStream in interface java.sql.ResultSet
Parameters:
column - the column number for the update
in - the reader to use for the update
len - the length of the stream
Throws:
java.sql.SQLException -  

updateCharacterStream

public void updateCharacterStream(java.lang.String cname,
 java.io.Reader r,
 int len)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a character stream value.

Specified by:
updateCharacterStream in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
r - the reader to use for the update
len - the length of the stream
Throws:
java.sql.SQLException -  

updateDate

public void updateDate(int column,
 java.sql.Date d)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Date value.

Specified by:
updateDate in interface java.sql.ResultSet
Parameters:
column - the column number for the update
d - the value to use in the update
Throws:
java.sql.SQLException -  

updateDate

public void updateDate(java.lang.String cname,
 java.sql.Date d)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Date value.

Specified by:
updateDate in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
d - the value to use in the update
Throws:
java.sql.SQLException -  

updateDouble

public void updateDouble(int column,
 double d)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Double value.

Specified by:
updateDouble in interface java.sql.ResultSet
Parameters:
column - the column number for the update
d - the value to use in the update
Throws:
java.sql.SQLException - a database error occurred

updateDouble

public void updateDouble(java.lang.String cname,
 double d)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Double value.

Specified by:
updateDouble in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
d - the value to use in the update
Throws:
java.sql.SQLException - a database error occurred

updateFloat

public void updateFloat(int column,
 float f)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a float value.

Specified by:
updateFloat in interface java.sql.ResultSet
Parameters:
column - the column number for the update
f - the value to use in the update
Throws:
java.sql.SQLException -  

updateFloat

public void updateFloat(java.lang.String cname,
 float f)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a float value.

Specified by:
updateFloat in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
f - the value to use in the update
Throws:
java.sql.SQLException -  

updateInt

public void updateInt(int column,
 int x)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a integer value.

Specified by:
updateInt in interface java.sql.ResultSet
Parameters:
column - the column number for the update
x - the value to use in the update
Throws:
java.sql.SQLException -  

updateInt

public void updateInt(java.lang.String cname,
 int x)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a integer value.

Specified by:
updateInt in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
x - the value to use in the update
Throws:
java.sql.SQLException -  

updateLong

public void updateLong(int column,
 long l)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a long value.

Specified by:
updateLong in interface java.sql.ResultSet
Parameters:
column - the column number for the update
l - the value to use in the update
Throws:
java.sql.SQLException -  

updateLong

public void updateLong(java.lang.String cname,
 long l)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a long value.

Specified by:
updateLong in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
l - the value to use in the update
Throws:
java.sql.SQLException -  

updateNull

public void updateNull(int column)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a null value.

Specified by:
updateNull in interface java.sql.ResultSet
Parameters:
column - the column number for the update
Throws:
java.sql.SQLException -  

updateNull

public void updateNull(java.lang.String cname)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a null value.

Specified by:
updateNull in interface java.sql.ResultSet
Parameters:
cname - the name of the column to be updated
Throws:
java.sql.SQLException -  

updateObject

public void updateObject(int column,
 java.lang.Object ob)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Object value.

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
column - the column number for the update
ob - the value to use in the update
Throws:
java.sql.SQLException -  

updateObject

public void updateObject(int column,
 java.lang.Object ob,
 int scale)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Object value.

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
column - the column number for the update
ob - the value to use in the update
scale - the scale to use for numeric types
Throws:
java.sql.SQLException -  

updateObject

public void updateObject(java.lang.String cname,
 java.lang.Object ob)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Object value.

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
ob - the value to use in the update
Throws:
java.sql.SQLException -  

updateObject

public void updateObject(java.lang.String cname,
 java.lang.Object ob,
 int scale)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Object value.

Specified by:
updateObject in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
ob - the value to use in the update
scale - the scale for numeric types
Throws:
java.sql.SQLException -  

updateRow

public void updateRow()
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates the underlying database with the new contents of the current row.

Specified by:
updateRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException -  

updateShort

public void updateShort(int column,
 short s)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a short value.

Specified by:
updateShort in interface java.sql.ResultSet
Parameters:
column - the column number for the update
s - the value to use in the update
Throws:
java.sql.SQLException -  

updateShort

public void updateShort(java.lang.String cname,
 short s)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Object value.

Specified by:
updateShort in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
s - the value to use in the update
Throws:
java.sql.SQLException -  

updateString

public void updateString(int column,
 java.lang.String str)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a String value.

Specified by:
updateString in interface java.sql.ResultSet
Parameters:
column - the column number for the update
str - the value to use in the update
Throws:
java.sql.SQLException -  

updateString

public void updateString(java.lang.String cname,
 java.lang.String str)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a String value.

Specified by:
updateString in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
str - the value to use in the update
Throws:
java.sql.SQLException -  

updateTime

public void updateTime(int column,
 java.sql.Time t)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Time value.

Specified by:
updateTime in interface java.sql.ResultSet
Parameters:
column - the column number for the update
t - the value to use in the update
Throws:
java.sql.SQLException -  

updateTime

public void updateTime(java.lang.String cname,
 java.sql.Time t)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Time value.

Specified by:
updateTime in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
t - the value to use in the update
Throws:
java.sql.SQLException -  

updateTimestamp

public void updateTimestamp(int column,
 java.sql.Timestamp ts)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Timestamp value.

Specified by:
updateTimestamp in interface java.sql.ResultSet
Parameters:
column - the column number for the update
ts - the value to use in the update
Throws:
java.sql.SQLException -  

updateTimestamp

public void updateTimestamp(java.lang.String cname,
 java.sql.Timestamp ts)
 throws java.sql.SQLException
Not supported by the RealSQL-JDBC driver.

JDBC 2.0 Updates a column with a Time value.

Specified by:
updateTimestamp in interface java.sql.ResultSet
Parameters:
column - the name of the column to update
ts - the value to use in the update
Throws:
java.sql.SQLException -  

wasNull

public boolean wasNull()
 throws java.sql.SQLException
Reports whether the last column read had a value of SQL NULL.

Specified by:
wasNull in interface java.sql.ResultSet
Returns:
true if the column was null; else false.
Throws:
java.sql.SQLException -  

complete

public void complete()
Indicates that the retrieval of all rows in the ResultSet is complete.

addWarning

protected void addWarning(java.sql.SQLWarning msg)
Adds a new warning message to the SQLWarnings chain.

Parameters:
msg - new SQLWarning exception

getRowCount

protected int getRowCount()
Get the update count, this is only valid if the last SQL statement executed caused an update to occur on the database.

Returns:
update count.

isClosed

protected boolean isClosed()

RealityV15.0Comment on this topic