Hi,
Is there a way to take blob type data from an oracle database to a lavastorm graph as text (string) ?
Regards,
Özgün
edit: Solved this issue with a java node. Is there any other solution?
Hi,
Is there a way to take blob type data from an oracle database to a lavastorm graph as text (string) ?
Regards,
Özgün
edit: Solved this issue with a java node. Is there any other solution?
Last edited by Wizardous; 08-27-2014 at 07:40 AM.
Hi,
Have you tried using the JDBC Query node? I believe (haven't really tried it, someone can correct me if I'm wrong) that this should handle the oracle blob data.
Pretty sure that the DB Query nodes, however do not currently support binary (blob, clob etc) data types.
Regards,
Tim.
Hi Tim,
I am going to try and reply here.
Thank you,
Özgün
Hi Tim,
I just have chance to try JDBC query node to pull blob data. And we get the error below. Do you think it is driver related error?
"Geçersiz sütun türü" means "Invalid column type"Code:Exited with non zero status 2014-10-14 15:09:32.000; ERROR: error on row 0. java.sql.SQLException: Geçersiz sütun türü: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor id: 0 chain: 0 group: 0 cppDetail: context: nodeMain QueryDump.java@172 2014-10-14 15:09:32.000; ERROR: Exited with non zero status id: 0 chain: 0 group: 0 cppDetail: context: Salmon::NED::NodeMain::errorMsg() .\NodeMain.cpp@28
Thank you, Regards,
Özgün