Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Checking for empty resultset  RSS feed

 
Tom Joiner
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am running a SQL query which is like this:



And I want to check if the resultset is empty. Looking through the API here:

http://java.sun.com/j2se/1.3/docs/api/java/sql/ResultSet.html

I don't see the obvious solution. I can of course walk through the resultset twice, the first time counting it, and the second time using it, but this seems like a waste. Is there an API call that returns if it is empty?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
rs.next() returns false when the cursor can't move forward. So:
 
Shailesh Chandra
Ranch Hand
Posts: 1084
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just want to add one thing when you call rs.next() takes you to first row, make sure you do not call rs.next() again until you have retrieved value of all columns of first row.


Shailesh
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!