topic did not find registered driver with class name java.sql.Driver in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 04:44:40 GMT

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.?

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

Anonymous — Sat, 07 Sep 2019 11:04:21 GMT

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.

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

Anonymous — Sat, 07 Sep 2019 12:20:55 GMT

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.

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

Anonymous — Fri, 13 Sep 2019 13:38:30 GMT

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

Thanks all for support