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]

I am working on a tLOBDownload component. This component will accept a record set made by the tOracleRow component. In the tLOBDownload component you have to configure the columns you need for download the BLOB/CLOB and identify the LOBs (e.g. key fields or file names in the database).
You have to define the file name for the LOBs by the help of these fields.
The component iterates through the record set (actually a Java ResultSet) and writes all LOBs into files (one LOB has its own file).
Does this solution would fit also to your needs?

[Anonymous]

hello,
thanks for your answer. That's exacltly that i would!

[Anonymous]

I have published this component. It would be great if you try it and provide feedback for it. If you experience any problems please contact me or post it in this forum. This component is tested only by me as developer and is only in usage in one project so far.
http://www.talendforge.org/exchange/index.php?eid=1135&product=tos&action=view&nav=1,1,1

[Anonymous]

Jan,
it's working fine.
Thanks a lot

[Anonymous]

Is this just for Oracle? or can it be used for MSSQL?

[Anonymous]

please help to install complent in talend 5.5.1, don´t apear in pallete

[Anonymous]

hi,
talend help is done for you :
https://help.talend.com/search/all?query=Installing+a+custom+component&content-lang=en
regards
laurent

[Anonymous]

The component tLOBDownload:
http://www.talendforge.org/exchange/index.php?eid=1277&product=tos&action=view
does not depend on Oracle. It works with every database which provides objects with the java.sql.Clob or java.sql.Blob interface.

[Anonymous]

sorry, the component doesn't work for me...
context.pathWORKSPACE1 is the directory where I want to save the files
tjavarow_1  shows information only
no error, no files.... What happen? I'm running 5.4.1 on ubuntu linux.
thanks for your help.
--