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?
1 REPLY
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.