title: Where jdbc Rowsets are used?
body: <p>There are some JDBC <strong>Rowsets</strong> like <strong>CachedRowSet</strong>, <strong>WebRowSet</strong>, <strong>FilteredRowSet</strong> and <strong>JoinRowSet</strong>. Does any bode know where they are used?
  Ok, may be CachedRowSet is good where I do not want open and connection, may be WebRowSet good when I need insert some XML data ("may be" but I do not sure). But what about others?</p>
  
  <p>Obviously, It is better for performance to write join in SQL query instead of create 2 JoinRowSet, take all data from they and join fields in java. The same about FilteredRowSet - it is more efficient to add where clause to the SQL query instead of grub a lot of the data and filtered it by java.</p>
  
  <p>But somebody "invented" CachedRowSet, WebRowSet, FilteredRowSet and JoinRowSet why? Does anybody has some good experience about they usage?</p>