Passing byte[] data into tMSSqlSP binary datatype

[Anonymous]

Need to call SQL Server stored procedure with binary(10) datatype from Talend tMSSqlSP.
initial string(22) 0x00000709000000D00001 being converted in tJavaRow using .getBytes() method to byte[] length 10 field
but after SP call treated on database side as 0x30783030303030373039
Any ideas what am i doing wrong?

[Anonymous]

Hi 
How do you pass the byte[] to the tMSSQLSP? Can you please upload a screenshot of job?
Best regards
Shong

[Anonymous]

Message contents:


This is how listener is looks like:


Message got from ActiveMQ in "Raw mode", all properties are String
Parsed in Java into String fields ans byte[]


Then passed as 2 parameters in tMSSqlSP:


tLogRow output before SP call:


Procedure interface:


Data database side: