[resolved] Create file from a blob input (oracle db)

[Anonymous]

Hi,
I would like to create a picture (.jpg) from the blob data of an oracle table.
I have an oracle input that connects to the table "Photo" and retrieve the column "data" of type Blob.
How can I create the picture with this Blob data ?
I tried with a tMap and tJava, but the tMap will convert the blob into an "Object", so I don't know how I can work with this...
Thanks in advance for the help
Thomas

[Anonymous]

Hi ,
I am trying to retrieve text file from oracle database , trying to do it as shown above .
But there is a problem with the schema in tjavarow "cannot cast from byte to blob".
please help!
TIA
Hachi

[Anonymous]

Hi do you know if this Component is comptible with TOS DI 6.1?
I have an error message "Component not loaded"

[Anonymous]

The best way to download BLOBs is using the custom component tLOBDownload from Talend Exchange:
https://exchange.talend.com/#marketplaceproductoverview:gallery=marketplace%252F1&pi=marketplace%252...
This component is exactly made for this use case.

[Anonymous]

It Showing only the images names .The images are not downloading ..

I followed  Your Steps to download images from database. Please guide me how do this Talend job or Could You share your job.

Thank you..

Image_Extract.PNG

[Lr_Sudha]

Hi ,

I have used tBLOBDownload component to get BLOB (PDF File) from oracle database. It's downloaded the file but unable to open, getting below error;

Adobe Reader could not open … because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn’t correctly decoded). 

Any help is appreciated.

Thanks,

LRS

[trivikram]

hi sudheers,

were you able to find the solution for this problem, i have the same issue, can you send me screenshot or solution for it.

Thank you.