did not find registered driver with class name java.sql.Driver

[Anonymous]

I am using talend big data platform in that I have created a talend big data spark batch job. In that I have placed tHdfsconfiguration tjdbcconfiguration and tjdbcinput in job.
My goal is to read from MSSQL to HDFS.

But while running job , I'm getting error like below-

Did not find registered driver with class name java.sql.Driver

I have added jar from local to tjdbcconfiguration from Select Module.

Is there any configuration which I'm missing.?

[Anonymous]

Download Microsoft JDBC Driver for SQL Server (jar file) from https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc/6.2.2.jre8

In your Talend Job in tPrejob flow add a tLibraryLoad component and browse and select downloaded Jar.

[Anonymous]

I have already included mssql-jdbc-6.00.jar in tjdbcconfiguration and selected same in Select Module of tjdbcconfiguration.
And I also tried importing this jar using tLibraryLoad and it says selected module already installed.
So it means mssql-jdbc-6.00.jar already exists.
I have tried connecting to spark-shell --jars mssql-jdbc-600.jar

It's working well in spark shell. Looks like this jar is not available to worker node when running through Talend Big data.

[Anonymous · Accepted solution]

Issue was fixed by supplying jars through option of spark.yarn.jars and placing them on globe like hdfs.

Thanks all for support