java - converting the data from table to an xml file

Question

I am querying the database. And trying to conert the data from a particular table and display that as an xml. I tried the following code, but still the xml is empty. I am still checking what is the problem. In mean time I am posting here. Can anyone please check and tell what is the problem?

response.setContentType("text/xml"); 

private void writeToXML(PrintWriter pw, ResultSet rs, Map<String, String> m)
      throws Exception {
    pw.print("<data>\n");
    rs.beforeFirst();
    while (rs.next()) {
      pw.print("\t<row>\n");
      ResultSetMetaData metaData = rs.getMetaData();
      int cols = rs.getMetaData().getColumnCount();

      for (int i = 1; i <= cols; i++) {
        String name = metaData.getColumnName(i);
        String mappedValue = m.get(rs.getString(i));
        String value = mappedValue != null ? mappedValue : rs
            .getString(i);
        pw.print("\t\t<name>" + name + "</name><value>" + value
            + "</value>\n");
      }
      pw.print("\t</row>\n");

    }
    pw.print("</data>");

  }

Pierre · Accepted Answer · 2012-10-11 08:10:04Z

1

did you flush (and later, closed) the printWriter ?

pw.flush();

answered Oct 11, 2012 at 8:10

Pierre

35.4k33 gold badges120 silver badges197 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Unni Kris · Accepted Answer · 2012-10-11 08:15:13Z

1

You might be getting some exception. PrintWriter swallows exceptions.

Use System.out and see if the program is executing and if no then what exception you are getting.

answered Oct 11, 2012 at 8:15

Unni Kris

3,1034 gold badges39 silver badges58 bronze badges

Collectives™ on Stack Overflow

java - converting the data from table to an xml file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related