Solr7.3.1导入数据库数据

1.解压solr-7.3.1.zip到F:盘 solr-7.3.1\server\solr\configsets_default

2.在命令行进入F:\solr-7.3.1\bin，然后启动solr

./solr.cmd start

3.在F:\solr-7.3.1\server\solr下新建core1文件夹，并复制F:\solr-7.3.1\server\solr\configsets\_default\conf文件夹到core1下

4.进入solr控制页面添加Core

5.进入solr-7.3.1\dist文件夹下，复制如下jar包到solr-7.3.1\server\solr-webapp\webapp\WEB-INF\lib下

• solr-dataimporthandler-7.3.1.jar
• solr-dataimporthandler-extras-7.3.1.jar

6.下载所需连接的数据库的驱动jar包到solr-7.3.1\server\solr-webapp\webapp\WEB-INF\lib下

7.在solr-7.3.1\server\solr\core1\conf\solrconfig.xml添加相关配置

<!--数据库配置 -->
<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler"> 
	<lst name="defaults">  
		  <str name="config">data-config.xml</str>  
	</lst>  
</requestHandler> 

8.在solr-7.3.1\server\solr\core1\conf\下新建data-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<dataConfig>
	<dataSource 
	type="JdbcDataSource" 
	driver="oracle.jdbc.driver.OracleDriver" 
	url="jdbc:oracle:thin:@xxxxxxxxx:1521:orcl11g" 
	user="xxxxxx" 
	password="xxxx" /> 
	<document>
		<entity name="TB_BPM_INSTANCE" query="select 
		PROC_DEF_KEY,
		VERSIONNO,
		BUSINESS_KEY,
		WFINSTNAME,
		WFINSTCODE,
		CREATEUSERID,
		CREATETIME,
		STATE,
		SUBMITTIME,
		ISTEST,
		REMARK,
		WNUMBER from TB_BPM_INSTANCE">
			<field column="PROC_DEF_KEY" name="procDefKey"/> 
			<field column="VERSIONNO" name="versionNo"/> 
			<field column="BUSINESS_KEY" name="businessKey"/> 
			<field column="WFINSTNAME" name="wfinstName"/> 
			<field column="WFINSTCODE" name="wfinstCode"/> 
			<field column="CREATEUSERID" name="createUserId"/> 
			<field column="CREATETIME" name="createTime"/> 
			<field column="STATE" name="state"/> 
			<field column="SUBMITTIME" name="submitTime"/> 
			<field column="ISTEST" name="isTest"/> 
			<field column="REMARK" name="remark"/> 
			<field column="WNUMBER" name="wNumber"/> 
		</entity>
	</document>
</dataConfig>

9.修改solr-7.3.1\server\solr\core1\conf\managed-schema 添加如下内容，并注意<uniqueKey>procDefKey</uniqueKey> 的设置

<field name="procDefKey" type="string" indexed="true" stored="true"/>
<field name="versionNo" type="string" indexed="true" stored="true"/>
<field name="businessKey" type="string" indexed="true" stored="true"/>
<field name="wfinstCode" type="string" indexed="true" stored="true"/>
<field name="wfinstName" type="string" indexed="true" stored="true"/>
<field name="createUserId" type="string" indexed="true" stored="true"/>
<field name="createTime" type="string" indexed="true" stored="true"/>
<field name="state" type="string" indexed="true" stored="true"/>
<field name="submitTime" type="string" indexed="true" stored="true"/>
<field name="isTest" type="string" indexed="true" stored="true"/>
<field name="remark" type="string" indexed="true" stored="true"/>
<field name="wNumber" type="pint" indexed="true" stored="true"/>

10.选中Auto-Refresh Status然后点击Execute，导入数据