title: CachedRowSet: can it still be used to hold ResultSet data?
body: <p>I would like to write a java function that takes in a SQL query and returns a ResultSet for processing elsewhere.   This can't be done as a ResultSet is dead once the connection is closed.  </p>
  
  <p>Googling around I found a <a href="http://onjava.com/pub/a/onjava/2004/06/23/cachedrowset.html" rel="noreferrer">VERY OLD (2004) OReilly article</a> that had something that looked like the cure:  CachedRowSet.   You just drop in your ResultSet, the CachedRowSet saves the data, lets you close the connection and play with the data elsewhere using the returned CachedRowSet.</p>
  
  <p>The article references implementations of the CachedRowSet by Sun, which appear to be nowhere to be found.</p>
  
  <p>Modern javadocs ( for Java 1.5 and up ) seem to have something by the same name, "CachedRowSet", that is more than just a holder of ResultSet data.  That "CachedRowSet" seems to do the entire database processing from getting connections and everything else.   </p>
  
  <p>Is THAT "CachedRowSet" the same thing as is talked about in the old article?</p>
  
  <p>I would like something simple, like in the old article.  Something to plop a ResultSet into for processing after the conneciton is closed.</p>
  
  <p>Is there such an animal?</p>
  
  <p>Thanks</p>