topic Re: Adding jar to Talend component in Installing and Upgrading

Adding jar to Talend component

m_shiva2003 — Fri, 15 Nov 2024 21:00:59 GMT

Can someone please help me how to add a jar to talend component ? example i need to add jaxb-api-2.3.1.jar to tMSSqlInput component. I don't want to use tLibraryLoad component to load the jar in the job.

Re: Adding jar to Talend component

Shicong_Hong — Tue, 02 Apr 2024 02:01:28 GMT

Hello

You can install or replace the jar from Modules view.

Please try and let me know if you have any other questions/issues.

Regards

Shicong

Re: Adding jar to Talend component

m_shiva2003 — Tue, 02 Apr 2024 02:35:12 GMT

Thanks Shicong. Unfortunately this feature is only replacing the jar. I wan to add a jar. Have you added jar and do you see the installed jars under that component or component showing the new jar added ?

Re: Adding jar to Talend component

Shicong_Hong — Tue, 02 Apr 2024 10:14:23 GMT

Can you clarify why you need to add the jaxb-api-2.3.1.jar to tMSSqlInput component? I checked the Modules view, tMSSqlInput doesn't required this jar to work.

Instead of using tLibraryLoad to load the external jar to the job, you can also do it through Setup codes dependencies.

Regards

Shicong

Re: Adding jar to Talend component

m_shiva2003 — Tue, 02 Apr 2024 12:03:26 GMT

Shicong, jaxb-api-2.3.1.jar and jaxb-runtime-2.3.4.jar files are required for SQL Server 2019 (AOL / Always-On) connectivity with Java 11 and above. Currently these jars are not included in MSSql* components.

Re: Adding jar to Talend component

m_shiva2003 — Tue, 02 Apr 2024 14:49:40 GMT

jaxb-api-2.3.1.jar and jaxb-runtime-2.3.4.jar required for MS jdbc drivers to connect to SQL Server 2019

Re: Adding jar to Talend component

Shicong_Hong — Wed, 03 Apr 2024 05:46:10 GMT

Hello @m_shiva2003 , Thanks for your clarification, this sounds like a development issue. However, I am not a component developer. If you are a Java developer and are interesting in learning how to define the required jar files, take a look at the below section of the tMSSqlInput_java.xml file, the source files of component are located in <studio installation directory>\workspace\plugins\org.talend.designer.components.localprovider_8.0.1.20211104_0248\components\tMSSqlInput folder.