Finding out the number of rows a database has.

[Naf Rash]

I wanted to ask about retrieving the number of rows from ResultSetMetadata(ie, to find out the number of rows a particular database has- the one that is being connected to). I know that getCoulumnCount tells you the number of columns the table has but how would I find out the number of rows because as far as I can see there is no getRowCount method as such? Plaese help!

[Nicola Zuliani]

Did you try with a "while" which increments a variable?
...or with a query with a COUNT(*)...

[Naf Rash]

Do you mean something like while there is another row increment some counter?

[leo donahue]

Originally posted by Naf Rash:
I wanted to ask about retrieving the number of rows from ResultSetMetadata(ie, to find out the number of rows a particular database has- the one that is being connected to). I know that getCoulumnCount tells you the number of columns the table has but how would I find out the number of rows because as far as I can see there is no getRowCount method as such? Plaese help!

You can use the RowSet Interface which extends java.sql.ResultSet It has a method called getMaxRows().

[Naf Rash]

I have tried the method getMaxRows but I have read that it:
The maxRows limit is the maximum number of rows that a RowSet can contain.

Therefore shouldn't the limit be set first? I have tried to use this method on an object of ResultSet but it isn't being recognised for this. Can you suggest why???

[leo donahue]

Originally posted by Naf Rash:
I have tried the method getMaxRows but I have read that it:
The maxRows limit is the maximum number of rows that a RowSet can contain.

Therefore shouldn't the limit be set first? I have tried to use this method on an object of ResultSet but it isn't being recognised for this. Can you suggest why???

You're right, scratch that last comment.
Try this:
ResultSet rs = stmt.executeQuery("Select whatever from whatever");
int count = 0;
while(rs.next()){
count++;
}
Just like Nicola suggested.

[Jason Steele]

ResultSet r = s.executeQuery("Select whatever from whatever");
r.last();               // go to the end of the result set
int count = r.getRow(); // get the row count
r.beforeFirst();  // move the cursor back to beginning

[Denna Ramani]

hey there,
the easy solution is
use this query "select count(*) form tablename;"
and then read the resultset with getInt(). so it will return number of rows in particular table.
Denna