why Talend convert the '<' and '>' caract from XML as DocumentType when merge with tAdvancedOutputXML and create < and > in my xml final ?

[FMartellucci1599461942]

Hello,

i want merge some xml into one file.

but when use tXMLInput with column in Document after link to tAdvancedOutputXML for merge xml existing with xml from file, he work but the add new element with decoding html &lt; and &gt; and not '<' and '>'

i will tryed to convert Document to Object (or String) but it cant merge into tAdvancedOutXML.... 😞

thanks you.

[FMartellucci1599461942]

ok it is to hard. I have changed my method

[FMartellucci1599461942]

I reopen this topic, because a i have the same problem.

i have a file with XML :

  <employeeDetails>

   <cryptPersonNumber>BLABLABLA</cryptPersonNumber>

  </employeeDetails>

and after i want insert this field String with this xml into CLOB oracle database , i have this :

<mess:employeeDetails>&lt;employeeDetails&gt;

   &lt;cryptPersonNumber&gt;BLABLABLA&lt;/cryptPersonNumber&gt;&lt;/employeeDetails&gt;</mess:employeeDetails>

Why my String Xml are translated all < > after the first element xml ??? why convert to String HTML ? i dont have do anything.

And plz dont tell me i obliged to convert String to Object (for no translate html < >) but after how insert Object to ORacle Clob ????

😞

[FMartellucci1599461942]

@not specified not specified​  you cant add the choice into parameter on tAdvancedFileOutputXML for unescapeHTML4 the xml generated ?

the library can do this is org.apache.commons.test.StringEscapeUtils.unescapeHtml4

and no translate automatic '<' '>' to '&lt;' '&gt;' .... plzzz

[FMartellucci1599461942]

i have tried several solutions, but not work.

I have the same problem with the component DBRow and DBoutput, i want insert "PARTIAL XML elements" into my CLOB column oracle, and all translate automatically by Talend all "<" , ">", """ into "& lt;" , "& gt;" and "& quot;" 😞

why TAdvancedFileOutputXML and DBRow , DBoutput, translate all charaters ????? im blocked.

i have tried for DB insert, add function oracle for unescape and retreive "<, >" but it is limited at 4000 Chars (:( but solution.

i have tried for tAdvancedFileOutputXML a java code after for open the big file created and read line by line and use org.apache.commons.text.StringEscapeUtils.unescapeHTML4, but not work.

it is clearly a disaster to have an xml partial in DB which remains "<" ">" and the same thing to make an xml file with the tAdvancedFileOutputXML component.

i m tired of having to find solutions for situations that Talend Generates alone 😞