aspose file tools*
The moose likes JDBC 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 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "XML and DB comp" Watch "XML and DB comp" New topic
Author

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
Greenhorn

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: http://aspose.com/file-tools
 
subject: XML and DB comp
 
Similar Threads
XML in Webservices
Building generic XML for multilingual data
Java Xml parser
Extract db data into a XML
Building generic XML for multilingual data