Load the Entire XML Data to xml Type Field

VRM_5389 — Tue, 14 Jul 2020 17:14:57 GMT

Hi,

I have a Scenario to load the entire XML Content to the XML Field in DB.

Sample.xml

<?xml version="1.0" encoding="ISO-8859-15"?>

</ABC>

Approach :

tFileInputXML ==> tJavaRow(Store the entire XML data to Context Variable) ==> tdbrow(insert the value by casting to xml (insert into table(data) values(context.xml :: xml);)

Output:

XML Data is loaded to the XML Field in DB.

However only the below content is loaded

</ABC>

Missing :

<?xml version="1.0" encoding="ISO-8859-15"?>

Though the Log displays the above missing content. It is not being loaded to the field in DB.

When tried the manual Insert as below

insert into table(data) values('

<?xml version="1.0" encoding="ISO-8859-15"?>

</ABC>

Still the Version line is missing.

Appreciate your assistance here. Also please suggest if any appropriate/better design can be applied for the above scenario

Thank you

topic Load the Entire XML Data to xml Type Field in Talend Studio

Load the Entire XML Data to xml Type Field