SqlServer驱动包 Maven

SqlServer驱动包即 sqljdbc4-4.0.jar  我们在maven的pom文件中直接加入依赖是不行的。需要

下面几个步骤：

      1.下载适合自己操作系统的JDBC Driver 网站为

          https://msdn.microsoft.com/en-us/sqlserver/aa937724   然后解压。我们可以在解压的包中找到那个jar

      2.启动一个命令行然后cd到刚才我们解压的目录下，然后执行下面的命令。即将下载的包安装到我们的私服本地仓库。

mvn  install : install - file -Dfile=sqljdbc4.jar -Dpackaging=jar -DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=4.0

     

    执行成功后的界面是

6

[INFO] Scanning  for projects...

[INFO]

[INFO] ------------------------------------------------------------------------

[INFO] Building Maven Stub Project (No POM) 1

[INFO] ------------------------------------------------------------------------

[INFO]

[INFO] --- maven- install -plugin:2.3.1: install - file (default-cli) @ standalone-pom ---

[INFO] Installing  /Users/claude/installers/JDBC/sqljdbc_4 .0 /enu/sqljdbc4 .jar to /Users/claude/ .m2 /repository/com/microsoft/sqlserver/sqljdbc4/4 .0 /sqljdbc4-4 .0.jar

[INFO] Installing /var/folders/c6/q1bdtq557kv54783p1g6cbsw0000gp/T/mvninstall1874482299687761721 .pom to  /Users/claude/ .m2 /repository/com/microsoft/sqlserver/sqljdbc4/4 .0 /sqljdbc4-4 .0.pom

[INFO] ------------------------------------------------------------------------

[INFO] BUILD SUCCESS

[INFO] ------------------------------------------------------------------------

[INFO] Total  time : 1.208s

[INFO] Finished at: Tue Mar 13 14:07:31 EDT 2012

[INFO] Final Memory: 3M /81M

[INFO] ------------------------------------------------------------------------

   3.在Maven的pom文件中加入相关的依赖

< dependency >

     < groupId >com.microsoft.sqlserver</ groupId >

     < artifactId >sqljdbc4</ artifactId >

     < version >4.0</ version >

</ dependency >