Ok so I executed a: solr/dataimport?command=full-import then I checked here: solr/dataimport
I get a good xml message (figure 1.1) showing me that 125 records have been indexed (good) and I know one of them contains the word 'job'. I sould get results from this query string then right (figure 1.0 is my result - 0 records found)? solr/select?q=job figure 1.0 <response> − <lst name="responseHeader"> <int name="status">0</int> <int name="QTime">0</int> − <lst name="params"> <str name="q">job</str> </lst> </lst> <result name="response" numFound="0" start="0"/> </response> figure 1.1 <response> − <lst name="responseHeader"> <int name="status">0</int> <int name="QTime">0</int> </lst> − <lst name="initArgs"> − <lst name="defaults"> <str name="config">data-config.xml</str> </lst> </lst> <str name="status">idle</str> <str name="importResponse"/> − <lst name="statusMessages"> <str name="Total Requests made to DataSource">1</str> <str name="Total Rows Fetched">125</str> <str name="Total Documents Skipped">0</str> <str name="Full Dump Started">2008-11-10 22:33:55</str> − <str name=""> Indexing completed. Added/Updated: 125 documents. Deleted 0 documents. </str> <str name="Committed">2008-11-10 22:34:00</str> <str name="Optimized">2008-11-10 22:34:00</str> <str name="Time taken ">0:0:5.79</str> </lst> − <str name="WARNING"> This response format is experimental. It is likely to change in the future. </str> </response> Kevin -----Original Message----- From: Noble Paul നോബിള് नोब्ळ् [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2008 10:30 PM To: solr-user@lucene.apache.org Subject: Re: Newbie Question - getting search results from dataimport request handler XML is just an intermediete data format Solr internally has no XML data. When the data comes out XML is just another representation of the same data. Whether you put in data using XML or DB (SQL) it all goes into the same index . Query must be done on that index using the syntax http://localhost:8983/solr/select/?q=<your-query-goes-here> On Tue, Nov 11, 2008 at 9:55 AM, Kevin Penny <[EMAIL PROTECTED]> wrote: > Ok - and what would that be? (query interface) > > I need the URL format that would work in this situation to return data from > my setup. > > I've gone through the tutorial and used execution strings like: > http://localhost:8983/solr/select/?indent=on&q=video&sort=price+desc > etc however I'm working with sql data and not xml data. > > Thanks > > -----Original Message----- > From: Noble Paul നോബിള് नोब्ळ् [mailto:[EMAIL PROTECTED] > Sent: Monday, November 10, 2008 10:18 PM > To: solr-user@lucene.apache.org > Subject: Re: Newbie Question - getting search results from dataimport request > handler > > you cannot query the DIH. It can only do indexing > after indexing you must do the indexing on the regular query interface > > On Tue, Nov 11, 2008 at 9:45 AM, Kevin Penny <[EMAIL PROTECTED]> wrote: >> My Question is: what is the format of a search that will return data? >> i.e. /solr/select?q=developer&qt=dataimport (won't work) nor will >> /solr/dataimport?q=developer (won't work) >> "HTTP ERROR: 404 >> NOT_FOUND >> RequestURI=/solr/dataimport" >> >> I have created a 'dataimport' set that contains data from a sql db. >> >> I can view meta data from this url: /solr/dataimport >> <response> >> − >> <lst name="responseHeader"> >> <int name="status">0</int> >> <int name="QTime">0</int> >> </lst> >> − >> <lst name="initArgs"> >> − >> <lst name="defaults"> >> <str name="config">data-config.xml</str> >> </lst> >> </lst> >> <str name="status">idle</str> >> <str name="importResponse"/> >> − >> <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-11-10 21:51:40</str> >> <str name="Time taken ">0:0:4.594</str> >> </lst> >> − >> <str name="WARNING"> >> This response format is experimental. It is likely to change in the future. >> </str> >> </response> >> >> I can verify that the data is there by going through >> /solr/admin/dataimport.jsp and doing 'verbose' true and debug now. >> It shows me the xml data set on the right as such: >> >> <response> >> − >> <lst name="responseHeader"> >> <int name="status">0</int> >> <int name="QTime">4594</int> >> </lst> >> − >> <lst name="initArgs"> >> − >> <lst name="defaults"> >> <str name="config">data-config.xml</str> >> </lst> >> </lst> >> <str name="command">full-import</str> >> <str name="mode">debug</str> >> − >> <arr name="documents"> >> − >> <arr> >> − >> <arr> >> <int>87133</int> >> </arr> >> </arr> >> − >> <arr> >> − >> <arr> >> <int>87134</int> >> </arr> >> </arr> >> − >> <arr> >> − >> <arr> >> <int>87135</int> >> </arr> >> </arr> >> − >> <arr> >> − >> <arr> >> <int>87136</int> >> </arr> >> </arr> >> − >> <arr> >> − >> <arr> >> <int>87137</int> >> </arr> >> </arr> >> − >> <arr> >> − >> <arr> >> <int>87138</int> >> </arr> >> </arr> >> − >> <arr> >> − >> <arr> >> <int>87139</int> >> </arr> >> </arr> >> − >> <arr> >> − >> <arr> >> <int>87140</int> >> </arr> >> </arr> >> − >> <arr> >> − >> <arr> >> <int>87141</int> >> </arr> >> </arr> >> − >> <arr> >> − >> <arr> >> <int>87142</int> >> </arr> >> </arr> >> </arr> >> − >> <lst name="verbose-output"> >> − >> <lst name="entity:item"> >> − >> <lst name="document#1"> >> − >> <str name="query"> >> SELECT j.id , j.title , FROM dbo.jobs j WITH (NOLOCK) >> LEFT WHERE j.siteid = 46 and j.active = 1 >> </str> >> <str name="time-taken">0:0:4.578</str> >> <str>----------- row #1-------------</str> >> <str name="zip"/> >> <str name="urltitle">Operations Software Developer Job</str> >> <str name="altlocation">SAN ANTONIO, TX, 78229</str> >> <str name="alttitle">Ope… >> >> >> Here is my solconfig.xml >> … >> <requestHandler name="dataimport" >> class="org.apache.solr.handler.dataimport.DataImportHandler"> >> <lst name="defaults"> >> <str name="config">data-config.xml</str> >> </lst> >> </requestHandler> >> … >> Data-config.xml is in the same dir as solconfig.xml >> >> My data-config.xml is like any other: >> <dataConfig> >> <dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" >> url="jdbc:sqlserver://xxxxxxxx:1433;databaseName=xxxxx" user="xxxxx" >> password="xxxxx" /> >> <document name="jobs"> >> <entity name="item" pk="id" query="SELECT j.id >> , j.title >> … >> FROM >> dbo.jobs … >> WHERE j.siteid = 46 and >> j.active = 1" >> deltaQuery="select id from dbo.jobs where lastmodified > >> '${dataimporter.last_index_time}'"> >> >> </entity> >> </document> >> </dataConfig> >> >> I'm using win xp with apache – and jetty + solr 1.3.0 >> >> Thanks >> >> >> > > > > -- > --Noble Paul > -- --Noble Paul
