Extract Blob from Oracle

[Anonymous]

Hello,
i work in an oracle database and i want to extract pictures of client. This pics was encoded in Blob field.
I try to export in tfiledelimited, but it doesn't work because i have 275 clients.
I would like to know how i can create 275 jpg files and if it's possible rename pic with the id_cli (primary key)

regards
Dams

[Anonymous]

The tLOBDownload component currently does not provide the access to the to stream directly. Normally LOBs are to large to process them directly in the job so I decided to save them to a file. For sure it would be possible to change this behaviour but this will take a bit time, I am heavy busy at the moment - sorry. 

[Anonymous]

That is not a problem. Thanks, jlolling. It is really a good component.

[Anonymous]

Hi jlolling,
I'm having below issue with the component :
Exception in component tLOBDownload_1
java.lang.Exception: Given object is not a Blob. It is of type:[B
at de.cimt.talendcomp.lob.download.LOBDownload.downloadLob(LOBDownload.java:136)

I'm using MySQL database with Talend Open Studio 6.1.1.
I crosschecked MySQL schema and column is a BLOB. I don't understand the issue.

Thanks for your feedback,
Mike

30MAR2016 # Solution found : issue come from that object returned is a byte array not a blob. I don't know why but I convert my byte array to a blob and it works.

[Anonymous]

Hi jlolling,
I'm having below issue with the component :
Exception in component tLOBDownload_1
java.lang.Exception: Given object is not a Blob. It is of type:[B
Please help.