Re: Solr dih to read Clob contents

2014-03-27 Thread Prasi S
The column in my database is of xml datatype. But if I do not use XMLSERIALIZE(SMRY as CLOB(1M)) as SMRY , and instead take SMRY field directly as select ID,SMRY from BOOK_REC, i get the below error, Exception while processing: x document : SolrInputDocument(fields: [id=45768734]):org.apache.solr

Re: Solr dih to read Clob contents

2014-03-24 Thread Prasi S
Below is my full configuration, And this is my xml data ZAYQ5181 Sam Mathews 2013-01-18T23:29:04.492 Thanks, Prasi On Mon, Mar 24, 2014 at 3:23 PM, Shalin Shekhar Mangar < shalinman...@gmail.com> wrote: > 1. I don't see the definition of a datasource named 'xmldata' in yo

Re: Solr dih to read Clob contents

2014-03-24 Thread Shalin Shekhar Mangar
1. I don't see the definition of a datasource named 'xmldata' in your data-config. 2. You have forEach="/*:summary" but I don't think that is a syntax supported by XPathRecordReader. If you can give a sample of the xml stored as Clob in your database, then we can help you write the right xpaths.

Re: Solr dih to read Clob contents

2014-03-24 Thread Prasi S
My database configuration is as below and i get my response from solr as below org...@1c8e807 Am i mising anything? Thanks, Prasi On Thu, Mar 20, 2014 at 4:25 PM, Gora Mohanty wrote: > On 20 March 2014 14:53, Prasi S wrote: > >

Re: Solr dih to read Clob contents

2014-03-20 Thread Gora Mohanty
On 20 March 2014 14:53, Prasi S wrote: > > Hi, > I have a requirement to index a database table with clob content. Each row > in my table a column which is an xml stored as clob. I want to read the > contents of xmlthrough dih and map each of the xml tag to a separate solr > field, > > Below is my