views:

49

answers:

0

After retrieving a result set from an Oracle 11g database, it takes roughly 75 seconds to convert the XMLType (this is a structured XML Storage, registered with an xsd) into either a java String or Document. I'm using Java 1.6, have the xdb.jar and xmlparserv2.jar

This xsd is <100 lines and the xml document is also <100 lines.

Sample code:

oracle.xdb.XMLType xml = oracle.xdb.XMLType.createXML((oracle.sql.OPAQUE)rset.getObject("XMLDATA"));

The other way, but still took just as long:

XMLType xml = (XMLType)rset.getObject("XMLDATA");
xml.getStringVal();

Or

XMLType xml = (XMLType)rset.getObject("XMLDATA");
org.w3c.dom.Document doc = xml.getDocument();

Either way of the above ways takes just as long.