Welcome to MSDN Blogs Sign in | Join | Help

Microsoft JDBC Driver Team Blog

Discussions related to Microsoft JDBC driver.
SQL Server 2008 feature support survey

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

Posted: Tuesday, October 14, 2008 10:40 AM by dpblogs

Comments

azgard said:

+2 Date/Time/Datetime2/DatetimeOffset data type

+1 Filestream data type

Why you must support explicit Sparse Columns? Is it not only a internal behavior?

# October 16, 2008 2:21 AM

dpblogs said:

azgard,

Yes, you are mainly right that Sparse Columns is primarily an SQL Server internal behavior, but the column metadata needs to be updated to allow users to discover that it is a Sparse Column.

We will think through all of the usage experience our customers will have through the driver if/when we tackle this SQL Server feature as well as all other features.

-Jimmy

# October 16, 2008 11:03 PM

Wes Clark said:

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.

# November 5, 2008 1:25 PM

Jiri W. said:

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

# November 9, 2008 1:10 PM

Otto said:

We are looking foreward to support for spatial data type.

# November 13, 2008 4:01 PM

Otto Axt said:

We are looking foreward to support for spatial data type.

# November 13, 2008 4:01 PM

Sagar I said:

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.

# December 6, 2008 6:25 AM

xavi said:

To conform with type 4 JDBC driver.

# December 13, 2008 12:49 PM

Vivek said:

Support connecting using Windows credentials from UNIX by specifying them on the connection string.

# December 14, 2008 10:49 PM

dpblogs said:

Thank-you all for your feedback.  They are very helpful to us.

Thanks,

Jimmy Wu

# December 19, 2008 8:17 PM

Brian Clark said:

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

# December 29, 2008 10:00 PM

Dan Heyl said:

Spatial data type is most important for us.

# January 16, 2009 9:54 AM

jasdue said:

Hi Jimmy,

When are you thinking to deliver sql 2008 jdbc driver? It is really urgent for me.

Thanks,

# January 16, 2009 2:35 PM

dpblogs said:

jasdue,

At this time I am not able to provide a timeframe when we will release a JDBC driver that support new features introduced in SQL Server 2008.  We are actively looking into this.

Sincerely,

Jimmy Wu

# January 19, 2009 9:53 PM

Michael said:

DateTime2 Support is very important:

- PreparedStatement.setTimestamp()

based on milliseconds (without rounding)

- Metadata should return the correct DataType not nvarchar.

For us this feature is important to migrate an Oracle application to SQLServer without refactoring the hole Timestamp handling.

Thanks

# March 17, 2009 2:59 PM

Rob radina said:

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.    

# April 3, 2009 9:16 PM

Rob radina said:

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.    

# April 3, 2009 9:16 PM

dpblogs said:

Hi Rob,

Good performance is certainly an important feature of any release!  When reading that much data, latency should be dominated by network and server disk I/O.  Changing the client driver shouldn't make that big of a difference.

Can you share your benchmark table schema, and perhaps the benchmark code, with us at https://connect.microsoft.com/SQLServer/feedback/CreateFeedback.aspx ?  Be sure to include "JDBC" somewhere in the title.  You'll be able to track our investigation of the issue.

Regards,

--David Olix [SQL Server]

# April 6, 2009 12:32 PM

Jeramyn said:

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.

# April 21, 2009 8:38 PM

Mugunthan Mugundan [MSFT] said:

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.

# April 30, 2009 1:30 PM

RG said:

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.

# May 22, 2009 9:58 AM

dpblogs said:

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]

# May 27, 2009 5:46 PM

RG said:

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.

# June 16, 2009 1:46 PM

OC said:

TVPs are very important to us. We have a Java service layer in front of SQL Server DB data layer for high volume OLTP. Currently we spend a lot of cycles breaking down comma-delimited lists using a T-SQL UDF so we can join to a table inside stored procs. Having this data structure built in Java first and passed into the proc allows us to spend less time in the data tier. I suspect this was a major motivator for creating TVPs in the first place...please bring them to Java the way you have for .Net.

# July 9, 2009 2:49 AM

noeldr said:

TVP, TVP, TVP, did I said TVP? :-)

# September 13, 2009 6:00 PM

dpblogs said:

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.

# September 15, 2009 5:40 PM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker