Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

vortex.sql
Class vortexResultSet

java.lang.Object
  |
  +--vortex.sql.vortexResultSet
All Implemented Interfaces:
java.sql.ResultSet
public class vortexResultSet
extends java.lang.Object
implements java.sql.ResultSet

This class implements the ResultSet for JDBC interface The class is designed to hold the results of database queries.

See Also:
ResultSet

Field Summary
 
Fields inherited from interface java.sql.ResultSet
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE
 
Constructor Summary
vortexResultSet(vortexRecord red, java.sql.Statement stmt)
          Constructs a new result set object
 
Method Summary
 boolean absolute(int row)
          Moves the cursor to the given row number in the result set.
 void afterLast()
          Not supported by VORTEXjdbc.
 void beforeFirst()
          Not supported by VORTEXjdbc.
 void cancelRowUpdates()
          Cancels the updates made to a row.
 void clearWarnings()
          Clear the warning chain.
 void close()
          Close a result set.
 void deleteRow()
          Deletes the current row from the result set and the underlying database.
protected  void finalize()
           
 int findColumn(java.lang.String name)
          Given a column name, this method returns the column index for that name.
 boolean first()
          Moves the cursor to the first row in the result set.
 java.sql.Array getArray(int column)
          Not supported by VORTEXjdbc.
 java.sql.Array getArray(java.lang.String name)
          Not supported by VORTEXjdbc.
 java.io.InputStream getAsciiStream(int column)
          Get the value of a column in the current row as a Java AsciiStream.
 java.io.InputStream getAsciiStream(java.lang.String name)
          Very large ascii values in a LONGVARCHAR column can be read in small chunks from a java.io.InputStream.
 java.math.BigDecimal getBigDecimal(int column)
          Gets 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)
          Get the value of a column in the current row as a Java BigDecimal.
 java.math.BigDecimal getBigDecimal(java.lang.String name)
          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 name, int scale)
          Retrieve the column value as a numeric based on column name
 java.io.InputStream getBinaryStream(int column)
          Get the value of a column in the current row as a Java BinaryStream.
 java.io.InputStream getBinaryStream(java.lang.String name)
          Very large binary values in a LONGVARBINARY column can be read in small chunks from a java.io.InputStream.
 java.sql.Blob getBlob(int column)
          Not supported by VORTEXjdbc.
 java.sql.Blob getBlob(java.lang.String name)
          Not supported by VORTEXjdbc.
 boolean getBoolean(int column)
          Get the value of a column in the current row as a Java boolean.
 boolean getBoolean(java.lang.String name)
          Retrieve the column value as a boolean based on column name
 byte getByte(int column)
          Get the value of a column in the current row as a Java byte.
 byte getByte(java.lang.String name)
          Get the value of a column in the current row as a Java byte.
 byte[] getBytes(int column)
          Get the value of a column in the current row as a Java byte array.
 byte[] getBytes(java.lang.String name)
          Retrieve the column value as a byte array based on column name
 java.io.Reader getCharacterStream(int column)
          Not supported by VORTEXjdbc.
 java.io.Reader getCharacterStream(java.lang.String name)
          Not supported by VORTEXjdbc.
 java.sql.Clob getClob(int column)
          Not supported by VORTEXjdbc.
 java.sql.Clob getClob(java.lang.String name)
          Not supported by VORTEXjdbc.
 int getConcurrency()
          Returns the concurrency mode of this result set.
 java.lang.String getCursorName()
          Return a cursor name
 java.sql.Date getDate(int column)
          Get the value of a column in the current row as a Java date.
 java.sql.Date getDate(int column, java.util.Calendar c)
          Get the value of a column in the current row as a Java date.
 java.sql.Date getDate(java.lang.String name)
          Retrieve the column value as a date based on column name
 java.sql.Date getDate(java.lang.String name, java.util.Calendar c)
          Get the value of a column in the current row as a Java date.
 double getDouble(int column)
          Get the value of a column in the current row as a Java double.
 double getDouble(java.lang.String name)
          Retrieve the column value as a double based on column name
 int getFetchDirection()
          Returns the fetch direction for this result set.
 int getFetchSize()
          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 name)
          Retrieve the column value as a float based on column name
 int getInt(int column)
          Get the value of a column in the current row as a Java int.
 int getInt(java.lang.String name)
          Retreive the column value as a int based on column name
 long getLong(int column)
          Get the value of a column in the current row as a Java long.
 long getLong(java.lang.String name)
          Retrieve the column value as a long based on column name
 java.sql.ResultSetMetaData getMetaData()
          return meta-data on a result set.
 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, int type)
          Get the value of a column in the current row as a Java Object.
 java.lang.Object getObject(int column, int type, int scale)
          Get the value of a column in the current row as a Java Object.
 java.lang.Object getObject(int column, java.util.Map map)
          Not supported by VORTEXjdbc.
 java.lang.Object getObject(java.lang.String name)
          Same as above, except returning the default SQL type
 java.lang.Object getObject(java.lang.String name, int type)
          Get the value of a column as an object; an integral value is returned as its java.lang equivalent object; a LONGVARCHAR or LONGVARBINARY value is returned as a java.io.InputStream.
 java.lang.Object getObject(java.lang.String name, int type, int scale)
          Get the value of a column as an object; an integral value is returned as its java.lang equivalent object; a LONGVARCHAR or LONGVARBINARY value is returned as a java.io.InputStream.
 java.lang.Object getObject(java.lang.String name, java.util.Map map)
          Returns the value of a column in the current row as a Java object.
 java.sql.Ref getRef(int column)
          Not supported by VORTEXjdbc.
 java.sql.Ref getRef(java.lang.String name)
          Not supported by VORTEXjdbc.
 int getRow()
          Retrieves the current row number.
 short getShort(int column)
          Get the value of a column in the current row as a Java short.
 short getShort(java.lang.String name)
          Retrieve the column value as a short based on column name
 java.sql.Statement getStatement()
          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 name)
          Get the value of a column in the current row as a Java String.
 java.sql.Time getTime(int column)
          Get the value of a column in the current row as a Java time.
 java.sql.Time getTime(int column, java.util.Calendar c)
          Get the value of a column in the current row as a Java time.
 java.sql.Time getTime(java.lang.String name)
          Retrieve the column value as a time based on column name
 java.sql.Time getTime(java.lang.String name, java.util.Calendar c)
          Get the value of a column in the current row as a Java time.
 java.sql.Timestamp getTimestamp(int column)
          Get the value of a column in the current row as a Java timestamp.
 java.sql.Timestamp getTimestamp(int column, java.util.Calendar c)
          Get the value of a column in the current row as a Java timestamp.
 java.sql.Timestamp getTimestamp(java.lang.String name)
          Retrieve the column value as a timestamp based on column name
 java.sql.Timestamp getTimestamp(java.lang.String name, java.util.Calendar c)
          Get the value of a column in the current row as a Java timestamp.
 int getType()
          Returns the type of this result set.
 java.io.InputStream getUnicodeStream(int column)
          Get the value of a column in the current row as a Java UnicodeStream.
 java.io.InputStream getUnicodeStream(java.lang.String name)
          Very large unicode values in a LONGVARCHAR column can be read in small chunks from a java.io.InputStream.
 java.net.URL getURL(int column)
          Get the value of a column as a URL object.
 java.net.URL getURL(java.lang.String name)
          Get the value of a column as a URL object.
 java.sql.SQLWarning getWarnings()
          Return warning message
 void insertRow()
          Inserts the contents of the insert row into the result set and the database.
 boolean isAfterLast()
          Not supported by VORTEXjdbc.
 boolean isBeforeFirst()
          Not supported by VORTEXjdbc.
 boolean isFirst()
          Indicates whether the cursor is on the first row of the result set.
 boolean isLast()
          Not supported by VORTEXjdbc.
 boolean isNull(int column)
          JDBC specification method to determine if a column is null.
 boolean isNull(java.lang.String name)
          column is NULL?
 boolean last()
          Moves the cursor to the last row in the result set.
 void moveToCurrentRow()
          Moves the cursor to the remembered cursor position, usually the current row.
 void moveToInsertRow()
          Moves the cursor to the insert row.
 boolean next()
          Move to the next row of record, return true if there is one
 boolean previous()
          Moves the cursor to the previous row in the result set.
 void refreshRow()
          Not supported by VORTEXjdbc.
 boolean relative(int rows)
          Moves the cursor a relative number of rows, either positive or negative.
 boolean rowDeleted()
          Not supported by VORTEXjdbc.
 boolean rowInserted()
          Not supported by VORTEXjdbc.
 boolean rowUpdated()
          Not supported by VORTEXjdbc.
 void setFetchDirection(int direction)
          Not supported by VORTEXjdbc.
 void setFetchSize(int rows)
          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.
 void updateArray(int column, java.sql.Array x)
          Updates a column with an array value.
 void updateArray(java.lang.String name, java.sql.Array x)
          Updates a column with an array value.
 void updateAsciiStream(int column, java.io.InputStream x, int length)
          Updates a column with an ascii stream value.
 void updateAsciiStream(java.lang.String name, java.io.InputStream x, int length)
          Updates a column with an ascii stream value.
 void updateBigDecimal(int column, java.math.BigDecimal x)
          Updates a column with a BigDecimal value.
 void updateBigDecimal(java.lang.String name, java.math.BigDecimal x)
          Updates a column with a BigDecimal value.
 void updateBinaryStream(int column, java.io.InputStream x, int length)
          Updates a column with a binary stream value.
 void updateBinaryStream(java.lang.String name, java.io.InputStream x, int length)
          Updates a column with a binary stream value.
 void updateBlob(int column, java.sql.Blob x)
          Updates a column with a blob value.
 void updateBlob(java.lang.String name, java.sql.Blob x)
          Updates a column with a Blob value.
 void updateBoolean(int column, boolean x)
          Updates a column with a boolean value.
 void updateBoolean(java.lang.String name, boolean x)
          Updates a column with a boolean value.
 void updateByte(int column, byte x)
          Updates a column with a byte value.
 void updateByte(java.lang.String name, byte x)
          Updates a column with a byte value.
 void updateBytes(int column, byte[] x)
          Updates a column with a byte array value.
 void updateBytes(java.lang.String name, byte[] x)
          Updates a column with a byte array value.
 void updateCharacterStream(int column, java.io.Reader x, int length)
          Updates a column with a character stream value.
 void updateCharacterStream(java.lang.String name, java.io.Reader x, int length)
          Updates a column with a character stream value.
 void updateClob(int column, java.sql.Clob x)
          Updates a column with a clob value.
 void updateClob(java.lang.String name, java.sql.Clob x)
          Updates a column with a Clob value.
 void updateDate(int column, java.sql.Date x)
          Updates a column with a Date value.
 void updateDate(java.lang.String name, java.sql.Date x)
          Updates a column with a Date value.
 void updateDouble(int column, double x)
          Updates a column with a Double value.
 void updateDouble(java.lang.String name, double x)
          Updates a column with a Double value.
 void updateFloat(int column, float x)
          Updates a column with a float value.
 void updateFloat(java.lang.String name, float x)
          Updates a column with a float value.
 void updateInt(int column, int x)
          Updates a column with a integer value.
 void updateInt(java.lang.String name, int x)
          Updates a column with a integer value.
 void updateLong(int column, long x)
          Updates a column with a long value.
 void updateLong(java.lang.String name, long x)
          Updates a column with a long value.
 void updateNull(int column)
          Give a nullable column a null value.
 void updateNull(java.lang.String name)
          Give a nullable column a null value.
 void updateObject(int column, java.lang.Object x)
          Updates a column with an Object value.
 void updateObject(int column, java.lang.Object x, int scale)
          Updates a column with an Object value.
 void updateObject(java.lang.String name, java.lang.Object x)
          Updates a column with an Object value.
 void updateObject(java.lang.String name, java.lang.Object x, int scale)
          Updates a column with an Object value.
 void updateRef(int column, java.sql.Ref x)
          Updates a column with a Ref value.
 void updateRef(java.lang.String name, java.sql.Ref x)
          Updates a column with a Ref value.
 void updateRow()
          Updates the underlying database with the new contents of the current row.
 void updateShort(int column, short x)
          Updates a column with a short value.
 void updateShort(java.lang.String name, short x)
          Updates a column with a short value.
 void updateString(int column, java.lang.String x)
          Updates a column with a String value.
 void updateString(java.lang.String name, java.lang.String x)
          Updates a column with a String value.
 void updateTime(int column, java.sql.Time x)
          Updates a column with a Time value.
 void updateTime(java.lang.String name, java.sql.Time x)
          Updates a column with a Time value.
 void updateTimestamp(int column, java.sql.Timestamp x)
          Updates a column with a Timestamp value.
 void updateTimestamp(java.lang.String name, java.sql.Timestamp x)
          Updates a column with a Timestamp value.
 boolean wasNull()
          JDBC specification method to determine if the last column read was null.
 
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

