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 Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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: 
_AnonymousUser
Specialist III
Specialist III
‎2010-11-16 01:38 PM

The TDS protocol does not support JDBC datatype 2003.

Hi,
i'm used talend open studio 4.1.1 r50363 and created one job with one tMSSqlInput, one tMap and one tMSSqlOutput. Running the job got the following error "The TDS protocol does not support JDBC datatype 2003.". Any ideas?
Labels (3)
Labels
213 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2011-01-20 11:01 PM

I found this too and I believe it is a bug in how TOS is setting byte[] columns -- if the column value is NULL, tMSSQLOutput uses prepared_statement.setNull(1, java.sql.Types.ARRAY). The ARRAY type is the JDBC datatype 2003 that is not supported.
Instead, TOS should do prepared_statement.setBytes(1, null) or possibly prepared_statement.setNull(1, java.sql.Types.VARBINARY).
I submitted a description and fix -- http://www.talendforge.org/bugs/view.php?id=18413 -- you may find it helpful to patch your db_output_bulk.skeleton as I did. To find the b_output_bulk.skeleton file to patch, go to <install dir>\plugins\org.talend.designer.components.localprovider_4.1.1.r50363\components\templates.
213 Views
0 Likes