Hi Jon I have my unique key set to false. <uniqueKey required="false">EMP_ID</uniqueKey>.
I tried with enabling the unique key. Still the same problem exists. Thanks con jonbaer wrote: > > What is your <uniqueKey> set to? Could it be you have duplicates in > your uniqueKey setup (thus producing only 10 rows in index)? > > - Jon > > On Oct 12, 2008, at 1:30 PM, con wrote: > >> >> I wrote a jdbc program to implement the same query. But it is >> returning all >> the responses, 25 nos. >> But the solr is still indexing only 10 rows. >> Is there any optimization settings by default in the solrconfig.xml >> that >> restricts the responses to 10 ? >> thanks >> con. >> >> >> >> >> >> Noble Paul നോബിള് नोब्ळ् wrote: >>> >>> template transformer does not eat up rows. >>> >>> I am almost sure that the query returns only 10 rows in that case. >>> could you write a quick jdbc program and verify that (not the oralce >>> client) >>> >>> everything else looks fine >>> >>> On Sat, Oct 11, 2008 at 4:52 PM, con <[EMAIL PROTECTED]> wrote: >>>> >>>> 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. >>>> >>>> >>> >>> >>> >>> -- >>> --Noble Paul >>> >>> >> >> -- >> View this message in context: >> http://www.nabble.com/Solr-indexing-not-taking-all-values-from-DB.-tp19916938p19943817.html >> Sent from the Solr - User mailing list archive at Nabble.com. >> > > > -- View this message in context: http://www.nabble.com/Solr-indexing-not-taking-all-values-from-DB.-tp19916938p19948508.html Sent from the Solr - User mailing list archive at Nabble.com.