from:http://claude.betancourt.us/add-microsoft-sql-jdbc-driver-to-maven/
Add Microsoft SQL JDBC driver to Maven
Maven does not directly support some libraries, like Microsoft’s SQL Server JDBC. This tutorial will show you how to add an external dependency to your local Maven repository. It assumes you have already installed Maven.
Download the JDBC driver for Microsoft SQL Server
- Visit the MSDN site for SQL Server and download the latest version of the JDBC driver for your operating system.
- Unzip the package
- Open a command prompt and switch into the expanded directory where the
jar
file is located. - Execute the following command. Be sure to modify the
jar
file name and version as necessary:
1
|
mvn install : install - file -Dfile=sqljdbc4.jar -Dpackaging=jar -DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=4.0 |
- You should see something similar to this:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
[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] ------------------------------------------------------------------------ |
Modify your POM
Include the new dependency by modifying your project’s pom.xml
. Add the following dependency:
1
2
3
4
5
|
< dependency > < groupId >com.microsoft.sqlserver</ groupId > < artifactId >sqljdbc4</ artifactId > < version >4.0</ version > </ dependency > |
Save the pom.xml
file and build the project to make sure no errors exist.
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步