title: Copying Java ResultSet
body: <p>I have a <code>java.sql.ResultSet</code> object that I need to update. However the result set is not updatable. Unfortunately this is a constraint on the particular framework I'm using.</p>
  
  <p>What I'm trying to achieve here is taking data from a database, then manipulating a small amount of the data and finally the data is being written to a CSV file.</p>
  
  <p>At this stage I think my best option is to create a new result set object and copy the contents of the original result set into the new one, manipulating the data as I do so.</p>
  
  <p>However, I've hunted high and low on Google and don't seem to be able to determine how to do this or whether it's even possible at all.</p>
  
  <p>I'm new to everything Java so any assistance would be gratefully received.</p>