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.