Solr从数据库创建索引报错org.apache.solr.common.SolrException: Document is missing mandatory uniqueKey field

这是我的dataConfig.xml文件

<?xml version="1.0" encoding="UTF-8" ?>  
<dataConfig>   
<dataSource type="JdbcDataSource"   
		  driver="com.mysql.jdbc.Driver"   
		  url="jdbc:mysql://localhost:3306/shoponline"   
		  user="root"   
		  password="123"/>   
<document> 
	<entity name="product" query="SELECT pid,pname,ptype,price,pdescription,picture FROM product ">
		 <field column="pid" name="id"/> 
		 <field column="pname" name="product_name"/> 
		 <field column="ptype" name="product_ptype"/> 
		 <field column="price" name="product_price"/> 
		 <field column="pdescription" name="product_description"/> 
		 <field column="picture" name="product_picture"/> 
	</entity>   
</document>   

</dataConfig>

解决方法就是确定你要生成索引的表有主键，

SELECT pid,pname,ptype,price,pdescription,picture FROM product

我的是pid是主键。必须要在select里或者直接可以select * 

<field column="pid" name="id"/> 

也要有主键对应的field