topic Getting compile error for the tDBInput (MS SQL SERVER), however working for other db input types in Talend Studio

Getting compile error for the tDBInput (MS SQL SERVER), however working for other db input types

Anonymous — Sat, 16 Nov 2024 03:49:18 GMT

My flow goes as tDBInput (MS SQL Server >> tjavarow >> tdbOutput (MS SQL SERVER)

however when I am trying to run this, it is throwing an error as

org.talend.designer.runprocess.ProcessorException: Job compile errors
At least job "JOB_SAHL_DB_DB" has a compile errors, please fix and export again.
Error Line: 2258
Detail Message: net.sourceforge.jtds.jdbc.TalendNTextImpl cannot be resolved to a type

however this error goes if I change the scheme of tDBInput from dynamic to specific column list.

Does any one have an idea of what could be the issue?

Thanks in advance!!

Re: Getting compile error for the tDBInput (MS SQL SERVER), however working for other db input types

Anonymous — Mon, 16 Dec 2019 13:33:06 GMT

Resolved this issue.
After researching, understood that it is because of the JTDS driver, I was using jtds-1.3.1 without patch. When I replaced the JDTS driver with the recent one i.e. with patch jtds-1.3.1-patch-20190523 it worked.

Re: Getting compile error for the tDBInput (MS SQL SERVER), however working for other db input types

talendenterprise — Wed, 05 Jan 2022 15:26:51 GMT

Hi,,

I am laready having the jtds jar as jtds-1.3.1-patch-20190523 but still getting the issue. any help?