Announcement and Discussions related to the Microsoft JDBC driver for SQL Server
Dear SQL Server Developer Community,
I am pleased to report that the Microsoft JDBC Driver 4.0 for SQL Server is now released. Thank you for all your great feedback on our three community technology previews (CTP). Our 4.0 release contains some great features which I would like to highlight.
Customers using non-Windows platforms now have the option of using Kerberos for authentication. The table below summarizes available authentication options.
Pure Java Kerberos
Kerberos with NTLM backup
We have several customers who have tested Kerberos via our CTP driver, some using Linux in a cross-realm environment.
The Microsoft JDBC Driver 4.0 for SQL Server supports AlwaysOn high availability and disaster recovery. Customers have the option to use AlwaysOn instead of database mirroring. Some key features include
SQL Server 2012 introduces a user interface for XEvents and users can choose to track driver related actions within XEvents. Simply set appropriate parameters for logging, create an XEvents session and the Microsoft JDBC Driver 4.0 for SQLServer will send tracing information to XEvents to enable troubleshooting and monitoring. The correlation information will be available in all XEvent targets including in memory, the XEvents ring buffer, log files, and the viewer in management studio.
Based on customer and partner feedback, we made a change to the way the FormatID field is handled in XA transactions. The Microsoft JDBC Driver 4.0 for SQL Server will now use the provided formatID field in all XA transactions.
Other features include UTF-16 support, enhanced SQL Azure support, support for sparse columns,and bug fixes.
You can find documentation on the driver at our MSDN documentation page, obtain technical support via our forums or Microsoft Customer Support, report bugs via the SQL Server Connect Site, and (most importantly!) download the new driver here.
Thank you for your support and we look forward to your feedback.
Shamitha ReddyProgram Manager - Microsoft JDBC Driver for SQL Server
Please, make it available via Maven Central.
Hi - We are trying to setup widows authentication from Linux(SUSE) box to SQL 2K8 backend. Is there a case study\KB which has step to step guide on how to achieve this?
We are using JDBC4.0 driver.
@fsdba If you are running on SUSE Linux you can authenticate using pure Java Kerberos or SQL Server Authentication. You can only use Windows authentication if you are running the JDBC Driver on the Windows platform.
Hi - Is ther any Documntation/case study/KB article on how to use Java Kerberos on Linux Suse environment?
The following topic covers Kerberos setup for WIndows, Linux, and other non-Windows environments.
One of the major complaints against using the MSSQL driver over jTDC was the performance. A developer in this post reports Microsoft driver is 50% slower than JTDC.
Any comment on performance improvements in this new version?
correction: It is jTDS not jTDC/JTDS.
Thanks for your feedback. We are continuously looking at ways to improve the performance and scalability of the Microsoft JDBC Driver for SQL Server. Would you like to provide us with more specifics via our blog contact page? blogs.msdn.com/.../contact.aspx
Also, have you compared our latest driver - Microsoft JDBC Driver 4.0 for SQL Server using SQL Server 2012 with jTDS?
I responded on Stack Overflow as well.
Can Microsoft conduct its own head-to-head performance tests against jTDS?
The conventional wisdom in the Java dev community is that when supporting SQL Server from Java, jTDS is the choice, because Microsoft's JDBC implementation has a reputation of being slow and buggy.
However jTDS is ageing - its last release was over 2 years ago - whereas Microsoft have been steadily releasing new versions. It might be time for this conventional wisdom to be updated?
There is an opportunity for Microsoft to fill the information void comparing jTDS and its own driver, in terms of both stability and performance.
The feedback that jTDS is faster than the Microsoft JDBC is mainly anecdotal. We have on numerous occasions asked for additional details regarding how the tests were conducted and have not received those details.
The key with performance benchmarking is to ensure that products are being compared equally (apples to apples instead of apples to oranges). We have heard that jTDS handles Secure Sockets Layer (SSL) communication differently from the Microsoft JDBC Driver. If the performance tests do not take into account these differences, the test results may be skewed.
We would be happy to partner with the community to conduct performance benchmark testing. Keep in mind that one needs written approval from Microsoft prior to publishing any results (see section 2 of our software license).
With regards to bugs in the Microsoft JDBC driver, every software product on the market will have some bugs. We encourage our users to report bugs via Microsoft Connect and also encourage the community to vote on those bugs so we can understand how many individuals are impacted by a particular bug. We carefully review every bug report we receive. We look at various variables including whether a workaround exists, if a fix can be made without impacting backward compatibility and then determine a course of action for that bug.
When choosing a driver, here a few points to consider
- How does the driver handle security including SSL communication? The Microsoft JDBC Driver is subjected to extensive Corporate security reviews at each release.
- How active are the forums? We have a very active forum that offers free community support. Other Microsoft JDBC users & MVP's frequently answer forum posts. In addition our forums are monitored by Microsoft Customer Support and the Microsoft Product Group. The forums are easily searchable on the internet and MSDN.
- Is paid support available? Support is available for our driver via Microsoft Customer Support. In addition, Customer Support and the Product Group have frequent communication on customer cases.
- Does the driver support new SQL Server releases/features? The Microsoft JDBC Driver 4.0 supports SQL Server 2012 along with Always On and XEvents. We strive to support new functionality in SQL Server, SQL Azure, PDW, and other Microsoft offerings.
- Is the driver adding new features regularly? We released the 4.0 version of the driver in March 2012 that included pure Java Kerberos support, a FormatID change (requested by customers & partners), and other features. We are looking forward to future releases of the driver so we can continue to expand on our driver's functionality.
I'm confused about this annoucement. I have a sqldjbc4.jar that is internally dated to 4/19/2010. It appears to be from Microsoft and it works. How is does my older version differ from this newer release?
I just tried out this newer release. My older version worked fine from my Java application. However, the new version generates the following error "SQL Server version 8 is not supported by this driver. ClientConnectionId:92d3a68d-f3db-4442-a6b0-115dfa86811f". Why is this happening?
The driver does not support running with "SET SHOWPLAN_ALL ON;"
As soon as that is turned on, every select statement throws an exception with:
The TDS protocol stream is not valid. Unexpected token TDS_COLMETADATA (0x81). [SQL State=08S01]
Driver version: 4.0.2206.100
Happens with SQL Server 2012 Express and SQL Server 2005 SP3
More details on the problem: the driver only throws an exception when setMaxRows() is called on the statement object before running the statement to be explained.
Great! Now can you please publish it to Maven Central?