How do I get the size of a java.sql.ResultSet?

java sql jdbc resultset record-count
Jake picture Jake · Oct 10, 2008 · Viewed 471.3k times · Source

Shouldn't this be a pretty straightforward operation? However, I see there's neither a size() nor length() method.

Answer

finnw picture finnw · Oct 10, 2008

Do a SELECT COUNT(*) FROM ... query instead.

OR

int size =0;
if (rs != null) 
{
  rs.last();    // moves cursor to the last row
  size = rs.getRow(); // get row id 
}

In either of the case, you won't have to loop over the entire data.

Related questions

Java Iterator backed by a ResultSet

I've got a class that implements Iterator with a ResultSet as a data member. Essentially the class looks like this: public class A implements Iterator{ private ResultSet entities; ... public Object next(){ entities.next(); return new Entity(entities.getString...etc....) } public …

Read More
JDBC returning empty result set

I'm using JDBC for very simple database connectivity. I have created my connection/statement and executed a query. I check the query object of the statement in the debugger to confirm that it is sending a proper query. I then …

Read More
Storing Result set into an array

i know this should be simpel and im probably staring straight at the problem but once again im stuck and need the help of the code gurus. im trying too take one row from a column in jdbc, and put …

Read More