Hi,
I performed steps given in http://wiki.apache.org/solr/DataImportHandler to
index data from database.

the data-config.xml is 
<dataConfig>
        <dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
        url="jdbc:sqlserver://192.168.1.120:1433;DatabaseName=g2" user="sa"
password="mima1234@" />
<document name="user">
        <entity name="t_user_principle" query="select * from t_user_principle">
                <field column="user_name" name="user_name" />
                <field column="is_logged_in" name="is_logged_in"/>
                <field column="distinguished_name" name="distinguished_name"/>
        </entity>
</document>
</dataConfig>

now I am able to view data that is indexed using URL
http://localhost:8080/solr/admin/dataimport.jsp to see the data as
<arr>
- <arr>
  <str>user1</str> 
  </arr>
- <arr>
  <str>0</str> 
  </arr>
- <arr>
  <str>CN=user1,OU=R&D</str> 
  </arr>
  </arr>

But when I search user_name:user1 then the result is not returned at all.
Am I missing something here??? Please help.
Thanks,
Ashish


-- 
View this message in context: 
http://www.nabble.com/Querying-DB-indexed-data-tp22428120p22428120.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to