Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@bouga74 ,can you show me the tmap screenshot?
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
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