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.