Resultset And Rowset Difference. A ResultSet maintains a connection to a database and because of that it cant be serialized and also we cant pass the Resultset object from one class to other class across the network. Since it has a connection to the database when you run the next method if the ResultSet needs more data it can go to the database and get itWhile the RowSet cant do that since it isnt connected to the database so it must load and hold all the data from your query as soon as you run the execute method.
Since it has a connection to the database when you run the next method if the ResultSet needs more data it can go to the database and get itWhile the RowSet cant do that since it isnt connected to the database so it must load and hold all the data from your query as soon as you run the execute method. Posted 19 years ago. You can pass a RowSet object over the network.
Difference between ResutSet and Rowset.
1The ResultSet does not contain all the data from your query. A ResultSet maintains a connection to a database and because of that it cant be serialized and also we cant pass the Resultset object from one class to other class across the network. RowSet object is a Java bean while ResultSet is not. A ResultSet maintains a connection to a database and because of that it cant be serialized and also we cant pass the Resultset object from one class to other class across the network.