ClassNotFoundException for "com.microsoft.sqlserver.jdbc.SQLServerDriver"

Question

This is a repeated question but I did everything right as mentioned. I have added following maven repo dependency to pom.xml of my project:

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

And this is my java code running on 1.8.0_144:

    package com.demo;

    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.Statement;

    public class Test {
    Connection con;
    Statement st;
    PreparedStatement ps;

     Test(){
          try {
                            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            con =       DriverManager.getConnection("jdbc:sqlserver://localhost:1521;user=SYSTEM;password=oracle;sid=xe");
            if(con != null) {
                System.out.println("Connected to MSsql !!");
            }

            //st = con.createStatement();


        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

    public static void main(String[] args) {

        new Test();
        System.out.println(System.getProperty("java.version"));
    }
}

Dmitriy Popov · Accepted Answer · 2019-06-21 16:11:12Z

2

Most probably test scope is not appropriate, if you're running your code not as a maven test.

Try to change the scope to <scope>compile</scope>.

If it does not help, please post or submit the whole project, so the case would be reproducible.

You can read about the scopes here http://maven.apache.org/guides/introduction/introduction-to-dependency-mechanism.html#Dependency_Scope.

answered Jun 21, 2019 at 16:11

Dmitriy Popov

2,3703 gold badges29 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dexter Over a year ago

That gave me a different error, so thats solved. Thank you.

Mark Rotteveel Over a year ago

@Dexter Your JDBC URL contains reference to Oracle things. You may want to check the Microsoft SQL Server JDBC documentation for the correct URL format.

Collectives™ on Stack Overflow

ClassNotFoundException for "com.microsoft.sqlserver.jdbc.SQLServerDriver"

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related