vortexResultSet

public vortexResultSet(vortexRecord red,
                       java.sql.Statement stmt)
                throws java.sql.SQLException
Constructs a new result set object

Parameters:
red - the vortexRecord returned from a previously executed query
Throws:
java.sql.SQLException - Not used.
Method Detail

next

public boolean next()
             throws java.sql.SQLException
Move to the next row of record, return true if there is one

Specified by:
next in interface java.sql.ResultSet
Returns:
true if there are more rows to process, otherwise false
Throws:
java.sql.SQLException - thrown if an error occurs during processing
See Also:
ResultSet.next()

isNull

public boolean isNull(int column)
               throws java.sql.SQLException
JDBC specification method to determine if a column is null.

Parameters:
column - the column being tested for nullness
Returns:
true if the column is null, false otherwise
Throws:
java.sql.SQLException - thrown if column out of range
Since:
JDBC 1.01.

wasNull

public boolean wasNull()
                throws java.sql.SQLException
JDBC specification method to determine if the last column read was null.

Specified by:
wasNull in interface java.sql.ResultSet
Returns:
true if the column was null, false otherwise
Throws:
java.sql.SQLException - thrown if column out of range
See Also:
ResultSet.wasNull()

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException
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

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException
Not supported by VORTEXjdbc. 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

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException
Not supported by VORTEXjdbc. 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

