topic Re: Passing byte[] data into tMSSqlSP binary datatype in Talend Studio https://community.qlik.com/t5/Talend-Studio/Passing-byte-data-into-tMSSqlSP-binary-datatype/m-p/2364471#M128212 Message contents: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MGnG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134438iE701979C7EFE5F2F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MGnG.png" alt="0683p000009MGnG.png" /></span> <BR /> <BR />This is how listener is looks like: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHFy.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130024i1423BAA4981BE420/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MHFy.png" alt="0683p000009MHFy.png" /></span> <BR /> <BR />Message got from ActiveMQ in "Raw mode", all properties are String <BR />Parsed in Java into String fields ans byte[] <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHG3.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143217iBECF29884DBB58CA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MHG3.png" alt="0683p000009MHG3.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MGva.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156270i4F6CF1B8298DBC10/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MGva.png" alt="0683p000009MGva.png" /></span> <BR /> <BR />Then passed as 2 parameters in tMSSqlSP: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MGvV.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154900i15BA6F8878B7DFC0/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MGvV.png" alt="0683p000009MGvV.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHBh.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132618i6943388164C91E65/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MHBh.png" alt="0683p000009MHBh.png" /></span> <BR /> <BR />tLogRow output before SP call: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MH5z.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134973iDE035302037B06CC/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MH5z.png" alt="0683p000009MH5z.png" /></span> <BR /> <BR />Procedure interface: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHG8.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/142483i389BE2A377ACBBE2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MHG8.png" alt="0683p000009MHG8.png" /></span> <BR /> <BR />Data database side: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHGD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129827i1EACD02DF1436412/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MHGD.png" alt="0683p000009MHGD.png" /></span> Fri, 22 Apr 2016 08:51:32 GMT Anonymous 2016-04-22T08:51:32Z Passing byte[] data into tMSSqlSP binary datatype https://community.qlik.com/t5/Talend-Studio/Passing-byte-data-into-tMSSqlSP-binary-datatype/m-p/2364469#M128210 <P>Need to call SQL Server stored procedure with binary(10) datatype from Talend tMSSqlSP.<BR />initial string(22) 0x00000709000000D00001 being converted in tJavaRow using .getBytes() method to byte[] length 10 field<BR />but after SP call treated on database side as&nbsp;0x30783030303030373039<BR />Any ideas what am i doing wrong?</P> Sat, 16 Nov 2024 10:40:54 GMT https://community.qlik.com/t5/Talend-Studio/Passing-byte-data-into-tMSSqlSP-binary-datatype/m-p/2364469#M128210 Anonymous 2024-11-16T10:40:54Z Re: Passing byte[] data into tMSSqlSP binary datatype https://community.qlik.com/t5/Talend-Studio/Passing-byte-data-into-tMSSqlSP-binary-datatype/m-p/2364470#M128211 Hi&nbsp; <BR />How do you pass the byte[] to the tMSSQLSP? Can you please upload a screenshot of job? <BR />Best regards <BR />Shong Fri, 22 Apr 2016 06:55:01 GMT https://community.qlik.com/t5/Talend-Studio/Passing-byte-data-into-tMSSqlSP-binary-datatype/m-p/2364470#M128211 Anonymous 2016-04-22T06:55:01Z Re: Passing byte[] data into tMSSqlSP binary datatype https://community.qlik.com/t5/Talend-Studio/Passing-byte-data-into-tMSSqlSP-binary-datatype/m-p/2364471#M128212 Message contents: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MGnG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134438iE701979C7EFE5F2F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MGnG.png" alt="0683p000009MGnG.png" /></span> <BR /> <BR />This is how listener is looks like: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHFy.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130024i1423BAA4981BE420/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MHFy.png" alt="0683p000009MHFy.png" /></span> <BR /> <BR />Message got from ActiveMQ in "Raw mode", all properties are String <BR />Parsed in Java into String fields ans byte[] <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHG3.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143217iBECF29884DBB58CA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MHG3.png" alt="0683p000009MHG3.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MGva.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156270i4F6CF1B8298DBC10/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MGva.png" alt="0683p000009MGva.png" /></span> <BR /> <BR />Then passed as 2 parameters in tMSSqlSP: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MGvV.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154900i15BA6F8878B7DFC0/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MGvV.png" alt="0683p000009MGvV.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHBh.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132618i6943388164C91E65/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MHBh.png" alt="0683p000009MHBh.png" /></span> <BR /> <BR />tLogRow output before SP call: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MH5z.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134973iDE035302037B06CC/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MH5z.png" alt="0683p000009MH5z.png" /></span> <BR /> <BR />Procedure interface: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHG8.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/142483i389BE2A377ACBBE2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MHG8.png" alt="0683p000009MHG8.png" /></span> <BR /> <BR />Data database side: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHGD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129827i1EACD02DF1436412/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MHGD.png" alt="0683p000009MHGD.png" /></span> Fri, 22 Apr 2016 08:51:32 GMT https://community.qlik.com/t5/Talend-Studio/Passing-byte-data-into-tMSSqlSP-binary-datatype/m-p/2364471#M128212 Anonymous 2016-04-22T08:51:32Z