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
bfpostmas...@benefitfocus.com
immediately and delete this message and any attachments from your system.
(01/2012)
<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>
<?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>
