topic Re: Unable to convert between java.io.FileInputStream and JAVA_OBJECT in Talend Studio

Unable to convert between java.io.FileInputStream and JAVA_OBJECT

Anonymous — Thu, 14 Feb 2019 10:25:28 GMT

Hi,

I have a MS SQL table with a [varbinary](max) FILESTREAM NOT NULL.

I would like to put the content of a local file in it, but I can't find a way to insert it correctly.

I tried :

And I configure my tFileInputRaw as this :

And my java var is an object.

But I have the following error :

[FATAL]: refcant_nom_tlnd.test_store_0_1.Test_Store - tDBOutput_1 Unable to convert between java.io.FileInputStream and JAVA_OBJECT

java.sql.SQLException: Unable to convert between java.io.FileInputStream and JAVA_OBJECT

at net.sourceforge.jtds.jdbc.Support.convert(Support.java:632)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setObjectBase(JtdsPreparedStatement.java:590)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setObject(JtdsPreparedStatement.java:907)

Is there a way to do that ?

Thanks a lot for every tips

Re: Unable to convert between java.io.FileInputStream and JAVA_OBJECT

manodwhb — Thu, 14 Feb 2019 11:05:59 GMT

@bouga74 ,can you show me the tmap screenshot?

Re: Unable to convert between java.io.FileInputStream and JAVA_OBJECT

akumar2301 — Thu, 14 Feb 2019 12:55:06 GMT

https://community.talend.com/t5/Design-and-Development/resolved-File-into-BLOB/td-p/67476

Re: Unable to convert between java.io.FileInputStream and JAVA_OBJECT

Anonymous — Thu, 14 Feb 2019 13:17:16 GMT

Thank you for your answer,

Here is my tMap :

@uganesh , I already find this article but I would like to do it without writing java code

Re: Unable to convert between java.io.FileInputStream and JAVA_OBJECT

Anonymous — Thu, 14 Feb 2019 14:43:16 GMT

I have the beginning of a solution.

It seems it's better when I use the Microsoft JDBC driver, and no the JTDS.

But I still have nothing in my field, which is surprising because it's OK in another table...

So it may be a ms sql configuration issue I think