Unable to convert between java.io.FileInputStream and JAVA_OBJECT

[Anonymous]

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

[manodwhb]

@bouga74 ,can you show me the tmap screenshot?

[akumar2301]

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

[Anonymous]

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

[Anonymous]

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