Re: Using MARS with JDBC Driver

To be clear I am talking about the MICROSOFT SQL SERVER 2005 JDBC DRIVER

--
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/




"Angel Saenz-Badillos[MS]" <angelsa@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:eHKsFQJHGHA.3176@xxxxxxxxxxxxxxxxxxxxxxx
> Wes,
> Mars is not supported with the v1.0 driver, it is a feature that we are
> looking to implement in a later release (given how extremely hard this is
> to implement and the poor bang for the buck this feature gives it will
> probably be implemented post v1.1).
>
> As per JDBC spec MARS like behavior is supported in this driver, (the
> driver will behave as if MARS is enabled thanks to some under the covers
> "magic") The two accepted ways to do this in the JDBC space are to either
> create a new connection under the covers whenever you ask for a second
> resultset or to client side cache the data from your entire resultset so
> that the tds buffer is free and available for a second resultset at any
> time. For this driver and keeping in mind that Pooling will be mostly
> supported by application servers we decided against opening a second
> connection (this basically kills your pooling story) and opted for client
> side caching.
>
> The obvious problem with client side caching is that it becomes really
> inneficient to retrieve large resultsets, in extreme cases you may
> actually run out of JVM memory! The workarround is to retrieve smaller
> ammounts of data (always a good recomendation) or when this is not
> feasible to use server side cursors. When you use server side cursors you
> only client side cache the specified (fetchsize) number of rows. We are
> providing a very granular server side cursor story in this driver.
>
> I hope this helps, let me know if you have any specific comments or
> concerns.
>
> --
> 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/
>
>
>
>
> "Wes Clark" <WesClark@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:9CE9D427-E6A4-42F8-82A9-023666DB084E@xxxxxxxxxxxxxxxx
>> Is MARS supported through JDBC? Is the connection the same? Is this
>> documented anywhere?
>
>


.

Relevant Pages

  • Re: SBS 2003 - SBS 2008 migration issues
    ... DHCP cannot work properly with the hyper-v role, and probably DNS, neither will the configuration wizards. ... clients losing the ability to use it after removing trend client, reseting winsock / removing network components / reinstalling teh client don't bring it back. ... When I add the 32 bit driver to the printer it simply tells me it's not a suitable driver, and to try adding the driver from a 32 bit client. ... If I install hyperV on the SBS 2008 will it run a win2k3 server? ...
    (microsoft.public.windows.server.sbs)
  • Re: Printer autocreation failing
    ... behaviour of a TS incompatible printer driver. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Tried installing that printer tray hotfix, ... Also tried updating the RDP client to the latest ...
    (microsoft.public.windows.terminal_services)
  • Re: Printer autocreation failing
    ... reinstall the driver onto the TS box). ... Check in Printers and Faxes - File - Server properties - ... Also tried updating the RDP client to the ... box and installing the print queue from the remote server ...
    (microsoft.public.windows.terminal_services)
  • Re: Printer autocreation failing
    ... redirection of the driver to the LJ4) and functional. ... Check in Printers and Faxes - File - Server properties - ... Also tried updating the RDP client to the ... box and installing the print queue from the remote server ...
    (microsoft.public.windows.terminal_services)
  • Re: .webpnp Driver file
    ... I think the client user will need to be an admin user if the driver contains ... Server is able to create webpnp file. ...
    (microsoft.public.windows.server.clustering)
Loading