I wanted to learn how to index data that I have on my dB. I followed the instructions on the wiki page for the Data Import Handler (Full Import Example -example-solr-home.jar). I got an exception running it as is (see below).
Anyway, I have a couple of questions before addressing the source of the exception. 1) what is the purpose of the dataimport jar file? Is it used to populate the dB? 2) The dataimport.jar file is NOT included in the war file. Why is that? It was recommended that it be added if I already have an existing installation of my war file. 3) at what point in time is the hsqldb dB supposed to be populated? Executing the URL http://localhost:2455/solr/db/dataimport I get a response with so to this degree is correctly configured. The exception happens when I attempt to execute the full-import command. Exception follows: SEVERE: The query failed 'select * from item' org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select * from item at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(J dbcDataSource.java:166) ...... Caused by: java.sql.SQLException: Table not found in statement [select * from item] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) Julio Castillo Edgenuity Inc.
