hi,
I have setup my solr installation to run with jetty and I am trying to
import an sqlite database in the solr index. I have setup a jdbc sqlite
driver:
<dataConfig>
<dataSource type="JdbcDataSource" driver="org.sqlite.JDBC"
url="jdbc:sqlite:/home/mathieu/data/final.db"/>
<document name="document">
<entity name="item" query="select id,thread_title from content">
<field column="ID" name="id" />
<field column="THREAD_TITLE" name="thread_title" />
</entity>
</document>
</dataConfig>
The schema:
<fields>
<field name="id" type="int" indexed="true" stored="true" required="true"
/>
<field name="thread_title" type="text" indexed="true" stored="true"/>
</fields>
<uniqueKey>id</uniqueKey>
<defaultSearchField>thread_title</defaultSearchField>
I kickstart the import process with
"wget http://localhost:8080/solr/dataimport?command=full-import";
It seems to work but the following command reports that only 499 documents
were indexed (yes, there are many more documents in my database):
"wget http://localhost:8080/solr/dataimport?command=status";
and the logs seem to imply that the import is finished:
INFO: Read dataimport.properties
27-Jan-2012 19:37:17 org.apache.solr.handler.dataimport.SolrWriter persist
INFO: Wrote last indexed time to dataimport.properties
27-Jan-2012 19:37:17 org.apache.solr.handler.dataimport.DocBuilder execute
INFO: Time taken = 0:0:1.52
I am at a loss. What can I do to debug this further ? Help of any kind
would be most welcome.
Mathieu
--
Mathieu Lacage <mathieu.lac...@alcmeon.com>
