Re: Store XML in a Database
From: Doyle (mypetrock_at_yahoo.com)
Date: 10/22/03
- Next message: Joan MacEachern: "[SUN] Take Sun Security Course and Get a Digital Camera"
- Previous message: Christophe Vanfleteren: "Re: Immutable classes"
- In reply to: Stefan Garde: "Store XML in a Database"
- Next in thread: Gregory Vaughan: "Re: Store XML in a Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 22 Oct 2003 10:26:10 -0700
"Stefan Garde" <stefangarde@hotmail.com> wrote in message news:<3f955ad5$0$54832$edfadb0f@dread11.news.tele.dk>...
> I need to figure out how you store a XML file (and its data) down in a
> Access database, by the help of SQL.
Do you need to just store the XML string or convert it into its
constituent parts and store it?
If you need to break it into its parts you should first figure out how
the XML file maps to the database. With any luck you should have some
level of entity/table mapping.
After loading your document into a XML-DOM parser with JAXP
(http://java.sun.com/xml/jaxp/index.html) or Xerces
(http://xml.apache.org/xerces2-j/index.html), you should be able to
recursively traverse your document. Once you are at the leaf nodes you
should be able to begin to enter the data into the database with
simple SQL statements.
I hope that is enough to get you started.
mypetrock
- Next message: Joan MacEachern: "[SUN] Take Sun Security Course and Get a Digital Camera"
- Previous message: Christophe Vanfleteren: "Re: Immutable classes"
- In reply to: Stefan Garde: "Store XML in a Database"
- Next in thread: Gregory Vaughan: "Re: Store XML in a Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
