Inserting xml to database

, ,
1

Hi All

can anyone help me out to insert xml to database and the vice versa by using flow services…

thanks in advance

2

Use jdbc adapter insert service for insertion of xml, what is size of xml? You can store it as BLOB object in DB.

3

hi sir

thanks for ur reply…

in which format shall i insert xml to database using adapter service…

as document or in xml itself?

my xml sizes few kb’s sir…

thanks in advance

4

Once you convert the xml into string you can insert that string into the database table which should be having your xml field as varchar.Please make sure of what would be the futhure size of the xml.If its gonna be variable size and too big then i would go with Shahid’s suggestion

thanks
Anil

5

Hello,
And before storing to DB, make sure that you create the fields similar to the XML doc…
And directly map to adapter service…