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

com.sun.sql.rowset
Class JdbcRowSetXImpl

java.lang.Object
  extended byjavax.sql.rowset.BaseRowSet
      extended bycom.sun.sql.rowset.BaseRowSetX
          extended bycom.sun.sql.rowset.JdbcRowSetXImpl
All Implemented Interfaces:
java.lang.Cloneable, JdbcRowSet, JdbcRowSetX, Joinable, java.sql.ResultSet, javax.sql.RowSet, java.io.Serializable
public class JdbcRowSetXImpl
extends BaseRowSetX
implements JdbcRowSetX, Joinable

The standard implementation of the JdbcRowSetX interface. See the interface defintion for full behavior and implementation requirements.

See Also:
Serialized Form

Field Summary
 
Fields inherited from class javax.sql.rowset.BaseRowSet
ASCII_STREAM_PARAM, asciiStream, BINARY_STREAM_PARAM, binaryStream, charStream, UNICODE_STREAM_PARAM, unicodeStream
 
Fields inherited from interface java.sql.ResultSet
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE
 
Constructor Summary
JdbcRowSetXImpl()
          Constructs a default JdbcRowSetXImpl object instance.
JdbcRowSetXImpl(java.sql.Connection con)
          Constructs a JdbcRowSetX object given a valid Connection object instance.
JdbcRowSetXImpl(java.sql.ResultSet res)
          Constructs a JdbcRowSetX object using a given valid ResultSet object instance.
JdbcRowSetXImpl(java.lang.String url, java.lang.String user, java.lang.String password)
          Constructs a JdbcRowSetX object using the standard JDBC URL and username and password parameters.
 
Method Summary
 boolean absolute(int row)
           
 void addPropertyChangeListener(java.beans.PropertyChangeListener listener)
          Add a PropertyChangeListener to the listener list.
 void addPropertyChangeListener(java.lang.String propertyName, java.beans.PropertyChangeListener listener)
          Add a PropertyChangeListener for a specific property.
 void afterLast()
           
 void beforeFirst()
           
 void cancelRowUpdates()
           
 void clearWarnings()
           
 void close()
           
 void closePreparedStatement()
          Closes the internal PreparedStatement and ResultSet objects.
 void closeResultSet()
          Closes the internal ResultSet object.
 void commit()
          Each JdbcRowSet contains a Connection object from the ResultSet or JDBC properties passed to it's constructors.
protected  java.sql.Connection connect()
           
 void deleteRow()
           
 void execute()
           
 int findColumn(java.lang.String columnName)
           
 boolean first()
           
 java.sql.Array getArray(int columnIndex)
           
 java.sql.Array getArray(java.lang.String colName)
           
 java.io.InputStream getAsciiStream(int columnIndex)
           
 java.io.InputStream getAsciiStream(java.lang.String columnName)
           
 boolean getAutoCommit()
          Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
 java.math.BigDecimal getBigDecimal(int columnIndex)
           
 java.math.BigDecimal getBigDecimal(int columnIndex, int scale)
           
 java.math.BigDecimal getBigDecimal(java.lang.String columnName)
           
 java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale)
           
 java.io.InputStream getBinaryStream(int columnIndex)
           
 java.io.InputStream getBinaryStream(java.lang.String columnName)
           
 java.sql.Blob getBlob(int columnIndex)
           
 java.sql.Blob getBlob(java.lang.String colName)
           
 boolean getBoolean(int columnIndex)
           
 boolean getBoolean(java.lang.String columnName)
           
 byte getByte(int columnIndex)
           
 byte getByte(java.lang.String columnName)
           
 byte[] getBytes(int columnIndex)
           
 byte[] getBytes(java.lang.String columnName)
           
 java.io.Reader getCharacterStream(int columnIndex)
           
 java.io.Reader getCharacterStream(java.lang.String columnName)
           
 java.sql.Clob getClob(int columnIndex)
           
 java.sql.Clob getClob(java.lang.String colName)
           
 int getConcurrency()
          Returns the concurrency for this RowSet object.
 java.lang.String getCursorName()
           
 java.sql.DatabaseMetaData getDatabaseMetaData()
          Retrieves a DatabaseMetaData object that contains metadata about the database to which this JdbcRowSetX object references.
 java.sql.Date getDate(int columnIndex)
           
 java.sql.Date getDate(int columnIndex, java.util.Calendar cal)
           
 java.sql.Date getDate(java.lang.String columnName)
           
 java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal)
           
 double getDouble(int columnIndex)
           
 double getDouble(java.lang.String columnName)
           
 int getFetchDirection()
          Retrieves this RowSet object's current setting for the fetch direction.
 int getFetchSize()
          Returns the fetch size for this RowSet object.
 float getFloat(int columnIndex)
           
 float getFloat(java.lang.String columnName)
           
 int getHoldability()
          Retrieves the current holdability of this JdbcRowSetX object
 int getInt(int columnIndex)
           
 int getInt(java.lang.String columnName)
           
 long getLong(int columnIndex)
           
 long getLong(java.lang.String columnName)
           
 int[] getMatchColumnIndexes()
          Retrieves the column id as int array that was set using setMatchColumn(int []) for this rowset.
 java.lang.String[] getMatchColumnNames()
          Retrieves the column name as String array that was set using setMatchColumn(String []) for this rowset.
 java.sql.ResultSetMetaData getMetaData()
          Retrieves the number, types and properties of this rowset's ResultSet object's columns.
 java.lang.Object getObject(int columnIndex)
           
 java.lang.Object getObject(int columnIndex, java.util.Map map)
           
 java.lang.Object getObject(java.lang.String columnName)
           
 java.lang.Object getObject(java.lang.String colName, java.util.Map map)
           
 java.sql.ParameterMetaData getParameterMetaData()
          Retrieves the number, types and properties of this JdbcRowSetX object's parameters.
protected  java.sql.PreparedStatement getPreparedStatement()
           
 java.sql.Ref getRef(int columnIndex)
           
 java.sql.Ref getRef(java.lang.String colName)
           
 int getRow()
           
 RowSetWarning getRowSetWarnings()
          Retrieves the first warning reported by calls on this JdbcRowSet object.
 short getShort(int columnIndex)
           
 short getShort(java.lang.String columnName)
           
 java.sql.Statement getStatement()
           
 java.lang.String getString(int columnIndex)
           
 java.lang.String getString(java.lang.String columnName)
           
 java.sql.Time getTime(int columnIndex)
           
 java.sql.Time getTime(int columnIndex, java.util.Calendar cal)
           
 java.sql.Time getTime(java.lang.String columnName)
           
 java.sql.Time getTime(java.lang.String columnName, java.util.Calendar cal)
           
 java.sql.Timestamp getTimestamp(int columnIndex)
           
 java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal)
           
 java.sql.Timestamp getTimestamp(java.lang.String columnName)
           
 java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal)
           
 int getType()
          Returns the type of this RowSet object.
 java.io.InputStream getUnicodeStream(int columnIndex)
           
 java.io.InputStream getUnicodeStream(java.lang.String columnName)
           
 java.net.URL getURL(int columnIndex)
           
 java.net.URL getURL(java.lang.String columnName)
           
 java.sql.SQLWarning getWarnings()
           
 void insertRow()
           
 boolean isAfterLast()
           
 boolean isBeforeFirst()
           
 boolean isExecuted()
          Returns true if this rowset is in an executed state
 boolean isFirst()
           
 boolean isLast()
           
 boolean last()
           
 void moveToCurrentRow()
           
 void moveToInsertRow()
           
 boolean next()
           
 boolean previous()
           
 void refreshRow()
           
 boolean relative(int rows)
           
 void releaseSavepoint(java.sql.Savepoint savepoint)
          Removes the given Savepoint object from the current transaction.
 void removePropertyChangeListener(java.beans.PropertyChangeListener listener)
          Remove a PropertyChangeListener from the listener list.
 void removePropertyChangeListener(java.lang.String propertyName, java.beans.PropertyChangeListener listener)
          Remove a PropertyChangeListener for a specific property.
 void rollback()
          Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
 void rollback(java.sql.Savepoint s)
          Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
 boolean rowDeleted()
           
 boolean rowInserted()
           
 boolean rowUpdated()
           
 void setAutoCommit(boolean autoCommit)
          Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
 void setCommand(java.lang.String command)
          Sets this RowSet object's command property to the given String object and clears the parameters, if any, that were set for the previous command.
 void setConcurrency(int concurrency)
          Sets the concurrency for this RowSet object to the specified concurrency.
 void setDataSourceName(java.lang.String dataSourceName)
          Sets the DataSource name property for this RowSet object to the given logical name and sets this RowSet object's Url property to null.
 void setFetchDirection(int direction)
          Gives the driver a performance hint as to the direction in which the rows in this RowSet object will be processed.
 void setFetchSize(int rows)
          Sets the fetch size for this RowSet object to the given number of rows.
 void setHoldability(int holdability)
          Changes the holdability of this JdbcRowSetX object to the given holdability.
 void setMatchColumn(int columnIdx)
          Sets the designated parameter to the given int object.
 void setMatchColumn(int[] columnIdxes)
          Sets the designated parameter to the given int array.
 void setMatchColumn(java.lang.String columnName)
          Sets the designated parameter to the given String object.
 void setMatchColumn(java.lang.String[] columnNames)
          Sets the designated parameter to the given String array.
 void setMaxRows(int maxRows)
          Sets the maximum number of rows that this RowSet object may contain to the given number.
 void setPassword(java.lang.String password)
          Sets the password used to create a database connection for this RowSet object to the given String object.
 java.sql.Savepoint setSavepoint()
          Creates an unnamed savepoint in the current transaction and returns the new Savepoint object that represents it.
 java.sql.Savepoint setSavepoint(java.lang.String name)
          Creates a savepoint with the given name in the current transaction and returns the new Savepoint object that represents it.
 void setTransactionIsolation(int transactionIsolation)
          Sets the transaction isolation property for this JDBC RowSet object to the given constant.
 void setType(int type)
          Sets the type for this RowSet object to the specified type.
 void setUrl(java.lang.String url)
          Sets the Url property for this RowSet object to the given String object and sets the dataSource name property to null.
 void setUsername(java.lang.String username)
          Sets the username property for this RowSet object to the given user name.
 void unsetMatchColumn(int columnIdx)
          Unsets the designated parameter to the given int object.
 void unsetMatchColumn(int[] columnIdxes)
          Unsets the designated parameter to the given int array.
 void unsetMatchColumn(java.lang.String columnName)
          Unsets the designated parameter to the given String object.
 void unsetMatchColumn(java.lang.String[] columnIdxes)
          Unsets the designated parameter to the given String array.
 void updateArray(int columnIndex, java.sql.Array a)
           
 void updateArray(java.lang.String columnName, java.sql.Array a)
           
 void updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
           
 void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)
           
 void updateBigDecimal(int columnIndex, java.math.BigDecimal x)
           
 void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)
           
 void updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
           
 void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)
           
 void updateBlob(int columnIndex, java.sql.Blob b)
           
 void updateBlob(java.lang.String columnName, java.sql.Blob b)
           
 void updateBoolean(int columnIndex, boolean x)
           
 void updateBoolean(java.lang.String columnName, boolean x)
           
 void updateByte(int columnIndex, byte x)
           
 void updateByte(java.lang.String columnName, byte x)
           
 void updateBytes(int columnIndex, byte[] x)
           
 void updateBytes(java.lang.String columnName, byte[] x)
           
 void updateCharacterStream(int columnIndex, java.io.Reader x, int length)
           
 void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length)
           
 void updateClob(int columnIndex, java.sql.Clob c)
           
 void updateClob(java.lang.String columnName, java.sql.Clob c)
           
 void updateDate(int columnIndex, java.sql.Date x)
           
 void updateDate(java.lang.String columnName, java.sql.Date x)
           
 void updateDouble(int columnIndex, double x)
           
 void updateDouble(java.lang.String columnName, double x)
           
 void updateFloat(int columnIndex, float x)
           
 void updateFloat(java.lang.String columnName, float x)
           
 void updateInt(int columnIndex, int x)
           
 void updateInt(java.lang.String columnName, int x)
           
 void updateLong(int columnIndex, long x)
           
 void updateLong(java.lang.String columnName, long x)
           
 void updateNull(int columnIndex)
           
 void updateNull(java.lang.String columnName)
           
 void updateObject(int columnIndex, java.lang.Object x)
           
 void updateObject(int columnIndex, java.lang.Object x, int scale)
           
 void updateObject(java.lang.String columnName, java.lang.Object x)
           
 void updateObject(java.lang.String columnName, java.lang.Object x, int scale)
           
 void updateRef(int columnIndex, java.sql.Ref ref)
           
 void updateRef(java.lang.String columnName, java.sql.Ref ref)
           
 void updateRow()
           
 void updateShort(int columnIndex, short x)
           
 void updateShort(java.lang.String columnName, short x)
           
 void updateString(int columnIndex, java.lang.String x)
           
 void updateString(java.lang.String columnName, java.lang.String x)
           
 void updateTime(int columnIndex, java.sql.Time x)
           
 void updateTime(java.lang.String columnName, java.sql.Time x)
           
 void updateTimestamp(int columnIndex, java.sql.Timestamp x)
           
 void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x)
           
 boolean wasNull()
           
 
Methods inherited from class com.sun.sql.rowset.BaseRowSetX
getMaxRows
 
Methods inherited from class javax.sql.rowset.BaseRowSet
addRowSetListener, clearParameters, getCommand, getDataSourceName, getEscapeProcessing, getMaxFieldSize, getParams, getPassword, getQueryTimeout, getShowDeleted, getTransactionIsolation, getTypeMap, getUrl, getUsername, initParams, isReadOnly, notifyCursorMoved, notifyRowChanged, notifyRowSetChanged, removeRowSetListener, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setEscapeProcessing, setFloat, setInt, setLong, setMaxFieldSize, setNull, setNull, setObject, setObject, setObject, setQueryTimeout, setReadOnly, setRef, setShort, setShowDeleted, setString, setTime, setTime, setTimestamp, setTimestamp, setTypeMap
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface javax.sql.rowset.JdbcRowSet
getShowDeleted, setShowDeleted
 
