Index a DB table directly into Solr

1. Start solr
   java -jar start.jar
2. Edit your solrconfig.xml to add the request handler
	<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">
	<lst name="defaults">
	  <str name="config">data-config.xml</str>
	</lst>
	</requestHandler>
3. Create a data-config.xml file as follows and save it to the conf dir
	<dataConfig>
		<dataSource type="JdbcDataSource" 
				  driver="com.mysql.jdbc.Driver"
				  url="jdbc:mysql://localhost:3306/dbname" 
				  user="root" 
				  password="111111"/>
	  <document>
		<entity name="id" 
				query="select id,name from mytable">
		</entity>
	  </document>
    </dataConfig>
	note: need to creat a DB named dbname and also create a table named mytable with property id and name.
	add some data in the table. like "1 , testuser"
4. Put the url in the browser. "http://localhost:8983/solr/dataimport?command=full-import"
5. Use slor admin to select import datas. "http://localhost:8983/solr/select/?q=testuser&version=2.2&start=0&rows=10&indent=on"
   You can find the result.
 Please click the url http://wiki.apache.org/solr/DIHQuickStart for more information
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值