Re: JDBC ResultSet and cursors



govus wrote:

Hi everyone-
I'm using the Microsoft JDBC driver for SQL Server 2000 and I'm trying
to avoid using server cursors.

Is there a way to guarantee that every query will not create a
server-side ResultSet with a cursor? In other words, I want every
ResultSet to be loaded into the client's (the web server's) memory.

Does setting the "selectMethod" connection property guarantee this?

Does SQL Server automatically decide which method is best and if so,
what is the default choice?

I would appreciate any insight. Thanks in advance!

Hi. If you don't set selectMethod, and if you always fully
process your result set before re-executing the statement
it came from, or running another query via another statement
(or even some DatabaseMetaData calls) then you will avoid
serverside cursors.

.

Relevant Pages

  • Re: JDBC ResultSet and cursors
    ... I'm using the Microsoft JDBC driver for SQL Server 2000 and I'm trying ... to avoid using server cursors. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: [9fans] 9pfuse and O_APPEND
    ... since it doesn't always guarantee POSIX sematics, ... But you still can't guarantee it. ... server that really owns that file, that's a difference in kind from ... client callbacks so that "posix semantics" work ... ...
    (comp.os.plan9)
  • Re: Best Nics.
    ... > environment, I was wondering if anybody would be able to advise as to a ... avoid anything with a realtek chipset. ... I wouldn't use them in my main server, where high CPU usage could impact ...
    (Debian-User)
  • Re: Management by Wrangler
    ... I can understand the reluctance of any server to be skeptical even if it ... such a guarantee he'd love to make a large profit. ... Management by wrangler, thats a rivet in every weak spot ...
    (rec.games.backgammon)
  • Re: IE slows when large file emailed
    ... Kevin may have some othersuggestions but Web Page link, FTP, IM trnsfer, ... >> guarantee an actual 384kbps upload. ... >> to send one to multiple recipients, and some of those recipients reject ... >> the attachment (actual their email server rejcts it), ...
    (microsoft.public.windows.server.sbs)
Loading