> resultset.first() returns SQLException: [Microsoft]
> [SQLServer 2000 Driver for JDBC]Unsupported method:
> and resultset.getFetchSize() returns 0 constantly, no matter
> how many records are returned by our SELECT statement.
> anyone have any ideas?
Sure. The first one is the driver explicitly telling us it doesn't implement that method,
so you'll have to do without.
As to the second, setFetchSize() and getFetchSize() have nothing to do with how
many rows you get back from your queries. They are just methods to hint to the
driver (if it's listening and capable of using the hint) how many data rows to get from
the server in one go (rather than getting one row every time you call next()). In other
words, it's just a tuning feature if the driver can use it. This driver cannot use the hint.
Depending on how the query was made, this driver can only get rows one-at-a-time,
or it will get them all at once. In any case, the driver will always return all the rows
that come from the DBMS in response to your query. If you actually want to limit
the amount of rows, the best way is with the SQL you issue.
Joe Weinstein at BEA