isFirst

public boolean isFirst()
                throws java.sql.SQLException
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

isLast

public boolean isLast()
               throws java.sql.SQLException
Not supported by VORTEXjdbc. Indicates whether the cursor is on the last row of the result set. Note: Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in 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

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException
Not supported by VORTEXjdbc. 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 the result set type is TYPE_FORWARD_ONLY

afterLast

public void afterLast()
               throws java.sql.SQLException
Not supported by VORTEXjdbc. 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 the result set type is TYPE_FORWARD_ONLY

first

public boolean first()
              throws java.sql.SQLException
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 the result set type is TYPE_FORWARD_ONLY

last

public boolean last()
             throws java.sql.SQLException
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 the result set type is TYPE_FORWARD_ONLY

getRow

public int getRow()
           throws java.sql.SQLException
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 error occurs

absolute

public boolean absolute(int row)
                 throws java.sql.SQLException
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. The first row is row 1, the second is row 2, and so on. If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) indicates the next-to-last row, and so on. 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
Parameters:
row - - the row number
Returns:
true if the cursor is on the result set; false otherwise
Throws:
java.sql.SQLException - thrown if row is 0 or result set type is TYPE_FORWARD_ONLY.

relative

public boolean relative(int rows)
                 throws java.sql.SQLException
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 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
Parameters:
rows - - the number of rows
Returns:
true if the cursor is on a row; false otherwise
Throws:
java.sql.SQLException - thrown if there is no current row or the result set type is TYPE_FORWARD_ONLY

