Hi

You gave us quite little information to go on, but I can list some probable
reasons for why you search doesn't match any documents. In schema.xml check
that:
- you have specified fields for custid, familyname, usrname
- that those fields have the attribute indexed="true"
- that they are not of type string (see
http://stackoverflow.com/questions/7175619/apache-solr-string-or-text)

Assuming you havent made any changes to the default request handler in
solrconfig.xml you need to specify what fields you want to match you query
with. You can do this during a query by changing your q-parameter
to "usrname:admin familyname:admin". This will match any documents where
the text "admin" is in either the usrname or familyname fields. Depending
on the field type you used in schema.xml the search might be case
sensitive, so check that you use the correct case as well.

Hope this helps

Åsmund

On Thu, Sep 20, 2012 at 2:39 PM, darshan <dk...@dreamsoftech.com> wrote:

> HI Fellows,
>
>                 I had added the following fields in my data-config.xml to
> implement Data Import Handler
>
> <dataConfig>
>
>   <dataSource driver="org.postgresql.Driver"
>
>      url="jdbc:postgresql://192.168.1.46:5432/evergreen"
>
>       user="postgres"
>
>     />
>
>   <document>
>
>    <entity name="page" query="SELECT *  from actor.usr">
>
>       <field column="CUSTID" name="custid" />
>
>       <field column="FAMILYNAME" name="familyname" />
>
>       <field column="USRNAME" name="usrname" />
>
>   </entity>
>
>   </document>
>
> </dataConfig>
>
> When I perform steps of Full import Example at
> http://wiki.apache.org/solr/DataImportHandler
>
> I can successfully index on my database, BUT here the issue is after
> visiting admin page for search and search for any text, I didn't receive
> any
> output and the response is always
>
> <response>
>
> <lst name="responseHeader">
>
> <int name="status">0</int>
>
> <int name="QTime">2</int>
>
> <lst name="params">
>
> <str name="indent">on</str>
>
> <str name="start">0</str>
>
> <str name="q">admin</str>
>
> <str name="version">2.2</str>
>
> <str name="rows">10</str>
>
> </lst>
>
> </lst>
>
> <result name="response" numFound="0" start="0"/>
>
> </response>
>
> Please guide me on this , am a newbie to apache solr.
>
>
>
> Thanks,
>
> Darshan
>
>
>
>
>
>

Reply via email to