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

Highlighted
Five Stars

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

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!!

Five Stars

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

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.

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog