The RowSet
interface provides a set of JavaBeans properties that allow a RowSet
instance to be configured to connect to a JDBC data source and read
some data from the data source. A group of setter methods (setInt
,
setBytes
, setString
, and so on)
provide a way to pass input parameters to a rowset's command property.
This command is the SQL query the rowset uses when it gets its data from
a relational database, which is generally the case.
The RowSet
interface supports JavaBeans events, allowing other components in an
application to be notified when an event occurs on a rowset,
such as a change in its value.
The RowSet
interface is unique in that it is intended to be
implemented using the rest of the JDBC API. In other words, a
RowSet
implementation is a layer of software that executes "on top"
of a JDBC driver. Implementations of the RowSet
interface can
be provided by anyone, including JDBC driver vendors who want to
provide a RowSet
implementation as part of their JDBC products.
A RowSet
object may make a connection with a data source and
maintain that connection throughout its life cycle, in which case it is
called a connected rowset. A rowset may also make a connection with
a data source, get data from it, and then close the connection. Such a rowset
is called a disconnected rowset. A disconnected rowset may make
changes to its data while it is disconnected and then send the changes back
to the original source of the data, but it must reestablish a connection to do so.
A disconnected rowset may have a reader (a RowSetReader
object)
and a writer (a RowSetWriter
object) associated with it.
The reader may be implemented in many different ways to populate a rowset
with data, including getting data from a non-relational data source. The
writer can also be implemented in many different ways to propagate changes
made to the rowset's data back to the underlying data source.
Rowsets are easy to use. The RowSet
interface extends the standard
java.sql.ResultSet
interface. The RowSetMetaData
interface extends the java.sql.ResultSetMetaData
interface.
Thus, developers familiar
with the JDBC API will have to learn a minimal number of new APIs to
use rowsets. In addition, third-party software tools that work with
JDBC ResultSet
objects will also easily be made to work with rowsets.
ResultSet
objects should be
closed when the method Connection.commit
is called.ResultSet
object that may NOT be updated.ResultSet
object that may be updated.setFetchDirection
as a hint to the driver, which the driver may ignore.setFetchDirection
as a hint to the driver, which the driver may ignore.setFetchDirection
as a hint to the driver, which the driver may ignore.ResultSet
objects should not
be closed when the method Connection.commit
is called.ResultSet
object
whose cursor may move only forward.ResultSet
object
that is scrollable but generally not sensitive to changes made by others.ResultSet
object
that is scrollable and generally sensitive to changes made by others.ResultSet
object.
If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.
If the given row number is negative, the cursor moves to
an absolute row position with respect to
the end of the result set. For example, calling the method
absolute(-1)
positions the
cursor on the last row; calling the method absolute(-2)
moves the cursor to the next-to-last row, and so on.
An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.
Note: Calling absolute(1)
is the same
as calling first()
. Calling absolute(-1)
is the same as calling last()
.
RowSet
object.ResultSet
object, just after the
last row. This method has no effect if the result set contains no rows.ResultSet
object, just before the
first row. This method has no effect if the result set contains no rows.ResultSet
object.
This method may be called after calling an
updater method(s) and before calling
the method updateRow
to roll back
the updates made to a row. If no updates have been made or
updateRow
has already been called, this method has no
effect.RowSet
object's command.
In general, parameter values remain in force for repeated use of a
RowSet
object. 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, which can
be done by calling the method clearParameters
.
ResultSet
object.
After this method is called, the method getWarnings
returns null
until a new warning is
reported for this ResultSet
object.ResultSet
object's database and
JDBC resources immediately instead of waiting for
this to happen when it is automatically closed.
Note: A ResultSet
object
is automatically closed by the
Statement
object that generated it when
that Statement
object is closed,
re-executed, or is used to retrieve the next result from a
sequence of multiple results. A ResultSet
object
is also automatically closed when it is garbage collected.
ResultSet
object
and from the underlying database. This method cannot be called when
the cursor is on the insert row.RowSet
object with data.
The execute
method may use the following properties
to create a connection for reading data: url, data source name,
user name, password, transaction isolation, and type map.
The execute
method may use the following properties
to create a statement to execute a command:
command, read only, maximum field size,
maximum rows, escape processing, and query timeout.
If the required properties have not been set, an exception is thrown. If this method is successful, the current contents of the rowset are discarded and the rowset's metadata is also (re)set. If there are outstanding updates, they are ignored.
If this RowSet
object does not maintain a continuous connection
with its source of data, it may use a reader (a RowSetReader
object) to fill itself with data. In this case, a reader will have been
registered with this RowSet
object, and the method
execute
will call on the reader's readData
method as part of its implementation.
ResultSet
column name to its
ResultSet
column index.ResultSet
object.ResultSet
object as an Array
object
in the Java programming language.ResultSet
object as an Array
object
in the Java programming language.ResultSet
object as
a stream of ASCII characters. The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0
when the method
InputStream.available
is called whether there is data available or not.
ResultSet
object as a stream of
ASCII characters. The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARCHAR
values.
The JDBC driver will
do any necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0
when the method available
is called whether there is data available or not.
ResultSet
object as a
java.math.BigDecimal
with full precision.ResultSet
object as
a java.sql.BigDecimal
in the Java programming language.ResultSet
object as a
java.math.BigDecimal
with full precision.ResultSet
object as
a java.math.BigDecimal
in the Java programming language.ResultSet
object as a binary stream of
uninterpreted bytes. The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0
when the method
InputStream.available
is called whether there is data available or not.
ResultSet
object as a stream of uninterpreted
byte
s.
The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0
when the method available
is called whether there is data available or not.
ResultSet
object as a Blob
object
in the Java programming language.ResultSet
object as a Blob
object
in the Java programming language.ResultSet
object as
a boolean
in the Java programming language.ResultSet
object as
a boolean
in the Java programming language.ResultSet
object as
a byte
in the Java programming language.ResultSet
object as
a byte
in the Java programming language.ResultSet
object as
a byte
array in the Java programming language.
The bytes represent the raw values returned by the driver.ResultSet
object as
a byte
array in the Java programming language.
The bytes represent the raw values returned by the driver.ResultSet
object as a
java.io.Reader
object.ResultSet
object as a
java.io.Reader
object.ResultSet
object as a Clob
object
in the Java programming language.ResultSet
object as a Clob
object
in the Java programming language.RowSet
object's command property.
The command property contains a command string, which must be an SQL
query, that can be executed to fill the rowset with data.
The default value is null
.ResultSet
object.
The concurrency used is determined by the
Statement
object that created the result set.ResultSet
object.
In SQL, a result table is retrieved through a cursor that is
named. The current row of a result set can be updated or deleted
using a positioned update/delete statement that references the
cursor name. To insure that the cursor has the proper isolation
level to support update, the cursor's SELECT
statement
should be of the form SELECT FOR UPDATE
. If
FOR UPDATE
is omitted, the positioned updates may fail.
The JDBC API supports this SQL feature by providing the name of the
SQL cursor used by a ResultSet
object.
The current row of a ResultSet
object
is also the current row of this SQL cursor.
Note: If positioned update is not supported, a
SQLException
is thrown.
RowSet
object. Users should set
either the url property or the data source name property. The rowset will use
the property that was set more recently to get a connection.ResultSet
object as
a java.sql.Date
object in the Java programming language.ResultSet
object as a java.sql.Date
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the date if the underlying database does not store
timezone information.ResultSet
object as
a java.sql.Date
object in the Java programming language.ResultSet
object as a java.sql.Date
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the date if the underlying database does not store
timezone information.ResultSet
object as
a double
in the Java programming language.ResultSet
object as
a double
in the Java programming language.RowSet
object.
If escape scanning is enabled, which is the default, the driver will do
escape substitution before sending an SQL statement to the database.ResultSet
object.ResultSet
object.ResultSet
object as
a float
in the Java programming language.ResultSet
object as
a float
in the Java programming language.ResultSet
object as
an int
in the Java programming language.ResultSet
object as
an int
in the Java programming language.ResultSet
object as
a long
in the Java programming language.ResultSet
object as
a long
in the Java programming language.BINARY
,
VARBINARY
, LONGVARBINARYBINARY
, CHAR
,
VARCHAR
, and LONGVARCHAR
columns.
If the limit is exceeded, the excess data is silently discarded.RowSet
object can contain.
If the limit is exceeded, the excess rows are silently dropped.ResultSet
object's columns.Gets the value of the designated column in the current row
of this ResultSet
object as
an Object
in the Java programming language.
This method will return the value of the given column as a
Java object. The type of the Java object will be the default
Java object type corresponding to the column's SQL type,
following the mapping for built-in types specified in the JDBC
specification. If the value is an SQL NULL
,
the driver returns a Java null
.
This method may also be used to read database-specific
abstract data types.
In the JDBC 2.0 API, the behavior of method
getObject
is extended to materialize
data of SQL user-defined types. When a column contains
a structured or distinct value, the behavior of this method is as
if it were a call to: getObject(columnIndex,
this.getStatement().getConnection().getTypeMap())
.
ResultSet
object as an Object
in the Java programming language.
If the value is an SQL NULL
,
the driver returns a Java null
.
This method uses the given Map
object
for the custom mapping of the
SQL structured or distinct type that is being retrieved.Gets the value of the designated column in the current row
of this ResultSet
object as
an Object
in the Java programming language.
This method will return the value of the given column as a
Java object. The type of the Java object will be the default
Java object type corresponding to the column's SQL type,
following the mapping for built-in types specified in the JDBC
specification. If the value is an SQL NULL
,
the driver returns a Java null
.
This method may also be used to read database-specific abstract data types.
In the JDBC 2.0 API, the behavior of the method
getObject
is extended to materialize
data of SQL user-defined types. When a column contains
a structured or distinct value, the behavior of this method is as
if it were a call to: getObject(columnIndex,
this.getStatement().getConnection().getTypeMap())
.
ResultSet
object as an Object
in the Java programming language.
If the value is an SQL NULL
,
the driver returns a Java null
.
This method uses the specified Map
object for
custom mapping if appropriate.execute
. It is not usually part of the serialized state
of a RowSet
object.SQLException
is thrown.ResultSet
object as a Ref
object
in the Java programming language.ResultSet
object as a Ref
object
in the Java programming language.ResultSet
object as
a short
in the Java programming language.ResultSet
object as
a short
in the Java programming language.Statement
object that produced this
ResultSet
object.
If the result set was generated some other way, such as by a
DatabaseMetaData
method, this method returns
null
.ResultSet
object as
a String
in the Java programming language.ResultSet
object as
a String
in the Java programming language.ResultSet
object as
a java.sql.Time
object in the Java programming language.ResultSet
object as a java.sql.Time
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the time if the underlying database does not store
timezone information.ResultSet
object as
a java.sql.Time
object in the Java programming language.ResultSet
object as a java.sql.Time
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the time if the underlying database does not store
timezone information.ResultSet
object as
a java.sql.Timestamp
object in the Java programming language.ResultSet
object as a java.sql.Timestamp
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the timestamp if the underlying database does not store
timezone information.ResultSet
object as
a java.sql.Timestamp
object.ResultSet
object as a java.sql.Timestamp
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the timestamp if the underlying database does not store
timezone information.RowSet
object.ResultSet
object.
The type is determined by the Statement
object
that created the result set.Map
object associated with this
RowSet
object, which specifies the custom mapping
of SQL user-defined types, if any. The default is for the
type map to be empty.ResultSet
object as
as a stream of two-byte Unicode characters. The first byte is
the high byte; the second byte is the low byte.
The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARCHAR
values. The
JDBC driver will do any necessary conversion from the database
format into Unicode.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream.
Also, a stream may return 0
when the method
InputStream.available
is called, whether there is data available or not.
ResultSet
object as a stream of two-byte
Unicode characters. The first byte is the high byte; the second
byte is the low byte.
The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARCHAR
values.
The JDBC technology-enabled driver will
do any necessary conversion from the database format into Unicode.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream.
Also, a stream may return 0
when the method
InputStream.available
is called, whether there
is data available or not.
RowSet
object will use to
create a connection if it uses the DriverManager
instead of a DataSource
object to establish the connection.
The default value is null
.ResultSet
object as a java.net.URL
object in the Java programming language.ResultSet
object as a java.net.URL
object in the Java programming language.RowSet
object.
The username property is set at run time before calling the method
execute
. It is
not usually part of the serialized state of a RowSet
object.ResultSet
object.
Subsequent warnings on this ResultSet
object
will be chained to the SQLWarning
object that
this method returns.
The warning chain is automatically cleared each time a new
row is read. This method may not be called on a ResultSet
object that has been closed; doing so will cause an
SQLException
to be thrown.
Note: This warning chain only covers warnings caused
by ResultSet
methods. Any warning caused by
Statement
methods
(such as reading OUT parameters) will be chained on the
Statement
object.
ResultSet
object and into the database.
The cursor must be on the insert row when this method is called.ResultSet
object.ResultSet
object.ResultSet
object.ResultSet
object.
Note: Calling the method isLast
may be expensive
because the JDBC driver
might need to fetch ahead one row in order to determine
whether the current row is the last row in the result set.RowSet
object is read-only.
If updates are possible, the default is for a rowset to be
updatable.
Attempts to update a read-only rowset will result in an
SQLException
being thrown.
ResultSet
object.insertRow
methods may be
called when the cursor is on the insert row. All of the columns in
a result set must be given a value each time this method is
called before calling insertRow
.
An updater method must be called before a
getter method can be called on a column value.ResultSet
cursor is initially positioned
before the first row; the first call to the method
next
makes the first row the current row; the
second call makes the second row the current row, and so on.
If an input stream is open for the current row, a call
to the method next
will
implicitly close it. A ResultSet
object's
warning chain is cleared when a new row is read.
ResultSet
object.The refreshRow
method provides a way for an
application to
explicitly tell the JDBC driver to refetch a row(s) from the
database. An application may want to call refreshRow
when
caching or prefetching is being done by the JDBC driver to
fetch the latest value of a row from the database. The JDBC driver
may actually refresh multiple rows at once if the fetch size is
greater than one.
All values are refetched subject to the transaction isolation
level and cursor sensitivity. If refreshRow
is called after
calling an updater method, but before calling
the method updateRow
, then the
updates made to the row are lost. Calling the method
refreshRow
frequently will likely slow performance.
relative(0)
is valid, but does
not change the cursor position.
Note: Calling the method relative(1)
is identical to calling the method next()
and
calling the method relative(-1)
is identical
to calling the method previous()
.
RowSet
object.ResultSet
object can detect deletions.ResultSet
object can detect visible inserts.RowSet
object's command
with the given Array
value. The driver will convert this
to the ARRAY
value that the Array
object
represents before sending it to the database.RowSet
object's command
to the given java.io.InputStream
value.
It may be more practical to send a very large ASCII value via a
java.io.InputStream
rather than as a LONGVARCHAR
parameter. The driver 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.
RowSet
object's command
to the given java.math.BigDeciaml
value.
The driver converts this to
an SQL NUMERIC
value before sending it to the database.RowSet
object's command
to the given java.io.InputStream
value.
It may be more practical to send a very large binary value via a
java.io.InputStream
rather than as a LONGVARBINARY
parameter. The driver 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.
RowSet
object's command
with the given Blob
value. The driver will convert this
to the BLOB
value that the Blob
object
represents before sending it to the database.RowSet
object's command
to the given Java boolean
value. The driver converts this to
an SQL BIT
value before sending it to the database.RowSet
object's command
to the given Java byte
value. The driver converts this to
an SQL TINYINT
value before sending it to the database.RowSet
object's command
to the given Java array of byte
values. Before sending it to the
database, the driver converts this to an SQL VARBINARY
or
LONGVARBINARY
value, depending on the argument's size relative
to the driver's limits on VARBINARY
values.RowSet
object's command
to the given java.io.Reader
value.
It may be more practical to send a very large UNICODE value via a
java.io.Reader
rather than as a LONGVARCHAR
parameter. The driver 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.
RowSet
object's command
with the given Clob
value. The driver will convert this
to the CLOB
value that the Clob
object
represents before sending it to the database.RowSet
object's command property to the given
SQL query.
This property is optional
when a rowset gets its data from a data source that does not support
commands, such as a spreadsheet.RowSet
object to the given
concurrency level. This method is used to change the concurrency level
of a rowset, which is by default ResultSet.CONCUR_READ_ONLY
RowSet
object to the
given String
.
The value of the data source name property can be used to do a lookup of
a DataSource
object that has been registered with a naming
service. After being retrieved, the DataSource
object can be
used to create a connection to the data source that it represents.
RowSet
object's command
to the given java.sql.Date
value. The driver converts this to
an SQL DATE
value before sending it to the database, using the
default java.util.Calendar
to calculate the date.RowSet
object's command
with the given java.sql.Date
value. The driver will convert this
to an SQL DATE
value, using the given java.util.Calendar
object to calculate the date.RowSet
object's command
to the given Java double
value. The driver converts this to
an SQL DOUBLE
value before sending it to the database.RowSet
object on or
off. If escape scanning is on (the default), the driver will do
escape substitution before sending an SQL statement to the database.ResultSet
object will be processed.
The initial value is determined by the
Statement
object
that produced this ResultSet
object.
The fetch direction may be changed at any time.ResultSet
object.
If the fetch size specified is zero, the JDBC driver
ignores the value and is free to make its own best guess as to what
the fetch size should be. The default value is set by the
Statement
object
that created the result set. The fetch size may be changed at any time.RowSet
object's command
to the given Java float
value. The driver converts this to
an SQL REAL
value before sending it to the database.RowSet
object's command
to the given Java int
value. The driver converts this to
an SQL INTEGER
value before sending it to the database.RowSet
object's command
to the given Java long
value. The driver converts this to
an SQL BIGINT
value before sending it to the database.BINARY
,
VARBINARY
, LONGVARBINARYBINARY
, CHAR
,
VARCHAR
, and LONGVARCHAR
columns.
If the limit is exceeded, the excess data is silently discarded.
For maximum portability, use values greater than 256.RowSet
object can contain to the specified number.
If the limit is exceeded, the excess rows are silently dropped.RowSet
object's SQL
command to SQL NULL
.
Note: You must specify the parameter's SQL type.
RowSet
object's SQL
command to SQL NULL
. This version of the method setNull
should be used for SQL user-defined types (UDTs) and REF
type
parameters. Examples of UDTs 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 UDT or REF
parameter. In the case of a UDT,
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 UDT 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-defined or REF
type,
the typeName parameter is ignored.
RowSet
object's command
with a Java Object
. For integral values, the
java.lang
equivalent objects should be used.
The JDBC specification provides a standard mapping from Java Object types to SQL types. The driver will convert the given Java object to its standard SQL mapping before sending it 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 the method SQLData.writeSQL
to write the object to an SQLOutput
data stream.
If the object is an instance of a class implementing the Ref
,
Struct
, Array
, Blob
,
or Clob
interfaces,
the driver uses the default mapping to the corresponding SQL type.
An exception is thrown if there is an ambiguity, for example, if the object is of a class implementing more than one of these interfaces.
RowSet
object's command
with a Java Object
. For integral values, the
java.lang
equivalent objects should be used.
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.
Even though it is supported, it is not recommended that this method be called with floating point input values.
RowSet
object's command
with the given Java Object
. For integral values, the
java.lang
equivalent objects should be used (for example,
an instance of the class Integer
for an int
).
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 the method SQLData.writeSQL
to write the object to an SQLOutput
data stream.
If the object is an instance of a class implementing the Ref
,
Struct
, Array
, Blob
,
or Clob
interfaces,
the driver uses the default mapping to the corresponding SQL type.
Note that this method may be used to pass datatabase-specific abstract data types.
RowSet
object to
the given String
.SQLException
is thrown.RowSet
object is read-only to the
given boolean
.RowSet
object's command
with the given Ref
value. The driver will convert this
to the appropriate REF(<structured-type>)
value.RowSet
object's command
to the given Java short
value. The driver converts this to
an SQL SMALLINT
value before sending it to the database.RowSet
object's command
to the given Java String
value. Before sending it to the
database, the driver converts this to an SQL VARCHAR
or
LONGVARCHAR
value, depending on the argument's size relative
to the driver's limits on VARCHAR
values.RowSet
object's command
to the given java.sql.Time
value. The driver converts this to
an SQL TIME
value before sending it to the database, using the
default java.util.Calendar
to calculate it.RowSet
object's command
with the given java.sql.Time
value. The driver will convert this
to an SQL TIME
value, using the given java.util.Calendar
object to calculate it, before sending it to the database.RowSet
object's command
to the given java.sql.Timestamp
value. The driver converts this to
an SQL TIMESTAMP
value before sending it to the database, using the
default java.util.Calendar
to calculate it.RowSet
object's command
with the given java.sql.Timestamp
value. The driver will
convert this to an SQL TIMESTAMP
value, using the given
java.util.Calendar
object to calculate it, before sending it to the
database.RowSet
obejct.RowSet
object to the given type.
This method is used to change the type of a rowset, which is by
default read-only and non-scrollable.java.util.Map
object as the default
type map for this RowSet
object. This type map will be
used unless another type map is supplied as a method parameter.RowSet
object will use when it uses the
DriverManager
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.RowSet
object to the
given String
.java.sql.Array
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Array
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateRow
or
insertRow
methods are called to update the database.updateRow
or
insertRow
methods are called to update the database.java.math.BigDecimal
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.BigDecimal
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateRow
or
insertRow
methods are called to update the database.updateRow
or
insertRow
methods are called to update the database.java.sql.Blob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Blob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.boolean
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.boolean
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.byte
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.byte
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.byte
array value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateRow
or insertRow
methods are called to update the database.updateRow
or
insertRow
methods are called to update the database.updateRow
or
insertRow
methods are called to update the database.java.sql.Clob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Clob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Date
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Date
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.double
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.double
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.float
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.float
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.int
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.int
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.long
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.long
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.updateRow
or insertRow
methods are called to update the database.null
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.Object
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.Object
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.Object
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.Object
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Ref
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Ref
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.ResultSet
object.
This method cannot be called when the cursor is on the insert row.short
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.short
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.String
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.String
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Time
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Time
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Timestamp
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.java.sql.Timestamp
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.NULL
.
Note that you must first call one of the getter methods
on a column to try to read its value and then call
the method wasNull
to see if the value read was
SQL NULL
.