Results 1 to 4 of 4

Thread: Acquiring blob data

  1. #1

    Question Acquiring blob data

    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.

  2. #2
    Lavastorm Employee
    Join Date
    Aug 2009
    Location
    Cologne
    Posts
    513

    Default

    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. #3

    Default

    Hi Tim,

    I am going to try and reply here.

    Thank you,

    Özgün

  4. #4

    Default

    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?

    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
    "Geçersiz sütun türü" means "Invalid column type"

    Thank you, Regards,

    Özgün

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •