Is it like to specify the tLibraryLoad with sqoop component everytime?

One Star

Is it like to specify the tLibraryLoad with sqoop component everytime?

Hi,
I am using tSqoopImport/tSqoopExport component. In my use case I am using SQL Server as the source/target connection. For both the components I need to specify the JDBC connection string. To tun the job successfully I need to mention the JDBC JAR file using tLibraryLoad.
If I copy the same JAR file in lib directory of Talend workspace and do not use tLibrary Component, then the component is not able to find the JAR and throws the error for the same. Ideally if JAR is present in lib directory then it should pick the JAR from there. But it doesn't seems like that and everytime I need to specify tLibraryLoad.
Is it like to specify the tLibraryLoad with tSqoopImport/tSqoopExport component everytime?
Five Stars

Re: Is it like to specify the tLibraryLoad with sqoop component everytime?

Just a thought...
Did you try closing and reopening the project after adding the jar file to the lib directory. 
One Star

Re: Is it like to specify the tLibraryLoad with sqoop component everytime?

Thanks Nikhil for reply.
I tried with your mentioned approach, but it is giving me same exception as below:
Exception in component tSqoopExport_1
java.lang.RuntimeException: Could not load db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:797)
at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
at org.apache.sqoop.manager.CatalogQueryManager.getColumnNames(CatalogQueryManager.java:148)
at org.apache.sqoop.manager.ConnManager.configureDbOutputColumns(ConnManager.java:672)
at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:96)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at demo.output_table_copy_0_1.output_table_Copy.tSqoopExport_1Process(output_table_Copy.java:363)
at demo.output_table_copy_0_1.output_table_Copy.runJobInTOS(output_table_Copy.java:631)
at demo.output_table_copy_0_1.output_table_Copy.main(output_table_Copy.java:490)

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now