lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajdeep Alapati <rajdeep.alap...@benefitfocus.com>
Subject Not able to see the output when search is clicked
Date Wed, 11 Jan 2012 11:01:59 GMT
Hi,

In my SOLR, I have a query based data-config written and was able to manage below steps but
i was not able to see the output



1) Register Data Import Request handler in Solr-config.xml
2) Modify Data-Config.xml for the appropriate query to get data imported from which includes
making use of Jtds Driver for Sql server
3) Modify SolrConfig.xml file for registering db-data-config.xml in Request Handler item
4) Modify schema.xml for the output result. Right now we are facing issues here.please let
me attach 2 files 1) schema.xml 2) db-data-config.xml.

Schema.xml

<?xml version="1.0" encoding="UTF-8" ?>
  <schema name="example" version="1.2">
  <types>
      <fieldType name="string" class="solr.StrField" sortMissingLast="true" omitNorms="true"
/>
      <fieldType name="int" class="solr.TrieIntField" precisionStep="0" omitNorms="true"
positionIncrementGap="0" />
      <fieldType name="date" class="solr.TrieDateField" omitNorms="true" precisionStep="0"
positionIncrementGap="0" />
      <fieldType name="text" class="solr.TextField" positionIncrementGap="100">
          <analyzer type="index">
              <tokenizer class="solr.WhitespaceTokenizerFactory" />
              <filter class="solr.StopFilterFactory" ignoreCase="true" words="stopwords.txt"
enablePositionIncrements="true" />
              <filter class="solr.WordDelimiterFilterFactory" generateWordParts="1" generateNumberParts="1"
catenateWords="1" catenateNumbers="1" catenateAll="0" splitOnCaseChange="1" />
              <filter class="solr.LowerCaseFilterFactory" />
              <filter class="solr.SnowballPorterFilterFactory" language="English" protected="protwords.txt"
/>
          </analyzer>
        <analyzer type="query">
          <tokenizer class="solr.WhitespaceTokenizerFactory" />
          <filter class="solr.SynonymFilterFactory" synonyms="synonyms.txt" ignoreCase="true"
expand="true" />
          <filter class="solr.StopFilterFactory" ignoreCase="true" words="stopwords.txt"
enablePositionIncrements="true" />
          <filter class="solr.WordDelimiterFilterFactory" generateWordParts="1" generateNumberParts="1"
catenateWords="0" catenateNumbers="0" catenateAll="0" splitOnCaseChange="1" />
          <filter class="solr.LowerCaseFilterFactory" />
          <filter class="solr.SnowballPorterFilterFactory" language="English" protected="protwords.txt"
/>
        </analyzer>
      </fieldType>
      </types>
  <fields>
      <field name="FileId" type="string" indexed="true" stored="true" required="true" />
	  <field name="Title" type="string" indexed="true" stored="true" required="true" />
      
  </fields>
   
   <uniqueKey>FileId</uniqueKey>
   <defaultSearchField>FileId</defaultSearchField>
   <solrQueryParser defaultOperator="AND" />
  </schema>


db-data-config.xml

<dataConfig>
    <dataSource type="JdbcDataSource" driver="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://17.30.199.667:1433;databaseName=XXXX"
user="XXXX" password="XXX" />
    <document>
		<entity name="Files" query="Select FileID,Title from files">
			
			<field column="FileID" name="FileID" />
			<field column="Title" name="Title" />
		
		</entity>
            
            
        
    </document>
</dataConfig>





5) Make full import http request for data to get indexed into solr server. Even though i see
that all the rows are indexed but not able to find results when search is clicked on the admin
page


Thanks
Raj Deep 
Benefitfocus is the largest benefits technology provider in the U.S. 
More than 15 million consumers, 300,000 employers and 60,000 brokers 
use our cloud-based platform to shop, enroll, manage and exchange all 
their benefits in one place. From consumer engagement and education 
to enrollment, communication and billing, Benefitfocus is helping 
companies find a better way to manage their benefits. For 
more information, visit www.benefitfocus.com 
Benefitfocus ­ All Your Benefits. One Place.

CONFIDENTIALITY NOTICE: This message and any attachments are for the 
use of the intended individuals and may contain information that is 
confidential and exempt from disclosure under law. If you are not the 
intended recipient, any further use, distribution, or disclosure of this 
message or attachments is strictly prohibited. If you have received this 
communication in error, please contact the sender or bfpostmaster@benefitfocus.com 
immediately and delete this message and any attachments from your system. (01/2012)

Mime
View raw message