MMResultSet (Teiid 6.1.0 API)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.metamatrix.jdbc
Class MMResultSet

java.lang.Object
  com.metamatrix.jdbc.WrapperImpl
      com.metamatrix.jdbc.MMResultSet

All Implemented Interfaces:: BatchFetcher, java.sql.ResultSet, java.sql.Wrapper

public class MMResultSet
extends WrapperImpl
implements ResultSet, BatchFetcher
extends WrapperImpl
implements ResultSet, BatchFetcher

The MMResultSet is the way query results are returned to the requesting client based upon a query given to the server. This abstract class that implements java.sql.ResultSet. This class represents access to results produced by any of the classes on the driver.

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`

Method Summary
`boolean`	`absolute(int row)`
`void`	`afterLast()` Moves the cursor to the end of the result set, just after the last row.
`void`	`beforeFirst()` Moves the cursor to the front of the result set, just before the first row.
`void`	`cancelRowUpdates()` Cancels the updates made to a row.
`protected void`	`checkClosed()`
`protected void`	`checkNotForwardOnly()`
`void`	`clearWarnings()`
`void`	`close()` Close this result set.
`void`	`deleteRow()`
`int`	`findColumn(java.lang.String columnName)` This method returns the integer that represents which column represents the column name parameter.
`protected int`	`findColumnIndex(java.lang.String columnName)`
`boolean`	`first()` Moves the cursor to the first row in this ResultSet object.
`protected int`	`getAbsoluteRowNumber()`
`java.sql.Array`	`getArray(int columnIndex)`
`java.sql.Array`	`getArray(java.lang.String columnLabel)`
`java.io.InputStream`	`getAsciiStream(int columnIndex)`
`java.io.InputStream`	`getAsciiStream(java.lang.String columnLabel)`
`java.math.BigDecimal`	`getBigDecimal(int columnIndex)` This method will return the value in the current at the given column index row as a java.math.BigDecimal.
`java.math.BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Deprecated.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String columnName)` This method will return the value in the current row at the given column as a java.math.BigDecimal.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String columnName, int scale)` Deprecated.
`java.io.InputStream`	`getBinaryStream(int columnIndex)` This method will read in the data byte by byte and write it to an InputStream to be returned.
`java.io.InputStream`	`getBinaryStream(java.lang.String columnName)` This method will read in the data byte by byte and write it to an InputStream to be returned.
`java.sql.Blob`	`getBlob(int columnIndex)` This method will read in a SQL BLOB value stored in the given column as a Blob object.
`java.sql.Blob`	`getBlob(java.lang.String columnName)` This method will read in a SQL BLOB value stored in the given column as a Blob object.
`boolean`	`getBoolean(int columnIndex)` This method will return the value in the current row as a boolean value
`boolean`	`getBoolean(java.lang.String columnName)` This method will return the value in the current row at the given column as a boolean value.
`byte`	`getByte(int columnIndex)` This method will return the value in the current row as a byte value.
`byte`	`getByte(java.lang.String columnName)` This method will return the value in the current row as a byte value
`byte[]`	`getBytes(int columnIndex)` This method will return the value in the current row as an array of byte values
`byte[]`	`getBytes(java.lang.String columnName)` This method will return the value in the current row as an array of byte values
`java.io.Reader`	`getCharacterStream(int columnIndex)` This method will attempt to return the value contained at the index as a java.io.Reader object.
`java.io.Reader`	`getCharacterStream(java.lang.String columnName)` This method will attempt to return the value at the designated column determined by the columName as a java.io.Reader object.
`java.sql.Clob`	`getClob(int columnIndex)`
`java.sql.Clob`	`getClob(java.lang.String columnLabel)`
`java.util.Date`	`getCompletedTimestamp()` Gets the time command execution is compleated on the server.
`int`	`getConcurrency()` Get the concurrency type for this ResultSet object.
`java.util.List`	`getCurrentRecord()` Get all values in current record in column order
`java.lang.String`	`getCursorName()` Retrieves the RequestID for the query that created this ResultSet.
`java.sql.Date`	`getDate(int columnIndex)` This method will return the value in the current row as a Date object.
`java.sql.Date`	`getDate(int columnIndex, java.util.Calendar cal)` This method will return the value in the current row as a Date object.
`java.sql.Date`	`getDate(java.lang.String columnName)` Get the column value as a Date object
`java.sql.Date`	`getDate(java.lang.String columnName, java.util.Calendar cal)` Get the Date value for the given column.
`protected java.util.Calendar`	`getDefaultCalendar()`
`double`	`getDouble(int columnIndex)` This method will return the value in the current row as a double value.
`double`	`getDouble(java.lang.String columnName)` Get a double value based on the column name.
`int`	`getFetchDirection()` Gets the direction suggested to the driver as the direction in which to fetch rows.
`int`	`getFetchSize()` Get fetch size that will be used if this result set is backed by a cursor.
`protected int`	`getFinalRowNumber()`
`float`	`getFloat(int columnIndex)` This method will return the value in the current row as a float value.
`float`	`getFloat(java.lang.String columnName)` Get a float value based on the column name.
`int`	`getHoldability()`
`int`	`getInt(int columnIndex)` This method will return the value in the current row as a int value.
`int`	`getInt(java.lang.String columnName)` Get an integer based on the column index.
`long`	`getLong(int columnIndex)` This method will return the value in the current row as a long value.
`long`	`getLong(java.lang.String columnName)` Get a long based on the column name.
`java.sql.ResultSetMetaData`	`getMetaData()` This method returns the meta data of the result set, such as the number, types and properties of this resultSets columns.
`java.io.Reader`	`getNCharacterStream(int columnIndex)`
`java.io.Reader`	`getNCharacterStream(java.lang.String columnLabel)`
`java.sql.NClob`	`getNClob(int columnIndex)`
`java.sql.NClob`	`getNClob(java.lang.String columnLabel)`
`java.lang.String`	`getNString(int columnIndex)`
`java.lang.String`	`getNString(java.lang.String columnLabel)`
`java.lang.Object`	`getObject(int column)` Get a java object based on the column index for the current row.
`java.lang.Object`	`getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map)`
`java.lang.Object`	`getObject(java.lang.String columnName)` Get a java object based on the column name.
`java.lang.Object`	`getObject(java.lang.String columnLabel, java.util.Map<java.lang.String,java.lang.Class<?>> map)`
`java.lang.Object`	`getObjectDirect(int column)` Get the value of the current row at the column index specified.
`protected int`	`getOffset()`
`java.util.List`	`getParameters()` Return a stored procedures parameters (may be null)
`long`	`getProcessingTime()` This gives the total time taken for execution of the command
`java.util.Date`	`getProcessingTimestamp()` Gets the time the command was submitted to the server.
`java.sql.Ref`	`getRef(int columnIndex)`
`java.sql.Ref`	`getRef(java.lang.String columnLabel)`
`int`	`getRow()` Get current row pointer.
`java.sql.RowId`	`getRowId(int columnIndex)`
`java.sql.RowId`	`getRowId(java.lang.String columnLabel)`
`short`	`getShort(int columnIndex)` Get a primitive short based on the column index.
`short`	`getShort(java.lang.String columnName)` Get a short based on the column name.
`java.sql.SQLXML`	`getSQLXML(int columnIndex)`
`java.sql.SQLXML`	`getSQLXML(java.lang.String columnLabel)`
`MMStatement`	`getStatement()` Retrieves the Statement object that produced this ResultSet object.
`java.lang.String`	`getString(int columnIndex)` Get a String based on the column index.
`java.lang.String`	`getString(java.lang.String columnName)` Get a string based on the column name.
`java.sql.Time`	`getTime(int columnIndex)` This method will return the value in the current row as a Time object.
`java.sql.Time`	`getTime(int columnIndex, java.util.Calendar cal)` This method will return the value in the current row as a Time object.
`java.sql.Time`	`getTime(java.lang.String columnName)` Get a java.sql.Time based on the column name.
`java.sql.Time`	`getTime(java.lang.String columnName, java.util.Calendar cal)` Get a java.sql.Time based on the column name.
`java.sql.Timestamp`	`getTimestamp(int columnIndex)` This method will return the value in the current row as a Timestamp object.
`java.sql.Timestamp`	`getTimestamp(int columnIndex, java.util.Calendar cal)` This method will return the value in the current row as a Timestamp object.
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName)` Get a java.sql.Timestamp based on the column name.
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName, java.util.Calendar cal)` Get a java.sql.Timestamp based on the column name.
`int`	`getType()`
`java.io.InputStream`	`getUnicodeStream(int columnIndex)`
`java.io.InputStream`	`getUnicodeStream(java.lang.String columnLabel)`
`protected java.util.Map`	`getUpdatedPlanDescription()`
`java.net.URL`	`getURL(int columnIndex)`
`java.net.URL`	`getURL(java.lang.String columnLabel)`
`java.sql.SQLWarning`	`getWarnings()` Retrieves the first warning reported by calls on this ResultSet object.
`protected boolean`	`hasNext()`
`void`	`insertRow()`
`boolean`	`isAfterLast()` Determines whether the cursor is after the last row in this ResultSet object.
`boolean`	`isBeforeFirst()` Determines whether the cursor is before the first row in this ResultSet object.
`boolean`	`isClosed()`
`boolean`	`isFirst()` True if current record is the first in the result set.
`boolean`	`isLast()` True if current record is the last in the result set.
`boolean`	`last()` Moves the cursor to the last row in the in this ResultSet object.
`void`	`moveToCurrentRow()` Moves the cursor to the remembered cursor position, usually the current row.
`void`	`moveToInsertRow()`
`boolean`	`next()` Move row pointer forward one row.
`boolean`	`previous()` Move row pointer backward one row.
`void`	`refreshRow()`
`boolean`	`relative(int rows)` Moves the cursor a number of rows relative to the current row in this ResultSet object.
`com.metamatrix.jdbc.BatchResults.Batch`	`requestBatch(int beginRow, int endRow)`
`boolean`	`rowDeleted()`
`boolean`	`rowInserted()`
`boolean`	`rowUpdated()`
`void`	`setFetchDirection(int direction)`
`void`	`setFetchSize(int rows)`
`void`	`setMaxFieldSize(int maxFieldSize)`
`protected void`	`setResultsData(ResultsMessage resultsMsg)`
`void`	`updateArray(int columnIndex, java.sql.Array x)`
`void`	`updateArray(java.lang.String columnLabel, java.sql.Array x)`
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x)`
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x, int length)`
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x, long length)`
`void`	`updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)`
`void`	`updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, int length)`
`void`	`updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length)`
`void`	`updateBigDecimal(int columnIndex, java.math.BigDecimal x)`
`void`	`updateBigDecimal(java.lang.String columnLabel, java.math.BigDecimal x)`
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x)`
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x, int length)`
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x, long length)`
`void`	`updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)`
`void`	`updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, int length)`
`void`	`updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length)`
`void`	`updateBlob(int columnIndex, java.sql.Blob x)`
`void`	`updateBlob(int columnIndex, java.io.InputStream inputStream)`
`void`	`updateBlob(int columnIndex, java.io.InputStream inputStream, long length)`
`void`	`updateBlob(java.lang.String columnLabel, java.sql.Blob x)`
`void`	`updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream)`
`void`	`updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)`
`void`	`updateBoolean(int columnIndex, boolean x)`
`void`	`updateBoolean(java.lang.String columnLabel, boolean x)`
`void`	`updateByte(int columnIndex, byte x)`
`void`	`updateByte(java.lang.String columnLabel, byte x)`
`void`	`updateBytes(int columnIndex, byte[] x)`
`void`	`updateBytes(java.lang.String columnLabel, byte[] x)`
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x)`
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x, int length)`
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x, long length)`
`void`	`updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, int length)`
`void`	`updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateClob(int columnIndex, java.sql.Clob x)`
`void`	`updateClob(int columnIndex, java.io.Reader reader)`
`void`	`updateClob(int columnIndex, java.io.Reader reader, long length)`
`void`	`updateClob(java.lang.String columnLabel, java.sql.Clob x)`
`void`	`updateClob(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateClob(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateDate(int columnIndex, java.sql.Date x)`
`void`	`updateDate(java.lang.String columnLabel, java.sql.Date x)`
`void`	`updateDouble(int columnIndex, double x)`
`void`	`updateDouble(java.lang.String columnLabel, double x)`
`void`	`updateFloat(int columnIndex, float x)`
`void`	`updateFloat(java.lang.String columnLabel, float x)`
`void`	`updateInt(int columnIndex, int x)`
`void`	`updateInt(java.lang.String columnLabel, int x)`
`void`	`updateLong(int columnIndex, long x)`
`void`	`updateLong(java.lang.String columnLabel, long x)`
`void`	`updateNCharacterStream(int columnIndex, java.io.Reader x)`
`void`	`updateNCharacterStream(int columnIndex, java.io.Reader x, long length)`
`void`	`updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateNClob(int columnIndex, java.sql.NClob clob)`
`void`	`updateNClob(int columnIndex, java.io.Reader reader)`
`void`	`updateNClob(int columnIndex, java.io.Reader reader, long length)`
`void`	`updateNClob(java.lang.String columnLabel, java.sql.NClob clob)`
`void`	`updateNClob(java.lang.String columnLabel, java.io.Reader reader)`
`void`	`updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)`
`void`	`updateNString(int columnIndex, java.lang.String string)`
`void`	`updateNString(java.lang.String columnLabel, java.lang.String string)`
`void`	`updateNull(int columnIndex)`
`void`	`updateNull(java.lang.String columnLabel)`
`void`	`updateObject(int columnIndex, java.lang.Object x)`
`void`	`updateObject(int columnIndex, java.lang.Object x, int scaleOrLength)`
`void`	`updateObject(java.lang.String columnLabel, java.lang.Object x)`
`void`	`updateObject(java.lang.String columnLabel, java.lang.Object x, int scaleOrLength)`
`void`	`updateRef(int columnIndex, java.sql.Ref x)`
`void`	`updateRef(java.lang.String columnLabel, java.sql.Ref x)`
`void`	`updateRow()`
`void`	`updateRowId(int columnIndex, java.sql.RowId x)`
`void`	`updateRowId(java.lang.String columnLabel, java.sql.RowId x)`
`void`	`updateShort(int columnIndex, short x)`
`void`	`updateShort(java.lang.String columnLabel, short x)`
`void`	`updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject)`
`void`	`updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject)`
`void`	`updateString(int columnIndex, java.lang.String x)`
`void`	`updateString(java.lang.String columnLabel, java.lang.String x)`
`void`	`updateTime(int columnIndex, java.sql.Time x)`
`void`	`updateTime(java.lang.String columnLabel, java.sql.Time x)`
`void`	`updateTimestamp(int columnIndex, java.sql.Timestamp x)`
`void`	`updateTimestamp(java.lang.String columnLabel, java.sql.Timestamp x)`
`boolean`	`wasNull()` This will return a boolean value if the last column that was read had a value equal to null.

Methods inherited from class com.metamatrix.jdbc.WrapperImpl
`isWrapperFor, unwrap`

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Methods inherited from interface java.sql.Wrapper
`isWrapperFor, unwrap`

Method Detail

setMaxFieldSize

public void setMaxFieldSize(int maxFieldSize)

close

public void close()
           throws java.sql.SQLException

Close this result set.

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

Throws:: java.sql.SQLException

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

checkClosed

protected void checkClosed()
                    throws java.sql.SQLException

Throws:: java.sql.SQLException

getParameters

public java.util.List getParameters()

Return a stored procedures parameters (may be null)

Returns:: List of stored procedure parameters which are set from the response

getObject

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

Get a java object based on the column index for the current row.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as an object.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException

Get fetch size that will be used if this result set is backed by a cursor. This may be the hint fetch size provided by com.metamatrix.jdbc.ResultsImpl#getFetchSize or it may have been reset by the server.

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

Throws:: java.sql.SQLException

public boolean next()
             throws java.sql.SQLException

Move row pointer forward one row. This may cause the cursor to fetch more rows.

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

Returns:: True if the current index is on a valid row, false if the pointer is past the end of the rows
Throws:: java.sql.SQLException - if this result set has an exception

public boolean previous()
                 throws java.sql.SQLException

Move row pointer backward one row. This may cause the cursor to fetch more rows.

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

Returns:: True if the current index is on a valid row, false if the pointer is before the beginning of the rows
Throws:: java.sql.SQLException - if this result set has an exception

getRow

public int getRow()
           throws java.sql.SQLException

Get current row pointer.

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

Returns:: Index of current row
Throws:: java.sql.SQLException - if this result set has an exception

getObjectDirect

public java.lang.Object getObjectDirect(int column)
                                 throws java.sql.SQLException

Get the value of the current row at the column index specified.

Parameters:: column - Column index
Returns:: Value at column, which may be null
Throws:: java.sql.SQLException - if this result set has an exception

getCurrentRecord

public java.util.List getCurrentRecord()
                                throws java.sql.SQLException

Get all values in current record in column order

Returns:: List of Object values in current row
Throws:: java.sql.SQLException - if an access error occurs.

getType

public int getType()
            throws java.sql.SQLException

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

Throws:: java.sql.SQLException

absolute

public boolean absolute(int row)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getUpdatedPlanDescription

protected java.util.Map getUpdatedPlanDescription()

requestBatch

public com.metamatrix.jdbc.BatchResults.Batch requestBatch(int beginRow,
                                                           int endRow)
                                                    throws java.sql.SQLException

Specified by:: requestBatch in interface BatchFetcher

Throws:: java.sql.SQLException

getFinalRowNumber

protected int getFinalRowNumber()

hasNext

protected boolean hasNext()
                   throws java.sql.SQLException

Throws:: java.sql.SQLException

getOffset

protected int getOffset()

getAbsoluteRowNumber

protected int getAbsoluteRowNumber()

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException

Cancels the updates made to a row. Since resultSet row updates are not supported, calling this method should not cause any effect. *

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

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

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getBigDecimal

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

This method will return the value in the current at the given column index row as a java.math.BigDecimal.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a BigDecimal object.
Throws:: java.sql.SQLException - if there is an error accessing metamatrix results.

getBigDecimal

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

This method will return the value in the current row at the given column as a java.math.BigDecimal.

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

Parameters:: The - name of the column whose value needs to be fetched in the current row.
Returns:: The value of the column as a BigDecimal object.
Throws:: java.sql.SQLException - if there is an error accessing metamatrix results.

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex,
                                          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:: columnIndex - the first column is 1, the second is 2, ...; scale - the number of digits to the right of the decimal
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if there is an error accessing metamatrix results.

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                          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:: columnName - the SQL name of the column; scale - the number of digits to the right of the decimal
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a metamatrix access error occurs

getBinaryStream

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

This method will read in the data byte by byte and write it to an InputStream to be returned.

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

Parameters:: columnIndex - The column position in the current row whose value is to be read.
Returns:: An InputStream object that delivers the column value as a binary stream.
Throws:: java.sql.SQLException

getBinaryStream

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

This method will read in the data byte by byte and write it to an InputStream to be returned.

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

Parameters:: columnName - The column name in the current row whose value is to be updated.
Returns:: An InputStream object that delivers the column value as a binary stream.
Throws:: java.sql.SQLException

getBlob

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

This method will read in a SQL BLOB value stored in the given column as a Blob object.

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

Parameters:: columnIndex - The column position in the current row whose value is to be read.
Returns:: The value of the column at columnIndex as a Blob object.
Throws:: java.sql.SQLException - if there is an error accessing metamatrix results.

getBlob

public java.sql.Blob getBlob(java.lang.String columnName)
                      throws java.sql.SQLException

This method will read in a SQL BLOB value stored in the given column as a Blob object.

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

Parameters:: columnName - The column name in the current row whose value is to be updated.
Returns:: The value of the column at columnIndex as a Blob object.
Throws:: java.sql.SQLException - if there is an error accessing metamatrix results.

getBoolean

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

This method will return the value in the current row as a boolean value

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a boolean value.
Throws:: java.sql.SQLException - if there is an error accessing metamatrix results.

getBoolean

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

This method will return the value in the current row at the given column as a boolean value.

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

Parameters:: The - name of the column whose value needs to be fetched in the current row.
Returns:: The value of the column as a boolean value.
Throws:: java.sql.SQLException - if there is an error accessing metamatrix results.

getByte

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

This method will return the value in the current row as a byte value.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a byte value.
Throws:: java.sql.SQLException - if there is an error accessing metamatrix results.

getByte

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

This method will return the value in the current row as a byte value

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

Parameters:: name - of the column whose byte value is to be returned.
Returns:: value of the column as a byte.
Throws:: java.sql.SQLException

getBytes

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

This method will return the value in the current row as an array of byte values

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

Parameters:: columnIndex - The column position in the current row whose value is to be read.
Returns:: The value of the column at columnIndex as an array of bytes.
Throws:: java.sql.SQLException - if there is an error accessing or converting the result value

getBytes

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

This method will return the value in the current row as an array of byte values

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

Parameters:: columnName - The column name in the current row whose value is to be updated.
Returns:: byte[]. The value of the column at columnIndex as an array of bytes.
Throws:: java.sql.SQLException - if there is an error accessing or converting the result value

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException

Get the concurrency type for this ResultSet object. The concurrency was set by the Statement object. The possible concurrency types are CONCUR_READ_ONLY and CONCUR_UPDATABLE.

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

Returns:: The resultSets are not updatable, this method returns CONCUR_READ_ONLY.
Throws:: java.sql.SQLException - if the there is an error accesing results

getCharacterStream

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

This method will attempt to return the value contained at the index as a java.io.Reader object.

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

Parameters:: columnIndex - The column position in the current row whose value is to be read.
Returns:: The value of the column as a java.io.Reader object.
Throws:: java.sql.SQLException

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String columnName)
                                  throws java.sql.SQLException

This method will attempt to return the value at the designated column determined by the columName as a java.io.Reader object.

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

Parameters:: columnName - The column name in the current row whose value is to be updated.
Returns:: The value of the column as a java.io.Reader object.
Throws:: java.sql.SQLException

getDate

public java.sql.Date getDate(int columnIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException

This method will return the value in the current row as a Date object. This will use the timeZone info of the calendar object.

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

Parameters:: The - index of the column whose value needs to be fetched.; Calender - object used to get the date value.
Returns:: The value of the column as a Date object.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getDate

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

Get the Date value for the given column.

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

Parameters:: columnName - . The name of the column whose value needs to be fetched.; Calender - object used to get the date value.
Returns:: value of the column as an int.
Throws:: java.sql.SQLException - unable to obtain date value for the given column.

getDate

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

This method will return the value in the current row as a Date object. This will assume the default timeZone.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a Date object.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getDate

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

Get the column value as a Date object

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

Parameters:: name - of the column in the resultset whose value is to be fetched.
Returns:: value of the column as an int.
Throws:: java.sql.SQLException

getDouble

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

This method will return the value in the current row as a double value.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a double value.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getDouble

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

Get a double value based on the column name.

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

Parameters:: name - of the column in the resultset whose value is to be fetched.
Returns:: value of the column as a double.
Throws:: java.sql.SQLException

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException

Gets the direction suggested to the driver as the direction in which to fetch rows.

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

Returns:: fetch direction for this ResultSet. This cannot be set and is alwayd FETCH_FORWARD.
Throws:: java.sql.SQLException

getFloat

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

This method will return the value in the current row as a float value.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a float value.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getFloat

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

Get a float value based on the column name.

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

Parameters:: name - of the column in the resultset whose value is to be fetched.
Returns:: value of the column as a float.
Throws:: java.sql.SQLException

getInt

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

This method will return the value in the current row as a int value.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a int value.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getInt

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

Get an integer based on the column index.

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

Parameters:: name - of the column in the resultset whose value is to be fetched.
Returns:: value of the column as an int.
Throws:: java.sql.SQLException

getLong

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

This method will return the value in the current row as a long value.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a long value.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getLong

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

Get a long based on the column name.

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

Parameters:: name - of the column in the resultset whose value is to be fetched.
Returns:: value of the column as a long.
Throws:: java.sql.SQLException

getObject

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

Get a java object based on the column name.

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

Parameters:: name - of the column in the resultset whose value is to be fetched.
Returns:: object which gives the column value.
Throws:: java.sql.SQLException

getShort

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

Get a primitive short based on the column index.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a short value.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getShort

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

Get a short based on the column name.

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

Parameters:: String - representing name of the column.
Returns:: short value of the column.
Throws:: java.sql.SQLException - if a results access error occurs.

getString

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

Get a String based on the column index.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a string value.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getString

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

Get a string based on the column name.

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

Parameters:: String - representing name of the column.
Returns:: String value of the column.
Throws:: java.sql.SQLException - if a results access error occurs.

getTime

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

This method will return the value in the current row as a Time object. This will assume the default timeZone.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a Time object.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getTime

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

Get a java.sql.Time based on the column name.

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

Parameters:: name - of the column whose value is to be fetched as a timestamp
Returns:: value of the column as a Timestamp object
Throws:: java.sql.SQLException - if a results access error occurs.

getTime

public java.sql.Time getTime(int columnIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException

This method will return the value in the current row as a Time object. This will use the timeZone info of the calendar object.

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

Parameters:: The - index of the column whose value needs to be fetched.; Calendar - object to be used to construct the Time object.
Returns:: The value of the column as a Time object.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getTime

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

Get a java.sql.Time based on the column name.

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

Parameters:: name - of the column whose value is to be fetched as a timestamp; calender - object to include the timezone info in the object returned
Returns:: value of the column as a Timestamp object
Throws:: java.sql.SQLException - if a results access error occurs.

getTimestamp

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

This method will return the value in the current row as a Timestamp object. This will assume the default timeZone.

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

Parameters:: The - index of the column whose value needs to be fetched.
Returns:: The value of the column as a Timestamp object.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getTimestamp

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

Get a java.sql.Timestamp based on the column name.

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

Parameters:: name - of the column whose value is to be fetched as a timestamp
Returns:: value of the column as a Timestamp object
Throws:: java.sql.SQLException - if a results access error occurs.

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException

This method will return the value in the current row as a Timestamp object. This will use the timeZone info of the calendar object.

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

Parameters:: The - index of the column whose value needs to be fetched.; Calendar - object to be used to construct the Timestamp object.
Returns:: The value of the column as a Timestamp object.
Throws:: java.sql.SQLException - if a results access error occurs or transform fails.

getTimestamp

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

Get a java.sql.Timestamp based on the column name.

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

Parameters:: name - of the column whose value is to be fetched as a timestamp; calender - object to include the timezone info in the object returned
Returns:: value of the column as a Timestamp object
Throws:: java.sql.SQLException - if a results access error occurs.

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException

Moves the cursor to the remembered cursor position, usually the current row. This method does not have any effect if the cursor is not on the insert row. ResultSet cannot currently be updated.

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

Throws:: java.sql.SQLException

wasNull

public boolean wasNull()
                throws java.sql.SQLException

This will return a boolean value if the last column that was read had a value equal to null. If the last column read was null return true, else return false.

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

Returns:: A boolean value showing if the lastvalue read in was null or not.
Throws:: java.sql.SQLException

setResultsData

protected void setResultsData(ResultsMessage resultsMsg)

getMetaData

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

This method returns the meta data of the result set, such as the number, types and properties of this resultSets columns.

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

Returns:: ResultSerMetaData object for these results.
Throws:: java.sql.SQLException - if results access error occurs

getCursorName

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

Retrieves the RequestID for the query that created this ResultSet.

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

Returns:: The requestID for the query that created these results
Throws:: java.sql.SQLException

getStatement

public MMStatement getStatement()
                         throws java.sql.SQLException

Retrieves the Statement object that produced this ResultSet object.

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

Returns:: a Statement object.
Throws:: java.sql.SQLException - if the there is an error accesing results

getWarnings

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

Retrieves the first warning reported by calls on this ResultSet object. Subsequent warnings on this ResultSet object will be chained to the SQLWarning object that this method returns.

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

Returns:: SQLWarning object representing any MetaMatrix warnings.
Throws:: java.sql.SQLException - if a database access error occurs or this method is called on a closed result set.

getProcessingTimestamp

public java.util.Date getProcessingTimestamp()
                                      throws java.sql.SQLException

Gets the time the command was submitted to the server.

Returns:: Date object representing time submitted to the server.
Throws:: java.sql.SQLException

getCompletedTimestamp

public java.util.Date getCompletedTimestamp()
                                     throws java.sql.SQLException

Gets the time command execution is compleated on the server.

Returns:: Date object representing time the commond finished execution.
Throws:: java.sql.SQLException

getProcessingTime

public long getProcessingTime()
                       throws java.sql.SQLException

This gives the total time taken for execution of the command

Returns:: long. Time for command execution on the server.
Throws:: java.sql.SQLException

isFirst

public boolean isFirst()
                throws java.sql.SQLException

True if current record is the first in the result set.

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

Returns:: True if current row is first
Throws:: QueryResultsException - if this result set has an exception; InvalidatedResultsException - if the results were obtained during a transaction and the transaction has been rolled back; java.sql.SQLException

isLast

public boolean isLast()
               throws java.sql.SQLException

True if current record is the last in the result set.

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

Returns:: True if current row is last
Throws:: QueryResultsException - if this result set has an exception; InvalidatedResultsException - if the results were obtained during a transaction and the transaction has been rolled back; java.sql.SQLException

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException

Determines whether the cursor is after the last row in this ResultSet object. This method should be called only if the result set is scrollable.

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

Returns:: true if the cursor is after the last row in the resultSet.
Throws:: java.sql.SQLException

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException

Determines whether the cursor is before the first row in this ResultSet object. This method should be called only if the result set is scrollable.

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

Returns:: true if the cursor is before the last row in the resultSet;false if the cursor is at any other position or the result set contains no rows.
Throws:: java.sql.SQLException

relative

public boolean relative(int rows)
                 throws java.sql.SQLException

Moves the cursor a number of rows relative to the current row in this ResultSet object. The number of rows may be positive or negative.

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

Parameters:: number - of rows to move relative to the present row.
Returns:: true if the cursor is on a valid row in the resultSet.
Throws:: java.sql.SQLException - if the there is an error accessing results

last

public boolean last()
             throws java.sql.SQLException

Moves the cursor to the last row in the in this ResultSet object. This method should be called only if the result set is scrollable.

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

Returns:: true if the cursor is on a validRow, false otherwise or if no rows exist.
Throws:: java.sql.SQLException - if the type of the ResultSet is TYPE_FORWARD_ONLY

checkNotForwardOnly

protected void checkNotForwardOnly()
                            throws java.sql.SQLException

Throws:: java.sql.SQLException

afterLast

public void afterLast()
               throws java.sql.SQLException

Moves the cursor to the end of the result set, just after the last row. Has no effect if the result set contains no rows.

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

Throws:: java.sql.SQLException - if a results access error occurs or the result set type is TYPE_FORWARD_ONLY

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException

Moves the cursor to the front of the result set, just before the first row. Has no effect if the result set contains no rows.

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

Throws:: java.sql.SQLException - if a results can not be accessed or the result set type is TYPE_FORWARD_ONLY

first

public boolean first()
              throws java.sql.SQLException

Moves the cursor to the first row in this ResultSet object.

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

Returns:: true if the cursor is on valid row, false if there are no rows in the resultset.
Throws:: java.sql.SQLException - if the ResulSet is of TYPE_FORWARD_ONLY.

findColumn

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

This method returns the integer that represents which column represents the column name parameter.

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

Parameters:: Name - of the column whose position is to be returned.
Returns:: Position of column amoung the columns in the ResultSet.
Throws:: java.sql.SQLException - if a database access error occurs.

findColumnIndex

protected int findColumnIndex(java.lang.String columnName)
                       throws java.sql.SQLException

Throws:: java.sql.SQLException

getDefaultCalendar

protected java.util.Calendar getDefaultCalendar()

deleteRow

public void deleteRow()
               throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getArray

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

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

Throws:: java.sql.SQLException

getArray

public java.sql.Array getArray(java.lang.String columnLabel)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getAsciiStream

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

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

Throws:: java.sql.SQLException

getAsciiStream

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

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

Throws:: java.sql.SQLException

getClob

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

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

Throws:: java.sql.SQLException

getSQLXML

public java.sql.SQLXML getSQLXML(int columnIndex)
                          throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getClob

public java.sql.Clob getClob(java.lang.String columnLabel)
                      throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getHoldability

public int getHoldability()
                   throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getNCharacterStream

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

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

Throws:: java.sql.SQLException

getNCharacterStream

public java.io.Reader getNCharacterStream(java.lang.String columnLabel)
                                   throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getNClob

public java.sql.NClob getNClob(int columnIndex)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getNClob

public java.sql.NClob getNClob(java.lang.String columnLabel)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getNString

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

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

Throws:: java.sql.SQLException

getNString

public java.lang.String getNString(java.lang.String columnLabel)
                            throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getObject

public java.lang.Object getObject(int columnIndex,
                                  java.util.Map<java.lang.String,java.lang.Class<?>> map)
                           throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getObject

public java.lang.Object getObject(java.lang.String columnLabel,
                                  java.util.Map<java.lang.String,java.lang.Class<?>> map)
                           throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getRef

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

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

Throws:: java.sql.SQLException

getRef

public java.sql.Ref getRef(java.lang.String columnLabel)
                    throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getRowId

public java.sql.RowId getRowId(int columnIndex)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getRowId

public java.sql.RowId getRowId(java.lang.String columnLabel)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getSQLXML

public java.sql.SQLXML getSQLXML(java.lang.String columnLabel)
                          throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getUnicodeStream

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

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

Throws:: java.sql.SQLException

getUnicodeStream

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

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

Throws:: java.sql.SQLException

getURL

public java.net.URL getURL(int columnIndex)
                    throws java.sql.SQLException

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

Throws:: java.sql.SQLException

getURL

public java.net.URL getURL(java.lang.String columnLabel)
                    throws java.sql.SQLException

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

Throws:: java.sql.SQLException

insertRow

public void insertRow()
               throws java.sql.SQLException

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

Throws:: java.sql.SQLException

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException

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

Throws:: java.sql.SQLException

refreshRow

public void refreshRow()
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException

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

Throws:: java.sql.SQLException

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException

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

Throws:: java.sql.SQLException

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException

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

Throws:: java.sql.SQLException

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException

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

Throws:: java.sql.SQLException

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateArray

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

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

Throws:: java.sql.SQLException

updateArray

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

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

Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x,
                              long length)
                       throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x)
                       throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x,
                              long length)
                       throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnLabel,
                              java.io.InputStream x)
                       throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBigDecimal

public void updateBigDecimal(java.lang.String columnLabel,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x,
                               long length)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x,
                               long length)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x)
                        throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBlob

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

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

Throws:: java.sql.SQLException

updateBlob

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

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

Throws:: java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex,
                       java.io.InputStream inputStream,
                       long length)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex,
                       java.io.InputStream inputStream)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String columnLabel,
                       java.io.InputStream inputStream,
                       long length)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String columnLabel,
                       java.io.InputStream inputStream)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean x)
                   throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBoolean

public void updateBoolean(java.lang.String columnLabel,
                          boolean x)
                   throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateByte

public void updateByte(int columnIndex,
                       byte x)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateByte

public void updateByte(java.lang.String columnLabel,
                       byte x)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBytes

public void updateBytes(int columnIndex,
                        byte[] x)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateBytes

public void updateBytes(java.lang.String columnLabel,
                        byte[] x)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  int length)
                           throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader,
                                  int length)
                           throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  long length)
                           throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x)
                           throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader,
                                  long length)
                           throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnLabel,
                                  java.io.Reader reader)
                           throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateClob

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

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

Throws:: java.sql.SQLException

updateClob

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

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

Throws:: java.sql.SQLException

updateClob

public void updateClob(int columnIndex,
                       java.io.Reader reader,
                       long length)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateClob

public void updateClob(int columnIndex,
                       java.io.Reader reader)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateClob

public void updateClob(java.lang.String columnLabel,
                       java.io.Reader reader,
                       long length)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateClob

public void updateClob(java.lang.String columnLabel,
                       java.io.Reader reader)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateDate

public void updateDate(int columnIndex,
                       java.sql.Date x)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateDate

public void updateDate(java.lang.String columnLabel,
                       java.sql.Date x)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateDouble

public void updateDouble(int columnIndex,
                         double x)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateDouble

public void updateDouble(java.lang.String columnLabel,
                         double x)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateFloat

public void updateFloat(int columnIndex,
                        float x)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateFloat

public void updateFloat(java.lang.String columnLabel,
                        float x)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateInt

public void updateInt(int columnIndex,
                      int x)
               throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateInt

public void updateInt(java.lang.String columnLabel,
                      int x)
               throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateLong

public void updateLong(int columnIndex,
                       long x)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateLong

public void updateLong(java.lang.String columnLabel,
                       long x)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x,
                                   long length)
                            throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   java.io.Reader x)
                            throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(java.lang.String columnLabel,
                                   java.io.Reader reader,
                                   long length)
                            throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(java.lang.String columnLabel,
                                   java.io.Reader reader)
                            throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.sql.NClob clob)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex,
                        java.io.Reader reader)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.sql.NClob clob)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNClob

public void updateNClob(java.lang.String columnLabel,
                        java.io.Reader reader)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNString

public void updateNString(int columnIndex,
                          java.lang.String string)
                   throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNString

public void updateNString(java.lang.String columnLabel,
                          java.lang.String string)
                   throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNull

public void updateNull(int columnIndex)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateNull

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

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

Throws:: java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x,
                         int scaleOrLength)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateObject

public void updateObject(java.lang.String columnLabel,
                         java.lang.Object x,
                         int scaleOrLength)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateObject

public void updateObject(java.lang.String columnLabel,
                         java.lang.Object x)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateRef

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

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

Throws:: java.sql.SQLException

updateRef

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

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

Throws:: java.sql.SQLException

updateRow

public void updateRow()
               throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateRowId

public void updateRowId(int columnIndex,
                        java.sql.RowId x)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateRowId

public void updateRowId(java.lang.String columnLabel,
                        java.sql.RowId x)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateShort

public void updateShort(int columnIndex,
                        short x)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateShort

public void updateShort(java.lang.String columnLabel,
                        short x)
                 throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateSQLXML

public void updateSQLXML(int columnIndex,
                         java.sql.SQLXML xmlObject)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateSQLXML

public void updateSQLXML(java.lang.String columnLabel,
                         java.sql.SQLXML xmlObject)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateString

public void updateString(int columnIndex,
                         java.lang.String x)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateString

public void updateString(java.lang.String columnLabel,
                         java.lang.String x)
                  throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateTime

public void updateTime(int columnIndex,
                       java.sql.Time x)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateTime

public void updateTime(java.lang.String columnLabel,
                       java.sql.Time x)
                throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateTimestamp

public void updateTimestamp(int columnIndex,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateTimestamp

public void updateTimestamp(java.lang.String columnLabel,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException

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

Throws:: java.sql.SQLException

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.metamatrix.jdbc Class MMResultSet

setMaxFieldSize

close

isClosed

checkClosed

getParameters

getObject

getFetchSize

next

previous

getRow

getObjectDirect

getCurrentRecord

getType

absolute

getUpdatedPlanDescription

requestBatch

getFinalRowNumber

hasNext

getOffset

getAbsoluteRowNumber

cancelRowUpdates

clearWarnings

getBigDecimal

getBigDecimal

getBigDecimal

getBigDecimal

getBinaryStream

getBinaryStream

getBlob

getBlob

getBoolean

getBoolean

getByte

getByte

getBytes

getBytes

getConcurrency

getCharacterStream

getCharacterStream

getDate

getDate

getDate

getDate

getDouble

getDouble

getFetchDirection

getFloat

getFloat

getInt

getInt

getLong

getLong

getObject

getShort

getShort

getString

getString

getTime

getTime

getTime

getTime

getTimestamp

getTimestamp

getTimestamp

getTimestamp

moveToCurrentRow

wasNull

setResultsData

getMetaData

getCursorName

getStatement

getWarnings

getProcessingTimestamp

getCompletedTimestamp

getProcessingTime

isFirst

isLast

isAfterLast

isBeforeFirst

com.metamatrix.jdbc
Class MMResultSet