The OpenLink JDBC driver for JDBC 3.0 has the following classes:
abstract public class BaseRowSet implements RowSet,Serializable {
// Public Constructors
public BaseRowSet();
// Public Methods
public void close() throws java.sql.SQLException;
public void addRowSetListener(javax.sql.RowSetListener rowsetlistener);
public void removeRowSetListener(javax.sql.RowSetListener rowsetlistener);
public void clearParameters() throws java.sql.SQLException;
public String getCommand();
public int getConcurrency() throws java.sql.SQLException;
public String getDataSourceName();
public boolean getEscapeProcessing() throws java.sql.SQLException;
public int getFetchDirection() throws java.sql.SQLException;
public int getFetchSize() throws java.sql.SQLException;
public int getMaxFieldSize() throws java.sql.SQLException;
public int getMaxRows() throws java.sql.SQLException;
public Object[] getParams() throws java.sql.SQLException;
public String getPassword();
public int getQueryTimeout() throws java.sql.SQLException;
public int getTransactionIsolation();
public int getType() throws java.sql.SQLException;
public Map getTypeMap() throws java.sql.SQLException;
public String getUrl() throws java.sql.SQLException;
public String getUsername();
public boolean isReadOnly();
public void setArray(int parameterIndex, java.sql.Array x)
throws java.sql.SQLException;
public void setAsciiStream(int parameterIndex, java.io.InputStream x,
int length) throws java.sql.SQLException;
public void setBigDecimal(int parameterIndex, java.math.BigDecimal x)
throws java.sql.SQLException;
public void setBinaryStream(int parameterIndex, java.io.InputStream x,
int length) throws java.sql.SQLException;
public void setBlob(int parameterIndex, java.sql.Blob x)
throws java.sql.SQLException;
public void setBoolean(int parameterIndex, boolean x)
throws java.sql.SQLException;
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException;
public void setBytes(int parameterIndex, byte[] x)
throws java.sql.SQLException;
public void setCharacterStream(int parameterIndex, java.io.Reader x,
int length) throws java.sql.SQLException;
public void setClob(int parameterIndex, java.sql.Clob x)
throws java.sql.SQLException;
public void setDate(int parameterIndex, java.sql.Date x)
throws java.sql.SQLException;
public void setDate(int parameterIndex, java.sql.Date x,
java.util.Calendar cal) throws java.sql.SQLException;
public void setDouble(int parameterIndex, double x)
throws java.sql.SQLException;
public void setFloat(int parameterIndex, float x)
throws java.sql.SQLException;
public void setInt(int parameterIndex, int x) throws java.sql.SQLException;
public void setLong(int parameterIndex, long x) throws java.sql.SQLException;
public void setRef(int parameterIndex, java.sql.Ref x)
throws java.sql.SQLException;
public void setShort(int parameterIndex, short x)
throws java.sql.SQLException;
public void setString(int parameterIndex, java.lang.String x)
throws java.sql.SQLException;
public void setTime(int parameterIndex, java.sql.Time x)
throws java.sql.SQLException;
public void setTime(int parameterIndex, java.sql.Time x,
java.util.Calendar cal) throws java.sql.SQLException;
public void setTimestamp(int parameterIndex, java.sql.Timestamp x)
throws java.sql.SQLException;
public void setTimestamp(int parameterIndex, java.sql.Timestamp x,
java.util.Calendar cal)
throws java.sql.SQLException;
public void setUnicodeStream(int parameterIndex, java.io.InputStream x,
int length) throws java.sql.SQLException;
public void setNull(int parameterIndex, int sqlType)
throws java.sql.SQLException;
public void setNull(int parameterIndex, int sqlType,
java.lang.String typeName) throws java.sql.SQLException;
public void setObject(int parameterIndex, java.lang.Object x)
throws java.sql.SQLException;
public void setObject(int parameterIndex, java.lang.Object x,
int targetSqlType) throws java.sql.SQLException;
public void setObject(int parameterIndex, java.lang.Object x,
int targetSqlType, int scale)
throws java.sql.SQLException;
public void setCommand(java.lang.String s) throws java.sql.SQLException;
public void setConcurrency(int i) throws java.sql.SQLException;
public void setDataSourceName(java.lang.String s)
throws java.sql.SQLException;
public void setEscapeProcessing(boolean flag) throws java.sql.SQLException;
public void setFetchDirection(int direction) throws java.sql.SQLException;
public void setFetchSize(int rows) throws java.sql.SQLException;
public void setMaxFieldSize(int max) throws java.sql.SQLException;
public void setMaxRows(int max) throws java.sql.SQLException;
public void setQueryTimeout(int seconds) throws java.sql.SQLException;
public void setReadOnly(boolean value) throws java.sql.SQLException;
public void setPassword(java.lang.String s) throws java.sql.SQLException;
public void setTransactionIsolation(int value) throws java.sql.SQLException;
public void setType(int value) throws java.sql.SQLException;
public void setTypeMap(java.util.Map value) throws java.sql.SQLException;
public void setUrl(java.lang.String s) throws java.sql.SQLException;
public void setUsername(java.lang.String s) throws java.sql.SQLException;
}
Synopsis: public void addRowSetListener(
javax.sql.RowSetListener rowsetlistener);
RowSet listener registration. Listeners are notified when an event occurs.
Synopsis: public void clearParameters() throws java.sql.SQLException;
In general, parameter values remain in force for repeated use of a RowSet. Setting a parameter value automatically clears its previous value. However, in some cases it is useful to immediately release the resources used by the current parameter values; this can be done by calling clearParameters.
Synopsis: public String getCommand();
Get the rowset's command property. The command property contains a command string that can be executed to fill the rowset with data. The default value is null.
Synopsis: public int getConcurrency() throws java.sql.SQLException;
Get the rowset concurrency.
Synopsis: public String getDataSourceName();
The JNDI name that identifies a JDBC data source. Users should set either the url or data source name properties. The most recent property set is used to get a connection.
Synopsis: public boolean getEscapeProcessing() throws java.sql.SQLException;
If escape scanning is on (the default), the driver will do escape substitution before sending the SQL to the database.
Synopsis: public int getFetchDirection() throws java.sql.SQLException;
Determine the fetch direction.
Synopsis: public int getFetchSize() throws java.sql.SQLException;
Determine the default fetch size.
Synopsis: public int getMaxFieldSize() throws java.sql.SQLException;
The maxFieldSize limit (in bytes) is the maximum amount of data returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR columns. If the limit is exceeded, the excess data is silently discarded.
Synopsis: public int getMaxRows() throws java.sql.SQLException;
The maxRows limit is the maximum number of rows that a RowSet can contain. If the limit is exceeded, the excess rows are silently dropped.
Synopsis: public Object[] getParams() throws java.sql.SQLException;
Get the parameters that were set on the rowset.
Synopsis: public String getPassword();
The password used to create a database connection. The password property is set at runtime before calling execute(). It is not usually part of the serialized state of a rowset object.
Synopsis: public int getQueryTimeout() throws java.sql.SQLException;
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute. If the limit is exceeded, a SQLException is thrown.
Synopsis: public int getTransactionIsolation();
The transaction isolation property contains the JDBC transaction isolation level used.
Synopsis: public int getType() throws java.sql.SQLException;
Return the type of this result set.
Synopsis: public Map getTypeMap() throws java.sql.SQLException;
Get the type-map object associated with this rowset. By default, the map returned is empty.
Synopsis: public String getUrl() throws java.sql.SQLException;
Get the url used to create a JDBC connection. The default value is null.
Synopsis: public String getUsername();
The username used to create a database connection. The username property is set at runtime before calling execute(). It is not usually part of the serialized state of a rowset object.
Synopsis: public boolean isReadOnly();
A rowset may be read-only. Attempts to update a read-only rowset will result in an SQLException being thrown. Rowsets are updateable, by default, if updates are possible.
Synopsis: public void removeRowSetListener(
javax.sql.RowSetListener rowsetlistener);
RowSet listener deregistration.
Synopsis: public void setArray(int parameterIndex, java.sql.Array x)
throws java.sql.SQLException;
Set an Array parameter.
Synopsis: public void setAsciiStream(int parameterIndex, java.io.InputStream x,
int length)
throws java.sql.SQLException;
When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. JDBC will read the data from the stream as needed, until it reaches end-of-file.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Synopsis: public void setBigDecimal(int parameterIndex, java.math.BigDecimal x)
throws java.sql.SQLException;
Set a parameter to a java.lang.BigDecimal value.
Synopsis: public void setBinaryStream(int parameterIndex,
java.io.InputStream x, int length)
throws java.sql.SQLException;
When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream. JDBC will read the data from the stream as needed, until it reaches end-of-file.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Synopsis: public void setBlob(int parameterIndex, java.sql.Blob x)
throws java.sql.SQLException;
Set a BLOB parameter.
Synopsis: public void setBoolean(int parameterIndex, boolean x)
throws java.sql.SQLException;
Set a parameter to a Java boolean value.
Synopsis: public void setByte(int parameterIndex, byte x)
throws java.sql.SQLException;
Set a parameter to a Java byte value.
Synopsis: public void setBytes(int parameterIndex, byte[] x)
throws java.sql.SQLException;
Set a parameter to a Java array of bytes.
Synopsis: public void setCharacterStream(int parameterIndex, java.io.Reader x,
int length)
throws java.sql.SQLException;
When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader. JDBC will read the data from the stream as needed, until it reaches end-of-file.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Synopsis: public void setClob(int parameterIndex, java.sql.Clob x)
throws java.sql.SQLException;
Set a CLOB parameter.
Synopsis: public void setCommand(java.lang.String s)
throws java.sql.SQLException;
Set the rowset's command property. This property is optional. The command property may not be needed when a rowset is produced by a data source that doesn't support commands, such as a spreadsheet.
Synopsis: public void setConcurrency(int i) throws java.sql.SQLException;
Set the rowset concurrency.
Synopsis: public void setDataSourceName(java.lang.String s)
throws java.sql.SQLException;
Set the data source name.
Synopsis: public void setDate(int parameterIndex, java.sql.Date x)
throws java.sql.SQLException;
Set a parameter to a java.sql.Date value.
Synopsis: public void setDate(int parameterIndex, java.sql.Date x,
java.util.Calendar cal)
throws java.sql.SQLException;
Set a parameter to a java.sql.Date value. The driver converts this to a SQL DATE value when it sends it to the database.
Synopsis: public void setDouble(int parameterIndex, double x)
throws java.sql.SQLException;
Set a parameter to a Java double value.
Synopsis: public void setEscapeProcessing(boolean flag)
throws java.sql.SQLException;
If escape scanning is on (the default), the driver will do escape substitution before sending the SQL to the database.
Synopsis: public void setFetchDirection(int direction)
throws java.sql.SQLException;
Give a hint as to the direction in which the rows in this result set will be processed. The initial value is determined by the statement that produced the result set. The fetch direction may be changed at any time.
Synopsis: public void setFetchSize(int rows) throws java.sql.SQLException;
Give the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set. If the fetch size specified is zero, then the JDBC driver ignores the value, and is free to make its own best guess as to what the fetch size should be. The default value is set by the statement that creates the result set. The fetch size may be changed at any time.
Synopsis: public void setFloat(int parameterIndex, float x)
throws java.sql.SQLException;
Set a parameter to a Java float value. The driver converts this to a SQL FLOAT value when it sends it to the database.
Synopsis: public void setInt(int parameterIndex, int x)
throws java.sql.SQLException;
Set a parameter to a Java int value.
Synopsis: public void setLong(int parameterIndex, long x)
throws java.sql.SQLException;
Set a parameter to a Java long value.
Synopsis: public void setMaxFieldSize(int max) throws java.sql.SQLException;
The maxFieldSize limit (in bytes) is set to limit the size of data that can be returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR fields. If the limit is exceeded, the excess data is silently discarded. For maximum portability use values greater than 256.
Synopsis: public void setMaxRows(int max) throws java.sql.SQLException;
The maxRows limit is set to limit the number of rows that any RowSet can contain. If the limit is exceeded, the excess rows are silently dropped.
Synopsis: public void setNull(int parameterIndex, int sqlType)
throws java.sql.SQLException;
Set a parameter to SQL NULL.
Note: You must specify the parameter's SQL type.
Synopsis: public void setNull(int parameterIndex, int sqlType,
java.lang.String typeName)
throws java.sql.SQLException;
Sets the designated parameter to SQL NULL. This version of setNull should be used for user-named types and REF type parameters. Examples of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.
Note: To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying a NULL user-defined or REF parameter. In the case of a user-named type the name is the type name of the parameter itself. For a REF parameter the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it. Although it is intended for user-named and Ref parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-named or REF type, the given typeName is ignored.
Synopsis: public void setObject(int parameterIndex, java.lang.Object x)
throws java.sql.SQLException;
Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.
The JDBC specification specifies a standard mapping from Java Object types to SQL types. The given argument java object will be converted to the corresponding SQL type before being sent to the database.
Note that this method may be used to pass datatabase specific abstract data types, by using a Driver specific Java type. If the object is of a class implementing SQLData, the rowset should call its method writeSQL() to write it to the SQL data stream. else If the object is of a class implementing Ref, Blob, Clob, Struct, or Array then pass it to the database as a value of the corresponding SQL type. Raise an exception if there is an ambiguity, for example, if the object is of a class implementing more than one of those interfaces.
Synopsis: public void setObject(int parameterIndex, java.lang.Object x,
int targetSqlType)
throws java.sql.SQLException;
This method is like setObject above, but the scale used is the scale of the second parameter. Scalar values have a scale of zero. Literal values have the scale present in the literal. While it is supported, it is not recommended that this method not be called with floating point input values.
Synopsis: public void setObject(int parameterIndex, java.lang.Object x,
int targetSqlType, int scale)
throws java.sql.SQLException;
Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.
The given Java object will be converted to the targetSqlType before being sent to the database. If the object is of a class implementing SQLData, the rowset should call its method writeSQL() to write it to the SQL data stream. else If the object is of a class implementing Ref, Blob, Clob, Struct, or Array then pass it to the database as a value of the corresponding SQL type.
Note that this method may be used to pass datatabase- specific abstract data types.
Synopsis: public void setPassword(java.lang.String s)
throws java.sql.SQLException;
Set the password.
Synopsis: public void setQueryTimeout(int seconds)
throws java.sql.SQLException;
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute. If the limit is exceeded, a SQLException is thrown.
Synopsis: public void setReadOnly(boolean value) throws java.sql.SQLException;
Set the read-onlyness of the rowset
Synopsis: public void setRef(int parameterIndex, java.sql.Ref x)
throws java.sql.SQLException;
Set a REF(<structured-type>) parameter.
Synopsis: public void setShort(int parameterIndex, short x)
throws java.sql.SQLException;
Set a parameter to a Java short value.
Synopsis: public void setString(int parameterIndex, java.lang.String x)
throws java.sql.SQLException;
Set a parameter to a Java String value.
Synopsis: public void setTime(int parameterIndex, java.sql.Time x)
throws java.sql.SQLException;
Set a parameter to a java.sql.Time value.
Synopsis: public void setTime(int parameterIndex, java.sql.Time x,
java.util.Calendar cal)
throws java.sql.SQLException;
Set a parameter to a java.sql.Time value. The driver converts this to a SQL TIME value when it sends it to the database.
Synopsis: public void setTimestamp(int parameterIndex, java.sql.Timestamp x)
throws java.sql.SQLException;
Set a parameter to a java.sql.Timestamp value.
Synopsis: public void setTimestamp(int parameterIndex, java.sql.Timestamp x,
java.util.Calendar cal)
throws java.sql.SQLException;
Set a parameter to a java.sql.Timestamp value. The driver converts this to a SQL TIMESTAMP value when it sends it to the database.
Synopsis: public void setTransactionIsolation(int value)
throws java.sql.SQLException;
Set the transaction isolation.
Synopsis: public void setType(int value) throws java.sql.SQLException;
Set the type of this result set.
Synopsis: public void setTypeMap(java.util.Map value)
throws java.sql.SQLException;
Install a type-map object as the default type-map for this rowset.
Synopsis: public void setUnicodeStream(int parameterIndex,
java.io.InputStream x, int length)
throws java.sql.SQLException;
When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. JDBC will read the data from the stream as needed, until it reaches end-of-file. The JDBC driver will do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Synopsis: public void setUrl(java.lang.String s) throws java.sql.SQLException;
Set the url used to create a connection. Setting this property is optional. If a url is used, a JDBC driver that accepts the url must be loaded by the application before the rowset is used to connect to a database. The rowset will use the url internally to create a database connection when reading or writing data. Either a url or a data source name is used to create a connection, whichever was specified most recently.
Synopsis: public void setUsername(java.lang.String s)
throws java.sql.SQLException;
Set the user name.
A OPLCachedRowSet is a disconnected, serializable, scrollable container for tabular data. A primary purpose of the OPLCachedRowSet class is to provide a representation of a JDBC ResultSet that can be passed between different components of a remote application. For example, a OPLCachedRowSet can be used to send the result of a query executed by an Enterprise JavaBeans component running in a server environment over a network to a client running in a web browser. A second use for OPLCachedRowSets is to provide scrolling and updating for ResultSets that don't provide these capabilities themselves. A OPLCachedRowSet can be used to augment the capabilities of a JDBC driver that doesn't have full support for scrolling and updating. Finally, a OPLCachedRowSet can be used to provide Java applications with access to tabular data in an environment such as a thin client or PDA, where it would be inappropriate to use a JDBC driver due to resource limitations or security considerations. The OPLCachedRowSet class provides a means to "get rows in" and "get changed rows out" without the need to implement the full JDBC API.
A OPLCachedRowSet object can contain data retrieved via a JDBC driver or data from some other source, such as a spreadsheet. Both a OPLCachedRowSet object and its metadata can be created from scratch. A component that acts as a factory for rowsets can use this capability to create a rowset containing data from non-JDBC data sources.
The term 'disconnected' implies that a OPLCachedRowSet only makes use of a JDBC connection briefly while data is being read from the database and used to populate it with rows, and again while updated rows are being propagated back to the underlying database. During the remainder of its lifetime, a OPLCachedRowSet object isn't associated with an underlying database connection. A OPLCachedRowSet object can simply be thought of as a disconnected set of rows that are being cached outside of a data source. Since all data is cached in memory, OPLCachedRowSets are not appropriate for extremely large data sets.
The contents of a OPLCachedRowSet may be updated and the updates can be propagated to an underlying data source. OPLCachedRowSets support an optimistic concurrency control mechanism - no locks are maintained in the underlying database during disconnected use of the rowset. Both the original value and current value of the OPLCachedRowSet are maintained for use by the optimistic routines.
public class OPLCachedRowSet extends BaseRowSet implements RowSetInternal,Serializable,Cloneable {
// Public Constructors
public OPLCachedRowSet() throws java.sql.SQLException;
// Public Methods
public void finalize() throws java.lang.Throwable;
public void setCommand(java.lang.String cmd) throws java.sql.SQLException;
public void setConcurrency(int concurrency) throws java.sql.SQLException;
public void acceptChanges() throws java.sql.SQLException;
public void acceptChanges(java.sql.Connection _conn)
throws java.sql.SQLException;
public void execute() throws java.sql.SQLException;
public void execute(java.sql.Connection _conn) throws java.sql.SQLException;
public void populate(java.sql.ResultSet rs) throws java.sql.SQLException;
public void setShowDeleted(boolean value) throws java.sql.SQLException;
public boolean getShowDeleted() throws java.sql.SQLException;
public String getTableName() throws java.sql.SQLException;
public void setTableName(java.lang.String _tableName)
throws java.sql.SQLException;
public int[] getKeyCols() throws java.sql.SQLException;
public void setKeyColumns(int[] keys) throws java.sql.SQLException;
public void cancelRowDelete() throws java.sql.SQLException;
public void cancelRowInsert() throws java.sql.SQLException;
public void cancelRowUpdates() throws java.sql.SQLException;
public boolean columnUpdated(int columnIndex) throws java.sql.SQLException;
public void setOriginal() throws java.sql.SQLException;
public void setOriginalRow() throws java.sql.SQLException;
public void restoreOriginal() throws java.sql.SQLException;
public int size();
public Collection toCollection() throws java.sql.SQLException;
public Collection toCollection(int col) throws java.sql.SQLException;
public void release() throws java.sql.SQLException;
public RowSet createCopy() throws java.sql.SQLException;
public RowSet createShared() throws java.sql.SQLException;
public void setMetaData(javax.sql.RowSetMetaData md)
throws java.sql.SQLException;
public Connection getConnection() throws java.sql.SQLException;
public ResultSet getOriginal() throws java.sql.SQLException;
public ResultSet getOriginalRow() throws java.sql.SQLException;
public void close() throws java.sql.SQLException;
public boolean next() throws java.sql.SQLException;
public boolean previous() throws java.sql.SQLException;
public boolean first() throws java.sql.SQLException;
public boolean last() throws java.sql.SQLException;
public boolean absolute(int row) throws java.sql.SQLException;
public boolean relative(int rows) throws java.sql.SQLException;
public void beforeFirst() throws java.sql.SQLException;
public void afterLast() throws java.sql.SQLException;
public boolean isBeforeFirst() throws java.sql.SQLException;
public boolean isAfterLast() throws java.sql.SQLException;
public boolean isFirst() throws java.sql.SQLException;
public boolean isLast() throws java.sql.SQLException;
public int getRow() throws java.sql.SQLException;
public boolean rowUpdated() throws java.sql.SQLException;
public boolean rowInserted() throws java.sql.SQLException;
public boolean rowDeleted() throws java.sql.SQLException;
public void refreshRow() throws java.sql.SQLException;
public void insertRow() throws java.sql.SQLException;
public void updateRow() throws java.sql.SQLException;
public void deleteRow() throws java.sql.SQLException;
public void moveToInsertRow() throws java.sql.SQLException;
public void moveToCurrentRow() throws java.sql.SQLException;
public boolean wasNull() throws java.sql.SQLException;
public SQLWarning getWarnings() throws java.sql.SQLException;
public void clearWarnings() throws java.sql.SQLException;
public String getCursorName() throws java.sql.SQLException;
public ResultSetMetaData getMetaData() throws java.sql.SQLException;
public int findColumn(java.lang.String columnName)
throws java.sql.SQLException;
public String getString(int columnIndex) throws java.sql.SQLException;
public boolean getBoolean(int columnIndex) throws java.sql.SQLException;
public byte getByte(int columnIndex) throws java.sql.SQLException;
public short getShort(int columnIndex) throws java.sql.SQLException;
public int getInt(int columnIndex) throws java.sql.SQLException;
public long getLong(int columnIndex) throws java.sql.SQLException;
public float getFloat(int columnIndex) throws java.sql.SQLException;
public double getDouble(int columnIndex) throws java.sql.SQLException;
public BigDecimal getBigDecimal(int columnIndex)
throws java.sql.SQLException;
public BigDecimal getBigDecimal(int columnIndex, int scale)
throws java.sql.SQLException;
public byte[] getBytes(int columnIndex) throws java.sql.SQLException;
public Date getDate(int columnIndex) throws java.sql.SQLException;
public Time getTime(int columnIndex) throws java.sql.SQLException;
public Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException;
public InputStream getAsciiStream(int columnIndex)
throws java.sql.SQLException;
public InputStream getUnicodeStream(int columnIndex)
throws java.sql.SQLException;
public InputStream getBinaryStream(int columnIndex)
throws java.sql.SQLException;
public Object getObject(int columnIndex) throws java.sql.SQLException;
public String getString(java.lang.String columnName)
throws java.sql.SQLException;
public boolean getBoolean(java.lang.String columnName)
throws java.sql.SQLException;
public byte getByte(java.lang.String columnName)
throws java.sql.SQLException;
public short getShort(java.lang.String columnName)
throws java.sql.SQLException;
public int getInt(java.lang.String columnName) throws java.sql.SQLException;
public long getLong(java.lang.String columnName)
throws java.sql.SQLException;
public float getFloat(java.lang.String columnName)
throws java.sql.SQLException;
public double getDouble(java.lang.String columnName)
throws java.sql.SQLException;
public BigDecimal getBigDecimal(java.lang.String columnName, int scale)
throws java.sql.SQLException;
public byte[] getBytes(java.lang.String columnName)
throws java.sql.SQLException;
public Date getDate(java.lang.String columnName)
throws java.sql.SQLException;
public Time getTime(java.lang.String columnName)
throws java.sql.SQLException;
public Timestamp getTimestamp(java.lang.String columnName)
throws java.sql.SQLException;
public InputStream getAsciiStream(java.lang.String columnName)
throws java.sql.SQLException;
public InputStream getUnicodeStream(java.lang.String columnName)
throws java.sql.SQLException;
public InputStream getBinaryStream(java.lang.String columnName)
throws java.sql.SQLException;
public Object getObject(java.lang.String columnName)
throws java.sql.SQLException;
public Reader getCharacterStream(int columnIndex)
throws java.sql.SQLException;
public Reader getCharacterStream(java.lang.String columnName)
throws java.sql.SQLException;
public BigDecimal getBigDecimal(java.lang.String columnName)
throws java.sql.SQLException;
public void updateNull(int columnIndex) throws java.sql.SQLException;
public void updateBoolean(int columnIndex, boolean x)
throws java.sql.SQLException;
public void updateByte(int columnIndex, byte x) throws java.sql.SQLException;
public void updateShort(int columnIndex, short x)
throws java.sql.SQLException;
public void updateInt(int columnIndex, int x) throws java.sql.SQLException;
public void updateLong(int columnIndex, long x) throws java.sql.SQLException;
public void updateFloat(int columnIndex, float x)
throws java.sql.SQLException;
public void updateDouble(int columnIndex, double x)
throws java.sql.SQLException;
public void updateBigDecimal(int columnIndex, java.math.BigDecimal x)
throws java.sql.SQLException;
public void updateString(int columnIndex, java.lang.String x)
throws java.sql.SQLException;
public void updateBytes(int columnIndex, byte[] x)
throws java.sql.SQLException;
public void updateDate(int columnIndex, java.sql.Date x)
throws java.sql.SQLException;
public void updateTime(int columnIndex, java.sql.Time x)
throws java.sql.SQLException;
public void updateTimestamp(int columnIndex, java.sql.Timestamp x)
throws java.sql.SQLException;
public void updateAsciiStream(int columnIndex, java.io.InputStream x,
int length) throws java.sql.SQLException;
public void updateBinaryStream(int columnIndex, java.io.InputStream x,
int length) throws java.sql.SQLException;
public void updateCharacterStream(int columnIndex, java.io.Reader x,
int length) throws java.sql.SQLException;
public void updateObject(int columnIndex, java.lang.Object x, int scale)
throws java.sql.SQLException;
public void updateObject(int columnIndex, java.lang.Object x)
throws java.sql.SQLException;
public void updateNull(java.lang.String columnName)
throws java.sql.SQLException;
public void updateBoolean(java.lang.String columnName, boolean x)
throws java.sql.SQLException;
public void updateByte(java.lang.String columnName, byte x)
throws java.sql.SQLException;
public void updateShort(java.lang.String columnName, short x)
throws java.sql.SQLException;
public void updateInt(java.lang.String columnName, int x)
throws java.sql.SQLException;
public void updateLong(java.lang.String columnName, long x)
throws java.sql.SQLException;
public void updateFloat(java.lang.String columnName, float x)
throws java.sql.SQLException;
public void updateDouble(java.lang.String columnName, double x)
throws java.sql.SQLException;
public void updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
throws java.sql.SQLException;
public void updateString(java.lang.String columnName, java.lang.String x)
throws java.sql.SQLException;
public void updateBytes(java.lang.String columnName, byte[] x)
throws java.sql.SQLException;
public void updateDate(java.lang.String columnName, java.sql.Date x)
throws java.sql.SQLException;
public void updateTime(java.lang.String columnName, java.sql.Time x)
throws java.sql.SQLException;
public void updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
throws java.sql.SQLException;
public void updateAsciiStream(java.lang.String columnName,
java.io.InputStream x, int length)
throws java.sql.SQLException;
public void updateBinaryStream(java.lang.String columnName,
java.io.InputStream x, int length)
throws java.sql.SQLException;
public void updateCharacterStream(java.lang.String columnName,
java.io.Reader reader, int length)
throws java.sql.SQLException;
public void updateObject(java.lang.String columnName, java.lang.Object x,
int scale) throws java.sql.SQLException;
public void updateObject(java.lang.String columnName, java.lang.Object x)
throws java.sql.SQLException;
public Statement getStatement() throws java.sql.SQLException;
public Object getObject(int colIndex, java.util.Map map)
throws java.sql.SQLException;
public Ref getRef(int colIndex) throws java.sql.SQLException;
public Blob getBlob(int colIndex) throws java.sql.SQLException;
public Clob getClob(int colIndex) throws java.sql.SQLException;
public Array getArray(int colIndex) throws java.sql.SQLException;
public Object getObject(java.lang.String colName, java.util.Map map)
throws java.sql.SQLException;
public Ref getRef(java.lang.String colName) throws java.sql.SQLException;
public Blob getBlob(java.lang.String colName) throws java.sql.SQLException;
public Clob getClob(java.lang.String colName) throws java.sql.SQLException;
public Array getArray(java.lang.String colName) throws java.sql.SQLException;
public Date getDate(int columnIndex, java.util.Calendar cal)
throws java.sql.SQLException;
public Date getDate(java.lang.String columnName, java.util.Calendar cal)
throws java.sql.SQLException;
public Time getTime(int columnIndex, java.util.Calendar cal)
throws java.sql.SQLException;
public Time getTime(java.lang.String columnName, java.util.Calendar cal)
throws java.sql.SQLException;
public Timestamp getTimestamp(int columnIndex, java.util.Calendar cal)
throws java.sql.SQLException;
public Timestamp getTimestamp(java.lang.String columnName,
java.util.Calendar cal)
throws java.sql.SQLException;
public URL getURL(int columnIndex) throws java.sql.SQLException;
public URL getURL(java.lang.String columnName) throws java.sql.SQLException;
public void updateRef(int columnIndex, java.sql.Ref x)
throws java.sql.SQLException;
public void updateRef(java.lang.String columnName, java.sql.Ref x)
throws java.sql.SQLException;
public void updateBlob(int columnIndex, java.sql.Blob x)
throws java.sql.SQLException;
public void updateBlob(java.lang.String columnName, java.sql.Blob x)
throws java.sql.SQLException;
public void updateClob(int columnIndex, java.sql.Clob x)
throws java.sql.SQLException;
public void updateClob(java.lang.String columnName, java.sql.Clob x)
throws java.sql.SQLException;
public void updateArray(int columnIndex, java.sql.Array x)
throws java.sql.SQLException;
public void updateArray(java.lang.String columnName, java.sql.Array x)
throws java.sql.SQLException;
}
Synopsis: public OPLCachedRowSet() throws java.sql.SQLException;
Create a OPLCachedRowSet object. The object has no metadata.
Synopsis: public boolean absolute(int row) throws java.sql.SQLException;
Move to an absolute row number in the rowset. It notifies listeners that the cursor has moved.
If row is positive, moves to an absolute row with respect to the beginning of the rowset. The first row is row 1, the second is row 2, etc.
If row is negative, moves to an absolute row position with respect to the end of rowset. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) indicates the next-to-last row, etc.
An attempt to position the cursor beyond the first/last row in the rowset, leaves the cursor before/after the first/last row, respectively.
Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().
Synopsis: public void acceptChanges() throws java.sql.SQLException;
Propagate all row update, insert, and delete changes to a data source. An SQLException is thrown if any of the updates cannot be propagated. If acceptChanges() fails then the caller can assume that none of the updates are reflected in the data source. The current row is set to the first "updated" row that resulted in an exception, in the case that an exception is thrown. With one exception, if the row that caused the exception is a "deleted" row, then in the usual case, when deleted rows are not shown, the current row isn't affected. When successful, calling acceptChanges() replaces the original value of the rowset with the current value. Note: Both the original and current value of the rowset are maintained. The original state is the value of the rowset following its creation (i.e. empty), or following the last call to acceptChanges(), execute(), populate(), release(), or restoreOriginal(). Internally, a RowSetWriter component is envoked to write the data for each row.
Synopsis: public void acceptChanges(java.sql.Connection _conn)
throws java.sql.SQLException;
Like acceptChanges() above, but takes a Connection argument. The Connection is used internally when doing the updates. This form isn't used unless the underlying data source is a JDBC data source.
Synopsis: public void afterLast() throws java.sql.SQLException;
Moves to the end of the rowset, just after the last row. Has no effect if the rowset contains no rows. It notifies listeners that the cursor has moved.
Synopsis: public void beforeFirst() throws java.sql.SQLException;
Moves to the front of the rowset, just before the first row. Has no effect if the rowset contains no rows. It notifies listeners that the cursor has moved.
Synopsis: public void cancelRowDelete() throws java.sql.SQLException;
Cancels deletion of the current row and notifies listeners that a row has changed. After calling cancelRowDelete() the current row is no longer marked for deletion. An exception is thrown if there is no current row. Note: This method can be ignored if deleted rows aren't being shown (the normal case).
Synopsis: public void cancelRowInsert() throws java.sql.SQLException;
Cancels insertion of the current row and notifies listeners that a row has changed. An exception is thrown if the row isn't an inserted row. The current row is immediately removed from the rowset. This operation cannot be undone.
Synopsis: public void cancelRowUpdates() throws java.sql.SQLException;
The cancelRowUpdates() method may be called after calling an updateXXX() method(s) and before calling updateRow() to rollback the updates made to a row. If no updates have been made or updateRow() has already been called, then this method has no effect. It notifies listeners that a row has changed, if it has effect.
Synopsis: public void clearWarnings() throws java.sql.SQLException;
After this call getWarnings returns null until a new warning is reported for this ResultSet.
Synopsis: public void close() throws java.sql.SQLException;
Releases the current contents of this rowset, discarding outstanding updates. The rowset contains no rows after the method release is called. This method sends a RowSetChangedEvent object to all registered listeners prior to returning.
Synopsis: public boolean columnUpdated(int columnIndex)
throws java.sql.SQLException;
Determine if the column from the current row has been updated.
Synopsis: public RowSet createCopy() throws java.sql.SQLException;
Creates a RowSet object that is a deep copy of this OPLCachedRowSet object's data. Updates made on a copy are not visible to the original rowset; a copy of a rowset is completely independent from the original. Making a copy saves the cost of creating an identical rowset from first principles, which can be quite expensive. For example, it doesn't do the query to a remote database server.
Synopsis: public RowSet createShared() throws java.sql.SQLException;
Returns a new rowset object backed by the same data. Updates made by a shared duplicate are visible to the original rowset and other duplicates. A rowset and its duplicates form a set of cursors that iterate over a shared set of rows, providing different views of the underlying data. Duplicates also share property values. So, for example, if a rowset is read-only then all of its duplicates will be read-only.
Synopsis: public void deleteRow() throws java.sql.SQLException;
Delete the current row from this OPLCachedRowSet object and it notifies listeners that a row has changed. Cannot be called when the cursor is on the insert row. The method marks the current row as deleted, but it does not delete the row from the underlying data source. The method acceptChanges must be called to delete the row in the data source.
Synopsis: public void execute() throws java.sql.SQLException;