Methods inherited from interface javax.sql.RowSet
addRowSetListener, clearParameters, getCommand, getDataSourceName, getEscapeProcessing, getMaxFieldSize, getMaxRows, getPassword, getQueryTimeout, getTransactionIsolation, getTypeMap, getUrl, getUsername, isReadOnly, removeRowSetListener, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setEscapeProcessing, setFloat, setInt, setLong, setMaxFieldSize, setNull, setNull, setObject, setObject, setObject, setQueryTimeout, setReadOnly, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setTypeMap
 

Constructor Detail

JdbcRowSetXImpl

public JdbcRowSetXImpl()
Constructs a default JdbcRowSetXImpl object instance.

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

JdbcRowSetXImpl

public JdbcRowSetXImpl(java.sql.Connection con)
                throws java.sql.SQLException
Constructs a JdbcRowSetX object given a valid Connection object instance.

Parameters:
con - - a JDBC Connection instance
Throws:
java.sql.SQLException - if a database error occurs

JdbcRowSetXImpl

public JdbcRowSetXImpl(java.lang.String url,
                       java.lang.String user,
                       java.lang.String password)
                throws java.sql.SQLException
Constructs a JdbcRowSetX object using the standard JDBC URL and username and password parameters.

Parameters:
url - - a database url of the form jdbc:subprotocol:subname
user - - the database user on whose behalf the connection is being made.
password - - the user's password.
Throws:
java.sql.SQLException - if a database error occurs

JdbcRowSetXImpl

public JdbcRowSetXImpl(java.sql.ResultSet res)
                throws java.sql.SQLException
Constructs a JdbcRowSetX object using a given valid ResultSet object instance.

Parameters:
res - the ResultSet object.
Throws:
java.sql.SQLException - if a database error occurs
Method Detail

isExecuted

public boolean isExecuted()
                   throws java.sql.SQLException
Description copied from interface: JdbcRowSetX
Returns true if this rowset is in an executed state

Specified by:
isExecuted in interface JdbcRowSetX
Returns:
a boolean true if, in its presnt state, calls that act on the internal ResultSet (e.g., next()) will not throw a SQLException for the reason: "rowset not executed") else returns false
Throws:
java.sql.SQLException - if a database access error occurs

execute

public void execute()
             throws java.sql.SQLException
Specified by:
execute in interface javax.sql.RowSet
Throws:
java.sql.SQLException

connect

protected java.sql.Connection connect()
                               throws java.sql.SQLException
Throws:
java.sql.SQLException

setCommand

public void setCommand(java.lang.String command)
                throws java.sql.SQLException
Description copied from class: BaseRowSetX
Sets this RowSet object's command property to the given String object and clears the parameters, if any, that were set for the previous command.

The command property may not be needed if the RowSet object gets its data from a source that does not support commands, such as a spreadsheet or other tabular file. Thus, this property is optional and may be null.

Specified by:
setCommand in interface javax.sql.RowSet
Overrides:
setCommand in class BaseRowSetX
Parameters:
command - a String object containing an SQL query that will be set as this RowSet object's command property; may be null but may not be an empty string
Throws:
java.sql.SQLException - if an empty string is provided as the command value
See Also:
BaseRowSet.getCommand()

setDataSourceName

public void setDataSourceName(java.lang.String dataSourceName)
                       throws java.sql.SQLException
Description copied from class: BaseRowSetX
Sets the DataSource name property for this RowSet object to the given logical name and sets this RowSet object's Url property to null. The name must have been bound to a DataSource object in a JNDI naming service so that an application can do a lookup using that name to retrieve the DataSource object bound to it. The DataSource object can then be used to establish a connection to the data source it represents.

Users should set either the Url property or the dataSourceName property. If both properties are set, the driver will use the property set most recently.

Specified by:
setDataSourceName in interface javax.sql.RowSet
Overrides:
setDataSourceName in class BaseRowSetX
Parameters:
dataSourceName - a String object with the name that can be supplied to a naming service based on JNDI technology to retrieve the DataSource object that can be used to get a connection; may be null but must not be an empty string
Throws:
java.sql.SQLException - if there is a problem setting the dataSourceName property or name is an empty string
See Also:
BaseRowSet.getDataSourceName()

setUrl

public void setUrl(java.lang.String url)
            throws java.sql.SQLException
Description copied from class: BaseRowSetX
Sets the Url property for this RowSet object to the given String object and sets the dataSource name property to null. The Url property is a JDBC URL that is used when the connection is created using a JDBC technology-enabled driver ("JDBC driver") and the DriverManager. The correct JDBC URL for the specific driver to be used can be found in the driver documentation. Although there are guidelines for for how a JDBC URL is formed, a driver vendor can specify any String object except one with a length of 0 (an empty string).

Setting the Url property is optional if connections are established using a DataSource object instead of the DriverManager. The driver will use either the URL property or the dataSourceName property to create a connection, whichever was specified most recently. If an application uses a JDBC URL, it must load a JDBC driver that accepts the JDBC URL before it uses the RowSet object to connect to a database. The RowSet object will use the URL internally to create a database connection in order to read or write data.

Specified by:
setUrl in interface javax.sql.RowSet
Overrides:
setUrl in class BaseRowSetX
Parameters:
url - a String object that contains the JDBC URL that will be used to establish the connection to a database for this RowSet object; may be null but must not be an empty string
Throws:
java.sql.SQLException - if an error occurs setting the Url property or the parameter supplied is a string with a length of 0 (an empty string)
See Also:
BaseRowSet.getUrl()

setUsername

public void setUsername(java.lang.String username)
Description copied from class: BaseRowSet
Sets the username property for this RowSet object to the given user name. Because it is not serialized, the username property is set at run time before calling the method execute.

Specified by:
setUsername in interface javax.sql.RowSet
Overrides:
setUsername in class BaseRowSet
Parameters:
username - the String object containing the user name that is supplied to the data source to create a connection. It may be null.
See Also:
BaseRowSet.getUsername()

setPassword

public void setPassword(java.lang.String password)
Description copied from class: BaseRowSet
Sets the password used to create a database connection for this RowSet object to the given String object. Because the password property is not serialized, it is set at run time before calling the method execute.

Specified by:
setPassword in interface javax.sql.RowSet
Overrides:
setPassword in class BaseRowSet
Parameters:
password - the String object that represents the password that is supplied to the database to create a connection. It may be null.
See Also:
BaseRowSet.getPassword()

setType

public void setType(int type)
             throws java.sql.SQLException
Description copied from class: BaseRowSet
Sets the type for this RowSet object to the specified type. The default type is ResultSet.TYPE_SCROLL_INSENSITIVE.

Specified by:
setType in interface javax.sql.RowSet
Overrides:
setType in class BaseRowSet
Parameters:
type - one of the following constants: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
Throws:
java.sql.SQLException - if the parameter supplied is not one of the following constants: ResultSet.TYPE_FORWARD_ONLY or ResultSet.TYPE_SCROLL_INSENSITIVE ResultSet.TYPE_SCROLL_SENSITIVE
See Also:
BaseRowSet.getConcurrency(), BaseRowSet.getType()

setConcurrency

public void setConcurrency(int concurrency)
                    throws java.sql.SQLException
Description copied from class: BaseRowSet
Sets the concurrency for this RowSet object to the specified concurrency. The default concurrency for any RowSet object (connected or disconnected) is ResultSet.CONCUR_UPDATABLE, but this method may be called at any time to change the concurrency.

