IdmsResultSet

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

ca.idms.jdbc
Class IdmsResultSet

java.lang.Object
  ca.idms.io.TraceObject
      ca.idms.jdbc.IdmsJdbcObject
          ca.idms.jdbc.IdmsResultObject
              ca.idms.jdbc.IdmsResultSet

All Implemented Interfaces:: Trace, SQLState, java.sql.ResultSet, java.sql.Wrapper

public class IdmsResultSet
extends IdmsResultObject
implements java.sql.ResultSet
extends IdmsResultObject
implements java.sql.ResultSet

IDMS implementation of the ResultSet interface.

A ResultSet provides access to a table of data generated by executing a Statement. The table rows are retrieved in sequence. Within a row its column values can be accessed in any order.

A ResultSet maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The 'next' method moves the cursor to the next row.

The getXXX methods retrieve column values for the current row. You can retrieve values either using the index number of the column, or by using the name of the column. In general using the column number will be more efficient. Columns are numbered from 1.

For maximum portability, ResultSet columns within each row should be read in left-to-right order and each column should be read only once.

For the getXXX methods, the JDBC driver attempts to convert the underlying data to the specified Java type and returns a suitable Java value. See the JDBC specification for allowable mappings from SQL types to Java types with the ResultSet.getXXX methods.

Column names used as input to getXXX methods are case insensitive. When performing a getXXX using a column name, if several columns have the same name, then the value of the first matching column will be returned. The column name option is designed to be used when column names are used in the SQL query. For columns that are NOT explicitly named in the query, it is best to use column numbers. If column names were used there is no way for the programmer to guarantee that they actually refer to the intended columns.

A ResultSet is automatically closed by the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results.

The number, types and properties of a ResultSet's columns are provided by the ResulSetMetaData object returned by the getMetaData method.

Version:: 3.00, 06/27/08
Author:: Dave Ross
See Also:: IdmsStatement.executeQuery(java.lang.String), IdmsStatement.getResultSet(), IdmsResultObject, IdmsResultSetMetaData, Sqlvar, Sqlval, Sqlda, Sqlbuf, Section

Field Summary

Fields inherited from class ca.idms.jdbc.IdmsJdbcObject
`FAKE_METHODS, FAKE_SUPPORT, fakeSupport, MESSAGES`