previous

public boolean previous()
                 throws java.sql.SQLException
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 call previous() 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 not
Throws:
java.sql.SQLException - thrown if there is no current row or the result set type is TYPE_FORWARD_ONLY

getArray

public java.sql.Array getArray(int column)
                        throws java.sql.SQLException
Not supported by VORTEXjdbc. Gets a SQL ARRAY value from the current row of this ResultSet object.

Specified by:
getArray in interface java.sql.ResultSet
Parameters:
column - the column to fetch
Returns:
an Array object representing the SQL ARRAY value in the specified column
Throws:
java.sql.SQLException

getArray

public java.sql.Array getArray(java.lang.String name)
                        throws java.sql.SQLException
Not supported by VORTEXjdbc. Gets a SQL ARRAY value from the current row of this ResultSet object.

Specified by:
getArray in interface java.sql.ResultSet
Returns:
an Array object representing the SQL ARRAY value in the specified column
Throws:
java.sql.SQLException

getBlob

public java.sql.Blob getBlob(int column)
                      throws java.sql.SQLException
Not supported by VORTEXjdbc. Gets a BLOB value in the current row of this ResultSet object.

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

getBlob

public java.sql.Blob getBlob(java.lang.String name)
                      throws java.sql.SQLException
Not supported by VORTEXjdbc. Gets a BLOB value in the current row of this ResultSet object.

