dfc error

Hi, I am running the following piece of code : IDfXmlQuery q = new DfXmlQuery(); q.setDql("select r_object_id from dm_user"); q.execute(IDfQuery.DF_EXEC_QUERY, session); FileOutputStream fos; fos = new FileOutputStream("D:\\output.xml"); q.getXMLString(fos); fos.flush(); fos.close(); And i am getting the following exception: Exception in thread "main" java.lang.NullPointerException at com.documentum.xerces_2_8_0.xml.serialize.BaseMarkupSerializer.serializeNode(Unknown Source) at com.documentum.xerces_2_8_0.xml.serialize.BaseMarkupSerializer.serialize(Unknown Source) at com.documentum.xml.xdql.DfXmlQuery.serializeDOM(DfXmlQuery.java:364) at com.documentum.xml.xdql.DfXmlQuery.getXMLString(DfXmlQuery.java:331) at xmlTesting.generatexml(xmlTesting.java:81) at xmlTesting.main(xmlTesting.java:117) Can you please help me in this?

Find more posts tagged with

Comments

aflowers001

Guessing that one issue will be the query as r_object_id is not an attribute of dm_user

Try a different query such as select user_name from dm_user and be a little more defensive in the coding and check if the query returns results.

Joydeep85

I tried using printwirter this time: PrintWriter outputFile1 = new PrintWriter(new File("d://2_test.xml")); IDfXmlQuery q = new DfXmlQuery(); q.setDql("select user_name from dm_user where user_name='test'"); q.execute(IDfQuery.DF_EXEC_QUERY, session); outputFile1.println("set,c,l,user_state"); q.getXMLString(outputFile1); outputFile1.close(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } catch (DfException e) { e.printStackTrace(); } But i get the same error: Exception in thread "main" java.lang.NullPointerException at com.documentum.xerces_2_8_0.xml.serialize.BaseMarkupSerializer.serializeNode(Unknown Source) at com.documentum.xerces_2_8_0.xml.serialize.BaseMarkupSerializer.serialize(Unknown Source) at com.documentum.xml.xdql.DfXmlQuery.serializeDOM(DfXmlQuery.java:364) at com.documentum.xml.xdql.DfXmlQuery.getXMLString(DfXmlQuery.java:307) at xmlTesting.generatexml(xmlTesting.java:93) at xmlTesting.main(xmlTesting.java:128)

aflowers001

Reformatting your code and it looks like this

PrintWriter outputFile1 = new PrintWriter(new File("d://2_test.xml"));

IDfXmlQuery q = new DfXmlQuery();

q.setDql("select user_name from dm_user where user_name='test'");

q.execute(IDfQuery.DF_EXEC_QUERY, session);

outputFile1.println("set,c,l,user_state");

q.getXMLString(outputFile1);

outputFile1.close();

}

catch (FileNotFoundException e)

{ e.printStackTrace(); }

catch (IOException e)

{ e.printStackTrace(); }

catch (DfException e) { e.printStackTrace(); }

Try putting a call to getXMLString() in there, say right after the execute as per System.out.println(q.getXMLString()); and see what the XML might look like. Also does the query return and data?