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

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

William Brogden
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 12998
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?

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