Difference Betwixt Connected Vs Disconnected Rowset Inward Coffee Jdbc | Rowsetprovider, Rowsetfactory Example

RowSet interface is approximately other fundamental interface from JDBC API, which extends the ResultSet interface to supply back upward for the JavaBean factor model. Along alongside convenient methods to gear upward connexion parameters e.g. setUrl(), setUsername(), setPassword() as well as setCommand(), it equally good defines getters as well as setters for unlike information types e.g. getLong() as well as setLong(). Another characteristic of RowSet is that it supports trial listeners. You tin attach listeners to RowSet object to heed for events, much similar Observer pattern pattern. RowSet acts equally Subject as well as notifies Observer on events similar alter inward cursor location, alter inward row or alter inward the entire RowSet. There are 2 types of RowSet available inward JDBC 4.1 API, connected as well as disconnected.

Influenza A virus subtype H5N1 connected RowSet e'er keeps connexion alongside database, spell a disconnected RowSet connects to database, larn the information as well as thence unopen the connection.

This doesn't preclude from working alongside information though, you lot tin withal alter information inward disconnected state, but to commit, connexion needs to hold upward re-established past times RowSet.

Java provides v unlike types of RowSet, JdbcRowSet, JoinRowSet, CachedRowSet, FilteredRowSet and WebRowSet. Out of these v only JdbcRowSet is connected RowSet, residue of them are disconnected row sets.

It's real of import to empathise these novel concepts shape JDBC API, in that place are real popular JDBC Interview questions based upon these concepts e.g. difference betwixt RowSet as well as ResultSet as well as difference betwixt Connected vs Disconnected RowSet.

Once you lot are familiar alongside fundamental concept of RowSet class, you lot should hold upward able to answer these enquiry past times your own.

Difference betwixt Connected as well as Disconnected RowSet

As I mentioned, top dog departure betwixt connected as well as disconnected RowSet is that quondam e'er keeps a database connection, spell after doesn't. It connects to database, larn the information as well as thence unopen the connection. Here are distich of to a greater extent than differences betwixt them :

1) Disconnected database connected to the database alone when they desire to read or write, all the times they are disconnected from the database, on the other hand, Connected database locomote out along JDBC connexion hold upward all time.

2) Only JdbcRowSet from JDBC 4.1 API is connected, residue similar CachedRowSet, WebRowSet are disconnected RowSet implementation.

3) Disconnected RowSet are Serializable and that's why suitable for sending over the network

RowSet Example inward Java

Let's encounter a uncomplicated instance of RowSet inward Java. In this example, nosotros volition retrieve employees tape using RowSet instead of ResultSet interface. So far, you lot mightiness accept alone seen a ResultSet object returning query result, but from JDBC 4.1 API, you lot tin locomote whatever implementation of RowSet implementation for querying database as well as retrieving result. In this JDBC example, nosotros volition locomote JdbcRowSet class. In guild to create object of JdbcRowSet, you lot involve a RowSetFactory, which tin hold upward created past times using newFactory() method of RowSetProvider. Once you lot accept an object of RowSet, you lot tin overstep configuration details similar database URL, username as well as password past times calling their respective setProperties() method e.g. setURL(), setUsername() as well as setPassword(). After configuration, its fourth dimension to specify our SQL SELECT Query, nosotros volition locomote method called setCommand() for providing query. Now you lot tin execute the query past times calling execute() method. Did you lot notice a much cleaner as well as uncomplicated API? After query execution its fourth dimension to retrieve data, which is real similar to what you lot are used past times calling diverse getXXX() method from ResultSet. You simply involve to iterate through RowSet past times checking hasNext() method inward spell loop as well as getting information row past times row.

