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
6) Am i missing any step to configure the output,I have changed
db-data-config,schema.xml and solrconfig.xml files ,Do i need to change any
other files for the output
Thanks
Raj Deep
--
View this message in context:
http://lucene.472066.n3.nabble.com/Not-able-to-see-output-in-XML-output-tp3653445p3653445.html
Sent from the Solr - User mailing list archive at Nabble.com.
