i try to index table in mysql database,
1st i create db-config.xml file which contain
<dataSource type="JdbcDataSource" name="1stTrial"
Driver="com.mysql.jdbc.Driver" encoding="UTF-8"
url="jdbc:mysql://localhost:3306/(database
name)"
user="(user)" password="(password)"
batchSize="-1"/>
followed by
<entity dataSource="1stTrial" name="(table name)" pk="id" query="select *
from (table name)">
and defining of table like
<field column="id" name="ID"/>
<field column="Text1" name="(field name)"/>
2nd i add this field in schema.xml file
and finally decide in solronfig.xml file the db-config.xml file as
<requestHandler name="/dataimport"
class="org.apache.solr.handler.dataimport.DataImportHandler">
<lst name="defaults">
<str name="config">db-data-config.xml</str>
</lst>
</requestHandler>
i found index folder which contain only segment.gen & segment_1 files
and when try to search no result i got
any body can present a help ???
thanks in advance
--
View this message in context:
http://lucene.472066.n3.nabble.com/indexing-mysql-database-tp1719883p1719883.html
Sent from the Solr - User mailing list archive at Nabble.com.
