Hi Noble
Thanks for your reply
In my data-config.xml I have;
<entity name="employees" transformer="TemplateTransformer"
query="Select
EMP_ID , EMP_NAME , NVL (COMMENT ,'-Nil-') as COMMENT from EMPLOYEES">
<field column="rowtype" template="employees" />
<field column="EMP_ID" name="EMP_ID" />
<field column="EMP_NAME" name="EMP_NAME" />
<field column="COMMENT" name="COMMENT" />
</entity>
<entity name="customers" transformer="TemplateTransformer"
query="Select
CUST_ID , CUST_NAME , NVL (COMMENT ,'-Nil-') as COMMENT from CUSTOMERS">
<field column="rowtype" template="customers" />
<field column="CUST_ID" name="CUST_ID />
<field column="CUST_NAME" name="CUST_NAME" />
<field column="COMMENT" name="COMMENT" />
</entity>
Whether this, TemplateTransformer, is the one that is restricting the
resultset count to 10?
Where can I find it out?
I need this TemplateTransformer because I want to query the responses of
either one of these at a time using the URL like,
http://localhost:8983/solr/select/?q=(Bob%20AND%20rowtype:customers)&version=2.2&start=0&rows=10&indent=on&wt=json
I tried in the debug mode:
(http://localhost:8983/solr/dataimport?command=full-import&debug=on&verbose=on)
, But it is not all mentioning anything after the 10th document.
Thanks and regards
con
Noble Paul നോബിള് नोब्ळ् wrote:
>
> The DIH status says 10 rows which means only 10 rows got fetched for
> that query. Do you have any custom transformers which eats up rows?
>
> Try the debug page of DIH and see what is happening to the rest of the
> rows.
>
>
>
> On Fri, Oct 10, 2008 at 5:32 PM, con <[EMAIL PROTECTED]> wrote:
>>
>> A simple question:
>> I performed the following steps to index data from a oracle db to solr
>> index
>> and then search:
>> a) I have the configurations for indexing data from a oracle db
>> b) started the server.
>> c) Done a full-import:
>> http://localhost:8983/solr/dataimport?command=full-import
>>
>> But when I do a search using http://localhost:8983/solr/select/?q=....
>> Not all the result sets that matches the search string are displayed.
>>
>> 1) Is the above steps enough for getting db values to solr index?
>> My configurations (data-config.xml and schema.xml )are quite correct
>> because
>> I am getting SOME of the result sets as search result(not all).
>> 2) Is there some value in sorconfig.xml, or some other files that limits
>> the
>> number of items being indexed? [For the time being I have only a few
>> hundreds of records in my db. ]
>> The query that I am specifying in data-config yields around 25 results if
>> i
>> execute it in a oracle client, where as the status of full-import is
>> something like:
>> <str name="status">idle</str>
>> <str name="importResponse">Configuration Re-loaded sucessfully</str>
>> <lst name="statusMessages">
>> <str name="Total Requests made to DataSource">1</str>
>> <str name="Total Rows Fetched">10</str>
>> <str name="Total Documents Skipped">0</str>
>> <str name="Full Dump Started">2008-10-10 17:29:03</str>
>> <str name="Time taken ">0:0:0.513</str>
>> </lst>
>>
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Solr-indexing-not-taking-all-values-from-DB.-tp19916938p19916938.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> --Noble Paul
>
>
--
View this message in context:
http://www.nabble.com/Solr-indexing-not-taking-all-values-from-DB.-tp19916938p19931736.html
Sent from the Solr - User mailing list archive at Nabble.com.
