How to find the number of rows in a Resultset object

[ramchander yshetti]

Hi All,

I am facing a problem in finding how to know the number of rows/records in a Resultset object.

Plz. give the possible ways other than using a counter variable and incrementing in while we traverse the resultset using a loop.

Bye
Ramchander

[fred Joly]

last() : Moves the cursor to the last row in this ResultSet object.
getRow() : Retrieves the current row number.

regards

[Naseem Khan]

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
while(rs.next()){
if(rs.isLast()){
System.out.println(rs.getRow());
}
}

regards


Naseem Khan

[Jeanne Boyarsky]

Ramchander,
For a more detailed explanation, take a look at the first FAQ.

[Scott Selikoff]

In general you can't. Sometimes the driver and dbms support it but even it were to, you might be sacraficing portability.

[Naseem Khan]

Hi Scott,

Its not the question of dbms.

Once you get the result in a ResultSet, now the question is whether your JDBC driver support Scrollable ResultSet or not.

Regards

Naseem