cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Conover <>
Subject possible solution to hierarchy problem - need advice
Date Tue, 08 Aug 2000 15:43:57 GMT
Ok so I think I might have an Oracle-specific solution to this hierarchical
resultsets problem.  I noticed in Marcelo's documentation that he used and
example of the oracle xml api (roughly like this):

(given java.sql.Connection cn)

OracleXMLQuery q = new OracleXMLQuery(cn, "select fname, lname from emp");
//substring(22) removes <?xml version... from xml string

so the result is that I have the XML output using Oracle's api, which
presumably would support output of nested queries (since it works in XSQL
and I assume the XSQL servlet uses this api under the covers).  This code
would be in an xsp taglib, so now I need to figure out how to load this XML
string output into the DOM on-the-fly.  I looked in the Xerces javadocs, and
it looks like I could possibly turn the string into a character stream (so
that I can create an "InputSource"), and feed that to the parser.  Is there
some way I can grab the current parser instance to do this, or (more likely)
I guess I need to instanciate a new parser every time, load the XML string,
extract a Document from that, then morph the Document into an Element and
return that out of the xsp:logic function.  Does this sound right, or is
there an easier way to load an XML string result from some java calls into
the DOM?


View raw message