How to select Huge CLOB and write it in flat file

Anonymous — Thu, 20 Feb 2014 08:47:06 GMT

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

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

Anonymous — Fri, 21 Feb 2014 03:42:26 GMT

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

topic How to select Huge CLOB and write it in flat file in Talend Studio

How to select Huge CLOB and write it in flat file

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