import javax.sql.rowset.*; import java.sql.*;  /**  * Java Program to illustrate how to locomote RowSet, RowSetProvider, as well as RowSetFactory inward JDBC  * In this example, RowSet is used to retrieve information from database instead of ResultSet.  * @author Javin Paul  */ public class RowSetDemo {      public static void main(String[] args) {         String url = "jdbc:mysql://localhost:3306/addressBook";         String userName = "root";         String password = "mysql123";                 try {             // first, create a manufactory object for rowset             RowSetFactory rowSetFactory = RowSetProvider.newFactory();              // create a JDBC rowset from the factory             JdbcRowSet rowSet = rowSetFactory.createJdbcRowSet();              // Set connexion properties             rowSet.setUrl(url);             rowSet.setUsername(userName);             rowSet.setPassword(password);              // Set SQL Query to execute             rowSet.setCommand("SELECT * FROM contact");             rowSet.execute();             System.out.println("id \tName \tDepartment \tEmail \t\Salary");              // Iterating over RowSet             while (rowSet.next()) {                 System.out.println(rowSet.getInt("id") + "\t"                         + rowSet.getString("name") + "\t"                         + rowSet.getString("department") + "\t"                         + rowSet.getString("email") + "\t"                         + rowSet.getString("salary"));             }         } catch (SQLException sqle) {             sqle.printStackTrace();         }     } }   Output Id      Name    Department      Email   Salary 1       Jack    Sales           jack@bluechip.com       9000 2       Jill    Marketing       jill@bluechip.com       8000 iii       Tom     Accounts        tom@bluechip.com        7000

You tin encounter how slowly is to locomote RowSet inward DAO  of your Java program, or you lot tin equally good locomote them along alongside DAO Design Pattern. Since RowSet inherit from java.sql.ResultSet interface, you lot tin genuinely overstep RowSet implementation to whatever method, which hold back ResultSet. This diagram volition give you lot to a greater extent than thought close ResultSet as well as RowSet shape hierarchy.  It equally good useful to notice out which RowSet implementation are Connected as well as which i are Disconnected. You tin encounter that in that place are 2 major implementation of RowSet interface, JdbcRowSet which is connected as well as CachedRowSet which is disconnected.

CachedRowSet further has distich of to a greater extent than implementation inward price of WebRowSet and its subclasses. This tabular array provides a dainty comparing of features supported past times unlike RowSet implementation inward JDBC API.

You tin encounter that JdbcRowSet is Scrollable, Updateable as well as Connected, spell CachedRowSet is equally good Serializable because its disconnected. WebRowSet farther adds characteristic of generating as well as consuming XML.

Things to recollect close RowSet, ResultSet as well as RowSetFactory

It's fourth dimension to revise few fundamental points close these classes from JDBC 4.1 API.

1) RowSet extends ResultSet interface to add together back upward of Java Bean model e.g. it adds methods similar setUrl() which makes it slowly to connect to database.

2) There are 2 types of RowSet, connected as well as disconnected. connected RowSet object brand a connexion alongside the database as well as maintain that connexion throughout its life cycle. On the other hand, a disconnected RowSet makes a connexion alongside data source, read information from it as well as unopen the connection. Influenza A virus subtype H5N1 disconnected RowSet tin withal brand changes to its information spell it is non connected alongside database, but it must re-establish connexion to commit those changes.

3) There are v implementations of RowSet available inward JDBC 4.1 API, JdbcRowSet, CachedRowSet, JoinRowSet, WebRowSet and FilteredRowSet. Out of these five, alone JdbcRowSet is a connected RowSet, residue of them are disconnected RowSets.

4) RowSetProvider provides methods to larn a RowSetFactory implementation, which tin hold upward used to instantiate a relevant RowSet implementation. Both of these are added from Java 1.7 only.

5) Disconnected RowSet classes are equally good Serializable inward Java.

That's all close What is RowSet inward JDBC, How to locomote RowSet to connect to database, as well as difference betwixt Connected as well as Disconnected RowSet inward Java. We accept equally good encounter instance of using RowSetProvider and RowSetFactory which tin hold upward used to  create unlike types of RowSet in Java. Remember, alone JdbcRowSet is the connected RowSet, residue of them are disconnected one.

Further Learning
JSP, Servlets as well as JDBC for Beginners: Build a Database App
Complete JDBC Programming Part 1 as well as 2
Java Platform: Working alongside Databases Using JDBC

Share this post