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