Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-12-16 06:50 AM

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

Labels (4)
Labels
1 user say ditto
503 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2019-12-16 08:33 AM
Author

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.
490 Views
0 Likes
talendenterprise
Contributor
Contributor
‎2022-01-05 10:26 AM

Hi,,

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

490 Views
0 Likes