Here is the method using which you can create XML file from your ResultSet
public String xmlCreation(ResultSet rSet, ResultSetMetaData rsMData){ try{ DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance(); DocumentBuilder parser = factory.newDocumentBuilder(); Document doc = parser.newDocument(); Element root = doc.createElement("ListData"); doc.appendChild(root); if(rSet!=null){ while(rSet.next()){ Element row = doc.createElement("Row"); root.appendChild(row); int totColumns = rsMData.getColumnCount(); for(int i=1;i<=totColumns;i++){ String columnName = rsMData.getColumnName(i); Object columnValue = rSet.getObject(i); Element childElement = doc.createElement(columnName); childElement.appendChild(doc.createTextNode(columnValue.toString())); row.appendChild(childElement); } } } TransformerFactory tranFactory = TransformerFactory.newInstance(); Transformer aTransformer = tranFactory.newTransformer(); Source src = new DOMSource(doc); StringWriter writer = new StringWriter(); Result dest = new StreamResult(writer); aTransformer.transform(src, dest); StringBuffer strBuf = writer.getBuffer(); System.out.println(strBuf.toString()); return strBuf.toString(); }catch(Exception e){ System.out.println("Opps Error: "+e.toString()); return null; } }