One Star

How to select Huge CLOB and write it in flat file

Dear all,
I try to write the content of a CLOB in a flat file.
I'm using tJDBCinput to select the CLOB content. My Clob has a length of 585003900. (can be bigger)
In my first test i got an out-of-memory error.
my memory assigned is already on 2048 MB.
I read in different posts/forum that i had to change the type of the field as "Byte []".
But when i try this solution, i get following error :
--> java.sql.SQLException: Unsupported feature
I didn't find any other alternative to this problem.
Does someone has an idea on how to resolve this issue?
thanks in advance for all the help,
Best regards,
Christophe
1 REPLY
Community Manager

Re: How to select Huge CLOB and write it in flat file

Hi Christophe
A CLOB (Character Large Object) is a data type that can be used to store a large collection of character data in a database table, so we read the CLOB data as an Object on DB input component, and then convert the object to a plain string with a piece of Java code on tJavaFlex, please my screenshots, I show you an example job.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business