Specified by:
setConcurrency in interface javax.sql.RowSet
Overrides:
setConcurrency in class BaseRowSet
Parameters:
concurrency - one of the following constants: ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
Throws:
java.sql.SQLException - if the parameter supplied is not one of the following constants: ResultSet.CONCUR_UPDATABLE or ResultSet.CONCUR_READ_ONLY
See Also:
BaseRowSet.getConcurrency(), BaseRowSet.isReadOnly()

setTransactionIsolation

public void setTransactionIsolation(int transactionIsolation)
                             throws java.sql.SQLException
Description copied from class: BaseRowSet
Sets the transaction isolation property for this JDBC RowSet object to the given constant. The DBMS will use this transaction isolation level for transactions if it can.

For RowSet implementations such as the CachedRowSet that operate in a disconnected environment, the SyncProvider object being used offers complementary locking and data integrity options. The options described below are pertinent only to connected RowSet objects (JdbcRowSet objects).

Specified by:
setTransactionIsolation in interface javax.sql.RowSet
Overrides:
setTransactionIsolation in class BaseRowSet
Parameters:
transactionIsolation - one of the following constants, listed in ascending order: Connection.TRANSACTION_NONE, Connection.TRANSACTION_READ_UNCOMMITTED, Connection.TRANSACTION_READ_COMMITTED, Connection.TRANSACTION_REPEATABLE_READ, or Connection.TRANSACTION_SERIALIZABLE
Throws:
java.sql.SQLException - if the given parameter is not one of the Connection constants
See Also:
SyncFactory, SyncProvider, BaseRowSet.getTransactionIsolation()

setMaxRows

public void setMaxRows(int maxRows)
                throws java.sql.SQLException
Description copied from class: BaseRowSetX
Sets the maximum number of rows that this RowSet object may contain to the given number. If this limit is exceeded, the excess rows are silently dropped.

Specified by:
setMaxRows in interface javax.sql.RowSet
Overrides:
setMaxRows in class BaseRowSetX
Parameters:
maxRows - an int indicating the current maximum number of rows; zero means that there is no limit
Throws:
java.sql.SQLException - if an error occurs internally setting the maximum limit on the number of rows that a JDBC RowSet object can contain; or if max is less than 0; or if max is less than the fetchSize of the RowSet

getPreparedStatement

protected java.sql.PreparedStatement getPreparedStatement()
                                                   throws java.sql.SQLException
Throws:
java.sql.SQLException

next

public boolean next()
             throws java.sql.SQLException
Specified by:
next in interface java.sql.ResultSet
Throws:
java.sql.SQLException

close

public void close()
Specified by:
close in interface java.sql.ResultSet

closePreparedStatement

public void closePreparedStatement()
Description copied from interface: JdbcRowSetX
Closes the internal PreparedStatement and ResultSet objects.

Specified by:
closePreparedStatement in interface JdbcRowSetX

closeResultSet

public void closeResultSet()
Description copied from interface: JdbcRowSetX
Closes the internal ResultSet object.

Specified by:
closeResultSet in interface JdbcRowSetX

wasNull

public boolean wasNull()
                throws java.sql.SQLException
Specified by:
wasNull in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getString

public java.lang.String getString(int columnIndex)
                           throws java.sql.SQLException
Specified by:
getString in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBoolean

public boolean getBoolean(int columnIndex)
                   throws java.sql.SQLException
Specified by:
getBoolean in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getByte

public byte getByte(int columnIndex)
             throws java.sql.SQLException
Specified by:
getByte in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getShort

public short getShort(int columnIndex)
               throws java.sql.SQLException
Specified by:
getShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getInt

public int getInt(int columnIndex)
           throws java.sql.SQLException
Specified by:
getInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getLong

public long getLong(int columnIndex)
             throws java.sql.SQLException
Specified by:
getLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getFloat

public float getFloat(int columnIndex)
               throws java.sql.SQLException
Specified by:
getFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getDouble

public double getDouble(int columnIndex)
                 throws java.sql.SQLException
Specified by:
getDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex,
                                          int scale)
                                   throws java.sql.SQLException
Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBytes

public byte[] getBytes(int columnIndex)
                throws java.sql.SQLException
Specified by:
getBytes in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getDate

public java.sql.Date getDate(int columnIndex)
                      throws java.sql.SQLException
Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getTime

public java.sql.Time getTime(int columnIndex)
                      throws java.sql.SQLException
Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex)
                                throws java.sql.SQLException
Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getAsciiStream

public java.io.InputStream getAsciiStream(int columnIndex)
                                   throws java.sql.SQLException
Specified by:
getAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getUnicodeStream

public java.io.InputStream getUnicodeStream(int columnIndex)
                                     throws java.sql.SQLException
Specified by:
getUnicodeStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBinaryStream

public java.io.InputStream getBinaryStream(int columnIndex)
                                    throws java.sql.SQLException
Specified by:
getBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getString

public java.lang.String getString(java.lang.String columnName)
                           throws java.sql.SQLException
Specified by:
getString in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBoolean

public boolean getBoolean(java.lang.String columnName)
                   throws java.sql.SQLException
Specified by:
getBoolean in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getByte

public byte getByte(java.lang.String columnName)
             throws java.sql.SQLException
Specified by:
getByte in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getShort

public short getShort(java.lang.String columnName)
               throws java.sql.SQLException
Specified by:
getShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getInt

public int getInt(java.lang.String columnName)
           throws java.sql.SQLException
Specified by:
getInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getLong

public long getLong(java.lang.String columnName)
             throws java.sql.SQLException
Specified by:
getLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getFloat

public float getFloat(java.lang.String columnName)
               throws java.sql.SQLException
Specified by:
getFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getDouble

public double getDouble(java.lang.String columnName)
                 throws java.sql.SQLException
Specified by:
getDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                          int scale)
                                   throws java.sql.SQLException
Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBytes

public byte[] getBytes(java.lang.String columnName)
                throws java.sql.SQLException
Specified by:
getBytes in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getDate

public java.sql.Date getDate(java.lang.String columnName)
                      throws java.sql.SQLException
Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getTime

public java.sql.Time getTime(java.lang.String columnName)
                      throws java.sql.SQLException
Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName)
                                throws java.sql.SQLException
Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String columnName)
                                   throws java.sql.SQLException
Specified by:
getAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String columnName)
                                     throws java.sql.SQLException
Specified by:
getUnicodeStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String columnName)
                                    throws java.sql.SQLException
Specified by:
getBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException
Specified by:
getWarnings in interface java.sql.ResultSet
Throws:
java.sql.SQLException

clearWarnings

public void clearWarnings()
Specified by:
clearWarnings in interface java.sql.ResultSet

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException
Specified by:
getCursorName in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException
Retrieves the number, types and properties of this rowset's ResultSet object's columns.

Specified by:
getMetaData in interface java.sql.ResultSet
Returns:
the description of this rowset's ResultSet object's columns
Throws:
java.sql.SQLException - if a database access error occurs

getObject

public java.lang.Object getObject(int columnIndex)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getObject

public java.lang.Object getObject(java.lang.String columnName)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException

findColumn

public int findColumn(java.lang.String columnName)
               throws java.sql.SQLException
Specified by:
findColumn in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getCharacterStream

