Maven does not directly support some libraries, like Microsoft's SQL Server JDBC. This tutorial'll show you what to add a 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:
12345678910111213141516 |
[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:
12345 |
<
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.
http://claude.betancourt.us/add-microsoft-sql-jdbc-driver-to-maven/
From for notes (Wiz)
Java series: Add Microsoft SQL JDBC driver to Maven