[JDBC] How to get row-count of result-set?

[Sven Köhler]

Hi,

how can i get the number of rows returned by
PreparedStatement s = "...";
ResultSet r = s.executeQuery();

I currently use
int count;
if (r.isAfterLast())
count = 0;
else
{
r.last();
count = r.getRow();
}

My hope is, that last() instructs the kernel to move the cursor to the last row, and therefor the traffic won't be that much.
Is there a more sapdb-optimized version to get the number of rows returned by a select-statement?


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general