topic Re: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver in Talend Studio

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

sunny3 — Sat, 16 Nov 2024 05:06:57 GMT

Hi,

i am running a job and it has some mssql components.

i am getting the below error:

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)

could you please tell me what might be the reason for it

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

sarora1 — Tue, 30 Jul 2019 14:38:39 GMT

Looks like you are missing some jars. Is Talend not prompting you for which dll it wants?

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

sunny3 — Tue, 30 Jul 2019 14:50:59 GMT

no it did not prompt for insatlling any jar,

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

sarora1 — Wed, 31 Jul 2019 14:10:51 GMT

Check in your Java if you have dlls for sql server. I have sqljdbc_auth.dll since I am using integratedSecurity=true;

For me its in C:/Java/jre8x64/bin/sqljdbc_auth.dll - YMMV

And, if you add new dlls you need to restart studio.