wood burning stoves 2.0*
The moose likes Servlets and the fly likes Why Resultset's next is giving false Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Why Resultset Watch "Why Resultset New topic
Author

Why Resultset's next is giving false

Huzefa Zohaib
Ranch Hand

Joined: Nov 21, 2001
Posts: 40
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.
Asher Tarnopolski
Ranch Hand

Joined: Jul 28, 2001
Posts: 260
what's your query order?


Asher Tarnopolski
SCJP,SCWCD
Kunal Aher
Greenhorn

Joined: Apr 07, 2000
Posts: 20
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


Kunal
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

Moved from Servlets -> JDBC
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Why Resultset's next is giving false