Specified by:
getBlob in interface java.sql.ResultSet
Parameters:
name - the column to fetch
Returns:
a Blob object representing the SQL BLOB value in the specified column
Throws:
java.sql.SQLException

getClob

public java.sql.Clob getClob(int column)
                      throws java.sql.SQLException
Not supported by VORTEXjdbc. Gets a CLOB value in the current row of this ResultSet object.

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

getClob

public java.sql.Clob getClob(java.lang.String name)
                      throws java.sql.SQLException
Not supported by VORTEXjdbc. Gets a CLOB value in the current row of this ResultSet object.

Specified by:
getClob in interface java.sql.ResultSet
Parameters:
name - the column to fetch
Returns:
a Clob object representing the SQL CLOB value in the specified column
Throws:
java.sql.SQLException

getCharacterStream

public java.io.Reader getCharacterStream(int column)
                                  throws java.sql.SQLException
Not supported by VORTEXjdbc. 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 column to fetch
Returns:
the value in the specified column as a java.io.Reader
Throws:
java.sql.SQLException

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String name)
                                  throws java.sql.SQLException
Not supported by VORTEXjdbc. Gets the value of a column in the current row as a java.io.Reader.

Specified by:
getCharacterStream in interface java.sql.ResultSet
Returns:
the value in the specified column as a java.io.Reader
Throws:
java.sql.SQLException

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:
column - the column being retrieved
Returns:
the column as a String
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getString(int)

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:
column - 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 - thrown for invalid columns or bad rows

getBoolean

public boolean getBoolean(int column)
                   throws java.sql.SQLException
Get the value of a column in the current row as a Java boolean. Interprets "", null, and "0" as false, others as true.

Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
column - the column for which the value is being retrieved
Returns:
false for "", null, or "0"; true otherwise
Throws:
java.sql.SQLException - a sure sign of the apocolypse
See Also:
ResultSet.getBoolean(int)

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 column being retrieved
Returns:
the named column as a short
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getShort(int)

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 column being retrieved
Returns:
the named column as an integer
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getInt(int)

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 column being retrieved
Returns:
the named column as a short
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getLong(int)

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 column being retrieved
Returns:
the named column as a float
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getFloat(int)

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 column being retrieved
Returns:
the named column as a double
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getDouble(int)

getBigDecimal

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

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
column - the column being retrieved
scale - how many decimal digits after the floating point to maintain
Returns:
the named column as a Numeric
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getBigDecimal(int, int)

getBytes

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

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
column - the column being retrieved
Returns:
a byte array that is the value of the column
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getBytes(int)

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

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
column - the column being retrieved
Returns:
the date value for the column
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getDate(int)

getDate

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

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
column - the column being retrieved
Returns:
the date value for the column
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getDate(int)

getDate

public java.sql.Date getDate(java.lang.String name,
                             java.util.Calendar c)
                      throws java.sql.SQLException
Get the value of a column in the current row as a Java date.

Specified by:
getDate in interface java.sql.ResultSet
Returns:
the date value for the column
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getDate(int)

getTime

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

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
column - the column being retrieved
Returns:
the column as a java.sql.Time object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getTime(int)

