Get the new Microsoft JDBC Driver 6.0 Preview


Today, we are pleased to announce the availability of the second community technical preview (CTP) of the Microsoft JDBC 6.0 Driver for SQL Server! This new driver now supports Table-Valued Parameters and Azure Active Directory. In addition to these new features, we have added additionally functionality for Always Encrypted. The driver also supports Internationalized Domain Names and Parameterized Queries introduced in the previous CTP release.

Read more about the full release communication here.

Downloaded the driver from the Microsoft Download Center and find more documentation on MSDN.

 

JDBC Driver Version JRE Versions JDBC API Version
6.0 1.5, 1.6, 1.7, 1.8 3.0, 4.0, 4.1, 4.2

 

Our team is continuing to work on more exciting features. Stay tuned for future announcements and follow SQL ServerAzure SQL Database, and Azure SQL DW on Twitter.

Andrea Lam (andrela@microsoft.com)

Comments (12)

  1. scott says:

    I am unable to download the Microsoft JDBC Driver for SQL Server today.

    Below is the error message.
    We are sorry, the page you requested cannot be found.
    The URL may be misspelled or the page you're looking for is no longer available.

    1. scott says:

      Looks like this issue resolved now.

      1. Andrea Lam says:

        Hi Scott,

        Apologies for the issues you were experiencing and happy to hear they were resolved. The Microsoft Download Center tends to be finicky. Please feel free to reach out to me if you run into any future problems.

        Thanks,
        Andrea Lam
        Program Manager
        andrela@microsoft.com

  2. Paul-Andre Panon says:

    Is the JDBC driver 6.0 "Preview" release ready for production but was only labeled as Preview because SQL Server 2016 was still in Preview?
    SQL Server 2016 was released on Wednesday, but the download links for the MS JDBC driver 6.0 still seem to say Preview. Will it be much longer before release of the JDBC 6.0 driver?

    1. Andrea Lam says:

      Hi Paul-Andre,

      I amexcited to announce that the driver was fully released earlier today. Please check out the blog posted today(https://blogs.msdn.microsoft.com/jdbcteam/2016/07/14/announcing-the-jdbc-driver-6-0-for-sql-server/).

      Thanks,
      Andrea Lam
      Program Manager
      andrela@microsoft.com

  3. Jonas says:

    Are there any plans to fix that memory leak that was introduced in driver 4.2?
    See https://connect.microsoft.com/SQLServer/Feedback/Details/2280301

    1. Andrea Lam says:

      Hi Jonas,

      Happy to report that we have fixed the issue in the JDBC 6.0 RTW driver.

      Thanks,
      Andrea Lam
      Program Manager
      andrela@microsoft.com

  4. Lotfi says:

    Great news ! Finally the Table-Valued Parameters are here !

  5. Feroze Daud says:

    Thanks for adding TVP support to the JDBC driver. This is a great feature and we have been waiting eagerly for it.

    I downloaded the driver to try it out. However, I am finding that it does not allow NULL values for Date types. The following code reproes the problem:

    ---
    public class DataTableTest
    {
    @Test
    public void test()
    {
    try {
    SQLServerDataTable dataTable = new SQLServerDataTable();
    dataTable.addColumnMetadata("id", Types.INTEGER);
    dataTable.addColumnMetadata("date", Types.DATE);

    dataTable.addRow(1, null);
    } catch (Exception e) {
    e.printStackTrace();
    }

    }
    }
    ---

    Can you please look into this asap?

    Here is a link to the case I opened on the forums: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/103d46a4-f26a-4782-8b51-b56ba9fb93fb/table-valued-parameters-and-null-date-values-in-ms-jdbc-60-driver?forum=sqldataaccess

  6. Hariharan Suresh says:

    Hi Andrea,
    Can you advise the probable GA date for the Microsoft SQL server JDBC driver 6.0 ?

    1. Andrea Lam says:

      Hi Hariharan,

      Very happy to announce that the driver just GA'ed earlier today. Please check out the blog posted today (https://blogs.msdn.microsoft.com/jdbcteam/2016/07/14/announcing-the-jdbc-driver-6-0-for-sql-server/).

      Thanks,
      Andrea Lam
      Program Manager
      andrela@microsoft.com

      1. Hariharan Suresh says:

        Thanks Andrea 🙂

Skip to main content