topic Re: [resolved] Converting Object(BLOB) to String in Talend Studio

[resolved] Converting Object(BLOB) to String

Anonymous — Fri, 16 Oct 2015 19:33:34 GMT

Hi,
i'm trying to convert an Object field (Blob type) into String... actually i'm looking for a talend equivalent for "convert(column using utf8)".
That works in my case, but i have several fields to convert using talend... it there an alternative?
Thanks!

Re: [resolved] Converting Object(BLOB) to String

Anonymous — Fri, 16 Oct 2015 19:36:04 GMT

Did you tried to set as Java type in the Talend schema for these kind of columns the type "String" ?

Re: [resolved] Converting Object(BLOB) to String

Anonymous — Fri, 16 Oct 2015 19:42:04 GMT

Hi jlolling,
i used "(String)row1.column" in tmap but only gives me random characters
Thanks

Re: [resolved] Converting Object(BLOB) to String

Anonymous — Fri, 16 Oct 2015 19:45:44 GMT

This cannot work because if you have in the schema the java type Object you will get a java.sql.Clob object and that cannot be cast to String.
Please edit the schema of the table and set the CLOB columns to the Java type String.
In the tMap it is to late. You have to force the database input component to get the value as String and not as java.sql.Clob object.

Re: [resolved] Converting Object(BLOB) to String

Anonymous — Fri, 16 Oct 2015 19:46:25 GMT

UPDATE:
i've set the Java type to String and same results

Re: [resolved] Converting Object(BLOB) to String

Anonymous — Fri, 16 Oct 2015 19:47:58 GMT

Please show me a screenshot. I do the same and have problems with it.

Re: [resolved] Converting Object(BLOB) to String

Anonymous — Fri, 16 Oct 2015 19:54:44 GMT

Hey finally WORKS!!!
i've change the Schema as you said and it works...
Thank you so much

Re: [resolved] Converting Object(BLOB) to String

Anonymous — Mon, 07 Jan 2019 12:43:58 GMT

Hi,

I need to transfer clob data type from oracle to text file. in mapping we are using tjavarow and toraclerow. and we have to pass this column from tjavarow to toraclerow. I tried a lot but could not get solution.

Kindly help.

Thanks

Re: [resolved] Converting Object(BLOB) to String

Anonymous — Tue, 29 Jan 2019 07:53:31 GMT

Hello,

If you are working with Oracle, you can use tOracleInput to read the CLOB column (Column Type can be set as Object).

Best regards

Sabrina

Re: [resolved] Converting Object(BLOB) to String

prbrganguly — Mon, 31 Jan 2022 07:13:21 GMT

Hello,

Several times I tried to transfer the Oracle BLOB data to MEDIUMBLOB of MYSQL using customer components tLOBDownload , not working , if any configuration , please help.

Thanks

Prabir

Re: [resolved] Converting Object(BLOB) to String

Anonymous — Tue, 15 Feb 2022 03:15:50 GMT

Hello,

As the third party custom components on Talend Exchange are created by Talend community users, we don't have the source code of these components. It is the ownership of the person who built it. Feel free to contact the author please.

Best regards

Sabrina

Re: [resolved] Converting Object(BLOB) to String

prbrganguly — Tue, 15 Feb 2022 12:32:24 GMT

Hello, I transferred BLOB data from oracle to Mysql , using the talend compound but the custom component tLOBDownload is not working at this conversion . Thanks Prabir