apache solr:7.3.0tomcat:7.0.29mysqlDriver:mysql-connector-java-5.1.24-bin.jar已将mysql驱动放入web-app/lib中,dataimport也加载成功,但是执行导入时就会报no uniquekey specified in schema和unable to read:dataimport.properties错误.db-data-config.xml:
配置如下:
<dataConfig>
<dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/caidata?characterEncoding=utf-8" user="root" password="123456" />
<document>
<entity name="product" query="select * from t_product">
<!--商品filed-->
<field column="prod_id" name="prodId" ></field>
<field column="name" name="prodName" ></field>
<field column="simple_intro" name="simpleIntro" ></field>
<!--品牌-->
<entity name="brand" query="select name from t_brand where id='${product.brand_id}'">
<field column="name" name="brandName"></field>
</entity>
<!--类别-->
<entity name="productCat" query="select cat_id from t_prod_cat where prod_id='${product.prod_id}'">
<entity name="cat" query="select name from t_cat where id='${productCat.cat_id}'">
<field column="name" name="catName"></field>
</entity>
</entity>
</entity>
</document>
</dataConfig>
<dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/caidata?characterEncoding=utf-8" user="root" password="123456" />
<document>
<entity name="product" query="select * from t_product">
<!--商品filed-->
<field column="prod_id" name="prodId" ></field>
<field column="name" name="prodName" ></field>
<field column="simple_intro" name="simpleIntro" ></field>
<!--品牌-->
<entity name="brand" query="select name from t_brand where id='${product.brand_id}'">
<field column="name" name="brandName"></field>
</entity>
<!--类别-->
<entity name="productCat" query="select cat_id from t_prod_cat where prod_id='${product.prod_id}'">
<entity name="cat" query="select name from t_cat where id='${productCat.cat_id}'">
<field column="name" name="catName"></field>
</entity>
</entity>
</entity>
</document>
</dataConfig>
解决方法:将数据源type属性删除即可。另外根据报出错误信息,我们可以在conf目录下创建dataImport.properties文件,此种方法没有实验,大家可以试一下。