list archives . users mailing list
 

Subject: Still problem with handling results

Date view Thread view Subject view Author view Attachment view

From: Alexander Wöhrer (w.alexander@gmx.at)
Date: Apr 15, 2003 09:23

Hey,

        I tried to convert back the results of an query from XML to WebRowSet with
the following lines:

        mResults = new WebRowSet();
        mResults.readXml(new InputStreamReader(r1.getResultsAsStream()));

        but all I get is the following exception:
        --------SQLException---------
        29943 [Thread-102] ERROR
k.org.ogsadai.porttype.gds.statement.Operations - Exception
        java.sql.SQLException: readXML: com/sun/xml/parser/Resolver
        at sun.jdbc.rowset.XmlReaderImpl.readXML(XmlReaderImpl.java:94)
        at sun.jdbc.rowset.WebRowSet.readXml(WebRowSet.java:161)
          ......

        Also tried to set

System.setProperty("org.xml.sax.parser","org.apache.xerces.parsers.DOMParser
;");
        but this doesn't help either.

        Hope somebody can help me with getting the results in a useable format,
cause getResultsAsDocument doesn't also work and quit with the following
exception:

        27940 [Thread-104] ERROR uk.org.ogsadai.common.XMLUtilities - Exception in
XMLUtilities:xmlFileToDOM
        org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the declaration of
element 'RowSet'.
        at
org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException
        ....

        Best regards,
                Alexander Wöhrer

Date view Thread view Subject view Author view Attachment view