Fields inherited from class ca.idms.io.TraceObject
`exclude, EXCLUDE, FALSE, include, INCLUDE, logWriter, PREFIX, PROPERTIES_FILE, PROPERTIES_KEY, snap, SNAP, SNAP_BYTES, SNAP_NATIVE, SNAP_OBJECT, SNAP_SQL, snapBytes, snapNative, snapObject, snapSql, stub, trace, TRACE, TRACE_FILE, TRACE_LIFE, TRACE_NATIVE, TRACE_PRODUCT, traceLife, traceNative, traceStream, TRUE`

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`

Fields inherited from interface ca.idms.qcli.SQLState
`SQL_00000, SQL_01000, SQL_01004, SQL_07001, SQL_07009, SQL_08001, SQL_08002, SQL_08003, SQL_08004, SQL_08006, SQL_08007, SQL_0A000, SQL_21000, SQL_22000, SQL_22001, SQL_22003, SQL_22005, SQL_22007, SQL_24000, SQL_25000, SQL_3C000, SQL_40000, SQL_42000, SQL_HY000, SQL_HY004, SQL_HY009, SQL_HY010, SQL_HY024, SQL_HY106, SQL_HYC00`

Method Summary
`boolean`	`absolute(int r)` Positions the cursor on the specified row.
`void`	`afterLast()` Positions the cursor after the last row.
`void`	`beforeFirst()` Positions the cursor before the first row.
`void`	`cancelRowUpdates()` IDMS does not currently support updateable ResultSets.
`void`	`close()` In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
`void`	`deleteRow()` IDMS does not currently support updateable ResultSets.
`protected void`	`finalize()` The finalizer traces object destruction.
`int`	`findColumn(java.lang.String name)` Maps a ResultSet column name to a ResultSet column number.
`boolean`	`first()` Positions the cursor on the first row.
`protected java.lang.Object`	`get(java.lang.reflect.Field f)` Overrides the default get method to allow the default snap method access to the value of a non-public variable.
`java.sql.Array`	`getArray(int c)` IDMS does not support the ARRAY type.
`java.sql.Array`	`getArray(java.lang.String c)` IDMS does not support the ARRAY type.
`java.io.InputStream`	`getAsciiStream(int c)` A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
`java.io.InputStream`	`getAsciiStream(java.lang.String c)` A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
`java.math.BigDecimal`	`getBigDecimal(int c)` Get the value of a column in the current row as a java.lang.BigDecimal object.
`java.math.BigDecimal`	`getBigDecimal(int c, int scale)` Get the value of a column in the current row as a java.lang.BigDecimal object.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String c)` Get the value of a column in the current row as a java.lang.BigDecimal object.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String c, int scale)` Get the value of a column in the current row as a java.lang.BigDecimal object.
`java.io.InputStream`	`getBinaryStream(int c)` A column value can be retrieved as a stream of uninterpreted ((byte[])v) and then read in chunks from the stream.
`java.io.InputStream`	`getBinaryStream(java.lang.String c)` A column value can be retrieved as a stream of uninterpreted ((byte[])v) and then read in chunks from the stream.
`java.sql.Blob`	`getBlob(int c)` IDMS does not support the BLOB type.
`java.sql.Blob`	`getBlob(java.lang.String c)` IDMS does not support the BLOB type.
`boolean`	`getBoolean(int c)` Get the value of a column in the current row as a Java boolean.
`boolean`	`getBoolean(java.lang.String c)` Get the value of a column in the current row as a Java boolean.
`byte`	`getByte(int c)` Get the value of a column in the current row as a Java byte.
`byte`	`getByte(java.lang.String c)` Get the value of a column in the current row as a Java byte.
`byte[]`	`getBytes(int c)` Get the value of a column in the current row as a Java byte array.
`byte[]`	`getBytes(java.lang.String c)` Get the value of a column in the current row as a Java byte array.
`java.io.Reader`	`getCharacterStream(int c)` Returns the value of the column as a java.io.Reader.
`java.io.Reader`	`getCharacterStream(java.lang.String c)` Returns the value of the column as a java.io.Reader.
`java.sql.Clob`	`getClob(int c)` IDMS does support the CLOB type.
`java.sql.Clob`	`getClob(java.lang.String c)` IDMS does support the CLOB type.
`int`	`getConcurrency()` Gets this ResultSet's concurrency.
`java.lang.String`	`getCursorName()` Gets the name of the SQL cursor used by this ResultSet.
`java.sql.Date`	`getDate(int c)` Gets the value of a column in the current row as a java.sql.Date object.
`java.sql.Date`	`getDate(int c, java.util.Calendar v)` Gets the value of a column in the current row as a java.sql.Date object.
`java.sql.Date`	`getDate(java.lang.String c)` Gets the value of a column in the current row as a java.sql.Date object.
`java.sql.Date`	`getDate(java.lang.String c, java.util.Calendar v)` Gets the value of a column in the current row as a java.sql.Date object.
`double`	`getDouble(int c)` Get the value of a column in the current row as a Java double.
`double`	`getDouble(java.lang.String c)` Get the value of a column in the current row as a Java double.
`float`	`getFloat(int c)` Get the value of a column in the current row as a Java float.
`float`	`getFloat(java.lang.String c)` Get the value of a column in the current row as a Java float.
`int`	`getHoldability()` For CA IDMS ResultSet holdability is a Connection attribute.
`int`	`getInt(int c)` Get the value of a column in the current row as a Java int.
`int`	`getInt(java.lang.String c)` Get the value of a column in the current row as a Java int.
`long`	`getLong(int c)` Get the value of a column in the current row as a Java long.
`long`	`getLong(java.lang.String c)` Get the value of a column in the current row as a Java long.
`java.sql.ResultSetMetaData`	`getMetaData()` The number, types and properties of a ResultSet's columns are provided by the getMetaData method.
`java.io.Reader`	`getNCharacterStream(int c)` IDMS does not support the NCHAR type.
`java.io.Reader`	`getNCharacterStream(java.lang.String c)` IDMS does not support the NCHAR type.
`java.sql.NClob`	`getNClob(int c)` IDMS does not support the NCLOB type.
`java.sql.NClob`	`getNClob(java.lang.String c)` IDMS does not support the NCLOB type.
`java.lang.String`	`getNString(int c)` IDMS does not support the NCHAR type.
`java.lang.String`	`getNString(java.lang.String c)` IDMS does not support the NCHAR type.
`java.lang.Object`	`getObject(int c)` Gets the value of a column in the current row as a Java object.
`java.lang.Object`	`getObject(int c, java.util.Map<java.lang.String,java.lang.Class<?>> v)` Gets the column value as an object of appropriate type.
`java.lang.Object`	`getObject(java.lang.String c)` Get the value of a column in the current row as a Java object.
`java.lang.Object`	`getObject(java.lang.String c, java.util.Map<java.lang.String,java.lang.Class<?>> v)` Gets the column value as an object of appropriate type.
`java.sql.Ref`	`getRef(int c)` IDMS does not support REFERENCE types.
`java.sql.Ref`	`getRef(java.lang.String c)` IDMS does not support REFERENCE types.
`int`	`getRow()` Gets the current row number.
`java.sql.RowId`	`getRowId(int c)` In IDMS, the ROWID type is defined as a pseudo-column equivalent to BIN(8) and contains the DBKey associated with the underlying database record.
`java.sql.RowId`	`getRowId(java.lang.String c)` In IDMS, the ROWID type is defined as a pseudo-column equivalent to BIN(8) and contains the DBKey associated with the underlying database record.
`short`	`getShort(int c)` Get the value of a column in the current row as a Java short.
`short`	`getShort(java.lang.String c)` Get the value of a column in the current row as a Java short.
`java.sql.SQLXML`	`getSQLXML(int c)` IDMS does not support the XML type.
`java.sql.SQLXML`	`getSQLXML(java.lang.String c)` IDMS does not support the XML type.
`java.sql.Statement`	`getStatement()` Gets the owner of this this result set.
`java.lang.String`	`getString(int c)` Get the value of a column in the current row as a Java String.
`java.lang.String`	`getString(java.lang.String c)` Get the value of a column in the current row as a Java String.
`java.sql.Time`	`getTime(int c)` Get the value of a column in the current row as a java.sql.Time object.
`java.sql.Time`	`getTime(int c, java.util.Calendar v)` Gets the value of a column in the current row as a java.sql.Time object.
`java.sql.Time`	`getTime(java.lang.String c)` Get the value of a column in the current row as a java.sql.Time object.
`java.sql.Time`	`getTime(java.lang.String c, java.util.Calendar v)` Gets the value of a column in the current row as a java.sql.Time object.
`java.sql.Timestamp`	`getTimestamp(int c)` Gets the value of a column in the current row as a java.sql.Timestamp object.
`java.sql.Timestamp`	`getTimestamp(int c, java.util.Calendar v)` Gets the value of a column in the current row as a java.sql.Time object.
`java.sql.Timestamp`	`getTimestamp(java.lang.String c)` Get the value of a column in the current row as a java.sql.Timestamp object.
`java.sql.Timestamp`	`getTimestamp(java.lang.String c, java.util.Calendar v)` Gets the value of a column in the current row as a java.sql.Time object.
`int`	`getType()` Gets this ResultSet's type.
`java.io.InputStream`	`getUnicodeStream(int c)` A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream.
`java.io.InputStream`	`getUnicodeStream(java.lang.String c)` A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream.
`java.net.URL`	`getURL(int c)` IDMS does not support the URL type.
`java.net.URL`	`getURL(java.lang.String c)` IDMS does not support the URL type.
`void`	`insertRow()` IDMS does not currently support updateable ResultSets.
`boolean`	`isAfterLast()` Checks if the cursor is positioned after the last row.
`boolean`	`isBeforeFirst()` Checks if the cursor is positioned before the first row.
`boolean`	`isFirst()` Checks if the cursor is positioned on the first row.
`boolean`	`isLast()` Checks if the cursor is positioned on the last row.
`boolean`	`last()` Positions the cursor on the last row.
`void`	`moveToCurrentRow()` IDMS does not currently support updateable ResultSets.
`void`	`moveToInsertRow()` IDMS does not currently support updateable ResultSets.
`boolean`	`next()` Returns the next row, if any.
`boolean`	`previous()` Positions the cursor on the previous row, if any.
`void`	`refreshRow()` IDMS does not currently support updateable ResultSets.
`boolean`	`relative(int r)` Positions the cursor relative to the current row.
`boolean`	`rowDeleted()` IDMS does not currently support updateable ResultSets.
`boolean`	`rowInserted()` IDMS does not currently support updateable ResultSets.
`boolean`	`rowUpdated()` IDMS does not currently support updateable ResultSets.
`void`	`updateArray(int c, java.sql.Array v)` IDMS does not support the ARRAY type or updateable ResultSets.
`void`	`updateArray(java.lang.String c, java.sql.Array v)` IDMS does not support the ARRAY type or updateable ResultSets.
`void`	`updateAsciiStream(int c, java.io.InputStream v)` IDMS does not support updateable ResultSets.
`void`	`updateAsciiStream(int c, java.io.InputStream r, int v)` IDMS does not support updateable ResultSets.
`void`	`updateAsciiStream(int c, java.io.InputStream v, long l)` IDMS does not support updateable ResultSets.
`void`	`updateAsciiStream(java.lang.String c, java.io.InputStream v)` IDMS does not support updateable ResultSets.
`void`	`updateAsciiStream(java.lang.String c, java.io.InputStream r, int v)` IDMS does not support updateable ResultSets.
`void`	`updateAsciiStream(java.lang.String c, java.io.InputStream v, long l)` IDMS does not support updateable ResultSets.
`void`	`updateBigDecimal(int c, java.math.BigDecimal v)` IDMS does not support updateable ResultSets.
`void`	`updateBigDecimal(java.lang.String c, java.math.BigDecimal v)` IDMS does not support updateable ResultSets.
`void`	`updateBinaryStream(int c, java.io.InputStream v)` IDMS does not support updateable ResultSets.
`void`	`updateBinaryStream(int c, java.io.InputStream r, int v)` IDMS does not support updateable ResultSets.
`void`	`updateBinaryStream(int c, java.io.InputStream v, long l)` IDMS does not support updateable ResultSets.
`void`	`updateBinaryStream(java.lang.String c, java.io.InputStream v)` IDMS does not support updateable ResultSets.
`void`	`updateBinaryStream(java.lang.String c, java.io.InputStream r, int v)` IDMS does not support updateable ResultSets.
`void`	`updateBinaryStream(java.lang.String c, java.io.InputStream v, long l)` IDMS does not support updateable ResultSets.
`void`	`updateBlob(int c, java.sql.Blob v)` IDMS does not support the BLOB type or updateable ResultSets.
`void`	`updateBlob(int c, java.io.InputStream v)` IDMS does not support the BLOB type or updateable ResultSets.
`void`	`updateBlob(int c, java.io.InputStream v, long l)` IDMS does not support the BLOB type or updateable ResultSets.
`void`	`updateBlob(java.lang.String c, java.sql.Blob v)` IDMS does not support the BLOB type or updateable ResultSets.
`void`	`updateBlob(java.lang.String c, java.io.InputStream v)` IDMS does not support the BLOB type or updateable ResultSets.
`void`	`updateBlob(java.lang.String c, java.io.InputStream v, long l)` IDMS does not support the BLOB type or updateable ResultSets.
`void`	`updateBoolean(int c, boolean v)` IDMS does not support updateable ResultSets.
`void`	`updateBoolean(java.lang.String c, boolean v)` IDMS does not support updateable ResultSets.
`void`	`updateByte(int c, byte v)` IDMS does not support updateable ResultSets.
`void`	`updateByte(java.lang.String c, byte v)` IDMS does not support updateable ResultSets.
`void`	`updateBytes(int c, byte[] v)` IDMS does not support updateable ResultSets.
`void`	`updateBytes(java.lang.String c, byte[] v)` IDMS does not support updateable ResultSets.
`void`	`updateCharacterStream(int c, java.io.Reader v)` IDMS does not support updateable ResultSets.
`void`	`updateCharacterStream(int c, java.io.Reader r, int v)`
`void`	`updateCharacterStream(int c, java.io.Reader v, long l)` IDMS does not support updateable ResultSets.
`void`	`updateCharacterStream(java.lang.String c, java.io.Reader v)` IDMS does not support updateable ResultSets.
`void`	`updateCharacterStream(java.lang.String c, java.io.Reader r, int v)` IDMS does not support updateable ResultSets.
`void`	`updateCharacterStream(java.lang.String c, java.io.Reader v, long l)` IDMS does not support updateable ResultSets.
`void`	`updateClob(int c, java.sql.Clob v)` IDMS does not support the CLOB type or updateable ResultSets.
`void`	`updateClob(int c, java.io.Reader v)` IDMS does not support the CLOB type or updateable ResultSets.
`void`	`updateClob(int c, java.io.Reader v, long l)` IDMS does not support the CLOB type or updateable ResultSets.
`void`	`updateClob(java.lang.String c, java.sql.Clob v)` IDMS does not support the CLOB type or updateable ResultSets.
`void`	`updateClob(java.lang.String c, java.io.Reader v)` IDMS does not support the CLOB type or updateable ResultSets.
`void`	`updateClob(java.lang.String c, java.io.Reader v, long l)` IDMS does not support the CLOB type or updateable ResultSets.
`void`	`updateDate(int c, java.sql.Date v)` IDMS does not support updateable ResultSets.
`void`	`updateDate(java.lang.String c, java.sql.Date v)` IDMS does not support updateable ResultSets.
`void`	`updateDouble(int c, double v)` IDMS does not support updateable ResultSets.
`void`	`updateDouble(java.lang.String c, double v)` IDMS does not support updateable ResultSets.
`void`	`updateFloat(int c, float v)` IDMS does not support updateable ResultSets.
`void`	`updateFloat(java.lang.String c, float v)` IDMS does not support updateable ResultSets.
`void`	`updateInt(int c, int v)` IDMS does not support updateable ResultSets.
`void`	`updateInt(java.lang.String c, int v)` IDMS does not support updateable ResultSets.
`void`	`updateLong(int c, long v)` IDMS does not support updateable ResultSets.
`void`	`updateLong(java.lang.String c, long v)` IDMS does not support updateable ResultSets.
`void`	`updateNCharacterStream(int c, java.io.Reader v)` IDMS does not support the NCHAR type or updateable ResultSets.
`void`	`updateNCharacterStream(int c, java.io.Reader v, long l)` IDMS does not support the NCHAR type or updateable ResultSets.
`void`	`updateNCharacterStream(java.lang.String c, java.io.Reader v)` IDMS does not support the NCHAR type or updateable ResultSets.
`void`	`updateNCharacterStream(java.lang.String c, java.io.Reader v, long l)` IDMS does not support the NCHAR type or updateable ResultSets.
`void`	`updateNClob(int c, java.sql.NClob v)` IDMS does not support the NCLOB type or updateable ResultSets.
`void`	`updateNClob(int c, java.io.Reader v)` IDMS does not support the NCLOB type or updateable ResultSets.
`void`	`updateNClob(int c, java.io.Reader v, long l)` IDMS does not support the NCLOB type or updateable ResultSets.
`void`	`updateNClob(java.lang.String c, java.sql.NClob v)` IDMS does not support the NCLOB type or updateable ResultSets.
`void`	`updateNClob(java.lang.String c, java.io.Reader v)` IDMS does not support the NCLOB type or updateable ResultSets.
`void`	`updateNClob(java.lang.String c, java.io.Reader v, long l)` IDMS does not support the NCLOB type or updateable ResultSets.
`void`	`updateNString(int c, java.lang.String v)` IDMS does not support the NCHAR type or updateable ResultSets.
`void`	`updateNString(java.lang.String c, java.lang.String v)` IDMS does not support the NCHAR type or updateable ResultSets.
`void`	`updateNull(int c)` IDMS does not support updateable ResultSets.
`void`	`updateNull(java.lang.String c)` IDMS does not support updateable ResultSets.
`void`	`updateObject(int c, java.lang.Object o)` IDMS does not support updateable ResultSets.
`void`	`updateObject(int c, java.lang.Object o, int s)` IDMS does not support updateable ResultSets.
`void`	`updateObject(java.lang.String c, java.lang.Object o)` IDMS does not support updateable ResultSets.
`void`	`updateObject(java.lang.String c, java.lang.Object o, int s)` IDMS does not support updateable ResultSets.
`void`	`updateRef(int c, java.sql.Ref v)` IDMS does not support REFERENCE types or updateable ResultSets.
`void`	`updateRef(java.lang.String c, java.sql.Ref v)` IDMS does not support REFERENCE types or updateable ResultSets.
`void`	`updateRow()` IDMS does not currently support updateable ResultSets.
`void`	`updateRowId(int c, java.sql.RowId v)` IDMS does not support updateable ResultSets.
`void`	`updateRowId(java.lang.String c, java.sql.RowId v)` IDMS does not support updateable ResultSets.
`void`	`updateShort(int c, short v)` IDMS does not support updateable ResultSets.
`void`	`updateShort(java.lang.String c, short v)` IDMS does not support updateable ResultSets.
`void`	`updateSQLXML(int c, java.sql.SQLXML v)` IDMS does not support the XML type or updateable ResultSets.
`void`	`updateSQLXML(java.lang.String c, java.sql.SQLXML v)` IDMS does not support the XML type or updateable ResultSets.
`void`	`updateString(int c, java.lang.String v)` IDMS does not support updateable ResultSets.
`void`	`updateString(java.lang.String c, java.lang.String v)` IDMS does not support updateable ResultSets.
`void`	`updateTime(int c, java.sql.Time v)` IDMS does not support updateable ResultSets.
`void`	`updateTime(java.lang.String c, java.sql.Time v)` IDMS does not support updateable ResultSets.
`void`	`updateTimestamp(int c, java.sql.Timestamp v)` IDMS does not support updateable ResultSets.
`void`	`updateTimestamp(java.lang.String c, java.sql.Timestamp v)` IDMS does not support updateable ResultSets.
`boolean`	`wasNull()` A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value.

Methods inherited from class ca.idms.jdbc.IdmsResultObject
`getFetchDirection, getFetchSize, isClosed, setFetchDirection, setFetchSize`

Methods inherited from class ca.idms.jdbc.IdmsJdbcObject
`clearWarnings, getWarnings, hasCursor, hasUpdate, isStarted, isSuspended, isWrapperFor, notifyStatementError, unwrap`

Methods inherited from class ca.idms.io.TraceObject
`getBoolean, getClasses, getInteger, getProperty, listProperties, message, parseList, print, print, print, println, println, snap, snap, snap, snap, snap, snap, snap, toHex, toHex, toHex, toHex, toHex, toString, trace, trace, trace, trace, trace, trace, traceEntry, unloadProperties`

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

Methods inherited from interface java.sql.ResultSet
`clearWarnings, getFetchDirection, getFetchSize, getWarnings, isClosed, setFetchDirection, setFetchSize`

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

Method Detail

finalize

protected void finalize()
                 throws java.lang.Throwable

Description copied from class: TraceObject

The finalizer traces object destruction.

Overrides:: finalize in class TraceObject

Throws:: java.lang.Throwable - if an error occurs

get

protected java.lang.Object get(java.lang.reflect.Field f)
                        throws java.lang.IllegalAccessException

Overrides the default get method to allow the default snap method access to the value of a non-public variable.

Overrides:: get in class IdmsResultObject

Parameters:: f - a Field returned by Class.getDeclaredFields
Returns:: the Object named by f
Throws:: java.lang.IllegalAccessException - should not really happen, but Field.get requires it
See Also:: TraceObject.snap, TraceObject.snap()

close

public void close()
           throws java.sql.SQLException

In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.

Note: A ResultSet is automatically closed by the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet is also automatically closed when it is garbage collected.

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

Throws:: java.sql.SQLException - if a database error occurs.

getCursorName

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

Gets the name of the SQL cursor used by this ResultSet. The cursor name must have been set before the cursor is opened, that is, before the statement is executed.

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

Returns:: the SQL cursor name
Throws:: java.sql.SQLException - if not set or CA IDMS is 12.01

getMetaData

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

The number, types and properties of a ResultSet's columns are provided by the getMetaData method.

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

Returns:: the description of a ResultSet's columns
Throws:: java.sql.SQLException - if a database error occurs.

getStatement

public java.sql.Statement getStatement()
                                throws java.sql.SQLException

Gets the owner of this this result set.

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

Returns:: the IdmsStatement or IdmsCatalogStatement.
Throws:: java.sql.SQLException - not really
Since:: 1.2

getType

public int getType()
            throws java.sql.SQLException

Gets this ResultSet's type.

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

Returns:: TYPE_FORWARD_ONLY or TYPE_SCROLL_INSENSITIVE
Throws:: java.sql.SQLException - never
Since:: 17.0

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException

Gets this ResultSet's concurrency.

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

Returns:: ResultSet.CONCUR_READ_ONLY.
Throws:: java.sql.SQLException - never
Since:: 1.2

getHoldability

public int getHoldability()
                   throws java.sql.SQLException

For CA IDMS ResultSet holdability is a Connection attribute.

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

Returns:: the holdability set for the connection.
Throws:: java.sql.SQLException - not really
Since:: 1.6
See Also:: IdmsConnection.getHoldability(), IdmsConnection.getHoldability()

public boolean next()
             throws java.sql.SQLException

Returns the next row, if any. The underlying cursor is automatically when SQLCODE = 100 or when maxRows is reached.

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

Returns:: true if the new current row is valid; false if no more rows
Throws:: java.sql.SQLException - if a database error occurs.

getRow

public int getRow()
           throws java.sql.SQLException

Gets the current row number.

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

Returns:: the current row number, 0 if none
Throws:: java.sql.SQLException - never
Since:: 1.2

wasNull

public boolean wasNull()
                throws java.sql.SQLException

A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value. Note that you must first call getXXX on a column to try to read its value and then call wasNull() to find if the value was the SQL NULL.

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

Returns:: true if last column read was SQL NULL
Throws:: java.sql.SQLException - if a getXXX was not called.

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException

Checks if the cursor is positioned before the first row. The driver supports this method for both TYPE_FORWARD_ONLY and TYPE_SCROLL_INSENSITIVE result sets.

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

Returns:: true if before the first row or no rows have been fetched yet, false otherwise.
Throws:: java.sql.SQLException - if closed
Since:: 17.0

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException

Checks if the cursor is positioned after the last row. The driver supports this method for both TYPE_FORWARD_ONLY and TYPE_SCROLL_INSENSITIVE result sets.

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

Returns:: true or false
Throws:: java.sql.SQLException - if closed
Since:: 17.0

isFirst

public boolean isFirst()
                throws java.sql.SQLException

Checks if the cursor is positioned on the first row. The driver supports this method for both TYPE_FORWARD_ONLY and TYPE_SCROLL_INSENSITIVE result sets.

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

Returns:: true if it is, false if not or no current row
Throws:: java.sql.SQLException - if closed
Since:: 17.0

isLast

public boolean isLast()
               throws java.sql.SQLException

Checks if the cursor is positioned on the last row. If positioned on the last row in fetch buffer and SQLCODE != 100 the driver attempts to fetch the next row. This can cause the internal fetch buffer to grow if done repeatedly.

The driver supports this method for both TYPE_FORWARD_ONLY and TYPE_SCROLL_INSENSITIVE result sets.

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

Returns:: true if it is, false if not or no current row
Throws:: java.sql.SQLException - if closed or an error occurs attempting to fetch the next row.
Since:: 17.0

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException

Positions the cursor before the first row.

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

Throws:: java.sql.SQLException - if closed or TYPE_FORWARD_ONLY
Since:: 17.0

first

public boolean first()
              throws java.sql.SQLException

Positions the cursor on the first row.

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

Returns:: true if positioned on a row, false otherwise
Throws:: java.sql.SQLException - if closed, TYPE_FORWARD_ONLY, or a database error occurs fetching the first row
Since:: 17.0

last

public boolean last()
             throws java.sql.SQLException

Positions the cursor on the last row.

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

Returns:: true if positioned on a row, false otherwise
Throws:: java.sql.SQLException - if closed, TYPE_FORWARD_ONLY, or an error occurs fetching the remainder of the result set
Since:: 17.0

afterLast

public void afterLast()
               throws java.sql.SQLException

Positions the cursor after the last row.

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

Throws:: java.sql.SQLException - if closed, TYPE_FORWARD_ONLY, or an error occurs fetching the remainder of the result set
Since:: 17.0

public boolean previous()
                 throws java.sql.SQLException

Positions the cursor on the previous row, if any.

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

Returns:: true if positioned on a row, false otherwise
Throws:: java.sql.SQLException - if closed or TYPE_FORWARD_ONLY
Since:: 17.0

absolute

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

Positions the cursor on the specified row.

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

Parameters:: r - row number
Returns:: true if positioned on a row, false otherwise
Throws:: java.sql.SQLException - if closed, TYPE_FORWARD_ONLY, or an error occurs fetching the remainder of the result set
Since:: 17.0

relative

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

Positions the cursor relative to the current row.

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

Parameters:: r - number of rows to move
Returns:: true if positioned on a row, false otherwise
Throws:: java.sql.SQLException - if closed, TYPE_FORWARD_ONLY, or an error occurs fetching the remainder of the result set
Since:: 17.0

insertRow

public void insertRow()
               throws java.sql.SQLException

IDMS does not currently support updateable ResultSets.

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

Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateRow

public void updateRow()
               throws java.sql.SQLException

IDMS does not currently support updateable ResultSets.

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

Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

deleteRow

public void deleteRow()
               throws java.sql.SQLException

IDMS does not currently support updateable ResultSets.

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

Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException

IDMS does not currently support updateable ResultSets.

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

Throws:: java.sql.SQLException - always
Since:: 1.2

refreshRow

public void refreshRow()
                throws java.sql.SQLException

IDMS does not currently support updateable ResultSets.

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

Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException

IDMS does not currently support updateable ResultSets.

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

Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException

IDMS does not currently support updateable ResultSets.

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

Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException

IDMS does not currently support updateable ResultSets.

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

Returns:: false always
Throws:: java.sql.SQLException - never
Since:: 1.2

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException

IDMS does not currently support updateable ResultSets.

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

Returns:: false always
Throws:: java.sql.SQLException - never
Since:: 1.2

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException

IDMS does not currently support updateable ResultSets.

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

Returns:: false always
Throws:: java.sql.SQLException - never
Since:: 1.2

getString

public java.lang.String getString(int c)
                           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:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.

getBoolean

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

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

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

Parameters:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is false
Throws:: java.sql.SQLException - if a database error occurs.

getByte

public byte getByte(int c)
             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:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getShort

public short getShort(int c)
               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:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getInt

public int getInt(int c)
           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:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getLong

public long getLong(int c)
             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:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getFloat

public float getFloat(int c)
               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:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getDouble

public double getDouble(int c)
                 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:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getBigDecimal

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

Get the value of a column in the current row as a java.lang.BigDecimal object. This is the JDBC 2.0 version of this API. It is provided in our 1.2 driver for minimal compatibility with JDBC 2.0 applications.

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

Parameters:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.

getBigDecimal

public java.math.BigDecimal getBigDecimal(int c,
                                          int scale)
                                   throws java.sql.SQLException

Get the value of a column in the current row as a java.lang.BigDecimal object. This is the JDBC 1.2 version of the API. It is deprecated in JDBC 2.0.

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

Parameters:: c - column number.; scale - the number of digits to the right of the decimal.
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.

getBytes

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

Get the value of a column in the current row as a Java byte array. The ((byte[])v) represent the raw values returned by the driver.

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

Parameters:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.

getDate

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

Gets the value of a column in the current row as a java.sql.Date object. No adjustments are made for time zones.

Date and time values stored in a CA IDMS database are assumed to be in terms of the local time zone for the machine where the CA IDMS system is running. These values, which are basically fetched as Strings, are parsed and are converted to Date objects using the default TimeZone (technically the default Calendar) in effect for the Java VM. No adjustments are made for time zones.

When the CA IDMS system and the Java VM are running in different time zones use the getDate(int,java.util.Calendar) method to specify the time zone used to interpret the database value.

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

Parameters:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.
See Also:: getDate(int,java.util.Calendar), getTime(int,java.util.Calendar), getTimestamp(int,java.util.Calendar)

getTime

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

Get the value of a column in the current row as a java.sql.Time object. No adjustments are made for time zones.

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

Parameters:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.
See Also:: getDate(int), getDate(int,java.util.Calendar), getTime(int), getTime(int,java.util.Calendar)

getTimestamp

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

Gets the value of a column in the current row as a java.sql.Timestamp object. No adjustments are made for time zones.

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

Parameters:: c - column number.
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.
See Also:: getTime(int), getTimestamp(int,java.util.Calendar)

getAsciiStream

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

A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.

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. . Also, a stream may return 0 for available() whether there is data available or not.

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

Parameters:: c - column number.
Returns:: a Java input stream that delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null.
Throws:: java.sql.SQLException - if a database error occurs.

getUnicodeStream

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

A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into Unicode.

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. Also, a stream may return 0 for available() whether there is data available or not.

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

Parameters:: c - column number.
Returns:: a Java input stream that delivers the database column value as a stream of two byte Unicode characters. If the value is SQL NULL then the result is null.
Throws:: java.sql.SQLException - if a database error occurs.

getBinaryStream

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

A column value can be retrieved as a stream of uninterpreted ((byte[])v) and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.

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

Parameters:: c - column number.
Returns:: a Java input stream that delivers the database column value as a stream of uninterpreted ((byte[])v). If the value is SQL NULL then the result is null.
Throws:: java.sql.SQLException - if a database error occurs.

getString

public java.lang.String getString(java.lang.String c)
                           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:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.

getBoolean

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

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

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

Parameters:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is false
Throws:: java.sql.SQLException - if a database error occurs.

getByte

public byte getByte(java.lang.String c)
             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:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getShort

public short getShort(java.lang.String c)
               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:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getInt

public int getInt(java.lang.String c)
           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:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getLong

public long getLong(java.lang.String c)
             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:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getFloat

public float getFloat(java.lang.String c)
               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:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getDouble

public double getDouble(java.lang.String c)
                 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:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is 0
Throws:: java.sql.SQLException - if a database error occurs.

getBigDecimal

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

Get the value of a column in the current row as a java.lang.BigDecimal object. JDBC 2.0 version.

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

Parameters:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String c,
                                          int scale)
                                   throws java.sql.SQLException

Get the value of a column in the current row as a java.lang.BigDecimal object. JDBC 1.2 version.

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

Parameters:: c - the SQL name of the column; scale - the number of digits to the right of the decimal
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.

getBytes

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

Get the value of a column in the current row as a Java byte array. The ((byte[])v) represent the raw values returned by the driver.

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

Parameters:: c - is the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.

getDate

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

Gets the value of a column in the current row as a java.sql.Date object. No adjustments are made for time zones.

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

Parameters:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.
See Also:: getDate(int)

getTime

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

Get the value of a column in the current row as a java.sql.Time object. No adjustments are made for time zones.

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

Parameters:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.

getTimestamp

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

Get the value of a column in the current row as a java.sql.Timestamp object. No adjustments are made for time zones.

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

Parameters:: c - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database error occurs.
See Also:: getTimestamp(int)

getAsciiStream

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

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:: c - the SQL name of the column
Returns:: a Java input stream that delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null.
Throws:: java.sql.SQLException - if a database error occurs.

getUnicodeStream

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

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:: c - is the SQL name of the column
Returns:: a Java input stream that delivers the database column value as a stream of two byte Unicode characters. If the value is SQL NULL then the result is null.
Throws:: java.sql.SQLException - if a database error occurs.

getBinaryStream

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

A column value can be retrieved as a stream of uninterpreted ((byte[])v) and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.

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:: c - the SQL name of the column
Returns:: a Java input stream that delivers the database column value as a stream of uninterpreted ((byte[])v). If the value is SQL NULL then the result is null.
Throws:: java.sql.SQLException - if a database error occurs.

getObject

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

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

This method will return the value of the given column as a Java object. The type of the Java object will be the default Java Object type corresponding to the column's SQL type, following the mapping specified in the JDBC spec.

This method may also be used to read database specific abstract data types.

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

Parameters:: c - column number.
Returns:: A java.lang.Object holding the column value.
Throws:: java.sql.SQLException - if a database error occurs.

getObject

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

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

This method may also be used to read datatabase specific abstract data types.

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

Parameters:: c - the SQL name of the column
Returns:: A java.lang.Object holding the column value.
Throws:: java.sql.SQLException - if a database error occurs.

findColumn

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

Maps a ResultSet column name to a ResultSet column number.

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

Parameters:: name - the name of the column
Returns:: the column number
Throws:: java.sql.SQLException - if a database error occurs.

getCharacterStream

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

Returns the value of the column as a java.io.Reader.

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

Parameters:: c - column number
Returns:: the Reader, null if the value is SQL NULL
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.2

getCharacterStream

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

Returns the value of the column as a java.io.Reader.

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

Parameters:: c - column name
Returns:: the Reader, null if the value is SQL NULL
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.2

getClob

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

IDMS does support the CLOB type.

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

Parameters:: c - column number, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getClob

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

IDMS does support the CLOB type.

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

Parameters:: c - column name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getDate

public java.sql.Date getDate(int c,
                             java.util.Calendar v)
                      throws java.sql.SQLException

Gets the value of a column in the current row as a java.sql.Date object. The converted value is adjusted for the specified time zone, if supplied.

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

Parameters:: c - column number; v - Calendar object specifying time zone information. This represents the time zone where the IDMS Central Version is running.
Returns:: the adjusted Date
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.2
See Also:: getDate(int), getTime(int,Calendar), getTimestamp(int,Calendar)

getDate

public java.sql.Date getDate(java.lang.String c,
                             java.util.Calendar v)
                      throws java.sql.SQLException

Gets the value of a column in the current row as a java.sql.Date object. The converted value is adjusted for the specified time zone, if supplied.

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

Parameters:: c - column name; v - Calendar object specifying time zone information. This represents the time zone where the IDMS Central Version is running.
Returns:: the adjusted Date
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.2
See Also:: getDate(int,Calendar)

getObject

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

Gets the column value as an object of appropriate type. CA IDMS does not support UDTs, so it does not support mapping of UDTs. This method is equivalent to getObject(int).

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

Parameters:: c - column number; v - the Map, ignored
Returns:: the object
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.2

getObject

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

Gets the column value as an object of appropriate type. CA IDMS does not support UDTs, so it does not support mapping of UDTs. This method is equivalent to getObject(String).

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

Parameters:: c - column name; v - the Map, ignored
Returns:: the object
Throws:: java.sql.SQLException - if an error occurs
Since:: 1.2

getRef

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

IDMS does not support REFERENCE types.

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

Parameters:: c - column number, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getRef

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

IDMS does not support REFERENCE types.

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

Parameters:: c - column name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getTime

public java.sql.Time getTime(int c,
                             java.util.Calendar v)
                      throws java.sql.SQLException

Gets the value of a column in the current row as a java.sql.Time object. The converted value is adjusted for the specified time zone, if supplied. The driver will assume that the value returned from the database is in the TimeZone in effect for the Calendar object.

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

Parameters:: c - column number; v - Calendar object specifying time zone information. This represents the time zone where the IDMS Central Version is running.
Returns:: the adjusted Time
Throws:: java.sql.SQLException - if an error occurs
See Also:: getTime(int)

getTime

public java.sql.Time getTime(java.lang.String c,
                             java.util.Calendar v)
                      throws java.sql.SQLException

Gets the value of a column in the current row as a java.sql.Time object. The converted value is adjusted for the specified time zone, if supplied.

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

Parameters:: c - column name; v - Calendar object specifying time zone information. This represents the time zone where the IDMS Central Version is running.
Returns:: the adjusted Time
Throws:: java.sql.SQLException - if an error occurs
See Also:: getTime(int,Calendar)

getTimestamp

public java.sql.Timestamp getTimestamp(int c,
                                       java.util.Calendar v)
                                throws java.sql.SQLException

Gets the value of a column in the current row as a java.sql.Time object. The converted value is adjusted for the specified time zone, if supplied.

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

Parameters:: c - column number; v - Calendar object specifying time zone information. This represents the time zone where the IDMS Central Version is running.
Returns:: the adjusted Timestamp
Throws:: java.sql.SQLException - if an error occurs
See Also:: getTime(int,Calendar), getTimestamp(int)

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String c,
                                       java.util.Calendar v)
                                throws java.sql.SQLException

Gets the value of a column in the current row as a java.sql.Time object. The converted value is adjusted for the specified time zone, if supplied.

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

Parameters:: c - column name; v - Calendar object specifying time zone information. This represents the time zone where the IDMS Central Version is running.
Returns:: the adjusted Timestamp
Throws:: java.sql.SQLException - if an error occurs
See Also:: getTimestamp(int,Calendar)

getArray

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

IDMS does not support the ARRAY type.

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

Parameters:: c - column number, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getArray

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

IDMS does not support the ARRAY type.

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

Parameters:: c - column name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getBlob

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

IDMS does not support the BLOB type.

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

Parameters:: c - column number, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getBlob

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

IDMS does not support the BLOB type.

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

Parameters:: c - column name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

getURL

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

IDMS does not support the URL type.

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

Parameters:: c - column number, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.4
See Also:: IdmsJdbcObject.fakeSupport

getURL

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

IDMS does not support the URL type.

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

Parameters:: c - column name, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.4
See Also:: IdmsJdbcObject.fakeSupport

getNCharacterStream

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

IDMS does not support the NCHAR type.

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

Parameters:: c - column number, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

getNCharacterStream

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

IDMS does not support the NCHAR type.

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

Parameters:: c - column name, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

getNClob

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

IDMS does not support the NCLOB type.

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

Parameters:: c - column number, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

getNClob

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

IDMS does not support the NCLOB type.

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

Parameters:: c - column name, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

getNString

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

IDMS does not support the NCHAR type.

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

Parameters:: c - column number, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

getNString

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

IDMS does not support the NCHAR type.

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

Parameters:: c - column name, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

getRowId

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

In IDMS, the ROWID type is defined as a pseudo-column equivalent to BIN(8) and contains the DBKey associated with the underlying database record. ROWID can be obtained by specifically coding it in a SELECT statement's column projection list. ROWID can be null if it is the result of an outer join operation.

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

Parameters:: c - column number
Returns:: instance of RowId class representing the ROWID
Throws:: java.sql.SQLException - if a DB error occurs or the method is called on a closed ResultSet
Since:: 1.6

getRowId

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

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

Parameters:: c - column name
Returns:: instance of RowId class representing the ROWID
Throws:: java.sql.SQLException - if a DB error occurs or the method is called on a closed ResultSet
Since:: 1.6

getSQLXML

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

IDMS does not support the XML type.

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

Parameters:: c - column name, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

getSQLXML

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

IDMS does not support the XML type.

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

Parameters:: c - column name, ignored
Returns:: null
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateAsciiStream

public void updateAsciiStream(int c,
                              java.io.InputStream r,
                              int v)
                       throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateAsciiStream

public void updateAsciiStream(java.lang.String c,
                              java.io.InputStream r,
                              int v)
                       throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateBigDecimal

public void updateBigDecimal(int c,
                             java.math.BigDecimal v)
                      throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateBigDecimal

public void updateBigDecimal(java.lang.String c,
                             java.math.BigDecimal v)
                      throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateBinaryStream

public void updateBinaryStream(int c,
                               java.io.InputStream r,
                               int v)
                        throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column numbrt, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateBinaryStream

public void updateBinaryStream(java.lang.String c,
                               java.io.InputStream r,
                               int v)
                        throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateBoolean

public void updateBoolean(int c,
                          boolean v)
                   throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateBoolean

public void updateBoolean(java.lang.String c,
                          boolean v)
                   throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateByte

public void updateByte(int c,
                       byte v)
                throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column numbrt, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateByte

public void updateByte(java.lang.String c,
                       byte v)
                throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateBytes

public void updateBytes(int c,
                        byte[] v)
                 throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateBytes

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

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateCharacterStream

public void updateCharacterStream(int c,
                                  java.io.Reader r,
                                  int v)
                           throws java.sql.SQLException

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

Throws:: java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String c,
                                  java.io.Reader r,
                                  int v)
                           throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateDate

public void updateDate(int c,
                       java.sql.Date v)
                throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateDate

public void updateDate(java.lang.String c,
                       java.sql.Date v)
                throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateDouble

public void updateDouble(int c,
                         double v)
                  throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateDouble

public void updateDouble(java.lang.String c,
                         double v)
                  throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateFloat

public void updateFloat(int c,
                        float v)
                 throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateFloat

public void updateFloat(java.lang.String c,
                        float v)
                 throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateInt

public void updateInt(int c,
                      int v)
               throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateInt

public void updateInt(java.lang.String c,
                      int v)
               throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateLong

public void updateLong(int c,
                       long v)
                throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateLong

public void updateLong(java.lang.String c,
                       long v)
                throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateNull

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

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateNull

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

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateObject

public void updateObject(int c,
                         java.lang.Object o)
                  throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; o - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateObject

public void updateObject(java.lang.String c,
                         java.lang.Object o)
                  throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; o - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateObject

public void updateObject(int c,
                         java.lang.Object o,
                         int s)
                  throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; o - value, ignored; s - scale, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateObject

public void updateObject(java.lang.String c,
                         java.lang.Object o,
                         int s)
                  throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; o - value, ignored; s - scale, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateShort

public void updateShort(int c,
                        short v)
                 throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateShort

public void updateShort(java.lang.String c,
                        short v)
                 throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateString

public void updateString(int c,
                         java.lang.String v)
                  throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateString

public void updateString(java.lang.String c,
                         java.lang.String v)
                  throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateTime

public void updateTime(int c,
                       java.sql.Time v)
                throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateTime

public void updateTime(java.lang.String c,
                       java.sql.Time v)
                throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateTimestamp

public void updateTimestamp(int c,
                            java.sql.Timestamp v)
                     throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateTimestamp

public void updateTimestamp(java.lang.String c,
                            java.sql.Timestamp v)
                     throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.2
See Also:: IdmsJdbcObject.fakeSupport

updateArray

public void updateArray(int c,
                        java.sql.Array v)
                 throws java.sql.SQLException

IDMS does not support the ARRAY type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.4
See Also:: IdmsJdbcObject.fakeSupport

updateArray

public void updateArray(java.lang.String c,
                        java.sql.Array v)
                 throws java.sql.SQLException

IDMS does not support the ARRAY type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.4
See Also:: IdmsJdbcObject.fakeSupport

updateBlob

public void updateBlob(int c,
                       java.sql.Blob v)
                throws java.sql.SQLException

IDMS does not support the BLOB type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.4
See Also:: IdmsJdbcObject.fakeSupport

updateBlob

public void updateBlob(java.lang.String c,
                       java.sql.Blob v)
                throws java.sql.SQLException

IDMS does not support the BLOB type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.4
See Also:: IdmsJdbcObject.fakeSupport

updateClob

public void updateClob(int c,
                       java.sql.Clob v)
                throws java.sql.SQLException

IDMS does not support the CLOB type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.4
See Also:: IdmsJdbcObject.fakeSupport

updateClob

public void updateClob(java.lang.String c,
                       java.sql.Clob v)
                throws java.sql.SQLException

IDMS does not support the CLOB type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.4
See Also:: IdmsJdbcObject.fakeSupport

updateRef

public void updateRef(int c,
                      java.sql.Ref v)
               throws java.sql.SQLException

IDMS does not support REFERENCE types or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.4
See Also:: IdmsJdbcObject.fakeSupport

updateRef

public void updateRef(java.lang.String c,
                      java.sql.Ref v)
               throws java.sql.SQLException

IDMS does not support REFERENCE types or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.4
See Also:: IdmsJdbcObject.fakeSupport

updateAsciiStream

public void updateAsciiStream(int c,
                              java.io.InputStream v)
                       throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateAsciiStream

public void updateAsciiStream(java.lang.String c,
                              java.io.InputStream v)
                       throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateAsciiStream

public void updateAsciiStream(int c,
                              java.io.InputStream v,
                              long l)
                       throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateAsciiStream

public void updateAsciiStream(java.lang.String c,
                              java.io.InputStream v,
                              long l)
                       throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateBinaryStream

public void updateBinaryStream(int c,
                               java.io.InputStream v)
                        throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateBinaryStream

public void updateBinaryStream(java.lang.String c,
                               java.io.InputStream v)
                        throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateBinaryStream

public void updateBinaryStream(int c,
                               java.io.InputStream v,
                               long l)
                        throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateBinaryStream

public void updateBinaryStream(java.lang.String c,
                               java.io.InputStream v,
                               long l)
                        throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateBlob

public void updateBlob(int c,
                       java.io.InputStream v)
                throws java.sql.SQLException

IDMS does not support the BLOB type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateBlob

public void updateBlob(java.lang.String c,
                       java.io.InputStream v)
                throws java.sql.SQLException

IDMS does not support the BLOB type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateBlob

public void updateBlob(int c,
                       java.io.InputStream v,
                       long l)
                throws java.sql.SQLException

IDMS does not support the BLOB type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateBlob

public void updateBlob(java.lang.String c,
                       java.io.InputStream v,
                       long l)
                throws java.sql.SQLException

IDMS does not support the BLOB type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateCharacterStream

public void updateCharacterStream(int c,
                                  java.io.Reader v)
                           throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateCharacterStream

public void updateCharacterStream(java.lang.String c,
                                  java.io.Reader v)
                           throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateCharacterStream

public void updateCharacterStream(int c,
                                  java.io.Reader v,
                                  long l)
                           throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateCharacterStream

public void updateCharacterStream(java.lang.String c,
                                  java.io.Reader v,
                                  long l)
                           throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateClob

public void updateClob(int c,
                       java.io.Reader v)
                throws java.sql.SQLException

IDMS does not support the CLOB type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateClob

public void updateClob(java.lang.String c,
                       java.io.Reader v)
                throws java.sql.SQLException

IDMS does not support the CLOB type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateClob

public void updateClob(int c,
                       java.io.Reader v,
                       long l)
                throws java.sql.SQLException

IDMS does not support the CLOB type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateClob

public void updateClob(java.lang.String c,
                       java.io.Reader v,
                       long l)
                throws java.sql.SQLException

IDMS does not support the CLOB type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNCharacterStream

public void updateNCharacterStream(int c,
                                   java.io.Reader v)
                            throws java.sql.SQLException

IDMS does not support the NCHAR type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNCharacterStream

public void updateNCharacterStream(java.lang.String c,
                                   java.io.Reader v)
                            throws java.sql.SQLException

IDMS does not support the NCHAR type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNCharacterStream

public void updateNCharacterStream(int c,
                                   java.io.Reader v,
                                   long l)
                            throws java.sql.SQLException

IDMS does not support the NCHAR type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNCharacterStream

public void updateNCharacterStream(java.lang.String c,
                                   java.io.Reader v,
                                   long l)
                            throws java.sql.SQLException

IDMS does not support the NCHAR type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNClob

public void updateNClob(int c,
                        java.sql.NClob v)
                 throws java.sql.SQLException

IDMS does not support the NCLOB type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNClob

public void updateNClob(java.lang.String c,
                        java.sql.NClob v)
                 throws java.sql.SQLException

IDMS does not support the NCLOB type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNClob

public void updateNClob(int c,
                        java.io.Reader v)
                 throws java.sql.SQLException

IDMS does not support the NCLOB type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNClob

public void updateNClob(java.lang.String c,
                        java.io.Reader v)
                 throws java.sql.SQLException

IDMS does not support the NCLOB type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNClob

public void updateNClob(int c,
                        java.io.Reader v,
                        long l)
                 throws java.sql.SQLException

IDMS does not support the NCLOB type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNClob

public void updateNClob(java.lang.String c,
                        java.io.Reader v,
                        long l)
                 throws java.sql.SQLException

IDMS does not support the NCLOB type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored; l - length, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNString

public void updateNString(int c,
                          java.lang.String v)
                   throws java.sql.SQLException

IDMS does not support the NCHAR type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateNString

public void updateNString(java.lang.String c,
                          java.lang.String v)
                   throws java.sql.SQLException

IDMS does not support the NCHAR type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateRowId

public void updateRowId(int c,
                        java.sql.RowId v)
                 throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateRowId

public void updateRowId(java.lang.String c,
                        java.sql.RowId v)
                 throws java.sql.SQLException

IDMS does not support updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateSQLXML

public void updateSQLXML(int c,
                         java.sql.SQLXML v)
                  throws java.sql.SQLException

IDMS does not support the XML type or updateable ResultSets.

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

Parameters:: c - column number, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

updateSQLXML

public void updateSQLXML(java.lang.String c,
                         java.sql.SQLXML v)
                  throws java.sql.SQLException

IDMS does not support the XML type or updateable ResultSets.

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

Parameters:: c - column name, ignored; v - value, ignored
Throws:: java.sql.SQLException - always
Since:: 1.6
See Also:: IdmsJdbcObject.fakeSupport

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

ca.idms.jdbc Class IdmsResultSet

finalize

get

close

getCursorName

getMetaData

getStatement

getType

getConcurrency

getHoldability

next

getRow

wasNull

isBeforeFirst

isAfterLast

isFirst

isLast

beforeFirst

first

last

afterLast

previous

absolute

relative

insertRow

updateRow

deleteRow

cancelRowUpdates

refreshRow

moveToCurrentRow

moveToInsertRow

rowInserted

rowUpdated

rowDeleted

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getUnicodeStream

getBinaryStream

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getUnicodeStream

getBinaryStream

getObject

getObject

findColumn

getCharacterStream

getCharacterStream

getClob

getClob

getDate

getDate

getObject

getObject

getRef

ca.idms.jdbc
Class IdmsResultSet