public java.io.Reader getCharacterStream(int columnIndex)
                                  throws java.sql.SQLException
Specified by:
getCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String columnName)
                                  throws java.sql.SQLException
Specified by:
getCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex)
                                   throws java.sql.SQLException
Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName)
                                   throws java.sql.SQLException
Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException
Specified by:
isBeforeFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException
Specified by:
isAfterLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException

isFirst

public boolean isFirst()
                throws java.sql.SQLException
Specified by:
isFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException

isLast

public boolean isLast()
               throws java.sql.SQLException
Specified by:
isLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException
Specified by:
beforeFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException

afterLast

public void afterLast()
               throws java.sql.SQLException
Specified by:
afterLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException

first

public boolean first()
              throws java.sql.SQLException
Specified by:
first in interface java.sql.ResultSet
Throws:
java.sql.SQLException

last

public boolean last()
             throws java.sql.SQLException
Specified by:
last in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getRow

public int getRow()
           throws java.sql.SQLException
Specified by:
getRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException

absolute

public boolean absolute(int row)
                 throws java.sql.SQLException
Specified by:
absolute in interface java.sql.ResultSet
Throws:
java.sql.SQLException

relative

public boolean relative(int rows)
                 throws java.sql.SQLException
Specified by:
relative in interface java.sql.ResultSet
Throws:
java.sql.SQLException

previous

public boolean previous()
                 throws java.sql.SQLException
Specified by:
previous in interface java.sql.ResultSet
Throws:
java.sql.SQLException

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException
Description copied from class: BaseRowSetX
Gives the driver a performance hint as to the direction in which the rows in this RowSet object will be processed. The driver may ignore this hint.

A RowSet object inherits the default properties of the ResultSet object from which it got its data. That ResultSet object's default fetch direction is set by the Statement object that created it.

This method applies to a RowSet object only while it is connected to a database using a JDBC driver.

A RowSet object may use this method at any time to change its setting for the fetch direction.

Specified by:
setFetchDirection in interface java.sql.ResultSet
Overrides:
setFetchDirection in class BaseRowSetX
Parameters:
direction - one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
Throws:
java.sql.SQLException - if (1) the RowSet type is TYPE_FORWARD_ONLY and the given fetch direction is not FETCH_FORWARD or (2) the given fetch direction is not one of the following: ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
See Also:
BaseRowSetX.getFetchDirection()

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException
Description copied from class: BaseRowSetX
Retrieves this RowSet object's current setting for the fetch direction. The default type is ResultSet.FETCH_FORWARD

Specified by:
getFetchDirection in interface java.sql.ResultSet
Overrides:
getFetchDirection in class BaseRowSetX
Returns:
one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
Throws:
java.sql.SQLException - if an error occurs in determining the current fetch direction for fetching rows
See Also:
BaseRowSetX.setFetchDirection(int)

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException
Description copied from class: BaseRowSetX
Sets the fetch size for this RowSet object to the given number of rows. The fetch size gives a JDBC technology-enabled driver ("JDBC driver") a hint as to the number of rows that should be fetched from the database when more rows are needed for this RowSet object. If the fetch size specified is zero, the driver ignores the value and is free to make its own best guess as to what the fetch size should be.

A RowSet object inherits the default properties of the ResultSet object from which it got its data. That ResultSet object's default fetch size is set by the Statement object that created it.

This method applies to a RowSet object only while it is connected to a database using a JDBC driver. For connected RowSet implementations such as JdbcRowSet, this method has a direct and immediate effect on the underlying JDBC driver.

A RowSet object may use this method at any time to change its setting for the fetch size.

For RowSet implementations such as CachedRowSet, which operate in a disconnected environment, the SyncProvider object being used may leverage the fetch size to poll the data source and retrieve a number of rows that do not exceed the fetch size and that may form a subset of the actual rows returned by the original query. This is an implementation variance determined by the specific SyncProvider object employed by the disconnected RowSet object.

Specified by:
setFetchSize in interface java.sql.ResultSet
Overrides:
setFetchSize in class BaseRowSetX
Parameters:
rows - the number of rows to fetch; 0 to let the driver decide what the best fetch size is; must not be less than 0 or more than the maximum number of rows allowed for this RowSet object (the number returned by a call to the method BaseRowSetX.getMaxRows())
Throws:
java.sql.SQLException - if the specified fetch size is less than 0 or more than the limit for the maximum number of rows
See Also:
BaseRowSetX.getFetchSize()

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException
Description copied from class: BaseRowSetX
Returns the fetch size for this RowSet object. The default value is zero.

Specified by:
getFetchSize in interface java.sql.ResultSet
Overrides:
getFetchSize in class BaseRowSetX
Returns:
the number of rows suggested as the fetch size when this RowSet object needs more rows from the database
Throws:
java.sql.SQLException - if an error occurs determining the number of rows in the current fetch size
See Also:
BaseRowSetX.setFetchSize(int)

getType

public int getType()
            throws java.sql.SQLException
Description copied from class: BaseRowSet
Returns the type of this RowSet object. The type is initially determined by the statement that created the RowSet object. The RowSet object can call the method setType at any time to change its type. The default is TYPE_SCROLL_INSENSITIVE.

Specified by:
getType in interface java.sql.ResultSet
Overrides:
getType in class BaseRowSet
Returns:
the type of this JDBC RowSet object, which must be one of the following: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
Throws:
java.sql.SQLException - if an error occurs getting the type of of this RowSet object
See Also:
BaseRowSet.setType(int)

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException
Description copied from class: BaseRowSet
Returns the concurrency for this RowSet object. The default is CONCUR_UPDATABLE for both connected and disconnected RowSet objects.

An application can call the method setConcurrency at any time to change a RowSet object's concurrency.

Specified by:
getConcurrency in interface java.sql.ResultSet
Overrides:
getConcurrency in class BaseRowSet
Returns:
the concurrency type for this RowSet object, which must be one of the following: ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
Throws:
java.sql.SQLException - if an error occurs getting the concurrency of this RowSet object
See Also:
BaseRowSet.setConcurrency(int), BaseRowSet.isReadOnly()

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException
Specified by:
rowUpdated in interface java.sql.ResultSet
Throws:
java.sql.SQLException

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException
Specified by:
rowInserted in interface java.sql.ResultSet
Throws:
java.sql.SQLException

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException
Specified by:
rowDeleted in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNull

public void updateNull(int columnIndex)
                throws java.sql.SQLException
Specified by:
updateNull in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean x)
                   throws java.sql.SQLException
Specified by:
updateBoolean in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateByte

public void updateByte(int columnIndex,
                       byte x)
                throws java.sql.SQLException
Specified by:
updateByte in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateShort

public void updateShort(int columnIndex,
                        short x)
                 throws java.sql.SQLException
Specified by:
updateShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateInt

public void updateInt(int columnIndex,
                      int x)
               throws java.sql.SQLException
Specified by:
updateInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateLong

public void updateLong(int columnIndex,
                       long x)
                throws java.sql.SQLException
Specified by:
updateLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateFloat

public void updateFloat(int columnIndex,
                        float x)
                 throws java.sql.SQLException
Specified by:
updateFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateDouble

