Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to convert between java.io.FileInputStream and JAVA_OBJECT

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 :

0683p000009M36t.jpg

 

And I configure my tFileInputRaw as this :

0683p000009M2wC.jpg

 

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

Labels (4)
4 Replies
manodwhb
Champion II
Champion II

@bouga74 ,can you show me the tmap screenshot?

Anonymous
Not applicable
Author

Thank you for your answer,

 

Here is my tMap :

0683p000009M37D.jpg

 

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

Anonymous
Not applicable
Author

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