Acquiring blob data

[Wizardous]

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?

[Tim Meagher]

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.

[Wizardous]

Hi Tim,

I am going to try and reply here.

Thank you,

Özgün

[Wizardous]

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?

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

"Geçersiz sütun türü" means "Invalid column type"

Thank you, Regards,

Özgün