Missing artifact com microsoft sqlserver sqljdbc4 jar 4 0

Question

I am trying to add MS SQL driver dependency in my POM xml file and the following is the dependency    lt dependency gt       lt groupId gt com microsoft sqlserver lt  groupId gt       lt artifactId gt sqljdbc4 lt  artifactId gt       lt version gt 4 0 lt  version gt   lt  dependency gt    but I get this exception     Missing artifact com microsoft sqlserver sqljdbc4 jar 4 0   I really don t understand the issue

User · Answer

The above answer only adds the sqljdbc4 jar to the local repository  As a result  when creating the final project jar for distribution   sqljdbc4 will again be missing as was indicated in the comment by  Tony regarding runtime error    Microsoft  and Oracle and other third party providers  restrict the distribution of their software as per the ENU EULA  Therefore those software modules do not get added in Maven produced jars for distribution  There are hacks to get around it  such as providing the location of the 3rd party jar file at runtime   but as a developer you must be careful about violating the licensing    A better approach for jdbc connectors drivers is to use jTDS  which is compatible to most DBMS s  more reliable  faster  as per benchmarks   and distributed under GNU license  It will make your life much easier to use this than trying to pound the square peg into the round hole following any of the other techniques above

User · Answer

It is not too hard  I have not read the license yet   However I have proven this works   You can copy sqljdbc4 jar file to a network share or local directory   Your build gradle should look like this    apply plugin   java    apply plugin   maven    apply plugin   enhance   sourceCompatibility   1 8 version    1 0     library versions def hibernateVersion  4 3 10 Final  def microsoftSQLServerJDBCLibVersion  4 0  def springVersion  2 5 6   def log4jVersion  1 2 16  def jbossejbapiVersion  3 0 0 GA   repositories       mavenCentral       maven url  file   Sharedir releases      dependencies       testCompile group   junit   name   junit   version   4 11      compile  org hibernate hibernate-core  hibernateVersion      compile  com microsoft sqlserver sqljdbc4  microsoftSQLServerJDBCLibVersion     task showMeCache  lt  lt        configurations compile each   println it       under the sharedir releases directory  I have directory similar to maven structure which is  sharedir releases com microsoft sqlserver sqljdbc4 4 0 sqljdbc4-4 0 jar  good luck   David Yen

User · Answer

UPDATE  Microsoft now provide this artifact in maven central  See  nirmal s answer for further details  https   stackoverflow com a 41149866 1570834    ORIGINAL ANSWER  The issue is that Maven can t find this artifact in any of the configured maven repositories   Unfortunately Microsoft doesn t make this artifact available via any maven repository  You need to download the jar from the Microsoft website  and then manually install it into your local maven repository   You can do this with the following maven command   mvn install install-file -Dfile sqljdbc4 jar -DgroupId com microsoft sqlserver -DartifactId sqljdbc4 -Dversion 4 0 -Dpackaging jar   Then next time you run maven on your POM it will find the artifact

User · Answer

just add    lt dependency gt         lt groupId gt com microsoft sqlserver lt  groupId gt         lt artifactId gt sqljdbc4 lt  artifactId gt         lt version gt 4 0 lt  version gt         lt scope gt runtime lt  scope gt    lt  dependency gt

User · Answer

You can also create a project repository  It s useful if more developers are working on the same project  and the library must be included in the project   First  create a repository structure in your project s lib directory  and then copy the library into it  The library must have following name-format   lt artifactId gt - lt version gt  jar  lt your project dir gt  lib com microsoft sqlserver  lt artifactId gt   lt version gt    Create pom file next to the library file  and put following information into it    lt  xml version  1 0  encoding  UTF-8   gt    lt project xsi schemaLocation  http   maven apache org POM 4 0 0 http   maven apache org xsd maven-4 0 0 xsd  xmlns  http   maven apache org POM 4 0 0            xmlns xsi  http   www w3 org 2001 XMLSchema-instance  gt        lt modelVersion gt 4 2 0 lt  modelVersion gt        lt groupId gt com microsoft sqlserver lt  groupId gt        lt artifactId gt sqljdbc4 lt  artifactId gt        lt version gt 4 2 lt  version gt    lt  project gt     At this point  you should have this directory structure   lt your project dir gt  lib com microsoft sqlserver sqljdbc4 4 2 sqljdbc4-4 2 jar  lt your project dir gt  lib com microsoft sqlserver sqljdbc4 4 2 sqljdbc4-4 2 pom  Go to your project s pom file and add new repository    lt repositories gt        lt repository gt            lt id gt Project repository lt  id gt            lt url gt file     basedir  lib lt  url gt        lt  repository gt    lt  repositories gt     Finally  add a dependency on the library    lt dependencies gt        lt dependency gt            lt groupId gt com microsoft sqlserver lt  groupId gt            lt artifactId gt sqljdbc4 lt  artifactId gt            lt version gt 4 2 lt  version gt        lt  dependency gt    lt  dependencies gt      Update 2017-03-04 It seems like the library can be obtained from publicly available repository   see nirmal s and Jacek Grzelaczyk s answers for more details  Update 2020-11-04 Currently Maven has a convenient target install which allow you to deploy an existing package into a project   file repository without the need of creating POM files manually  It will generate those files for you  mvn install install-file       -Dfile sqljdbc4 jar       -DgroupId com microsoft sqlserver       -DartifactId sqljdbc4       -Dversion 4 2       -Dpackaging jar       -DlocalRepositoryPath   your project dir  lib

