Hi ,
I need help with importing data, through DIH. ( using solr-3.6.1, tomcat6 )
I see the following error when I try to do a full-import from my
local MySQL table ( http:/s..../solr//dataimport?command=full-import"
).
<snip>
..
<str name="Total Requests made to DataSource">0</str>
<str name="Total Rows Fetched">0</str>
<str name="Total Documents Processed">0</str>
<str name="Total Documents Skipped">0</str>
<str name="">Indexing failed. Rolled back all changes.</str>
....
</snip>
I did search to find ways to solve this problem and did create the
file dataimport.properties , but no success.
Any help would be appreciated.
cheers,
Kolla
PS: When I check the admin panel for statistics for the query
/dataimport , I see the following:
Status : IDLE
Documents Processed : 0
Requests made to DataSource : 0
Rows Fetched : 0
Documents Deleted : 0
Documents Skipped : 0
Total Documents Processed : 0
Total Requests made to DataSource : 0
Total Rows Fetched : 0
Total Documents Deleted : 0
Total Documents Skipped : 0
handlerStart : 1391612468278
requests : 5
errors : 0
timeouts : 0
totalTime : 28
avgTimePerRequest : 5.6
Also, Here is my dataconfig file.
<dataConfig>
<dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/DBNAME"
user="USER" password="PWD"/>
<document>
<entity name="docs" query="select * from TABLENAME">
<field column="id" name="id"/>
<field column="content" name="text"/>
<field column="title" name="title"/>
</entity>
</document>
--
Cheers,
Kolla
