getting NULL POINTER EXCEPTION while exporting ResultSet to XML

[Riteshti]

Im trying this java code to export data from database using sql query, But getting a null pointer exception. getting no clue to remove it . Im getting this exception at line no 26.

try {
 
    DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
    DocumentBuilder builder = factory.newDocumentBuilder();
    Document doc = builder.newDocument();
    Element results = doc.createElement("Results");
    doc.appendChild(results);
 
    Class.forName("oracle.jdbc.OracleDriver");
    Connection con = DriverManager
            .getConnection("jdbc:oracle:thin:@localhost:1521:XE", "hr", "hr");
 
    ResultSet rs = con.createStatement().executeQuery("select * from departments");
 
    ResultSetMetaData rsmd = rs.getMetaData();
    int colCount = rsmd.getColumnCount();
 
    while (rs.next()) {
        Element row = doc.createElement("Row");
        results.appendChild(row);
        for (int i = 1; i <= colCount; i++) {
            String columnName = rsmd.getColumnName(i);
            Object value = rs.getObject(i);
            Element node = doc.createElement(columnName);
            row.appendChild(node);
                node.appendChild(doc.createTextNode(value.toString()));
        }
    }
 
 
    DOMSource domSource = new DOMSource(doc);
    TransformerFactory tf = TransformerFactory.newInstance();
    Transformer transformer = tf.newTransformer();
    transformer.setOutputProperty(OutputKeys.OMIT_XML_DECLARATION, "yes");
    transformer.setOutputProperty(OutputKeys.METHOD, "xml");
    transformer.setOutputProperty(OutputKeys.ENCODING, "ISO-8859-1");
    StringWriter sw = new StringWriter();
    StreamResult sr = new StreamResult(sw);
    transformer.transform(domSource, sr);
 
    System.out.println(sw.toString());
 
 
    con.close();
    rs.close();
 
} catch (Exception e) {
    e.printStackTrace();
}

Also I have tested

doc

has a "null" value , right after its assignment.

Help required. Thank You

[r035198x]

So look at the code that assigns that doc value and check its documentation to see what conditions it returns a null value.