Mssql-jdbc - The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity with SQL Server through the standard JDBC. Microsoft/mssql- jdbc: The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity with SQL Server through the standard JDBC application program interfaces (APIs). Welcome to the Microsoft JDBC Driver for SQL Server project! The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in the Java Platform, Enterprise Editions. The Driver provides access to Microsoft SQL Server and Azure SQL Database from any Java application, application server, or Java- enabled applet. We hope you enjoy using the Microsoft JDBC Driver for SQL Server. SQL Server Team. Take our survey. Let us know how you think we're doing. Status of Most Recent Builds. Announcements. What's coming next? We will look into adding a more comprehensive set of tests, improving our javadocs, and start developing the next set of features. Get Started. Build. If you know of a driver or wrapper for SQLite that is not listed below, please feel free to add it to the list. Please indicate SQLite version(s) supported.Prerequisites. Java 8. Maven. An instance of SQL Server or Azure SQL Database that you can connect to. Build the JAR files.
Maven builds automatically trigger a set of verification tests to run. For these tests to pass, you will first need to add an environment variable in your system called mssql_jdbc_test_connection_properties to provide the correct connection properties for your SQL Server or Azure SQL Database instance. To build the jar files, you must use Java 8 with Maven. You can choose to build a JDBC 4. JRE 7) and/or a JDBC 4. JRE 8). Maven. If you have not already done so, add the environment variable mssql_jdbc_test_connection_properties in your system with the connection properties for your SQL Server or SQL DB instance. Run one of the commands below to build a JDBC 4. JDBC 4. 2 compliant jar in the \target directory. Run mvn install - Pbuild. This creates JDBC 4. Run mvn install - Pbuild. This creates JDBC 4. NOTE: Beginning release v. Gradle build script and it will be left in the repository for reference. Please refer to issue #6. Gradle. If you have not already done so, add the environment variable mssql_jdbc_test_connection_properties in your system with the connection properties for your SQL Server or SQL DB instance. Run one of the commands below to build a JDBC 4. JDBC 4. 2 compliant jar in the \build\libs directory. Run gradle build - Pbuild=build. This creates JDBC 4. Run gradle build - Pbuild=build. This creates JDBC 4. Resources. Documentation. API reference documentation is available in Javadocs. This driver is documented on Microsoft's Documentation web site. Sample Code. For samples, please see the src\sample directory. Download the DLLs. For some features (e. Integrated Authentication and Distributed Transactions), you may need to use the sqljdbc_xa and sqljdbc_auth DLLs. They can be downloaded from the Microsoft Download Center. Download the driver. Don't want to compile anything? We're now on the Maven Central Repository. Add the following to your POM file to get the most stable release: < dependency>. Id> com. microsoft. Id>. < artifact. Id> mssql- jdbc< /artifact. Id>. < version> 6. The driver can be downloaded from the Microsoft Download Center. To get the latest preview version of the driver, add the following to your POM file: < dependency>. Id> com. microsoft. Id>. < artifact. Id> mssql- jdbc< /artifact. Id>. < version> 6. Dependencies. This project has following dependencies: Compile Time: azure- keyvault : Azure Key Vault Provider for Always Encrypted feature (optional)adal. Azure Active. Directory Library for Java for Azure Active Directory Authentication feature (optional)Test Time: junit: jar : For Unit Test cases. Dependency Tree. One can see all dependencies including Transitive Dependency by executing following command. Azure Key Vault and Azure Active Directory Authentication Dependencies. Projects that require either of the two features need to explicitly declare the dependency in their pom file. For Example: If you are using Azure Key Vault feature then you need to redeclare azure- keyvault dependency in your project's pom file. Please see the following snippet: < dependency>. Id> com. microsoft. Id>. < artifact. Id> mssql- jdbc< /artifact. Id>. < version> 6. Id> com. microsoft. Id>. < artifact. Id> azure- keyvault< /artifact. Id>. < version> 1. Please note as of the v. SQLServer. Column. Encryption. Azure. Key. Vault. Provider object has changed. Please refer to this Wiki page for more information. Guidelines for Creating Pull Requests. We love contributions from the community. To help improve the quality of our code, we encourage you to use the mssql- jdbc_formatter. Thank you! Guidelines for Reporting Issues. We appreciate you taking the time to test the driver, provide feedback and report any issues. It would be extremely helpful if you: Report each issue as a new issue (but check first if it's already been reported)Try to be detailed in your report. Useful information for good bug reports include. What you are seeing and what the expected behaviour is. Which jar file? Environment details: e. Java version, client operating system? Table schema (for some issues the data types make a big difference!)Any other relevant information you want to share. Try to include a Java sample demonstrating the isolated problem. Thank you! Reporting security issues and security bugs. Security issues and bugs should be reported privately, via email, to the Microsoft Security Response Center (MSRC) secure@microsoft. You should receive a response within 2. If for some reason you do not, please follow up via email to ensure we received your original message. Further information, including the MSRC PGP key, can be found in the Security Tech. Center. Contributors. Special thanks to everyone who has contributed to the project. Up- to- date list of contributors: https: //github. Microsoft/mssql- jdbc/graphs/contributorsmarschall (Philippe Marschall)pierresouchay (Pierre Souchay)gordthompson (Gord Thompson)gstojsiccosmofrit. Jamie. Magee (Jamie Magee)mfriesen (Mike Friesen)tonytamwksehrope (Sehrope Sarkuni)jacobovazquezbrettwooldridge (Brett Wooldridge)License. The Microsoft JDBC Driver for SQL Server is licensed under the MIT license. See the LICENSE file for more details. Code of conduct. This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |