What is Difference between ResultSet and RowSet in java JDBC
javax.sql.RowSet is an interface which can be used as a JavaBeans component in a visual Bean development environment, It can be created and configured at design time and can be executed at runtime in java.
Read this post for details on ResultSet: ResultSet in java - Types, concurrency, holdability of ResultSet in java
javax.sql.rowset.RowSet is a wrapper around a ResultSet which makes it possible to use the result set as a JavaBeans component in jdbc java.
ResultSet alone cannot be used as a JavaBeans component.
RowSet interface extends ResultSet interface in java.
javax.sql.rowset.JdbcRowSet the subclass of RowSet is a wrapper around a ResultSet which makes it possible to use the result set as a JavaBeans component.
Implementations of RowSet can be Connected or Disconnected.
Connected implementations of RowSet in JDBC java
- javax.sql.rowset.JdbcRowSet
Disconnected implementations of RowSet in JDBC java
- javax.sql.rowset.CachedRowSet
- javax.sql.rowset.WebRowSet
- javax.sql.rowset.FilteredRowSet
- javax.sql.rowset.JoinRowSet
More about Connected implementations of Rowset >
JdbcRowSet extends RowSet
More about Disconnected implementations of Rowset >
CachedRowSet extends RowSet
WebRowSet extends CachedRowSet
FilteredRowSet and JoinRowSet extends WebRowSet
What is Connected implementations of RowSet ?
connected rowset means it continues to maintain its connection with database after retrieval of data as well
What is Disconnected implementations of RowSet ?
Disconnected rowset means it doesn’t continues to maintain its connection with database after retrieval of data as well. It disconnects after retrieval of data.
Related >