Re: How to use server side cursors?

Tech-Archive recommends: Fix windows errors by optimizing your registry

We are actively working on this issue. I will post here as soon as I hear
more.

Thank you,
Angel

--
Angel Saenz-Badillos [MS] DataWorks
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging: http://weblogs.asp.net/angelsb/




"Mark" <Mark@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1E035388-E550-4CBF-A7AD-09C52C1B0F0B@xxxxxxxxxxxxxxxx
With SQL Server 2000 and the previous jdbc driver, we used the
SelectMethod=cursor on the jdbc url and everything worked fine. We
upgraded
to SQL Server 2005 and the new jdbc driver (sqljdbc.jar) and have run into
problems where using the SelectMethod=cursor causes batch updates to fail
with the following:

Exception: com.microsoft.sqlserver.jdbc.SQLServerException:
sp_cursoropen/sp_cursorprepare: The statement parameter can only be a
single
select or a single stored procedure.

If we remove the SelectMethod=cursor we get the jdbc client running out of
memory when we query large tables with the following exception:

The system is out of memory. Use server side cursors for large resultsets

So how can we use server side cursors with the new driver and still have
batch updates working? Is there another way to enable server side cursors?



.

Relevant Pages

  • Re: Unblocking items in firewall - Symantec AntiVirus Corporate Edition
    ... > I sell a server based software product. ... > Symantec AntiVirus Corporate Edition product but one of my customers ... It will not block connection attempts. ... Is my JDBC connection code incorrect? ...
    (comp.security.firewalls)
  • Re: -952 Authentication Error on Solaris 10
    ... Then it sends the info into the server, ... causing Informix to barf on the authentication and then failing. ... Now I know and I'm looking at not using the Informix native jdbc ... driver but trying to use the informix jdbc driver that ships with the ...
    (comp.databases.informix)
  • Re: JDBC or ODBC?
    ... But if it came down to it, I bet I could beat slightly performance of JDBC ... The reason for this is ODBC ... we are choosing between a server that sits on top of Windows ... >> performance implication directly related to the database access ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: Cannot connect to my SQL 2005 server using JDBC - can any dia
    ... Do you have any references on which version of the Microsoft JDBC driver ... is talking about doesn't talk to UDP 1434 to retrieve the port automatically. ... I have seen some scenarios where not every JDBC drivers handles problems with the UDP broadcast from the SQL Browser service ... Cannot connect to my SQL 2005 server using JDBC - can any diagnostic tool tell me what the problem is? ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Bidirectional cursor navigation
    ... It has async operations (including async connections), ... has server-side AND client-side cursors, ... >> the wonders of the web implemented connected architectures. ... >> Server can support thousands of users (we ...
    (microsoft.public.dotnet.framework.adonet)