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!
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.
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.
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.
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.
