This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes XML and Related Technologies and the fly likes Editing an XML file Stored in Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Editing an XML file Stored in Database" Watch "Editing an XML file Stored in Database" New topic
Author

Editing an XML file Stored in Database

Varshini Priya
Ranch Hand

Joined: Feb 17, 2008
Posts: 94

Hi All,

I have an XML file stored as a BLOB in one of the tables in the Database. Im not sure how to edit the Xml file and store it back in the Database Please help me edit the XML file .

Thanks in Advance

Regards
Varshini
William Brogden
Author and all-around good cowpoke
Rancher

Joined: Mar 22, 2000
Posts: 12998
    
    5
The steps are going to be:

1. recover the blob from database
2. create a stream that reads the contents of the blob
3. feed the stream to a parser to create a DOM (Document Object Model) of the document in memory
4. modify the DOM
5. serialize the DOM back to text
6. store the modified text in database

How far have you gotten?
How familiar are you with Java's XML related library?

Bill
 
Have you checked out Aspose?
 
subject: Editing an XML file Stored in Database
 
It's not a secret anymore!