lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ravi1984 <ravi.keat...@gmail.com>
Subject Importing/Indexing the DB2 XML FieldType in SOLR
Date Thu, 05 Dec 2013 09:30:18 GMT
I'm using DB2 9.x and I have a column named DTL_XML of type XML. Following
are the snippets of data-config.xml & schema.xml within my SOLR instance.

data-config.xml:
    <dataSource driver="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://myIP:myPort/DBName" user="testUsr" password="testPwd" />
    <document>
    <entity name="cust_data" query="select DTL_XML from testSch.SUMMRY_DTL
FETCH FIRST 50 ROWS ONLY">
        <field column="DTL_XML" name="cust_data" />
        </entity>
    </document>

Snippets from schema.xml:
<field name="cust_data" type="text" indexed="true" stored="true"/>
<uniqueKey>cust_data</uniqueKey>
<copyField source="cust_data" dest="text"/>

When I query the SOLR, my requirement is to retrieve the cust_data as XML
string, but instead I was getting the data as following:
"cust_data": "com.ibm.db2.jcc.c.fc@628f628f"

Can somebody help me to find a way to retrieve the cust_data as XML String
(instead of above object representation) from SOLR? Thanks in advance!



--
View this message in context: http://lucene.472066.n3.nabble.com/Importing-Indexing-the-DB2-XML-FieldType-in-SOLR-tp4105079.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message