Partager via

Open sourcing the Microsoft JDBC Driver and Maven support

  • Article

We are excited to announce the open sourcing of the Microsoft JDBC Driver for SQL Server! By open sourcing the driver, we hope to get quicker feedback from the community, release on a faster cadence, and develop new features based on the scenarios Java developers need to support. Please check out the announcement video.

Open sourcing the driver includes:

  • Java source code on GitHub under MIT license
    • We hope developers will participate in developing the driver with us by filing issues and making pull requests
  • Build scripts for Maven and Ant
    • Build your own jars to support either JDBC 4.1 specification (for use with JRE 7) or JDBC 4.2 specification (for use with JRE 8)

With open sourcing, we have finally made the driver available on the Maven Central Repository. We have two jars available to support JRE 7 or 8. They can be selected by changing the version –  “6.1.0.jre8”  or  “6.1.0.jre7” . Add the JDBC driver to your Maven project by adding the following code to your POM file to include it as a dependency in your project.

 <dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>6.1.0.jre8</version>
</dependency>

The JDBC driver can be used to connect to SQL anywhere. Use it to connect to SQL Server (on-prem or in the cloud), Azure SQL Database, and Azure SQL Data Warehouse. Feature support for the JDBC driver has carried over from our JDBC Driver 6.0. This includes support for:

  • Always Encrypted
  • Azure Active Directory authentication
  • Table-Valued Parameters
  • Internationalized Domain Names (IDN)
  • Extended support for Parameterized Queries
  • Bulk Copy
  • Transparent connections to AlwaysOn Availability Groups

We look forward to working together to bring value to Java developers using SQL Server. If you have any questions or issues, please report them on the GitHub repository. To get started with developing apps in your programming language of choice and SQL Server, check out our new tutorials.

Andrea Lam (Program Manager)
andrela@microsoft.com

Comments

  • Anonymous
    November 18, 2016
    Good news, thanks Microsoft!
  • Anonymous
    November 18, 2016
    I got mssql working on debian.https://gist.github.com/brianherman/99c363de4fd64a31f047da0f281879d6
  • Anonymous
    November 18, 2016
    The comment has been removed
  • Anonymous
    November 19, 2016
    That's a wonderful news! It's time to replace jtds :)
  • Anonymous
    December 21, 2016
    Thats awesome. Thank you.
  • Anonymous
    January 24, 2017
    Great news, thanks !Would it be possible to deploy the x86/x64 sqljdbc_auth.dll DLLs also for integrated security on Windows? Can't seem to find them anywhere :(
    • Anonymous
      March 14, 2017
      You can find the DLLs on the Microsoft Download Center: https://www.microsoft.com/en-us/download/details.aspx?id=11774
      • Anonymous
        July 18, 2017
        Yes, the DLLs can be found by that manual download, but it'd be helpful if they were also deployed via Maven (would need to be a separate artifactId to prevent version conflicts), or better yet included in any new versions of the existing artifacts.
        • Anonymous
          July 19, 2017
          Unfortunately due to licensing, it's been difficult for us to upload the DLLs to Maven, but this is definitely something we have been considering.Thanks,Andrea LamProgram Manager andrela@microsoft.com
  • Anonymous
    March 28, 2017
    Hi folksThis is great news. So any project can use the appropriate drivers on JRE7 and JRE8. Cheers for that. Our only concern is, that within the transient dependencies there are some version conflicts which are basically not resolveable.For example: net.minidev:json-smart is referenced in two distinct versions. One depending on a 1.x version and the other in a 2.x version. According to the project page for json-smart the two apis are not compatible. So which version should it be? When running a java application, the lib appearing first in classpath ususally winns and this version is used. This may lead to unexpected runtime erros.This is impossible to solve by the project using the library.What are your thoughts on that. Will you clean up these dependencies to produce a valid maven artifact?Cheers- Michael
  • Anonymous
    July 24, 2017
    Very Good News. Thank you !