Thursday, January 26, 2017

How to install the Sqljdbc4 for use Sql server with hibernate, spring, maven and eclipse

If we want to use sql server with a maven project that uses hibernate and spring we need the jdbc for sql server, but the maven has not integrate this jar, for this reason we have install it manually, for get it we can follow these steps.

First we must download the jar jdbc for sql server, we can download it from this link
https://mvnrepository.com/artifact/com.microsoft.sqlserver

In this example i have downloaded the Sqljdbc4 and i saved in the D:\jdbc\

Later Right click on the project, click on Run As ->Maven Build...

In the field goal you must put the code

 install:install-file -Dfile="D:\jdbc\sqljdbc4.jar" -DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=4.0 -Dpackaging=jar  


Click on Apply -> Click on Run

The next step is put in the pom.xml file the next code

 <!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/sqljdbc4 -->  
 <dependency>  
   <groupId>com.microsoft.sqlserver</groupId>  
   <artifactId>sqljdbc4</artifactId>  
   <version>4.0</version>  
 </dependency>  


With these steps you will have the jdbc for sql server ready in the maven project

No comments:

Post a Comment