You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Tim Hurring <ti...@finzsoft.com> on 2012/03/13 01:35:26 UTC
Incomplete documents with parent child DB relationship
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.
Re: Incomplete documents with parent child DB relationship
Posted by Mikhail Khludnev <mk...@griddynamics.com>.
Hello,
IIRC, DIH UI has some kind of verbose or debug option, which provides
expanded trace of what's going on. Can't you try to check it?
On Tue, Mar 13, 2012 at 4:35 AM, Tim Hurring <ti...@finzsoft.com>wrote:
> 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.
>
--
Sincerely yours
Mikhail Khludnev
Lucid Certified
Apache Lucene/Solr Developer
Grid Dynamics
<http://www.griddynamics.com>
<mk...@griddynamics.com>