compare the two xml file generate the third xml

[punna Kumar]

Hi,
i have a requirement to compare the two xml data and generate the defference xml containing the differnce data,

any one give the idea how i can do , i am using DOM Parser for parseing the xml file.


any idea


Rgds,
Punna.

[Ulf Dittmer]

It's probably less effort if you use one of the available xmldiff tools (google for it), and then use the results of that, than it is to roll your own.

[Srinivasa Raghavan]

We faced the same situation once, we wrote a script using Jdom it will take a node from the file 1 and parse the next XML. This happens in a recursive fashion. ( Dont know may be it's a expensive approach )
Even Text pad editor was helful, it checks the differences between two files.
[ November 09, 2005: Message edited by: Srinivasa Raghavan ]

[punna Kumar]

thanks for giving the approches,
here i have to take the two transations difference data i mean to say before the transationa and after transation, what is the data is modified.
based on modified data i have to create the xml. these things i have to do throug programatically , because these transations include the data bae operation, i am useing oracle 9i


i can do any thing with oracle

i mean comapre the data and generate the xml in back end it self


please help me?

punna

[Stan James]

I tried this once but didn't go very far with it. My idea was ...

given a node from A and a node from B
if they match
   result = true
   get all direct children of node A
   get all direct children of node B
   for each child in A
      if matching child exists in B
         result &= recursive compare
      else
         report child in A only 
   for each child in B
      if matching child exists in A
         do nothing, already did recursion
      else
         report child in B only
   return result
else
   return false

Now you have to define "match". Is it a match on the tag? On some or all of the attributes? On a simple String value? I think that's where I gave up on the XML I wanted to compare ... it had many repeats of the same tag name so I had to drill into attributes and children to even match two of them. Ick.