The TDS protocol does not support JDBC datatype 2003.

One Star

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?
One Star

Re: The TDS protocol does not support JDBC datatype 2003.

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.

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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog