create XML file from database on the fly.

[potineni39]

Hi All,
I'm new to XML and wanted to use XML to create a dynamic treemenu in our application(Developed in JSP/Java). Firstly i wanted to know how i can create an XML file using database queries. Is it possible to create XML files on the fly and get data from the file in JSP/Javascript.
Any suggestions...

Thanks in advance
Praveen

 

[deehowe]

I'm assuming you are using a relational database and, therefore, must format the output into xml since the database does not inherently support that.

I ask, because there are companies who support native xml storage. (I work for one called NeoCore, but this is not an endorsement of them. Others are Tamino, etc). The output from these kind of IM products are already in XML.

Not knowing the db you are working with, you may be able to output the results to a flat file, and use perl or some other scripting language to format the results. Many of the relational databases also have XML plug in software, but I'm not familiar with the ins and outs of it.

 

[MrTom]

jdom is a nice way to build up xml files. it is really simple and quick to use, especially in the situation you mention.

http://www-106.ibm.com/developerworks/java/library/j-jdom/

 

[fanningpj]

Further to what Mr. Tom said, JDOM have some samples of how to turn a JDBC ResultSet into a JDOM. The resulting JDOM can be output as XML using the org.jdom.output.XMLOutputter class.

http://cvs.jdom.org/cgi-bin/viewcvs.cgi/jdom-contrib/samples/