Iam new to XML technologies. Iam basically JSP/servlets guy. I just want your valuable guidance in a developing an application.
I just want to write a *.xml file populating it by values retrieved from database. I tried one exmple from IBM developerworks but then it writes out to console . This is done using DOM. But for my application i need this XML file so that i can club it with a corresponding XSL file and feed it to FOP that will result in XML-FO file which in turn gets converted into PDF.
Please let me know how to write this XML file with values from database.( I have the XML file with needed mapping as well that DOM makes use of.)It is pretty urgent.
Hi, which version of database are you using? Oracle 8i onwards supports fetching results in xml. similarily sql server (dont know which version since) also supports fetching results in xml. You can get the xml and then pass it to xsl and then generate the pdf.
If your database doesnt support, then generate the xml dynamically and then give it to xsl for conversion.
SCJP 1.4, SCDJWS , SCJA<br />I can do ALL things through CHRIST who strengthens me.