Freigeben über

SQL Server 2008 feature support survey

  • Artikel

Since the release of SQL Server 2008, we have heard from customers looking for a JDBC driver that supports SQL Server 2008.  I would like to use this post to ask you, our customers, which features of SQL Server 2008 do you need supported through the JDBC driver.  We want to make sure we are delivering features which adds the most value to our customers and your feedback will help us help you.

Here are some features to get things started:

  • Date/Time/Datetime2/DatetimeOffset data type
  • Sparse Columns
  • Table-Value Parameters
  • T-SQL MERGE command
  • Filestream data type
  • Spatial data type
  • HierarchyID data type

Please add any you don't see on the list.  If there are multiple features you need, please rank them in order of priority.

Thanks,
Jimmy Wu
SQL Server JDBC Team

Comments

  • Anonymous
    October 15, 2008
    The comment has been removed
  • Anonymous
    October 16, 2008
    The comment has been removed
  • Anonymous
    November 05, 2008
  1. Date/Time/Datetime2/DatetimeOffset data type
  2. Sparse Columns
  3. Spatial data type
  4. HierarchyID data type ?. Table-Value Parameters ?. T-SQL MERGE command ?. Filestream data type By ? I mean we haven't figured out if these would be of value yet.

  • Anonymous
    November 09, 2008
    It is very interesting for us to use JDBC driver to read an write Spatial data type. Now, we can use only Oracle SDO.

  • Anonymous
    November 13, 2008
    We are looking foreward to support for spatial data type.

  • Anonymous
    November 13, 2008
    We are looking foreward to support for spatial data type.

  • Anonymous
    December 05, 2008
    Re-posting Support for "Bulk Copy"? I was half way done porting the "Bulk Copy" using the current microsoft jdbc driver. Used the com.microsoft.jdbc.sqlserver.tds package to do that. and now when I look at your new classes, this package is gone, so I'll have to go back to JNI. Java applications deserves a "Bulk Copy" implementation, where one can call bcpInit, bcpSendRow, bcpBatch, bcpDone. without using the stupid file logic or JNI.

  • Anonymous
    December 13, 2008
    To conform with type 4 JDBC driver.

  • Anonymous
    December 14, 2008
    Support connecting using Windows credentials from UNIX by specifying them on the connection string.

  • Anonymous
    December 19, 2008
    The comment has been removed

  • Anonymous
    December 29, 2008
    Most important:

  1. Date/Time/Datetime2/DatetimeOffset data type
  2. Does anything need to be added to the driver to support wide tables (ie. tables with more than 1024 columns)? If so, then that would be important to us as well.
  3. Bulkcopy
  4. Sparse columns Thanks

  • Anonymous
    January 16, 2009
    Spatial data type is most important for us.

  • Anonymous
    January 16, 2009
    The comment has been removed

  • Anonymous
    January 19, 2009
    The comment has been removed

  • Anonymous
    March 17, 2009
    The comment has been removed

  • Anonymous
    April 03, 2009
    I would like better performance. We have an application that opens two resultsets of ~6 million rows and reads through all the data. The latest JTDS open source driver benchmark is about 2.7 minutes.  The MS 2.0 driver benchmark is 4.9 minutes.  Both resultsets have a small number of columns comprised of decimal data. Source DB is SQL 2008. JRE is 1.6.    

  • Anonymous
    April 03, 2009
    I would like better performance. We have an application that opens two resultsets of ~6 million rows and reads through all the data. The latest JTDS open source driver benchmark is about 2.7 minutes.  The MS 2.0 driver benchmark is 4.9 minutes.  Both resultsets have a small number of columns comprised of decimal data. Source DB is SQL 2008. JRE is 1.6.    

  • Anonymous
    April 06, 2009
    The comment has been removed

  • Anonymous
    April 21, 2009
    datetime2 support would be very much appreciated, we are currently having to use the setText() workaround to get proper millisecond resolution in dates since a date at the end of the day shows up tomorrow in the database.

  • Anonymous
    April 30, 2009
    For those interested in Spatial types, would Windows only support for Spatial types be good enough? We have some geo spatial libraries written in C++ would be hard to port all of them to Java in the short term. Also, do you use JPOX spatial types in your applications.

  • Anonymous
    May 22, 2009
    Table-Value Parameters - I am looking for a Java JDBC example on the "Table-Value Parameters" usage ? please let me know if you all have any URL on this.

  • Anonymous
    May 27, 2009
    Hello RG, We currently do not support TVPs. However, we are considering supporting them in a future release. Could you describe your TVP usage scenario? Thanks so much. --Tres London [SQL Server]

  • Anonymous
    June 16, 2009
    Hi Tres, I have several SP's that requires passing in list of key value pair's to the SP (array with a record like structure). so if a TVP is not supported currently ...then I guess XML is the only option. I was under the impression that since TVP is supported in Dot Net , it is available for Java as well. This is a very important feature ..Oracle has been supporting this type of interface for past decade.

  • Anonymous
    July 08, 2009
    The comment has been removed

  • Anonymous
    September 13, 2009
    TVP, TVP, TVP, did I said TVP? :-)

  • Anonymous
    September 15, 2009
    Thank you for the feature request - keep them coming. Unfortunately TVPs will not be making it into the next release. We will be publishing a roadmap for this next release on the blog in a bit to help.

  • Anonymous
    December 17, 2009
    The comment has been removed

  • Anonymous
    March 09, 2010
    Support of Datatime2 type in PreparedStatement.setTimestamp().  We are migrating Oracle to SQLServer and can not set Oracle datetime prior to 1753 to sqlserver without using Datatime2 type but current jdbc driver does not support it.  Big minus!

  • Anonymous
    April 10, 2010
    As mentioned in your post http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/7b4eac48-4eee-43a3-81a7-de41440e846c I would definitely like to see the JDBC driver be able to support secure, cross platform login authentication. In particular, I have a linux web server hosting LAN applications in a Windows network. I would like to be able to log the users on the SQL Server using Windows Authentication and not have to create new logins for everyone (out of sync with their workstation login IDs, passwords and expirations), or have to create a common SQL Server login where the individual user can't be identified (which is what I do now). If you have any question on this comment, my email address is mfoley@novatec-inc.com

  • Anonymous
    April 12, 2010
    Thank you Mark for providing your input. I will certainly contact you if I have further questions on your feedback. Thanks Amina

  • Anonymous
    August 22, 2010
    Hi, I am looking for a way to pass list of records, where each record having three columns, to Sql Server stored procedure. I have found that there are two ways of doing this - 1. Using OpenXML 2. TVP. I have studied that passing a large XML through network to the database might cause problems. So am i left with the only option of using TVP's? If so can some one give me the link, that shows java example usage of it? Thanks. Swetha.

  • Anonymous
    February 12, 2011
    Hi, We need support for the CURSOR data type. This will allow us to read multiple result-sets at a time easily(instead of multiple database calls), thus making more people switch to SQL Server 2008

  • Anonymous
    May 01, 2012
    I would like to see the driver support  secure cross-platform single sign-on capability.

  • Anonymous
    May 01, 2012
    @Steve  The 4.0 version of the Microsoft JDBC Driver (Released March 2012) supports pure Java Kerberos authentication that can be implemented in a cross realm and cross platform environment.  Here is a link to more details on our Kerberos authentication.  msdn.microsoft.com/.../gg558122.aspx Please let us know if you have additional requirements beyond what we offer today.

  • Anonymous
    March 12, 2014
    Can you please include FILESTREAM data type support (i.e File Streaming API ) similar to the .NET provided SQLFileStream class Thanks

  • Anonymous
    October 12, 2015
    Connection options would be my #1.  Not sure why MS would design a driver that operates in the JVM with a dependency on a Windows binary (e.g., the .dll used for windows authentication), but it continues to be a pain for those of us needing to communicate with Window products from non-Windows operating systems.