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 the line in Bold font.\[code\]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
racle: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 = http://stackoverflow.com/questions/15710179/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();}\[/code\]Stack trace :\[code\]java.lang.NullPointerExceptionat org.ProjectXML.ui.DataBaseToXML.main(DataBaseToXML.java:61)\[/code\]Any ideas?
racle:thinlocalhost: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 = http://stackoverflow.com/questions/15710179/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();}\[/code\]Stack trace :\[code\]java.lang.NullPointerExceptionat org.ProjectXML.ui.DataBaseToXML.main(DataBaseToXML.java:61)\[/code\]Any ideas?