title: java.sql.SQLException: ResultSet closed
body: <p>I cant not do the further process because I get ResultSet closed while running this code. I am adding the value after 15 row of the sqlite database table and I want to find average value of 15 row and that should be store in ArrayList.</p>
  
  <p>Here is the code:-</p>
  
  <pre><code>try {
      Class.forName("org.sqlite.JDBC");
      c = DriverManager.getConnection("jdbc:sqlite:test.db");
      c.setAutoCommit(false);
      System.out.println("Opened database successfully3");
      stmt = c.createStatement();
      rs = stmt
              .executeQuery("SELECT TIME,BID,ASK FROM '" + title + "' ;");
      System.out.println("Opened database successfully 20");
      while (rs.next()) {
          i++;
          System.out.println(i);
          if (i &gt; 15) {
              System.out.println("i am in");
              List&lt;String&gt; stocklist = new ArrayList&lt;String&gt;();
              String main = rs.getString(1);
              System.out.println(rs.getString(1));
              String s[] = main.split(" ", 2);
              String date = s[0];
              String time = s[1];
              stocklist.add(date);
              stocklist.add(time);
              stocklist.add(df.format(rs.getFloat("BID")));
              stocklist.add(df.format(rs.getFloat("ASK")));
              rs1 = stmt
                      .executeQuery("SELECT ASK FROM '" + title + "' ;");
              int j = 1;
              while (rs1.next()) {
                  if (j &lt; i) {
                      System.out.println(rs1.getFloat("ASK"));
                      avg = avg + rs1.getFloat("ASK");
                  }
                  j++;
              }
              rs1.close();
  
              System.out.println("i am out");
              avg = avg / 15;
              changepercent = ((rs.getFloat("ASK") - avg) / avg) * 100;
              stocklist.add(df.format(changepercent));
              stocklist.add("ETE");
              stocklist.add("HUN");
              stocklist.add("ALU");
              stocklist.add("ETE");
              stocklist.add("HUN");
              stocklist.add("ALU");
              stocklist.add("ETE");
              stocklist.add("HUN");
              hntm.addRow(stocklist);
          }
      }
      rs.close();
      stmt.close();
      c.close();
  } catch (Exception e) {
      System.err.println(e.getClass().getName() + ": " + e.getMessage());
      System.exit(0);
  }
  </code></pre>