topic Re: [resolved] File into BLOB in Talend Studio

[resolved] File into BLOB

Anonymous — Sat, 16 Nov 2024 14:29:55 GMT

I have a delimited file which I use to generate rows. I go thru a replace and a tMap process. At that point, I need to grab a file off of the filesystem based on a field value. That file is then to be a BLOB in the given row. I've got everything running well except I cannot find a clean way to get the file into the BLOB column. Any help or suggestions would be appreciated.

Re: [resolved] File into BLOB

Anonymous — Fri, 30 Nov 2007 03:22:02 GMT

Hi
Set the datatype as 'Object' for BLOB column when define the schema in tMap.
Best regards

shong

Re: [resolved] File into BLOB

Anonymous — Fri, 30 Nov 2007 19:01:23 GMT

I do have that column as a BLOB. How do I load a file off of the disk into an OBJECT column in the row?

Re: [resolved] File into BLOB

Anonymous — Sun, 02 Dec 2007 20:33:23 GMT

Here is a simple example converting this simple delimited file with a reference to another file into a BLOB

Samuel;Johnson;35;C:/temp/Samuel_Johnson.txt
David;Palmer;43;C:/temp/David_Palmer.txt

Note the tMap conversion in the first capture.
Regards,

Re: [resolved] File into BLOB

Anonymous — Tue, 04 Dec 2007 22:36:47 GMT

This results in
java.sql.SQLException: Unable to convert between java.io.File and JAVA_OBJECT.
Any thoughts? I can do this in Java by copying byte arrays around but it is very slow.

Re: [resolved] File into BLOB

Anonymous — Wed, 05 Dec 2007 03:18:09 GMT

java.sql.SQLException: Unable to convert between java.io.File and JAVA_OBJECT.

Which version of TOS did you use? Can you succeed in create a simple job as mhirt did?
Best regards

shong

Re: [resolved] File into BLOB

Anonymous — Thu, 06 Dec 2007 23:18:30 GMT

I solved this by creating by creating a small routine. I can then call it as a function in the tMap
public static Object ByteArrayFromFile(java.io.File file) {
try
{
java.io.FileInputStream fis = new java.io.FileInputStream(file);
int fileLength = (int) file.length();
byte[] incoming_file_data = new byte; // allocate byte array of right size
fis.read(incoming_file_data, 0, fileLength ); // read into byte array
fis.close();
return incoming_file_data;
}
catch(Exception err)
{
err.printStackTrace();
return null;
}

Works well in 2.2.2 and now 2.2.3

Re: [resolved] File into BLOB

Anonymous — Tue, 19 Apr 2016 06:42:45 GMT

Hi All,
i am struggling with the process of inserting image in sql server using talend. I have even gone through the process mentioned help.talend.com.
As i am new to talend so i dont have much idea. can anybody help me with detailed process of doing so.
Thanks & Regards

Re: [resolved] File into BLOB

Anonymous — Thu, 03 May 2018 12:21:18 GMT

Hi,

I've solved it by adding a tJavaRow with following content, before tMap:

java.io.File file = new java.io.File(((String)globalMap.get("tFileInputRaw_1_FILENAME_PATH")));
java.io.FileInputStream fis = new java.io.FileInputStream(file);
int fileLength = (int) file.length();
byte[] incoming_file_data = new byte[fileLength]; // allocate byte array of right size
fis.read(incoming_file_data, 0, fileLength ); // read into byte array
fis.close();
output_row.content = incoming_file_data;

I attach sample job screenshot.

1) tFileList loops through files to load

2) tFileInputRaw reads each file as Object

3) tJavaRow converts Object to byte[]

4) tMap retrieves byte[]

5) tOracleOutput stores byte[] column as BLOB DB internal type

Hope it helps!

2018-05-03_13h18_29.png