Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

query about rowset

 
ravi v kumar
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi

i am one more question?

what is rowset ?

and how it is different from resultset

and is the connection to db can be done my rowset without DriverManager and DataSource.

vth regards

rvk
 
Senthil B Kumar
Ranch Hand
Posts: 160
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
RowSet is another Interface which is inherting the ResultSet interface. But the main difference is it can be used as an JavaBean component.

The RowSet interface provides a set of JavaBeans properties that allow a RowSet instance to be configured to connect to a JDBC data source and read some data from the data source

The RowSet interface supports JavaBeans events, allowing other components in an application to be notified when an event occurs on a rowset, such as a change in its value

In other words, a RowSet implementation is a layer of software that executes "on top" of a JDBC driver.
 
Raj Chila
Ranch Hand
Posts: 128
Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
it also interesting to know that, the rowsets, in its various implementations (Cached, web and JDBC), enable us to keep the data "alive" even after releasing the connection to the Database which is not possible while working with the result sets. thus helping the better resource management.

just imagine, the need to create our own data structures to keep the data "offline" and then having to work on it.

another interesting thing is the Rowset implementation libraries are available as a seperate library that can be also used with JDK 1.4, atleast it worked for me.
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rowset are disconnected.

So connection need not to be remain open until data is processed.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic