What's the driver class name for SQL Server JDBC

Question

I want to connect my Java SpringBoot app to SQL Server and I get the information that spring cannot load driver class. I tried:

spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver

and

spring.datasource.driver-class-name=com.microsoft.jdbc.sqlserver.SQLServerDriver

But both did not work, here is my maven dependency

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>7.0.0.jre8</version>
    <scope>test</scope>
</dependency>

You can open up the `jar` file using a zip utility and see – Scary Wombat Oct 09 '18 at 07:49 — Scary Wombat, Oct 09 '18 at 07:49

score 20 · Accepted Answer · edited Oct 09 '18 at 07:52

20

According to this web page, the correct property is spring.datasource.driverClassName.

So, the full connection string should be:

spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

edited Oct 09 '18 at 07:52

Tim Biegeleisen

451,927
24
239
318

answered Oct 09 '18 at 07:51

Shepard62FR

240
2
10

What's the driver class name for SQL Server JDBC

1 Answers1

Linked