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:
My database configuration is as below
entity name=x query=SELECT ID, XMLSERIALIZE(SMRY as CLOB(1M)) as SMRY
FROM BOOK_REC fetch first 40 rows only
transformer=ClobTransformer
field column=MBR name=mbr /
entity name=y dataSource=xmldata dataField=x.SMRY
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.
Below is my full configuration,
dataConfig
dataSource driver=com.ibm.db2.jcc.DB2Driver
url=jdbc:db2://IP:port/dbname user= password= /
dataSource name=xmldata type=FieldReaderDataSource/
document
entity name=x query=SELECT ID, XMLSERIALIZE(SMRY as CLOB(1M)) as SMRY
FROM BOOK_REC fetch first 40
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 clob content.
root
authorA/author
On 20 March 2014 14:53, Prasi S prasi1...@gmail.com 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,
