title: Error with "TYPE_FORWARD_ONLY" in sqlite
body: <p>I am working with SQLite and JDBC and getting this error about the result_set being TYPE_FORWARD_ONLY.</p>
  
  <pre><code>    PreparedStatement get_mileage = conn.prepareStatement("SELECT * FROM workout_log");
      ResultSet mileage_count = get_mileage.executeQuery();
  
      mileage_count.absolute(week_start);
  
      for (int i=week_start;i&lt;=week_finish;i++){
          total_mileage+=mileage_count.getInt(1);
          mileage_count.next();
      }
  </code></pre>
  
  <p>The error is on the call to <code>absolute()</code> even though I know it is not moving backwards at all.  I have tried adding flags to <code>prepareStatement</code> but it says my version of SQLite does not support <code>ResultSet</code> that is not FORWARD_ONLY.  </p>
  
  <p>My question is why is this occuring, even though I am not moving backward?</p>