Everything in my program is ok except rsa.next(). I am not getting that rsa.next() is giving false although my HyperSonic database contains three colunms and two data entries.
while(rsa.next()) { String nm= rsa.getString ("name"); out.println (nm); } Please guide me what could be the problem in your suggestions.
Please try running the query from the tool to test if the query really returns something ! Secondly , if possible try to use cachedrowsets , the reference implementation is available on the sun site. Advantage is that u get to know the size of the fetched results ( which is so desperately required sometimes ) Cheers Kunal