using sqlserver jdbc driver with maven

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=3.0 -Dpackaging=jar

Then add it to your project with;

<dependency> 

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

     <artifactId>sqljdbc4</artifactId> 

     <version>3.0</version> 

</dependency>