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.