User · Answer

If you are having some issue when including dependency for 6 1 0 jre7 from  nirmals answer in https   stackoverflow com a 41149866 1570834  in your pom with commons-codec  azure-keyvault I prefer going with this        lt dependency gt          lt groupId gt com microsoft sqlserver lt  groupId gt          lt artifactId gt mssql-jdbc lt  artifactId gt          lt version gt 6 2 2 jre7 lt  version gt                       lt  dependency gt

User · Answer

For self-containing Maven project I usually installing all external jar dependencies into project s repository  For SQL Server JDBC driver you can do    download JDBC driver from https   www microsoft com en-us download confirmation aspx id 11774 create folder local-repo in your Maven project temporary copy sqljdbc42 jar into local-repo folder in local-repo folder run mvn deploy deploy-file -Dfile sqljdbc42 jar -DartifactId sqljdbc42 -DgroupId com microsoft sqlserver -DgeneratePom true -Dpackaging jar -Dversion 6 0 7507 100 -Durl file     to deploy JAR into local repository  stored together with your code in SCM  sqljdbc42 jar and downloaded files can be deleted modify your s pom xml and add reference to project s local repository  xml  lt repositories gt       lt repository gt           lt id gt parent-local-repository lt  id gt           lt name gt Parent Local repository lt  name gt           lt layout gt default lt  layout gt           lt url gt file     basedir  local-repo lt  url gt           lt releases gt               lt enabled gt true lt  enabled gt           lt  releases gt           lt snapshots gt               lt enabled gt true lt  enabled gt           lt  snapshots gt       lt  repository gt   lt  repositories gt   Now you can run your project everywhere without any additional configurations or installations

User · Answer

You can use another driver    lt dependency gt       lt groupId gt net sourceforge jtds lt  groupId gt       lt artifactId gt jtds lt  artifactId gt       lt version gt 1 3 1 lt  version gt   lt  dependency gt    and in xml   lt bean id  idNameDb  class  org springframework jdbc datasource DriverManagerDataSource  gt           lt property name  driverClassName  value  net sourceforge jtds jdbc Driver    gt           lt property name  url  value  jdbc jtds sqlserver    ip  1433 DatabaseName  name     gt           lt property name  username  value  user    gt           lt property name  password  value  password    gt   lt  bean gt

User · Answer

I had the similar problem and solved it by doing following     Download sqljdbc4 jar from the Microsoft website to your local machine  Right click on Project-- Import-- Maven-- Install or deploy an artifact to a Maven repository as shown below       Next-- Fill the following details Artifact file   path of the jar you downloaded  Ex  E  lib sqljdbc4 jar in my case    Group Id  com microsoft sqlserver Artifact Id  sqljdbc4 Version  4 0    Then Refresh clean the project  Thank you

User · Answer

Microsoft recently open sourced their jdbc driver   You can now find the driver on maven central    lt  -- https   mvnrepository com artifact com microsoft sqlserver mssql-jdbc -- gt   lt dependency gt       lt groupId gt com microsoft sqlserver lt  groupId gt       lt artifactId gt mssql-jdbc lt  artifactId gt       lt version gt 6 1 0 jre8 lt  version gt   lt  dependency gt    or for java 7    lt  -- https   mvnrepository com artifact com microsoft sqlserver mssql-jdbc -- gt   lt dependency gt       lt groupId gt com microsoft sqlserver lt  groupId gt       lt artifactId gt mssql-jdbc lt  artifactId gt       lt version gt 6 1 0 jre7 lt  version gt   lt  dependency gt

[sql-server] Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0

Examples related to sql-server

Examples related to spring

Examples related to maven

Examples related to pom.xml