getTime

public java.sql.Time getTime(int column,
                             java.util.Calendar c)
                      throws java.sql.SQLException
Get the value of a column in the current row as a Java time.

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
c - the calendar
Returns:
the column as a java.sql.Time object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getTime(int)

getTime

public java.sql.Time getTime(java.lang.String name,
                             java.util.Calendar c)
                      throws java.sql.SQLException
Get the value of a column in the current row as a Java time.

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
name - the column name to fetch
c - the calendar
Returns:
the column as a java.sql.Time object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getTime(int)

getTimestamp

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

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
column - the column being retrieved
Returns:
the column as a java.sql.Timestamp object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getTimestamp(int)

getTimestamp

public java.sql.Timestamp getTimestamp(int column,
                                       java.util.Calendar c)
                                throws java.sql.SQLException
Get the value of a column in the current row as a Java timestamp.

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
column - the column being retrieved
Returns:
the column as a java.sql.Timestamp object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getTimestamp(int)

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String name,
                                       java.util.Calendar c)
                                throws java.sql.SQLException
Get the value of a column in the current row as a Java timestamp.

Specified by:
getTimestamp in interface java.sql.ResultSet
Returns:
the column as a java.sql.Timestamp object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getTimestamp(int)

getAsciiStream

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

Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
column - the column being retrieved
Returns:
the column as a java.io.InputStream object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getAsciiStream(int)

getUnicodeStream

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

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
column - the column being retrieved
Returns:
the column as a java.io.InputStream object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getAsciiStream(int)

getBinaryStream

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

Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
column - the column being retrieved
Returns:
the column as a java.io.InputStream object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getBinaryStream(int)

close

public void close()
           throws java.sql.SQLException
Close a result set.

Specified by:
close in interface java.sql.ResultSet
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.close()

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException
Return a cursor name

Specified by:
getCursorName in interface java.sql.ResultSet
Returns:
"" for now
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getCursorName()

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException
return meta-data on a result set.

Specified by:
getMetaData in interface java.sql.ResultSet
Returns:
ResultSetMetaData object containing result set info
Throws:
java.sql.SQLException - thrown on error getting meta-data
See Also:
ResultSet.getMetaData()

getObject

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

Parameters:
column - the column desired
type - the SQL data type of the field
Returns:
the column specified as an Object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
See Also:
ResultSet.getObject(int)

getObject

public java.lang.Object getObject(int column,
                                  int type)
                           throws java.sql.SQLException
Get the value of a column in the current row as a Java Object. Uses a default scale of 0.

Parameters:
column - The SQL column index
type - SQL type code defined by java.sql.Types
Returns:
the column specified as an Object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows
Since:
JDBC 1.01.

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. Uses the column's default SQL type.

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
column - The SQL column index
Returns:
the column specified as an Object
Throws:
java.sql.SQLException - thrown for invalid columns or bad rows

getString

public java.lang.String getString(java.lang.String name)
                           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:
name - the column name
Returns:
the value of the column as a char string
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getString(int)

getByte

public byte getByte(java.lang.String name)
             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:
name - the column name
Returns:
the value of the column as a byte
Throws:
java.sql.SQLException - if a database-access error occurs.
See Also:
ResultSet.getByte(int)

getBoolean

public boolean getBoolean(java.lang.String name)
                   throws java.sql.SQLException
Retrieve the column value as a boolean based on column name

Specified by:
getBoolean in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the value of the column as a boolean
Throws:
java.sql.SQLException - if a database-access error occurs.
See Also:
ResultSet.getBoolean(int)

getShort

public short getShort(java.lang.String name)
               throws java.sql.SQLException
Retrieve the column value as a short based on column name

Specified by:
getShort in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the value of the column as a short
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getShort(int)

getInt

public int getInt(java.lang.String name)
           throws java.sql.SQLException
Retreive the column value as a int based on column name

Specified by:
getInt in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the value of the column as a int
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getInt(int)

getLong

public long getLong(java.lang.String name)
             throws java.sql.SQLException
Retrieve the column value as a long based on column name

