javax.sql.rowset

TopBlend: Here is the first difference. There are 7 differences.

~~is old.~~

is new.

Package javax.sql.rowset

Standard interfaces and base classes for JDBC RowSetimplementations.

Interface Summary
CachedRowSet	The interface that all standard implementations of CachedRowSet must implement.
FilteredRowSet	The standard interface that all standard implementations of FilteredRowSet must implement.
JdbcRowSet	The standard interface that all standard implementations of JdbcRowSet must implement.
Joinable	1.0 Background
JoinRowSet	The JoinRowSet interface provides a mechanism for combining related data from different RowSet objects into one JoinRowSet object, which represents an SQL JOIN.
Predicate	The standard interface that provides the framework for all FilteredRowSet objects to describe their filters.
WebRowSet	The standard interface that all implementations of a WebRowSet must implement.

Class Summary
BaseRowSet	An abstract class providing a RowSet object with its basic functionality.
RowSetMetaDataImpl	Provides implementations for the methods that set and get metadata information about a RowSet object's columns.

Exception Summary
RowSetWarning	An extension of SQLException that provides information about database warnings set on RowSet objects.

Package javax.sql.rowset Description

Standard interfaces and base classes for JDBC RowSetimplementations. This package contains interfaces and classes that a standard RowSet implementation either implements or extends.

1.0 Package Specification
2.0 Standard RowSet Definitions
3.0 Implementater's Guide
4.0 Related Specifications
5.0 Related Documentation

1.0 Package Specification 1.0 Package Specification

This package specifies five standard JDBC RowSet interfaces. All five extend the

RowSet

~~RowSet~~ interface described in the JDBC 3.0specification. It is anticipated that additional definitionsof more specialized JDBC RowSet types will emerge as this technology matures. Future definitions should be specified as subinterfaces using inheritance similar to the way it is used in this specification.

Note: The interface definitions provided in this package form the basis forall compliant JDBC RowSet implementations. Vendors and more advanceddevelopers who intend to provide their own compliant RowSet implementations should pay particular attention to the assertions detailed in specificationinterfaces.

2.0 Standard RowSet Definitions 2.0 Standard RowSet Definitions

JdbcRowSet - A wrapper around a ResultSet object that makes it possible to use the result set as a JavaBeans^TM component. Thus,a JdbcRowSet object can be a Bean that any toolmakes available for assembling an application as part of a component basedarchitecture . A JdbcRowSet object is a connected RowSetobject, that is, it must continually maintain its connection to its data source using a JDBCtechnology-enabled driver ("JDBC driver"). In addition, a JdbcRowSetobject provides a fully updatable and scrollable tabular data structure as defined in the JDBC 3.0 specification.
CachedRowSet^TM> - A CachedRowSet object is a JavaBeans^TM component that is scrollable, updatable, serializable, and generally disconnected from the source of its data. A CachedRowSet objecttypically contains rows from a result set, but it can also contain rows from anyfile with a tabular format, such as a spreadsheet. CachedRowSet implementations must use the SyncFactory to manage and obtain pluggableSyncProvider objects to provide synchronization between thedisconnected RowSet object and the originating data source. Typically a SyncProvider implementation relies upon a JDBCdriver to obtain connectivity to a particular data source.Further details on this mechanism are discussed in the javax.sql.rowset.spi packagespecification.
WebRowSet - A WebRowSet object is an extension of CachedRowSet that can read and write a RowSet object in a well formed XML format.This class calls an XmlReader object (an extension of the RowSetReader interface) to read a rowset in XML format. It calls an XmlWriter object (an extension of the RowSetWriter interface) to write a rowset in XML format. The reader and writer required byWebRowSet objects are provided by theSyncFactory in the form of SyncProviderimplementations. In order to ensure well formed XML usage, a standard generic XMLSchema is defined and published at http://java.sun.com/xml/ns/jdbc/webrowset.xsd .
FilteredRowSet - AFilteredRowSet object provides filtering functionality in a programmaticand extensible way. There are many instances when a RowSet objecthas a need to provide filtering in its contents without sacrificing the disconnectedenvironment, thus saving the expense of having to create a connection to the data source.Solutions to this need vary from providing heavyweight full scale SQL query abilities, to portable components, to more lightweight approaches. A FilteredRowSet object consumesan implementation of the Predicate interface, which may define a filter at run time. In turn, aFilteredRowSet object is tasked with enforcing the set filter for bothinbound and outbound read and write operations. That is, all filters can beconsidered as bi-directional. No standard filters are defined;however, sufficient mechanics are specified to permit any required filter to beimplemented.
JoinRowSet - The JoinRowSet interface describes a mechanism by which relationships can be established between two or more standard RowSet implementations. Any number of RowSet objects can be added to a JoinRowSet object provided the RowSet objects can be related in a SQL JOIN like fashion. By definition, the SQL JOIN statement is used to combine the data contained in two ( or more ) relationaldatabase tables based upon a common attribute. By establishing and then enforcingcolumn matches, a JoinRowSet object establishes relationships betweenRowSet instances without the need to touch the originating data source.

