title: Should I always close a CachedRowSet even if it goes out of scope?
body: <p>Consider the following code snippet:</p>
  
  <pre><code>public void getUsers() {
      CachedRowSet rowSet = new CachedRowSetImpl();
      .........     /* Initialize the rowset */
      String query = "SELECT user_id FROM users";
      rowSet.setCommand(query);
      rowSet.execute();
      .........    /* Do some job */
  
  }
  </code></pre>
  
  <p>Here the <code>CachedRowSet</code> object is used locally in a method. Do I need to manually close it here or the contents it holds will be grabage collected automatically when the method finishes?</p>