Specified by:
getLong in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the value of the column as a long
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getLong(int)

getFloat

public float getFloat(java.lang.String name)
               throws java.sql.SQLException
Retrieve the column value as a float based on column name

Specified by:
getFloat in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the value of the column as a float
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getFloat(int)

getDouble

public double getDouble(java.lang.String name)
                 throws java.sql.SQLException
Retrieve the column value as a double based on column name

Specified by:
getDouble in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the value of the column as a double
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getDouble(int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String name,
                                          int scale)
                                   throws java.sql.SQLException
Retrieve the column value as a numeric based on column name

Specified by:
getBigDecimal in interface java.sql.ResultSet
Parameters:
name - the column name
scale - the scale of the numeric column
Returns:
the value of the column as a numeric
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getBigDecimal(int, int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(int column)
                                   throws java.sql.SQLException
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:
column - - 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

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String name)
                                   throws java.sql.SQLException
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:
name - column to fetch
Returns:
the column value (full precision); if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException

getBytes

public byte[] getBytes(java.lang.String name)
                throws java.sql.SQLException
Retrieve the column value as a byte array based on column name

Specified by:
getBytes in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the value of the column as a byte array
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getByte(int)

getDate

public java.sql.Date getDate(java.lang.String name)
                      throws java.sql.SQLException
Retrieve the column value as a date based on column name

Specified by:
getDate in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the value of the column as a date
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getDate(int)

getTime

public java.sql.Time getTime(java.lang.String name)
                      throws java.sql.SQLException
Retrieve the column value as a time based on column name

Specified by:
getTime in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the value of the column as a time
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getTime(int)

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String name)
                                throws java.sql.SQLException
Retrieve the column value as a timestamp based on column name

Specified by:
getTimestamp in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the value of the column as a timestamp
Throws:
java.sql.SQLException - do nothing
See Also:
ResultSet.getTimestamp(int)

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String name)
                                   throws java.sql.SQLException
Very large ascii values in a LONGVARCHAR column can be read in small chunks from a java.io.InputStream.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.

Specified by:
getAsciiStream in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the java input stream which contains the ascii value
Throws:
java.sql.SQLException - Not used

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String name)
                                     throws java.sql.SQLException
Very large unicode values in a LONGVARCHAR column can be read in small chunks from a java.io.InputStream.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the java input stream which contains the unicode value
Throws:
java.sql.SQLException - Not used

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String name)
                                    throws java.sql.SQLException
Very large binary values in a LONGVARBINARY column can be read in small chunks from a java.io.InputStream.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.

Specified by:
getBinaryStream in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the java input stream which contains the binary value
Throws:
java.sql.SQLException - Not used

getObject

public java.lang.Object getObject(java.lang.String name,
                                  int type,
                                  int scale)
                           throws java.sql.SQLException
Get the value of a column as an object; an integral value is returned as its java.lang equivalent object; a LONGVARCHAR or LONGVARBINARY value is returned as a java.io.InputStream.

Parameters:
name - the column name
type - SQL type code defined by java.sql.Types
Returns:
the parameter value; if isNull the value is null
Throws:
java.sql.SQLException - Not used
Since:
JDBC 1.01.

getObject

public java.lang.Object getObject(java.lang.String name,
                                  int type)
                           throws java.sql.SQLException
Get the value of a column as an object; an integral value is returned as its java.lang equivalent object; a LONGVARCHAR or LONGVARBINARY value is returned as a java.io.InputStream. Uses default scale of 0.

Parameters:
name - the column name
type - SQL type code defined by java.sql.Types
Returns:
the column specified as an Object
Throws:
java.sql.SQLException
Since:
JDBC 1.01.

getObject

public java.lang.Object getObject(java.lang.String name)
                           throws java.sql.SQLException
Same as above, except returning the default SQL type

Specified by:
getObject in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
the column specified as an Object
Throws:
java.sql.SQLException

getObject

public java.lang.Object getObject(int column,
                                  java.util.Map map)
                           throws java.sql.SQLException
Not supported by VORTEXjdbc. 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:
column - 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

getObject

