ResultSet methods

I'm new to HSQLDB. I'm writing a Swing ICD10 Browser and selection tool 
(ICD10 is a medical terms coding scheme of W.H.O.).
I use hsqldb 1.7.1

Here is my problem.

ResultSet a = some_statement.executeQuery(some_query);
a.last();
System.out.println(a.getRow()); // prints 22 which is correct, as long 
the table has 22 records.
a.first();
System.out.println(a.getRow()); // prints again 22

So ResultSet.first() didn't do anything.

What am I doing wrong?

Thanks in advance.




-------------------------------------------------------
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn