jdbc export data into xml

Asked Nov 18 '12 at 21:13

Active Sep 15 '16 at 20:41

Viewed 420 times

Possible Duplicate:
Java: How to Indent XML Generated by Transformer
jdbc export to xml - declaration showing standalone = no

      TransformerFactory factory = TransformerFactory.newInstance();
      Transformer transformer = factory.newTransformer();
      String outputPathname = "output.xml";
      StreamResult result = new StreamResult(new File(outputPathname));
      Source source = new DOMSource(dataDoc);
      transformer.transform(source, result);

I need to use jdbc to export data into a specific structured xml document. I'm using the parsing approach. I need the top to show

    <?xml version="1.0" standalone="yes"?>

However, the file create actually shows

    <?xml version="1.0" encoding="UTF-8" standalone="no"?>.

How can I modify the code to achieve the desired form?

edited May 23 '17 at 12:01

Community

asked Nov 18 '12 at 21:13

zoe

4

It's actually *better* to have this `encoding` attribute. – Tomasz Nurkiewicz Nov 18 '12 at 21:18
You are right but it's a requirement to follow the specified structure..how can i set standalone to be yes? – zoe Nov 18 '12 at 21:23
@jtahlborn this is not a duplicate as this asks read the xml declaration the other asks how to indent xml – mmmmmm Nov 18 '12 at 22:24
How you generate xml using jdbc and what is parsing approach? What magic is this? – Miserable Variable Nov 18 '12 at 22:29

jdbc export data into xml

0 Answers0