java ResultSet size

[monty]

let's say I did a simple query on a database like
show tables;
in java, i get a ResultSet
how can I get the total number of rows in the ResultSet?
i tried getFetchSize(), but it seems it doesn't work (unless i'm missing
something)

i don't want to do
last()
and then
getRow()
i'm sure there's a better method to do that

thanks in advance for your help
Nicola

[Daniel Schneller]

As far as I remember, there is no way to directly query the number of
rows in a resultset.

Daniel

[Unregistered]

There is no direct method to get the count . either u should iterate result set or u should use
rs.last and rs.getRow.