Tomcat not able to find Microsoft SQL driver class

0
votes

Tomcat version - apache-tomcat-9.0.0.M19

I am trying to connect my spring application with microsoft sql database.

driverClassName=com.microsoft.sqlserver.jdbc.SQLserverDriver

Maven dependency - 

<dependency>
        <groupId>com.microsoft.sqlserver</groupId>
        <artifactId>mssql-jdbc</artifactId>
        <version>6.1.0.jre8</version>
    </dependency>

This jar is available in the generated war file and i have also placed the jar in the lib folder of the tomcat but i'm still getting the following error when i try to deploy my application on Tomcat -

Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLserverDriver' java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLserverDriver

What am i missing?

1
sql-servertomcat

1 Answers

0
votes

You have a typo in your config. The driver class is named com.microsoft.sqlserver.jdbc.SQLServerDriver, not com.microsoft.sqlserver.jdbc.SQLserverDriver.