I have some data in an H2 database that I'd like to move to SOLR. I
probably should/could extract and post the contents as 1 new document per
record, but I'd like to configure the data import handler and am having
some difficulty doing so. Following the wiki instructions[1], I have the
following in my db-data-config.xml:
<dataConfig>
<dataSource type="JdbcDataSource" driver="org.h2.Driver"
url="jdbc:h2:tcp://192.168.1.6/finance" user="sa" />
<document>
<entity name="receipt" query="select location as location, amount as
amount, done_on as when from RECEIPTS as r join APP_USERS as a on r.user_id
= a.id"/>
</document>
</dataConfig>
I also have dropped the JDBC driver into db/lib, witness:
% jar tvf ./lib/h2-1.3.164.jar | grep 'Driver'
13 Fri Feb 03 12:02:56 PST 2012 META-INF/services/java.sql.Driver
2508 Fri Feb 03 12:02:56 PST 2012 org/h2/Driver.class
485 Fri Feb 03 12:02:56 PST 2012 org/h2/util/DbDriverActivator.class
and I've added the appropriate fields to schema.xml:
<field name="location" type="string" indexed="true" stored="true"/>
<field name="amount" type="currency" indexed="true" stored="true"/>
<field name="when" type="date" indexed="true" stored="true"/>
There's nothing in my index and 343 rows in my table. What is going on? -- H
--
Sent from my mobile device
Envoyait de mon portable
1. http://wiki.apache.org/solr/DIHQuickStart
