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.
So in my db-data-config, I have the following:
<document>
<entity name="doc" query="SELECT d.EFFECTIVE_DT, d.ARCHIVE_ID FROM DOC
d">
<field column="EFFECTIVE_DT" name="effectiveDate" />
<field column="ARCHIVE_ID" name="id" />
<entity name="text" query="SELECT d.XML FROM DOC d WHERE
d.ARCHIVE_ID = '${doc.ARCHIVE_ID}'" transformer="ClobTransformer">
<field column="XML" name="text" clob="true" sourceColName="XML"
/>
</entity>
</entity>
</document>
Meanwhile, I have this in schema.xml:
<field name="text" type="text_ws" indexed="true" stored="true"
multiValued="true" omitNorms="false" termVectors="true" />
However, when I take a look at my indexes with Luke, I find that the items
labeled "text" simply say oracle.sql.OPAQUE and a bunch of numbers-in other
words, the OPAQUE.toString().
Can you give me some insight into where I am going wrong?
Thanks.
