title: How to get number of rows returned by Resultset while using HSQLDB?
body: <p>I am getting exception feature not supported while getting the total no of rows using ResultSet.last() function.
  I tried using the hsqldb specific connection and ResultSet class but no success.</p>
  
  <p>Can some one guide any way to get the no of rows from result set except looping through all the rows.</p>
  
  <p>the code snippet used for getting no of rows is given below:</p>
  
  <pre><code>rs.last();
  int total = rs.getRow();
  System.out.println("total no of rows in stu are "+total);
  rs.beforeFirst()
  </code></pre>