Setting up maven dependency for SQL Server

sql-server hibernate maven
mico picture mico · Aug 4, 2011 · Viewed 145.7k times · Source

I am developing a portlet where I have Hibernate access to SQL Server database. I set up maven dependencies for it and try to find out SQL Server connector on the same way I know MySql has it.

Still my Google-search gives only Mysql if I search for SQL Server connector. What is the right maven dependency value?

Answer

Stu.C picture Stu.C · Aug 8, 2011

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

Then add it to your project with;

<dependency>
  <groupId>com.microsoft.sqlserver</groupId>
  <artifactId>sqljdbc4</artifactId>
  <version>4.0</version>
</dependency>

Related questions

JPA - How to set string column to varchar(max) in DDL

With JPA, DDL-generation for the attribute: @Column final String someString; will be someString varchar(255) null @Column(length = 1337) final String someString; will yield someString varchar(1337) null. But how can I get it to produce someString varchar(max) null? Is it possible …

Read More
How to map an entity field whose name is a reserved word in JPA

@Column(name="open") Using sqlserver dialect with hibernate. [SchemaUpdate] Unsuccessful: create table auth_session (id numeric(19,0) identity not null, active tinyint null, creation_date datetime not null, last_modified datetime not null, maxidle int null, maxlive int null, open tinyint …

Read More
Java Hibernate with SQL Server 2012 not working?

I have a Java Hibernate project configuration which worked with SQL Server 2008 R2, now with a new OS 8.1 (from 7) and SQL Server 2012 (express), I'm unable to connect to SQL server. Relevant configuration which is/should be syntactically correct since it …

Read More