To add to this. Oracle 9i now has a native XMLType which is really a CLOB. However, it doesn't have the normal limitations of a CLOB -- you can use XPATH for selection and for indexing, a great improvement in my opinion. However, a drawback remains in that you are still unable to select individual nodes and attributes within the CLOB, so your SQL has to return the document as a whole.
Another drawback is that the Java API provided by Oracle is for 1.2, thus lacking regular expression support. Also, XML has to be updated as a whole, as Oracle still has nothing like XUpdate. Oracle is catching up to Xindice but still a ways back, in my opinion. >From: ROSSEL Olivier <[EMAIL PROTECTED]> >Subject: RE: sexy open source >Date: Wed, 14 Aug 2002 17:10:03 +0200 > > > >I am currently studying XML DB features of Oracle 9iR2. > > >It is quite impressive. > > >Very very advanced stuff !!! > > > > > How it compares to Tamino and Xindice? What are the cool > > features (in a > > nutshell ;)? > >I dunno Tamino. >I hope I will have the time to test Xindice. > >Oracle 9iR2 has a XML repository accesible vie Webdav, HTTP and FTP. >It handles foldering, versionning. > >It has schema validation system, and (automatic or manual) schema-based >XML-SQL mapping. >XPath functions are accessible inside SQL queries. And queries can provide >XML as output. > >I am currently investigating mapping SQL queries to HTTP URLs. >So we can use a simple Http generator to get XML from Oracle. > >This is a (very) simplified overview. > >I have not made stretch test yet. I-Lin Kuo Macromedia Certified ColdFusion 5.0 Advanced Developer Sun Certified Java 2 Programmer Ann Arbor, MI _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>