LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Acquiring blob data

    Employee
    Posted 08-25-2014 04:38

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: 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?


  • 2.  RE: Acquiring blob data

    Employee
    Posted 09-03-2014 05:38

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: 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.


  • 3.  RE: Acquiring blob data

    Employee
    Posted 09-04-2014 01:20

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Wizardous

    Hi Tim,

    I am going to try and reply here.

    Thank you,

    �zg�n


  • 4.  RE: Acquiring blob data

    Employee
    Posted 10-14-2014 05:13

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: 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