On 12 February 2014 20:53, Maheedhar Kolla <maheedhar.ko...@gmail.com> wrote: > > 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. [...]
You do not have to create dataimport.properties. Look in the Tomcat logs for more details on the error, and post the relevant sections here if you cannot make sense of it. My guess would be that your database credentials are incorrect, or that the SELECT is failing. Try logging into mysql from an admin. tool with those credentials, and running the SELECT manually. Regards, Gora