title: Closing ResultSet but not closing PreparedStatement
body: <p>What type of resource leak can I expect if ResultSet is closed, but PreparedStatement not. It is very suspicious that it can cause an open cursor issue...</p>
  
  <pre><code>   PreparedStatement p = connection.prepareStatement(...);
      try {
        ResultSet r = p.executeQuery();
        try {
          while (r.next()) {
            ....
          }
        } finally {
          try {
            r.close();
          } catch (SQLException e) {
          // log this or something -- prevent these from masking original exception
          }
        }
      }
  </code></pre>
  
  <p>It is Oracle 11g, jdbc 11.2.0.3</p>
  
  <p>Thanks</p>
  
  <p>Plz try to answer my question and not focusing on the fix</p>