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
,导入数据