com.microsoft.sqlserver.jdbc.SQLServerDriver class not found exception (NEW)

Question

Now I am working with Microsoft SQLserver jdbc connectivity when I try to define class.forname

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

error occurs, everything else is fine, but I dint have any idea about this error.

pom.xml:

<dependency>
  <groupId>com.microsoft.sqlserver</groupId>
  <artifactId>sqljdbc4</artifactId>
  <version>4-2.0</version>
  <scope>system</scope>
  <systemPath>D:\my current work(please backup this folder)\backup\12-15-2016\milma_jishnu/src/main/lib/sqljdbc4-2.0.jar</systemPath>
</dependency>

did you check inside the .m2 folder if the jar is present or not? — SpringLearner
– SpringLearner, Commented Dec 31, 2016 at 6:18

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

Quoting Maven documentation:

System Dependencies

Important note: This is marked deprecated.

Dependencies with the scope system are always available and are not looked up in repository. They are usually used to tell Maven about dependencies which are provided by the JDK or the VM. Thus, system dependencies are especially useful for resolving dependencies on artifacts which are now provided by the JDK, but where available as separate downloads earlier. Typical example are the JDBC standard extensions or the Java Authentication and Authorization Service (JAAS).

So, <scope>system</scope> tells Maven: This is already present, you don't need to do anything.

Ergo, it is not added to the classpath, and you wonder why it's not there?

Seems you misunderstood the purpose of <scope>system</scope>. Don't use it, because the MS SQL JDBC driver is not part of the JDK.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Dec 31, 2016 at 6:30

Andreas

160k13 gold badges164 silver badges262 bronze badges

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

1 Comment

Andreas Over a year ago

Use the compile or runtime scopes.

Collectives™ on Stack Overflow

com.microsoft.sqlserver.jdbc.SQLServerDriver class not found exception (NEW)

1 Answer 1

System Dependencies

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

System Dependencies

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related