public void updateDouble(int columnIndex,
                         double x)
                  throws java.sql.SQLException
Specified by:
updateDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException
Specified by:
updateBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateString

public void updateString(int columnIndex,
                         java.lang.String x)
                  throws java.sql.SQLException
Specified by:
updateString in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBytes

public void updateBytes(int columnIndex,
                        byte[] x)
                 throws java.sql.SQLException
Specified by:
updateBytes in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateDate

public void updateDate(int columnIndex,
                       java.sql.Date x)
                throws java.sql.SQLException
Specified by:
updateDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateTime

public void updateTime(int columnIndex,
                       java.sql.Time x)
                throws java.sql.SQLException
Specified by:
updateTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateTimestamp

public void updateTimestamp(int columnIndex,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException
Specified by:
updateTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException
Specified by:
updateAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException
Specified by:
updateBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  java.io.Reader x,
                                  int length)
                           throws java.sql.SQLException
Specified by:
updateCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x,
                         int scale)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                         java.lang.Object x)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateNull

public void updateNull(java.lang.String columnName)
                throws java.sql.SQLException
Specified by:
updateNull in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBoolean

public void updateBoolean(java.lang.String columnName,
                          boolean x)
                   throws java.sql.SQLException
Specified by:
updateBoolean in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateByte

public void updateByte(java.lang.String columnName,
                       byte x)
                throws java.sql.SQLException
Specified by:
updateByte in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateShort

public void updateShort(java.lang.String columnName,
                        short x)
                 throws java.sql.SQLException
Specified by:
updateShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateInt

public void updateInt(java.lang.String columnName,
                      int x)
               throws java.sql.SQLException
Specified by:
updateInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateLong

public void updateLong(java.lang.String columnName,
                       long x)
                throws java.sql.SQLException
Specified by:
updateLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateFloat

public void updateFloat(java.lang.String columnName,
                        float x)
                 throws java.sql.SQLException
Specified by:
updateFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateDouble

public void updateDouble(java.lang.String columnName,
                         double x)
                  throws java.sql.SQLException
Specified by:
updateDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBigDecimal

public void updateBigDecimal(java.lang.String columnName,
                             java.math.BigDecimal x)
                      throws java.sql.SQLException
Specified by:
updateBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateString

public void updateString(java.lang.String columnName,
                         java.lang.String x)
                  throws java.sql.SQLException
Specified by:
updateString in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBytes

public void updateBytes(java.lang.String columnName,
                        byte[] x)
                 throws java.sql.SQLException
Specified by:
updateBytes in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateDate

public void updateDate(java.lang.String columnName,
                       java.sql.Date x)
                throws java.sql.SQLException
Specified by:
updateDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateTime

public void updateTime(java.lang.String columnName,
                       java.sql.Time x)
                throws java.sql.SQLException
Specified by:
updateTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateTimestamp

public void updateTimestamp(java.lang.String columnName,
                            java.sql.Timestamp x)
                     throws java.sql.SQLException
Specified by:
updateTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(java.lang.String columnName,
                              java.io.InputStream x,
                              int length)
                       throws java.sql.SQLException
Specified by:
updateAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnName,
                               java.io.InputStream x,
                               int length)
                        throws java.sql.SQLException
Specified by:
updateBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(java.lang.String columnName,
                                  java.io.Reader reader,
                                  int length)
                           throws java.sql.SQLException
Specified by:
updateCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object x,
                         int scale)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateObject

public void updateObject(java.lang.String columnName,
                         java.lang.Object x)
                  throws java.sql.SQLException
Specified by:
updateObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException

insertRow

public void insertRow()
               throws java.sql.SQLException
Specified by:
insertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateRow

public void updateRow()
               throws java.sql.SQLException
Specified by:
updateRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException

deleteRow

public void deleteRow()
               throws java.sql.SQLException
Specified by:
deleteRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException

refreshRow

public void refreshRow()
                throws java.sql.SQLException
Specified by:
refreshRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException
Specified by:
cancelRowUpdates in interface java.sql.ResultSet
Throws:
java.sql.SQLException

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException
Specified by:
moveToInsertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException
Specified by:
moveToCurrentRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getStatement

public java.sql.Statement getStatement()
                                throws java.sql.SQLException
Specified by:
getStatement in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getObject

public java.lang.Object getObject(int columnIndex,
                                  java.util.Map map)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getRef

public java.sql.Ref getRef(int columnIndex)
                    throws java.sql.SQLException
Specified by:
getRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBlob

public java.sql.Blob getBlob(int columnIndex)
                      throws java.sql.SQLException
Specified by:
getBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getClob

public java.sql.Clob getClob(int columnIndex)
                      throws java.sql.SQLException
Specified by:
getClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getArray

public java.sql.Array getArray(int columnIndex)
                        throws java.sql.SQLException
Specified by:
getArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getObject

public java.lang.Object getObject(java.lang.String colName,
                                  java.util.Map map)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getRef

public java.sql.Ref getRef(java.lang.String colName)
                    throws java.sql.SQLException
Specified by:
getRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getBlob

public java.sql.Blob getBlob(java.lang.String colName)
                      throws java.sql.SQLException
Specified by:
getBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getClob

public java.sql.Clob getClob(java.lang.String colName)
                      throws java.sql.SQLException
Specified by:
getClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getArray

public java.sql.Array getArray(java.lang.String colName)
                        throws java.sql.SQLException
Specified by:
getArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getDate

