Re: Sp_CursorOpen,Fetch,Close

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 12:29:05 -0800

chinn wrote:

> Can Somebody explain what this actually means..
>
> exec sp_cursorfetch 180176529, 2, 1, 256

Sure. It means the driver is asking the dbms to execute the procedure
named 'sp_cursorfetch' with the arguments listed.

Joe Weinstein at BEA

>
>
> Thanks,
>
> "Alin Sinpalean" wrote:
>
>
>>Joe Weinstein wrote:
>>
>>>Correct, and congrats on the free jTDS driver. I suspect that the
>>
>>next
>>
>>>version of the free MS driver will be substantially better in many
>>
>>ways,
>>
>>>including this one. We'll see...
>>
>>Given their history with JDBC (not providing a driver for a very long
>>time and then only fixing a limited number of bugs in 5 years) and the
>>fact that they have no reason to support Java over .Net, I wouldn't bet
>>on that happening.
>>
>>In any case they would have to put in a major effort to get rid of the
>>current selectMode-based functionality (it took us months of hard work
>>to get this right). And if they won't any bugfixes they will make to
>>the driver won't really help much in performance terms. The only
>>advantage they have (and will still have, whatever they come up with)
>>is the brand name and the fact that most people don't even bother to
>>find out whether there's an alternative (so much so that many stick
>>with the JDBC-ODBC bridge even though it gets them into trouble every
>>so often).
>>
>>Anyway, thanks and keep up the good work.
>>
>>Alin.
>>
>>

Relevant Pages

  • Re: execute() vs executeUpdate() on a prepared statement
    ... the bug quickly,thanks. ... Server 2005 JDBC Driver ... execute may attempt to create a cursor. ... As you can tell the most important part of the repro is the SQL used ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Windows Scheduling on I/O bound systems with >2 cores/processo
    ... Each process does the continuous read & write DMA operations ... CPU usage: On <= 2 processor systems, ... We are running Load test on our PCI IO card(WDF driver), ... On machines with>2 processors a single process would execute its read ...
    (microsoft.public.development.device.drivers)
  • Re: execute() vs executeUpdate() on a prepared statement
    ... I have the same problem.I use the rtwjdbc driver connect ... the bug quickly,thanks. ... Server 2005 JDBC Driver ... execute may attempt to create a cursor. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: CPU Pegged at 100%
    ... Enquire, plan and execute ... Windows Image Acquisition and select Properties. ... Updated video driver, no effect. ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Data Download via ODBC
    ... when you execute a package manually it runs from your ... PC and under your security context. ... Did you install the Merant drivers on the server? ... getting is for unable to load driver. ...
    (microsoft.public.sqlserver.odbc)
Loading