3.0 Implementer's Guide 3.0 Implementer's Guide
Compliant implementations of JDBC RowSet Implementations must follow the assertions described in this specification. In accordancewith the terms of the Java Community Process , aTest Compatibility Kit (TCK) can be licensed to ensure compatibility with thespecification. The following paragraphs outline a number of starting points forimplementers of the standard JDBC RowSet definitions. Implementersshould also consult the Implementer's Guide in the javax.sql.rowset.spi package for guidelineson SyncProvider implementations.

3.1 Role of the BaseRowSet Class
A compliant JDBC RowSet implementation must implement one or more standard interfaces specified in this package and and may extend the BaseRowSet BaseRowSet abstract class provides any RowSet implementationwith its base functionality, including property manipulation and event notificationthat is fully compliant with JavaBeans com.sun.rowset package) usethe BaseRowSet class as a basis for their implementations.
The following table illustrates the features that the BaseRowSetabstract class provides.

Feature
Details

Properties
Provides standard JavaBeans property manipulation mechanisms to allow applications to get and set RowSet command andproperty values. Refer to the documentation of the javax.sql.RowSet interface (available in the JDBC 3.0 specification) for more details onthe standard RowSet properties.

Event notification
Provides standard JavaBeans event notifications to registered event listeners. Refer to the documentation of javax.sql.RowSetEvent interface (available in the JDBC 3.0 specification) formore details on how to register and handle standard RowSet events generatedby compliant implementations.

Setters for a RowSet object's command
Provides a complete set of setter methods for setting RowSet command parameters.

Streams
Provides fields for storing of stream instances in addition to providing a set of constants for stream type designation.

3.2 Connected RowSet Requirements
The JdbcRowSet describes a RowSet object that must alwaysbe connected to the originating data source. Implementations of the JdbcRowSetshould ensure that this connection is provided solely by a JDBC driver. Furthermore, RowSet objects that are implementations of the JdbcRowSet interface and are therefore operating in a connected environmentdo not use the SyncFactory to obtain a RowSetReader objector a RowSetWriter object. They can safely rely on the JDBC driver tosupply their needs by virtue of the presence of an underlying updatable and scrollableResultSet implementation.

3.3 Disconnected RowSet Requirements
A disconnected RowSet object, such as a CachedRowSet object, should delegate connection management to a SyncProvider object provided by the SyncFactory. To ensure fully disconnected semantics, all disconnected RowSet objects must ensurethat the original connection made to the data source to populate the RowSet object is closed to permit the garbage collector to recover and release resources. TheSyncProvider object ensures that the critical JDBC properties are maintained in order to re-establish a connection to the data source when a synchronization is required. A disconnected RowSet object should therefore ensure that no extraneous references remain on the Connection object.

3.4 Role of RowSetMetaDataImpl
The RowsetMetaDataImpl class is a utility class that provides an implementation of the RowSetMetaData interface, supplying standard settermethod implementations for metadata for both connected and disconnected RowSet objects. All implementations are free to use this standardimplementation but are not required to do so.

3.5 RowSetWarning Class
The RowSetWarning class provides warnings that can be seton RowSet implementations.Similar to SQLWarning ~~SQLWarning~~ should ensure that this chaining occurs if a warning is generated and also ensure that thewarnings are available via the getRowSetWarnings method defined in eitherthe JdbcRowSet interface or the CachedRowSet interface. After a warning has been retrieved with one of thegetRowSetWarnings methods, the RowSetWarning methodgetNextWarning can be called on it to retrieve any warnings that mightbe chained on it. If a warning is returned, getNextWarning can be calledon it, and so on until there are no more warnings.

3.6 The Joinable Interface
The Joinable interface provides both connected and disconnected RowSet objects with the capability to be added to a JoinRowSet object in an SQL JOIN operation.A RowSet object that has implemented the Joinable interface can set a match column, retrieve a match column, or unset a match column.A JoinRowSet object can then use the RowSet object'smatch column as a basis for adding the RowSet object.

4.0 Related Specifications 4.0 Related Specifications

JDBC 3.0 Specification
XML Schema
SyncML

5.0 Related Documentation 5.0 Related Documentation

JDBC RowSet Tutorial

Package javax.sql.rowset

Package javax.sql.rowset Description

Table of Contents

1.0 Package Specification 1.0 Package Specification

2.0 Standard RowSet Definitions 2.0 Standard RowSet Definitions

3.0 Implementer's Guide 3.0 Implementer's Guide

4.0 Related Specifications 4.0 Related Specifications

5.0 Related Documentation 5.0 Related Documentation

Feature	Details
Properties	Provides standard JavaBeans property manipulation mechanisms to allow applications to get and set RowSet command andproperty values. Refer to the documentation of the `javax.sql.RowSet` interface (available in the JDBC 3.0 specification) for more details onthe standard RowSet properties.
Event notification	Provides standard JavaBeans event notifications to registered event listeners. Refer to the documentation of `javax.sql.RowSetEvent` interface (available in the JDBC 3.0 specification) formore details on how to register and handle standard RowSet events generatedby compliant implementations.
Setters for a RowSet object's command	Provides a complete set of setter methods for setting RowSet command parameters.
Streams	Provides fields for storing of stream instances in addition to providing a set of constants for stream type designation.