Re: Indexing CLOB Column in Oracle

2010-03-17 Thread Lance Norskog
> > > Thanks. > > > > -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 C

RE: Indexing CLOB Column in Oracle

2010-03-17 Thread Neil Chaudhuri
: 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

RE: Indexing CLOB Column in Oracle

2010-03-17 Thread Neil Chaudhuri
ation. -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.getCl

RE: Indexing CLOB Column in Oracle

2010-03-17 Thread Craig Christman
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 y

Re: Indexing CLOB Column in Oracle

2010-03-16 Thread Shawn Heisey
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

Indexing CLOB Column in Oracle

2010-03-16 Thread Neil Chaudhuri
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