Which jar to use for connecting to MS SQL server

Question

Can some one please guide me to understand which jar file i need to include in my application to be able to set up a jdbc connection with ms sql server.

thanks in advance.

score 12 · Accepted Answer · edited Jul 13 '18 at 13:14

12

sqljdbc.jar and sqljdbc4.jar class library files to be used depending on your preferred Java Runtime Environment (JRE) settings. For more information about which JAR file to choose, see System Requirements for the JDBC Driver.

Downloads links and more information can be found here.

edited Jul 13 '18 at 13:14

Gord Thompson

116,920
32
215
418

answered Mar 19 '10 at 08:58

kevchadders

8,335
4
42
61

saugata · Answer 2 · 2018-07-13T12:31:10.573

6

You can use jtds jar, you will also need to add the dll/so to you java library path.

EDIT: More recent release

edited Jul 13 '18 at 12:31

answered Mar 19 '10 at 08:59

saugata

2,823
1
27
39

1

There are more recent versions on github: https://github.com/milesibastos/jTDS/releases – Bernhard Döbler Jul 04 '18 at 15:38
1

@Abhishek - [Microsoft's JDBC driver for SQL Server](https://github.com/Microsoft/mssql-jdbc) is now open source as well (MIT license). – Gord Thompson Jul 13 '18 at 13:19

score 4 · Answer 3 · answered Mar 19 '10 at 09:02

The Microsoft SQL Server JDBC Driver version 2.0 provides sqljdbc.jar and sqljdbc4.jar class library files to be used depending on your preferred Java Runtime Environment (JRE) settings.

sqljdbc4.jar class library requires a Java Runtime Environment (JRE) of version 6.0 or later.

score 3 · Answer 4 · answered Nov 15 '18 at 20:05

Microsoft started publishing their Driver JARs to the central Maven repo in 2017. See Maven Search for the available versions.

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>7.0.0.jre10</version>
</dependency>

score 0 · Answer 5 · answered Mar 19 '10 at 08:58

0

http://www.microsoft.com/downloads/details.aspx?FamilyID=99B21B65-E98F-4A61-B811-19912601FDC9&displaylang=en

MS JDBC Driver. Has documentation.

answered Mar 19 '10 at 08:58

TomTom

61,059
10
88
148

That version of the JDBC driver is very old (released over 9 years ago). Look [here](https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server) for more current information. – Gord Thompson Jul 13 '18 at 13:21
You make it sounds like giving a current answer more than 8 years ago (!) was bad. – TomTom Jul 13 '18 at 13:37
1

No, I was just giving future readers a heads-up that the link (which still works) takes them to a download page for an old version of the driver. A surprising number of mssql-jdbc questions are asked by people who are using an ancient version of the JDBC driver and don't even know it. – Gord Thompson Jul 13 '18 at 13:50

Which jar to use for connecting to MS SQL server

5 Answers5