I'm new to SOLR and have managed to get some basic indexing and querying
working. However I haven't been able to successfully implement the indexing
of a parent child database relationship.
My db-data-config.xml is:
<dataConfig>
<dataSource driver="com.ibm.as400.access.AS400JDBCDriver"
url="jdbc:as400://FAB/SV95TNDTA;;naming=system;" user="SV95TNGLB"
password="GLOBAL95TN" />
<document>
<entity name="client" query="SELECT #1ABCD, #1C8TX, #1AFTX, #1A7NA,
#1A8NA FROM AAAAREP">
<field column="#1ABCD" name="id" />
<field column="#1C8TX" name="surname" />
<field column="#1AFTX" name="forenames" />
<field column="#1A7NA" name="ird_number" />
<field column="#1A8NA" name="gst_number" />
<entity name="idreference" query="select M6ABR from ABM6CPP where
M6ABCD='${client.id}'">
<field column="M6ABR" name="id_reference" />
</entity>
</entity>
</document>
</dataConfig>
Most 'client' records will have one or more 'idreference' records. SOLR
seems to import the data successfully (see status below) but when I do a *:*
search there are no 'id_reference' elements in any document (see below at
bottom):
<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">0</int>
</lst>
<lst name="initArgs">
<lst name="defaults">
<str name="config">db-data-config.xml</str>
</lst>
</lst>
<str name="command">status</str>
<str name="status">idle</str>
<str name="importResponse"/>
<lst name="statusMessages">
<str name="Total Requests made to DataSource">13594</str>
<str name="Total Rows Fetched">13593</str>
<str name="Total Documents Skipped">0</str>
<str name="Full Dump Started">2012-03-13 13:15:07</str>
<str name="">
Indexing completed. Added/Updated: 13593 documents. Deleted 0 documents.
</str>
<str name="Committed">2012-03-13 13:15:36</str>
<str name="Optimized">2012-03-13 13:15:36</str>
<str name="Total Documents Processed">13593</str>
<str name="Time taken ">0:0:29.804</str>
</lst>
<str name="WARNING">
This response format is experimental. It is likely to change in the future.
</str>
</response>
<result name="response" numFound="13593" start="0" maxScore="1.0">
<doc>
<float name="score">1.0</float>
<str name="forenames">John David</str>
<str name="gst_number"></str>
<str name="id">0000012345</str>
<str name="ird_number">000000000000</str>
<str name="surname">Sagers</str>
</doc>
<doc>
<float name="score">1.0</float>
<str name="forenames">Mark James</str>
<str name="gst_number"></str>
<str name="id">0000000426</str>
<str name="ird_number"></str>
<str name="surname">Kirby</str>
</doc>
...
Any assistance would be greatly appreciated.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Incomplete-documents-with-parent-child-DB-relationship-tp3820963p3820963.html
Sent from the Solr - User mailing list archive at Nabble.com.