public java.sql.Date getDate(int columnIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getDate

public java.sql.Date getDate(java.lang.String columnName,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getTime

public java.sql.Time getTime(int columnIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getTime

public java.sql.Time getTime(java.lang.String columnName,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateRef

public void updateRef(int columnIndex,
                      java.sql.Ref ref)
               throws java.sql.SQLException
Specified by:
updateRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateRef

public void updateRef(java.lang.String columnName,
                      java.sql.Ref ref)
               throws java.sql.SQLException
Specified by:
updateRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateClob

public void updateClob(int columnIndex,
                       java.sql.Clob c)
                throws java.sql.SQLException
Specified by:
updateClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateClob

public void updateClob(java.lang.String columnName,
                       java.sql.Clob c)
                throws java.sql.SQLException
Specified by:
updateClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex,
                       java.sql.Blob b)
                throws java.sql.SQLException
Specified by:
updateBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateBlob

public void updateBlob(java.lang.String columnName,
                       java.sql.Blob b)
                throws java.sql.SQLException
Specified by:
updateBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateArray

public void updateArray(int columnIndex,
                        java.sql.Array a)
                 throws java.sql.SQLException
Specified by:
updateArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException

updateArray

public void updateArray(java.lang.String columnName,
                        java.sql.Array a)
                 throws java.sql.SQLException
Specified by:
updateArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getURL

public java.net.URL getURL(int columnIndex)
                    throws java.sql.SQLException
Specified by:
getURL in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getURL

public java.net.URL getURL(java.lang.String columnName)
                    throws java.sql.SQLException
Specified by:
getURL in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getRowSetWarnings

public RowSetWarning getRowSetWarnings()
                                throws java.sql.SQLException
Description copied from interface: JdbcRowSet
Retrieves the first warning reported by calls on this JdbcRowSet object. If a second warning was reported on this JdbcRowSet object, it will be chained to the first warning and can be retrieved by calling the method RowSetWarning.getNextWarning on the first warning. Subsequent warnings on this JdbcRowSet object will be chained to the RowSetWarning objects returned by the method RowSetWarning.getNextWarning. The warning chain is automatically cleared each time a new row is read. This method may not be called on a RowSet object that has been closed; doing so will cause an SQLException to be thrown.

Because it is always connected to its data source, a JdbcRowSet object can rely on the presence of active Statement, Connection, and ResultSet instances. This means that applications can obtain additional SQLWarning notifications by calling the getNextWarning methods that they provide. Disconnected Rowset objects, such as a CachedRowSet object, do not have access to these getNextWarning methods.

Specified by:
getRowSetWarnings in interface JdbcRowSet
Returns:
the first RowSetWarning object reported on this JdbcRowSet object or null if there are none
Throws:
java.sql.SQLException - if this method is called on a closed JdbcRowSet object
See Also:
RowSetWarning

unsetMatchColumn

public void unsetMatchColumn(int[] columnIdxes)
                      throws java.sql.SQLException
Unsets the designated parameter to the given int array. This was set using setMatchColumn as the column which will form the basis of the join.

The parameter value unset by this method should be same as was set.

Specified by:
unsetMatchColumn in interface Joinable
Parameters:
columnIdxes - the index into this rowset object's internal representation of parameter values
Throws:
java.sql.SQLException - if an error occurs or the parameter index is out of bounds or if the columnIdx is not the same as set using setMatchColumn(int [])
See Also:
Joinable.setMatchColumn(int)

unsetMatchColumn

public void unsetMatchColumn(java.lang.String[] columnIdxes)
                      throws java.sql.SQLException
Unsets the designated parameter to the given String array. This was set using setMatchColumn as the column which will form the basis of the join.

The parameter value unset by this method should be same as was set.

Specified by:
unsetMatchColumn in interface Joinable
Parameters:
columnIdxes - the index into this rowset object's internal representation of parameter values
Throws:
java.sql.SQLException - if an error occurs or the parameter index is out of bounds or if the columnName is not the same as set using setMatchColumn(String [])
See Also:
Joinable.setMatchColumn(int)

getMatchColumnNames

public java.lang.String[] getMatchColumnNames()
                                       throws java.sql.SQLException
Retrieves the column name as String array that was set using setMatchColumn(String []) for this rowset.

Specified by:
getMatchColumnNames in interface Joinable
Returns:
a String array object that contains the column names for the rowset which has this the match columns
Throws:
java.sql.SQLException - if an error occurs or column name is not set
See Also:
Joinable.setMatchColumn(int), Joinable.unsetMatchColumn(int)

getMatchColumnIndexes

public int[] getMatchColumnIndexes()
                            throws java.sql.SQLException
Retrieves the column id as int array that was set using setMatchColumn(int []) for this rowset.

Specified by:
getMatchColumnIndexes in interface Joinable
Returns:
a int array object that contains the column ids for the rowset which has this as the match columns.
Throws:
java.sql.SQLException - if an error occurs or column index is not set
See Also:
Joinable.setMatchColumn(int), Joinable.unsetMatchColumn(int)

setMatchColumn

public void setMatchColumn(int[] columnIdxes)
                    throws java.sql.SQLException
Sets the designated parameter to the given int array. This forms the basis of the join for the JoinRowSet as the column which will form the basis of the join.

The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumnIndexes is called.

Specified by:
setMatchColumn in interface Joinable
Parameters:
columnIdxes - the indexes into this rowset object's internal representation of parameter values; the first parameter is 0, the second is 1, and so on; must be 0 or greater
Throws:
java.sql.SQLException - if an error occurs or the parameter index is out of bounds
See Also:
Joinable.setMatchColumn(int[]), Joinable.unsetMatchColumn(int[])

setMatchColumn

public void setMatchColumn(java.lang.String[] columnNames)
                    throws java.sql.SQLException
Sets the designated parameter to the given String array. This forms the basis of the join for the JoinRowSet as the column which will form the basis of the join.

The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumn is called.

Specified by:
setMatchColumn in interface Joinable
Parameters:
columnNames - the name of the column into this rowset object's internal representation of parameter values
Throws:
java.sql.SQLException - if an error occurs or the parameter index is out of bounds
See Also:
Joinable.unsetMatchColumn(int), Joinable.setMatchColumn(int[])

setMatchColumn

public void setMatchColumn(int columnIdx)
                    throws java.sql.SQLException
Sets the designated parameter to the given int object. This forms the basis of the join for the JoinRowSet as the column which will form the basis of the join.

The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumn is called.

Specified by:
setMatchColumn in interface Joinable
Parameters:
columnIdx - the index into this rowset object's internal representation of parameter values; the first parameter is 0, the second is 1, and so on; must be 0 or greater
Throws:
java.sql.SQLException - if an error occurs or the parameter index is out of bounds
See Also:
Joinable.setMatchColumn(int[]), Joinable.unsetMatchColumn(int)

setMatchColumn

public void setMatchColumn(java.lang.String columnName)
                    throws java.sql.SQLException
Sets the designated parameter to the given String object. This forms the basis of the join for the JoinRowSet as the column which will form the basis of the join.

The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumn is called.

Specified by:
setMatchColumn in interface Joinable
Parameters:
columnName - the name of the column into this rowset object's internal representation of parameter values
Throws:
java.sql.SQLException - if an error occurs or the parameter index is out of bounds
See Also:
Joinable.unsetMatchColumn(int), Joinable.setMatchColumn(int[])

unsetMatchColumn

public void unsetMatchColumn(int columnIdx)
                      throws java.sql.SQLException
Unsets the designated parameter to the given int object. This was set using setMatchColumn as the column which will form the basis of the join.

The parameter value unset by this method should be same as was set.

Specified by:
unsetMatchColumn in interface Joinable
Parameters:
columnIdx - the index into this rowset object's internal representation of parameter values
Throws:
java.sql.SQLException - if an error occurs or the parameter index is out of bounds or if the columnIdx is not the same as set using setMatchColumn(int)
See Also:
Joinable.setMatchColumn(int)

unsetMatchColumn

public void unsetMatchColumn(java.lang.String columnName)
                      throws java.sql.SQLException
Unsets the designated parameter to the given String object. This was set using setMatchColumn as the column which will form the basis of the join.

The parameter value unset by this method should be same as was set.

Specified by:
unsetMatchColumn in interface Joinable
Parameters:
columnName - the index into this rowset object's internal representation of parameter values
Throws:
java.sql.SQLException - if an error occurs or the parameter index is out of bounds or if the columnName is not the same as set using setMatchColumn(String)
See Also:
Joinable.setMatchColumn(int)

getDatabaseMetaData

public java.sql.DatabaseMetaData getDatabaseMetaData()
                                              throws java.sql.SQLException
Description copied from interface: JdbcRowSetX
Retrieves a DatabaseMetaData object that contains metadata about the database to which this JdbcRowSetX object references. The metadata includes information about the database's tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, and so on.

Specified by:
getDatabaseMetaData in interface JdbcRowSetX
Returns:
a DatabaseMetaData object for this Connection object
Throws:
java.sql.SQLException - if a database access error occurs

releaseSavepoint

public void releaseSavepoint(java.sql.Savepoint savepoint)
                      throws java.sql.SQLException
Description copied from interface: JdbcRowSetX
Removes the given Savepoint object from the current transaction. Any reference to the savepoint after it have been removed will cause an SQLException to be thrown.

Specified by:
releaseSavepoint in interface JdbcRowSetX
Parameters:
savepoint - the Savepoint object to be removed
Throws:
java.sql.SQLException - if a database access error occurs or the given Savepoint object is not a valid savepoint in the current transaction

setSavepoint

public java.sql.Savepoint setSavepoint()
                                throws java.sql.SQLException
Description copied from interface: JdbcRowSetX
Creates an unnamed savepoint in the current transaction and returns the new Savepoint object that represents it.

Specified by:
setSavepoint in interface JdbcRowSetX
Returns:
the new Savepoint object
Throws:
java.sql.SQLException - if a database access error occurs or this Connection object is currently in auto-commit mode
See Also:
Savepoint

setSavepoint

public java.sql.Savepoint setSavepoint(java.lang.String name)
                                throws java.sql.SQLException
Description copied from interface: JdbcRowSetX
Creates a savepoint with the given name in the current transaction and returns the new Savepoint object that represents it.

Specified by:
setSavepoint in interface JdbcRowSetX
Parameters:
name - a String containing the name of the savepoint
Returns:
the new Savepoint object
Throws:
java.sql.SQLException - if a database access error occurs or this Connection object is currently in auto-commit mode
See Also:
Savepoint

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()
                                                throws java.sql.SQLException
Description copied from interface: JdbcRowSetX
Retrieves the number, types and properties of this JdbcRowSetX object's parameters.

Specified by:
getParameterMetaData in interface JdbcRowSetX
Returns:
a ParameterMetaData object that contains information about the number, types and properties of this PreparedStatement object's parameters
Throws:
java.sql.SQLException - if a database access error occurs
See Also:
ParameterMetaData

commit

public void commit()
            throws java.sql.SQLException
Description copied from interface: JdbcRowSet
Each JdbcRowSet contains a Connection object from the ResultSet or JDBC properties passed to it's constructors. This method wraps the Connection commit method to allow flexible auto commit or non auto commit transactional control support.

Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this Connection object. This method should be used only when auto-commit mode has been disabled.

Specified by:
commit in interface JdbcRowSet
Throws:
java.sql.SQLException - if a database access error occurs or this Connection object within this JdbcRowSet is in auto-commit mode
See Also:
Connection.setAutoCommit(boolean)

rollback

public void rollback()
              throws java.sql.SQLException
Description copied from interface: JdbcRowSet
Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it. Undoes all changes made in the current transaction and releases any database locks currently held by this Connection object. This method should be used only when auto-commit mode has been disabled.

Specified by:
rollback in interface JdbcRowSet
Throws:
java.sql.SQLException - if a database access error occurs or this Connection object within this JdbcRowSet is in auto-commit mode.
See Also:
JdbcRowSet.rollback(Savepoint)

rollback

public void rollback(java.sql.Savepoint s)
              throws java.sql.SQLException
Description copied from interface: JdbcRowSet
Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it. Undoes all changes made in the current transaction to the last set savepoint and releases any database locks currently held by this Connection object. This method should be used only when auto-commit mode has been disabled.

Specified by:
rollback in interface JdbcRowSet
Throws:
java.sql.SQLException - if a database access error occurs or this Connection object within this JdbcRowSet is in auto-commit mode.
See Also:
JdbcRowSet.rollback()

setAutoCommit

public void setAutoCommit(boolean autoCommit)
                   throws java.sql.SQLException
Description copied from interface: JdbcRowSet
Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it. This method wraps the Connection's getAutoCommit method to allow an application to set the JdbcRowSet transaction behavior.

Sets the current auto-commit mode for this Connection object.

Specified by:
setAutoCommit in interface JdbcRowSet
Returns:
the current state of this internal Connection object's auto-commit mode
Throws:
java.sql.SQLException - if a database access error occurs
See Also:
Connection.setAutoCommit(boolean)

getAutoCommit

public boolean getAutoCommit()
                      throws java.sql.SQLException
Description copied from interface: JdbcRowSet
Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it. This method wraps the Connection's getAutoCommit method to allow an application to determine the JdbcRowSet transaction behavior.

Sets this connection's auto-commit mode to the given state. If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions. Otherwise, its SQL statements are grouped into transactions that are terminated by a call to either the method commit or the method rollback. By default, new connections are in auto-commit mode.

Specified by:
getAutoCommit in interface JdbcRowSet
Throws:
java.sql.SQLException - if a database access error occurs
See Also:
Connection.getAutoCommit()

setHoldability

public void setHoldability(int holdability)
                    throws java.sql.SQLException
Description copied from interface: JdbcRowSetX
Changes the holdability of this JdbcRowSetX object to the given holdability.

Specified by:
setHoldability in interface JdbcRowSetX
Parameters:
holdability - a ResultSet holdability constant; one of ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
Throws:
java.sql.SQLException - if a database access occurs, the given parameter is not a ResultSet constant indicating holdability, or the given holdability is not supported
See Also:
JdbcRowSetX.getHoldability()

getHoldability

public int getHoldability()
                   throws java.sql.SQLException
Description copied from interface: JdbcRowSetX
Retrieves the current holdability of this JdbcRowSetX object

Specified by:
getHoldability in interface JdbcRowSetX
Returns:
the holdability, one of ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
Throws:
java.sql.SQLException - if a database access occurs
See Also:
JdbcRowSetX.setHoldability(int)

addPropertyChangeListener

public void addPropertyChangeListener(java.beans.PropertyChangeListener listener)
Description copied from interface: JdbcRowSetX
Add a PropertyChangeListener to the listener list. The listener is registered for all bound properties.

Specified by:
addPropertyChangeListener in interface JdbcRowSetX
Parameters:
listener - The PropertyChangeListener to be added

addPropertyChangeListener

public void addPropertyChangeListener(java.lang.String propertyName,
                                      java.beans.PropertyChangeListener listener)
Description copied from interface: JdbcRowSetX
Add a PropertyChangeListener for a specific property. The listener will be invoked only on a change of the specific property.

Specified by:
addPropertyChangeListener in interface JdbcRowSetX
Parameters:
propertyName - The name of the property to listen on.
listener - The PropertyChangeListener to be added

removePropertyChangeListener

public void removePropertyChangeListener(java.beans.PropertyChangeListener listener)
Description copied from interface: JdbcRowSetX
Remove a PropertyChangeListener from the listener list. This removes a PropertyChangeListener that was registered for all bound properties.

Specified by:
removePropertyChangeListener in interface JdbcRowSetX
Parameters:
listener - The PropertyChangeListener to be removed

removePropertyChangeListener

public void removePropertyChangeListener(java.lang.String propertyName,
                                         java.beans.PropertyChangeListener listener)
Description copied from interface: JdbcRowSetX
Remove a PropertyChangeListener for a specific property.

Specified by:
removePropertyChangeListener in interface JdbcRowSetX
Parameters:
propertyName - The name of the property that was listened on.
listener - The PropertyChangeListener to be removed
Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD