java: Hos to get the size of a returned result set?

Scruff · 2005-02-02 10:50:40

As the topic asks, cant seem to be able to do this for example if i execute a query that returns more than one result ResultSet rs = statement.executeQuery(QUERY); how do i get the size of the result set? I thought rs.getFetchSize(); would do it but it doesnt seem to. using NetBeans and j2sdk 1.5.0

02-02-2005 10:50AM

#1

Scruff

Registered Users, Registered Users 2 Posts: 4,228 ✭✭✭

Join Date: August 2001

Posts: 3521

As the topic asks, cant seem to be able to do this

for example if i execute a query that returns more than one result

ResultSet rs = statement.executeQuery(QUERY);

how do i get the size of the result set?
I thought

rs.getFetchSize();

would do it but it doesnt seem to.

using NetBeans and j2sdk 1.5.0

0

Comments

#2 02-02-2005 11:07AM

lynchie

Registered Users, Registered Users 2, Paid Member Posts: 2,033 ✭✭✭

Join Date: November 2001

Posts: 1914

If you need to know the size of it before you process it, use scrollable resultsets, go to the last row and call rs.getRow() on it.

0