public java.lang.Object getObject(java.lang.String name,
                                  java.util.Map map)
                           throws java.sql.SQLException
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:
map - the mapping from SQL type names to Java classes
Returns:
an object representing the SQL value
Throws:
java.sql.SQLException

getURL

public java.net.URL getURL(int column)
                    throws java.sql.SQLException
Get the value of a column as a URL object.

Specified by:
getURL in interface java.sql.ResultSet
Parameters:
column - - the first column is 1, the second is 2, ...
Returns:
the column specified as a URL Object
Throws:
java.sql.SQLException

getURL

public java.net.URL getURL(java.lang.String name)
                    throws java.sql.SQLException
Get the value of a column as a URL object.

Specified by:
getURL in interface java.sql.ResultSet
Parameters:
name - - name of the column
Returns:
the column specified as a URL Object
Throws:
java.sql.SQLException

isNull

public boolean isNull(java.lang.String name)
               throws java.sql.SQLException
column is NULL?

Parameters:
name - the column name
Returns:
true to indicate the column is NULL, otherwise return false.
Throws:
java.sql.SQLException - Not used
Since:
JDBC 1.01.

getRef

public java.sql.Ref getRef(int column)
                    throws java.sql.SQLException
Not supported by VORTEXjdbc. Gets a REF() column value from the current row.

Specified by:
getRef in interface java.sql.ResultSet
Parameters:
column - - the first column is 1, the second is 2, ...
Returns:
a Ref object representing an SQL REF value
Throws:
java.sql.SQLException - Not used

getRef

public java.sql.Ref getRef(java.lang.String name)
                    throws java.sql.SQLException
Not supported by VORTEXjdbc. Gets a REF() column value from the current row.

Specified by:
getRef in interface java.sql.ResultSet
Parameters:
name - the column name
Returns:
a Ref object representing an SQL REF value
Throws:
java.sql.SQLException - Not used

getType

public int getType()
            throws java.sql.SQLException
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

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException
Not supported by VORTEXjdbc. Gives a hint as to the direction in which the rows in this result set will be processed. The initial value is determined by the statement that produced the result set. The fetch direction may be changed at any time.

Specified by:
setFetchDirection in interface java.sql.ResultSet
Parameters:
direction - to set
Throws:
java.sql.SQLException

getFetchDirection

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

Specified by:
getFetchDirection in interface java.sql.ResultSet
Returns:
fetch direction
Throws:
java.sql.SQLException

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException
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 ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the statement that created the result set. The fetch size may be changed at any time.

Specified by:
setFetchSize in interface java.sql.ResultSet
Parameters:
rows - - the number of rows to fetch
Throws:
java.sql.SQLException

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException
Returns the fetch size for this result set.

Specified by:
getFetchSize in interface java.sql.ResultSet
Returns:
fetch size
Throws:
java.sql.SQLException

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException
Not supported by VORTEXjdbc. Indicates whether a row has been deleted. A deleted row may leave a visible "hole" in a result set. This method can be used to detect holes in a result set. The value returned depends on whether or not the result set can detect deletions.

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

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException
Not supported by VORTEXjdbc. Indicates whether the current row has had an insertion. The value returned depends on whether or not the result set can detect visible inserts.

Specified by:
rowInserted in interface java.sql.ResultSet
Returns:
true if a row has had an insertion and insertions are detected
Throws:
java.sql.SQLException

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException
Not supported by VORTEXjdbc. Indicates whether the current row has been updated. The value returned depends on whether or not the result set can detect updates.

Specified by:
rowUpdated in interface java.sql.ResultSet
Returns:
true if the row has been visibly updated by the owner or another, and updates are detected
Throws:
java.sql.SQLException

updateNull

public void updateNull(int column)
                throws java.sql.SQLException
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:
column - - the first column is 1, the second is 2, ...
Throws:
java.sql.SQLException

updateNull

public void updateNull(java.lang.String name)
                throws java.sql.SQLException
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:
name - the column name
Throws:
java.sql.SQLException

updateArray

public void updateArray(int column,
                        java.sql.Array x)
                 throws java.sql.SQLException
Updates a column with an array 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 a