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.
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.