Setting up maven dependency for SQL Server

Question

I am developing a portlet where I have Hibernate access to SQL Server database  I set up maven dependencies for it and try to find out SQL Server connector on the same way I know MySql has it   Still my Google-search gives only Mysql if I search for SQL Server connector  What is the right maven dependency value

User · Answer

Even after installing the sqlserver jar  my maven was trying to fetch the dependecy from maven repository  I then  provided my pom the repository of my local machine and it works fine after that   might be of help for someone        lt repository gt           lt id gt local lt  id gt           lt name gt local lt  name gt           lt url gt file   C  Users mywindows  m2 repository lt  url gt       lt  repository gt

User · Answer

Download the driver JAR from the link provided by Olaf and add it to your local Maven repository with   mvn install install-file -Dfile sqljdbc4 jar -DgroupId com microsoft sqlserver -DartifactId sqljdbc4 -Dversion 4 0 -Dpackaging jar  Then add it to your project with    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

User · Answer

I believe you are looking for the Microsoft SQL Server JDBC driver  http   msdn microsoft com en-us sqlserver aa937724

User · Answer

It looks like Microsoft has published some their drivers to maven central    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

User · Answer

Be careful with the answers above  sqljdbc4 jar is not distributed with under a public license which is why it is difficult to include it in a jar for runtime and distribution  See my answer below for more details and a much better solution  Your life will become much easier as mine did once I found this answer   https   stackoverflow com a 30111956 3368958

User · Answer

lt dependency gt     lt groupId gt com hynnet lt  groupId gt     lt artifactId gt sqljdbc4-chs lt  artifactId gt     lt version gt 4 0 2206 100 lt  version gt   lt  dependency gt    This worked for me if you use maven   https   search maven org artifact com hynnet sqljdbc4-chs 4 0 2206 100 jar

User · Answer

There is also an alternative  you could use the open-source jTDS driver for MS-SQL Server  which is compatible although not made by Microsoft  For that driver  there is a maven artifact that you can use   http   jtds sourceforge net   From http   mvnrepository com artifact net sourceforge jtds jtds     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    UPDATE nov 2016  Microsoft now published its MSSQL JDBC driver on github and it s also available on maven now    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

User · Answer

Answer for the  new  and  cool  Microsoft   Yay  SQL Server driver now under MIT license on   GitHub  https   github com Microsoft mssql-jdbc Maven Central  http   search maven org  search 7Cga 7C1 7Cmssql-jdbc    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    Answer for the  old  Microsoft   For my use-case  integration testing  it was sufficient to use a system scope for the JDBC driver s dependency as such    lt dependency gt       lt groupId gt com microsoft sqlserver lt  groupId gt       lt artifactId gt sqljdbc4 lt  artifactId gt       lt version gt 3 0 lt  version gt       lt scope gt system lt  scope gt       lt systemPath gt   basedir  lib sqljdbc4 jar lt  systemPath gt       lt optional gt true lt  optional gt   lt  dependency gt    That way  I could put the JDBC driver into local version control  No need to have each developer manually set stuff up in their own repositories   I took inspiration from this answer to another Stack Overflow question and I ve also blogged about it here

[sql-server] Setting up maven dependency for SQL Server

Examples related to sql-server

Examples related to hibernate

Examples related to maven