Delay closing resultsets

Fernando Lozano fsl at centroin.com.br
Fri Sep 29 21:32:37 EDT 2000


Hi there!


I am using the freetds jdbc driver for an application that queries
MS SQL Server 7 on a WAN. My application requires searches that
returns thousands of rows such as like 'name%' queries.

Most of the time my users will see the first dozens of rows and then
quit to a more refined search, but it looks like the freetds jdbc
driver conties to fetch all rows when I close it. The result is a
big delay (which can be of several minutes) when the user wants to
try another search. Using Connection.cancel() has the same result. 

Is this a bug of the driver, some feature not yet implemented, or
what? The only workaround I got so far is to call
Statement.setMaxRows(), but this way the user won't be able to see
all results, and this is not desirable.

Any hints will be very apreciated.


[]s, Fernando Lozano





More information about the FreeTDS mailing list