10G XmlDB - Need for speed

From: <jsvaughan_at_gmail.com>
Date: 23 May 2005 06:13:21 -0700
Message-ID: <1116854001.462184.264100@g44g2000cwa.googlegroups.com>

Hi,

Does anyone know how in 10g (10.1) xmldb I can query the resource_view by path and return the found document as an XmlType? What I want is to obtain the document as a Java W3C Document; XmlType has a getDOM method which would save me having to parse the character stream as below, and give me a bit of a speed up.

Currently our query is:

select extract(res, '/Resource/Contents/*').getClobVal() document from resource_view where equals_path(res, ?) = 1

and we then do:

Clob myClob = myResultSet.getClob(1);
myDocument =
XMLServices.getInstance().readDocument(myClob.getCharacterStream(), false);

Where readDocument uses a javax.xml.parsers.DocumentBuilder to parse the doc.

Any help very gratefully received

Jon Received on Mon May 23 2005 - 08:13:21 CDT