How to populate 2 CachedRowSet with the same ResultSet?

Question

I need help with duplicating a ResultSet using CachedRowSet or any other way possible. I'm at this point

ResultSet rs = stmt.executeQuery(query);

CachedRowSetImpl crs = new CachedRowSetImpl();
crs.populate(rs);

How would one populate a different CachedRowSet, say crs2, with the ResultSet rs?

Answer 1

to do a deep copy try

CachedRowSet crs2 = crs.createCopy();