What is rowset and its Type?

A RowSet is an object that encapsulates a set of rows from either Java Database Connectivity (JDBC) result sets or tabular data sources like a file or spreadsheet. RowSets support component-based development models like JavaBeans, with a standard set of properties and an event notification mechanism.

What are the different types  of RowSet ?

There are two types of RowSet are there. They are:

• Connected - A connected RowSet object connects to the database once and remains connected until the application terminates.
• Disconnected - A disconnected RowSet object connects to the database, executes a query to retrieve the data from the database and then closes the connection. A program may change the data in a disconnected RowSet while it is disconnected. Modified data can be updated in the database after a disconnected RowSet reestablishes the connection with the database.

What are the new features added to JDBC 4.0?

The major features added in JDBC 4.0 include :

• Auto-loading of JDBC driver class
• Connection management enhancements
• Support for RowId SQL type
• DataSet implementation of SQL using Annotations
• SQL exception handling enhancements
• SQL XML support