title: Copy ResultSet without using CachedRowSetImpl.execute()
body: <p>I'm trying to close the connection after executing a query. Before, I just create a <code>CachedRowSetImpl</code> instance and it will take care of release the resources for me. However, I am using Hive database driver from Hadoop project. It doesn't support <code>CachedRowSetImpl.execute()</code>. I'm wondering if is there any other way that allow me to copy the <code>ResultSet</code> object and close the connection?</p>