mssql-jdbc | Microsoft JDBC Driver for SQL Server | SQL Database library

 by   microsoft Java Version: v12.3.1 License: MIT

kandi X-RAY | mssql-jdbc Summary

kandi X-RAY | mssql-jdbc Summary

mssql-jdbc is a Java library typically used in Database, SQL Database applications. mssql-jdbc has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has high support. You can download it from GitHub.

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.

            kandi-support Support

              mssql-jdbc has a highly active ecosystem.
              It has 960 star(s) with 388 fork(s). There are 80 watchers for this library.
              There were 7 major release(s) in the last 12 months.
              There are 69 open issues and 700 have been closed. On average issues are closed in 108 days. There are 7 open pull requests and 0 closed requests.
              It has a positive sentiment in the developer community.
              The latest version of mssql-jdbc is v12.3.1

            kandi-Quality Quality

              mssql-jdbc has 0 bugs and 0 code smells.

            kandi-Security Security

              mssql-jdbc has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
              mssql-jdbc code analysis shows 0 unresolved vulnerabilities.
              There are 0 security hotspots that need review.

            kandi-License License

              mssql-jdbc is licensed under the MIT License. This license is Permissive.
              Permissive licenses have the least restrictions, and you can use them in most projects.

            kandi-Reuse Reuse

              mssql-jdbc releases are available to install and integrate.
              Build file is available. You can build the component from source.
              Installation instructions, examples and code snippets are available.
              It has 96212 lines of code, 6720 functions and 381 files.
              It has high code complexity. Code complexity directly impacts maintainability of the code.

            Top functions reviewed by kandi - BETA

            kandi has reviewed mssql-jdbc and discovered the below as its top functions. This is intended to give you an instant insight into mssql-jdbc implemented functionality, and help decide if they suit your requirements.
            • Connect to the pool .
            • Executes the specified DTVExecute operation .
            • Call DTC .
            • Discard current row .
            • Convert a JDBC time value to an object .
            • Enable SSL .
            • Parse the URL and return the properties .
            • Get the next result from the TDS .
            • Writes the type information .
            • Denormalize a decrypted value .
            Get all kandi verified functions for this library.

            mssql-jdbc Key Features

            No Key Features are available at this moment for mssql-jdbc.

            mssql-jdbc Examples and Code Snippets

            No Code Snippets are available at this moment for mssql-jdbc.

            Community Discussions


            Java to SQL Server using Windows Authentication
            Asked 2022-Mar-29 at 22:57

            I am trying to connect to a remote SQL Server DB from a Java application without success.

            I am able to successfully connect to that SQL Server instance from a SQL client for Mac called SQLPro for MSSQL

            However, if I try to connect from the Java application using those same credentials, I always get a Login failed error, this is the code snipper I'm using:



            Answered 2022-Mar-29 at 22:57

            To connect using Windows Auth with app-provided credentials, you must configure the connection to use NTLM. The current connection string is for SQL Auth.



            Liquibase error when changeset uses runWith=sqlcmd
            Asked 2022-Mar-25 at 13:03

            My environment is SQL Server 2019 and Liquibase 4.8.0

            I'm having troubles using runWith=sqlcmd within a changeset. Liquibase responds with:

            Attribute 'runWith' is not allowed to appear in element 'changeSet'

            However, looking at the documentation, and the examples (near the bottom), here:

   seems to be saying that the "runWith" attribute should be within the changeSet tag




            Answered 2022-Mar-25 at 13:03

            The short version is that you are pointing to out of date XSD files in the header of your XML Changelog file. You are pointing to some marked version 2.0 - which are super old and predate the capability.

            At any point, the correct ones are in the examples folder under your Liquibase installation.

            For reference, as of 4.8.0, the header in the example is:



            No target folder generated after running mvn clean install
            Asked 2022-Mar-04 at 10:42

            i am unable to see target folder after running mvn clean install Here is my parent pom.Traget folder is missing in folder structure. Build message is successful though



            Answered 2022-Feb-18 at 18:12

            in parent pom, i was using pom, which should not be used . It should either be jar or should not be specified at all.




            Why does Hibernate complain about being unable to load the authentication DLL even though its configured in Maven?
            Asked 2022-Feb-27 at 18:27

            I have a Java project in Windows with the following Maven config:



            Answered 2022-Feb-27 at 18:27

            Turns out there's a known bug in the SQL Server JDBC driver where the Maven-provided DLL isn't used when switching to integrated authentication. Instead, JDBC tries to load the same DLL from:



            Serenity Cucumber 7 parallel execution not working
            Asked 2022-Feb-23 at 01:01

            looking for help to execute cucumber 7 in parallel. My project is serenity with cucumber and java. In this link it is showing that it is possible to run but tried different combination and looks like I missed something.

            Here is my pom.xml file:



            Answered 2022-Feb-23 at 01:01

            Find the solution for parallel execution with cucumber 7 and serenity junit 4. Below pom.xml is tested and working to execute parallel. According to this pom.xml to execute two ways:

            1. locally - add to your runner in tags tag you want to run and then execute this command mvn clean verify

            2. mvn clean verify -Dtags="@yourtagHere"

            Working pom.xml:



            Why doesn't this JDBC select return any rows?
            Asked 2022-Feb-19 at 08:24

            I have the following SQL statement which I am trying to execute via JDBC PreparedStatement:



            Answered 2022-Feb-18 at 20:03

            The resultset starts before the first returned row. Call



            nexus-staging-maven-plugin: maven deploy failed: An API incompatibility was encountered while executing
            Asked 2022-Feb-11 at 22:39

            This worked fine for me be building under Java 8. Now under Java 17.01 I get this when I do mvn deploy.

            mvn install works fine. I tried 3.6.3 and 3.8.4 and updated (I think) all my plugins to the newest versions.

            Any ideas?



            Answered 2022-Feb-11 at 22:39

            Update: Version 1.6.9 has been released and should fix this issue! 🎉

            This is actually a known bug, which is now open for quite a while: OSSRH-66257. There are two known workarounds:

            1. Open Modules

            As a workaround, use --add-opens to give the library causing the problem access to the required classes:



            Spring Boot GraphQLQueryResolver won't run, runs on test project
            Asked 2022-Feb-09 at 10:11

            So I'm new into GraphQL and i got stuff running by manually setup a schemaparser and datafetchers. But I want to refactor and try out by implementing GraphQLQueryResolver to a class and controll my queries from there.

            I get it to work by making a new project, but with the same dependencies and should be same implementation, It doesn't run. When I delete the query-methods which reflects the schema, I'll get the error that I need to add methods based on the Queries in the schema, so I get the confirmation it reaches the class-file with the implementation of the GraphQLQueryResolver. But I still get this error when i add the rights methods:



            Answered 2022-Feb-09 at 10:11

            -- Solved --

            So I ran my default project on Spring Boot 2.7.0 and 2.6.3 on my test project. When I changed to 2.6.3 on default, it ran. So it seems like the latest GrahpQL isn't fully compatible with Spring Boot 2.7.0 yet. Which might be obvious because it was released in the last month.



            Building a Jar using gradle - Jar hasn't sql dependency
            Asked 2022-Jan-28 at 16:31

            I am trying to build a very simple Program. I only have one dependency, the msql-jdbc.

            Every build succeds. But if i try to run the jar this exception ist thrown:

            Error: Could not find or load main class metaDataDB-0.5-msSQL.jar Caused by: java.lang.ClassNotFoundException: metaDataDB-0.5-msSQL.jar

            If i look into the jar, for example 7zip, I see all my compiled Classes.

            The content of MANIFEST.MF is as follows:



            Answered 2022-Jan-27 at 10:43

            the problem exists in msSQL.jar, there are some missing classes I guess, you can go to and Implement the right jar for your JRE or experiment with different versions.



            Gitlab job not pulling Docker image
            Asked 2022-Jan-12 at 09:04

            Running a Gitlab project that uses a Docker image I created.

            Problem: Gitlab job execution log shows that image is not being pulled. Here is the .gitlab-ci.yml file, with the company stuff removed:



            Answered 2022-Jan-12 at 09:04

            Your runner is configured to use shell executor (as you can see line 3 of your printscreen) but to run Docker image, you have to use docker or docker-windows executor (depending of if container you want to run is Linux or Windows based).


            Community Discussions, Code Snippets contain sources that include Stack Exchange Network


            No vulnerabilities reported

            Install mssql-jdbc

            Ubuntu + SQL Server + Java. Red Hat + SQL Server + Java. Mac + SQL Server + Java. Windows + SQL Server + Java.
            Ubuntu + SQL Server + Java
            Red Hat + SQL Server + Java
            Mac + SQL Server + Java
            Windows + SQL Server + Java
            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 minimum version of Java 11 with Maven. You may choose to build JDBC 4.3 compliant jar file (for use with JRE 11 or newer JRE versions) and/or a JDBC 4.2 compliant jar file (for use with 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 JRE 11 and newer versions compatible jar or JRE 8 compatible jar in the \target directory. Run mvn install -Pjre17. This creates JRE 17 compatible jar in \target directory which is JDBC 4.3 compliant (Build with JDK 17+). Run mvn install -Pjre11. This creates JRE 11 compatible jar in \target directory which is JDBC 4.3 compliant (Build with JDK 11+). Run mvn install -Pjre8. This creates JRE 8 compatible jar in \target directory which is JDBC 4.2 compliant (Build with JDK 11+).
            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 JRE 11 and newer versions compatible jar or JRE 8 compatible jar in the \build\libs directory. Run gradle build -PbuildProfile=jre17. This creates JRE 17 compatible jar in \build\libs directory which is JDBC 4.3 compliant (Build with JDK 17+). Run gradle build -PbuildProfile=jre11. This creates JRE 11 compatible jar in \build\libs directory which is JDBC 4.3 compliant (Build with JDK 11+). Run gradle build -PbuildProfile=jre8. This creates JRE 8 compatible jar in \build\libs directory which is JDBC 4.2 compliant (Build with JDK 11+).
            For some features (e.g. Integrated Authentication and Distributed Transactions), you may need to use the sqljdbc_xa and mssql-jdbc_auth-<version>.<arch> DLLs. They can be found in the package that can be downloaded from Microsoft. mssql-jdbc_auth-<version>.<arch> can also be downloaded from Maven.
            Don't want to compile anything?.


            API reference documentation is available in Javadocs. This driver is documented on Microsoft Docs.
            Find more information at:

            Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items

            Find more libraries

            Stay Updated

            Subscribe to our newsletter for trending solutions and developer bootcamps

            Agree to Sign up and Terms & Conditions

            Share this Page

            share link