Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: BLOB to file

  1. #1

    Default BLOB to file

    I found the sample
    General - Load images and store into database table.ktr
    and it works great,
    but I need the other way round.

    I found the way to write the file with a 'text file output'-step but there is alway a 'new line' at the end. That's OK for XML but not for binary data.

    So can anybody help me to extract BLOBs into files.
    I guess it must be in a Javascript-step like the sample but my Java is so pur...

    thanks in advance!

  2. #2


    It's an old link:

    hope it helps

    Stefano Bonnin
    Comai Torino Srl

  3. #3


    ooops sorry it's your example...

    sorry again

  4. #4
    Join Date
    Nov 1999


    Something like this:

    var tmpFile = new;  
    var file = new"/tmp/"/+tmpFile.getName());  
    var fileOutputStream = new;
    fileOutputStream.write(content.getBytes(), 0, content.getBytes().length);

  5. #5


    Cool! Sometimes things can be so easy!
    Thanks a lot!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.