Re: Using MARS with JDBC Driver

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