ClassNotFoundException while attempting to connect SQL Server through rest API?

Question

I have a rest API service deployed which has a method where it attempts to connect to SQL Server. Locally before deployment, this all worked fine but now I get the error that the Sqljdbc file is missing. Below is the exception

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

Found many posts online here where suggestions to ensure library is in correct folder: src/main/webapp/WEB-INF/sqljdbc4.jar

WEB-INF/sqljdbc4.jar

I also added it to the folder /WEB-INF/lib/sqljdbc4.jar

Still I get the error. Any ideas or suggestions appreciated.

Does this sqljdbc4.jar contains mentioned class? Qualified name (package + class name) match is important. — Patryk Dobrowolski, Jul 16 '15 at 13:40
are you using compatible versions. the you are using is available in respected jar file. — SatyaTNV, Jul 16 '15 at 13:42
Have you checked that the driver is actually included in the deployment? — Mark Rotteveel, Jul 16 '15 at 13:45

score 0 · Answer 1 · answered Jul 16 '15 at 13:47

0

Have you checked if the system requirements of your server middleware are matching? Compare to this MS documentation: https://msdn.microsoft.com/en-us/library/ms378422%28v=sql.110%29.aspx

Do not forget to restart the server after adding the JAR.

answered Jul 16 '15 at 13:47

fhissen

347
2
7

So this is related to tomcat recognizing the driver and not the actual project? – vbNewbie Jul 16 '15 at 13:50
My guess is that it is either the wrong JRE version or the latter. Could there be a second sqljdbc*.jar in this tomcat installation? – fhissen Jul 16 '15 at 14:09

ClassNotFoundException while attempting to connect SQL Server through rest API?

1 Answers1