After trying that, the indexing process took a lot longer, which I found encouraging. However, when I inspected the indexes, the text property wasn't there. Very strange. I will keep digging.
Thanks for the tip though. I have used that function before, but I forgot to try it in this situation. -----Original Message----- From: Craig Christman [mailto:cchrist...@caci.com] Sent: Wednesday, March 17, 2010 11:23 AM To: solr-user@lucene.apache.org Subject: RE: Indexing CLOB Column in Oracle To convert an XMLTYPE to CLOB use the getClobVal() method like this: SELECT d.XML.getClobVal() FROM DOC d WHERE d.ARCHIVE_ID = '${doc.ARCHIVE_ID}' -----Original Message----- From: Shawn Heisey [mailto:s...@elyograg.org] Sent: Tuesday, March 16, 2010 7:37 PM To: solr-user@lucene.apache.org Subject: Re: Indexing CLOB Column in Oracle Disclaimer: My Oracle experience is miniscule at best. I am also a beginner at Solr, so grab yourself the proverbial grain of salt. I googled a bit on CLOB. One page I found mentioned setting up a view to return the data type you want. Can you use the functions described on these pages in either the Solr query or a view? http://www.oradev.com/dbms_lob.jsp http://www.dba-oracle.com/t_dbms_lob.htm http://www.praetoriate.com/dbms_packages/ddp_dbms_lob.htm I also was trying to find a way to convert from xmltype directly to a string in a query, but that quickly got way over my level of understanding. I saw hints that it is possible, though. Shawn On 3/16/2010 4:59 PM, Neil Chaudhuri wrote: > Since my original thread was straying to a new topic, I thought it made sense > to create a new thread of discussion. > > I am using the DataImportHandler to index 3 fields in a table: an id, a date, > and the text of a document. This is an Oracle database, and the document is > an XML document stored as Oracle's xmltype data type, which is an instance of > oracle.sql.OPAQUE. Still, it is nothing more than a fancy clob. >
