It can be anything from wrong credentials, to missing driver in the class path, to malformed connection string, etc..
What does the Solr log say? -----Original Message----- From: Maheedhar Kolla [mailto:maheedhar.ko...@gmail.com] Sent: יום ד 12 פברואר 2014 17:23 To: solr-user@lucene.apache.org Subject: Importing database DIH 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
