Very expensive. You end up doing 2 queries of every one or retrieving the
entire result set 2x.
Jim
"Isma" <Isma_at_iballo.com> wrote in message
news:3B6958BF.1B0AFF3F_at_iballo.com...
> Hi,
>
> I use a JDBC driver. I want to know whether exists a command to know the
> results number just after the query.(i.e. lines)
>
> [I know it exists getColumnCount() to know the number of columns return
> ..
> int numcols = rsmd.getColumnCount();
> ]
>
> stmt.execute(sql)
> ResultSet rs = stmt.getResultSet();
> ResultSetMetaData rsmd = rs.getMetaData();
>
>
> What about getfetchSize() ??? it always return 10 whatever returned
> results.
>
>
Received on Thu Aug 02 2001 - 19:25:10 CDT
