About the JDBC RowSet

Question

hi, i know about what a RowSet is and all; what i would like to know is if it works properly and is accepted already, or if it still has it's bugs and isn't as widely accepted as the classic ResultSet. it looks good to me so far, but i want to hear more experienced views on the subject.

Answer 1

RowSet

1. RowSet makes life a lot easier for all JDBC programmers. No more Connection objects, statement objects, just a single RowSet will do everything for you.
2. Rowsets make it easy to send tabular data over a network. They can also be used to provide scrollable result sets or updatable result sets when the underlying JDBC driver does not support them.
3. RowSet object follows the JavaBeans model for properties and event notification, it is a JavaBeans component that can be combined with other components in an application.
4. Rowsets may have many different implementations to fill different needs. These implementations fall into two broad categories, rowsets that are connected and those that are disconnected.

RowSet Tutorial

Answer 2

I think there are two factors in deciding if you RowSet is right for you:

1) Can you have the whole result in memory? Sometimes you need to parse the result set one row at a time and can't just get the whole thing in memory at once.

2) Have you tested your JDBC driver for the behavior with RowSet?

I think #2 is where you start with your question. The truth is that it is basically implementation dependent if a given RowSet is robust and production ready. In theory, you can use a RowSet implementation from a different vendor than the JDBC driver as well, and that should work as well.