File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes XML and DB comp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "XML and DB comp" Watch "XML and DB comp" New topic

XML and DB comp

raj joe
Ranch Hand

Joined: Mar 17, 2005
Posts: 99
I have a oracle DB with some data .I have exported the data to an XML file.
Now I want to compare the data in the XML and the database.

do you know of any tools that can help me ?
Sreenivasan M

Joined: Oct 05, 2006
Posts: 10
use java DOM/SAX parsing for xml file...and find out the tag names...and the inner text values...

use a similar approach for oracle bd file also...

after that compare using a java compare program...which takes two files as parameters adn compares the values between them
Purushoth Thambu
Ranch Hand

Joined: May 24, 2003
Posts: 425
How did you export the data from Oracle to XML? Did you use Oracle's XML functions like XMLForest, XMLElement? If so you could save this operation, plus it's more effective this way.
I agree. Here's the link:
subject: XML and DB comp
It's not a secret anymore!