Hi All,

I attempting to parse xml stored in a database as blobs 
and then store pieces of this xml such as titles and authors
in separate fields.

                <entity name="ArticleBlob" 
dataSource="blob${ArticleBlobInfo.BlobDbId}" 

query="select Blobdata, Blobdata as Blob2, Blobdata as Blob3,
                        Blobdata as Blob4 from ArticleBlob
                        where 
ArticleInstanceId='${ArticleInstance.ArticleInstanceId}' and
                                  
ArticleBlobNumber='${ArticleBlobInfo.BlobNumber}'"

                                  
transformer="BlobTransformer,HTMLStripTransformer,
                                              
BlobTitleTransformer,BlobAuthorTransformer >

                        <field column="Blobdata" name="Blobdata" blob="true" 
stripHTML="true"/>
                        <field column="Blob2" name="Title" blobTitle="true" />
                        <field column="Blob3" name="Author" blobAuthor="true" />

                </entity>               

The above configuration works, but the issue is that I have to parse 
the XML again and again for each new field. The indexing time increases
linearly.

What I would like to do is get the Blob once, parse the xml into a DOM
document
and populate all the fields at once, in a single transformer.

Is this possible? Could anyone point me in the right direction?

Regards,
Alexei
-- 
View this message in context: 
http://lucene.472066.n3.nabble.com/DIH-populate-multiple-fields-with-one-column-tp2367379p2367379.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to