Re: which driver support setQueryTimeout

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Shelby Goerlitz [MSFT] (shelbyg_at_microsoft.com)
Date: 03/18/04

  • Next message: Nathan Sokalski: "Database Queries Using DATE"
    Date: Wed, 17 Mar 2004 17:22:06 -0800
    
    

    Bruce:

    See answers inline.

    -shelby
    SQL Programming Model, SQL Server
    Microsoft

    "Bruce Robertson" <bruce_robertson01@yahoo.com> wrote in message
    news:c7c56b2c.0403170842.5efb9a2d@posting.google.com...
    > Brian - thanks for the response. We have a mission critical
    > application that depends on Microsoft JDBC and so I have some further
    > questions from your post:-
    >
    > 1) Since DataDirect are the authors of this driver can we expect to
    > get future support questions answered in this forum from DataDirect or
    > from Microsoft? I believe its always been somewhat unclear to users of
    > this product as to which company will be providing support, new
    > releases and the overall product roadmap.

    [shelbyg] Microsoft licenced a SQL Server 2000-only version of the Data
    Direct JDBC Connect 2.x driver, rebranded it as the freely downloadble SQL
    Server 2000 driver for JDBC (see:
    http://www.microsoft.com/presspass/press/2001/sep01/09-25MerantPR.asp).
    Microsoft also purchased tier-2 support from Data Direct for this driver,
    and the Microsoft and Data Direct teams work closely together to support
    this product -- for customers who have purchased SQL Server support and
    also, where time allows, by answering posts on this newsgroup. For the
    Microsoft brand driver, Microsoft owns the roadmap and all releases.

    >
    > 2) You mention SP3 of the driver. Can you advise when that will be
    > available for download?

    [shelbyg] SP3 is currently planned for this summer.

    >
    > 3) Do you know when the MS driver will support JDBC 3.0?

    [shelbyg] the JDBC driver hasn't been finalized for next release of SQL
    Server (http://www.microsoft.com/sql/yukon/productinfo/) but 3.0 spec
    compliance is high on the list. Hope to be able to announce specifics soon.

    >
    > 4) Will we ever be able to distribute the Microsoft driver with an OEM
    > application? Who makes that determination - DataDirect or Microsoft?
    >

    [shelbyg] the EULA for the SQL Server 2000 driver for JDBC is an agreement
    w/ Microsoft. Redist rights to third parties is also high on the
    requirements list for the next major version of this driver. Again
    specifics still TBD.

    > Thanks for your help..
    > Bruce R
    >
    > brian.derwart@datadirect.com (Brian Derwart) wrote in message
    news:<13919491.0403161500.15432228@posting.google.com>...
    > > Jim,
    > >
    > > The MS documentation is in error here. The setQueryTimeout method is
    > > supported with Statement, PreparedStatement and CallableStatement
    > > objects. If you test the method with some sample code, you'll find
    > > that no exception is thrown when you call the setQueryTimeout method.
    > > The documentation will be corrected for the MS SP3 release.
    > >
    > > Brian
    > >
    > >
    > > "Jim" <anonymous@discussions.microsoft.com> wrote in message
    news:<917201c40869$10ba0030$a601280a@phx.gbl>...
    > > > we installed "Microsoft SQL Server 2000 Driver for JDBC"
    > > > SP2. I found out setQueryTimeout is not supported for this
    > > > version but it is supported in 1.0. Does anyone know why.
    > > > Where can I find a driver support setQueryTimeout.
    > > >
    > > > Details
    > > > ---------------------------
    > > > If you go to the folder under
    > > > \Microsoft SQL Server 2000 Driver for JDBC\books\Msjdbcref
    > > > In msjdbcref.pdf. If you search "setQueryTimeout". you
    > > > will find that the version of SP2 do not support
    > > > setQueryTimeOut


  • Next message: Nathan Sokalski: "Database Queries Using DATE"

    Relevant Pages

    • SQL 2008 Upgrade Bug
      ... I had a similar situation and after calling MS support it turns out there is a bug in the SISS that will prevent the upgrade of an expired evaluation edition. ... I am not sure if you have unintalled the SQL Server and then reinstalled it. ... In this case I recommend that you contact Microsoft Customer Support Services ...
      (microsoft.public.sqlserver.setup)
    • RE: Database Engine Tuning Advisor
      ... In this case I am using an account that has sys admin rights. ... Thank you for using the Microsoft MSDN Managed Newsgroup. ... Tuning Advisor to connect to SQL server database. ... Microsoft Online Community Support ...
      (microsoft.public.sqlserver.tools)
    • RE: Configuration parameter in SQL database
      ... Welcome to Microsoft Newsgroup Support Service! ... how to store&return the configuration ... SQL Server + SQL Dependency Cache ...
      (microsoft.public.dotnet.general)
    • RE: Connecting remotely through VPN
      ... Thank you for using Microsoft MSDN Managed Newsgroup. ... TCP port is listening by your SQL Server. ... Microsoft Online Community Support ...
      (microsoft.public.sqlserver.connect)
    • Re: SQL Server Express 2005 stopped working--urgent
      ... Microsoft SQL Server Management Studio Express ... may want to attach the database files you found to this new instance. ... Microsoft Product Support Services so that a dedicated Support Professional ...
      (microsoft.public.sqlserver.setup)